College: Yuba Community College
Course: Accounting 2 LAB (online)
Platform/Website: Cengage (cengage.com)
Email: [email protected]
Password: Evangel1995
Once on the dashboard, proceed to go click on the "eBook: Excel Applications for Accounting Principles". A new window will open that shows the chapters on the left-hand side of the page. Scroll down and select "P24: MATERIAL AND LABOR VARLANCES (PRIMEVAR)." This chapter goes hand in hand with the spreadsheet you are to complete.
The name of the lab assignment for this week is "PRIMEWAR". It is due by 11:59 on WEDNESDAY, NOVEMBER 3, 2021.
*****MUST INCLUDE:*****
- ANSWERED QUESTIONS
- What if Section
- Chart Analysis Section
- Tickler Section
PLEASE READ ALL INFORMATION AND REQUIREMENTS ON PAGES 133-135 OF THE EBOOK CAREFULLY.
Worksheet PRIMEVAR Material and Labor Variances Data Section Materials price variance input Actual cost of material per pound (ounce, etc.)INPUT A Standard cost of mat. per pound (ounce, etc.)INPUT B Materials quantity variance input Actual quantity of materials usedINPUT C Standard quantity of mat. used for actual outputINPUT D Labor rate variance input Actual cost of labor per hourINPUT E Standard cost of labor per hour INPUT F Labor efficiency variance input Actual quantity of hours incurredINPUT G Standard quantity of hours for actual outputINPUT H Answer Section F or U Material price varianceFORMULA1FORMULA8 Material quantity varianceFORMULA2FORMULA9 Total materials varianceFORMULA3FORMULA10 Labor rate varianceFORMULA4 N/A Labor efficiency varianceFORMULA5 N/A Total labor varianceFORMULA6 N/A Total materials and labor variancesFORMULA7 N/A Sheet1 CM SPR 20 Chart Chart Data Table A0 B0 C0 D0 Chart Tickler Data Table StandardActual Material8082.6381578947 Labor4846.6052631579 ABCD0000