AutoSave OFF EU Lab 4 Brewer 8th Online Student Template Spring 2020 Home Insert Draw Page Layout Formulas Data Review View Tell me Share Comments > #Insert v Aral 10 ~ Al A ah Wraa Text X LI General 27-O 4 DX Delete Pasic B 1 U - Ay = = = -- Merge & Center Y % Sort & Ideas Sensitivity Conditional Format Cell Formatting as Teble Styles Farmat v Find & Select J29 A B C D E G H 1 K L N 0 P R 5 T w x Given Data/Problem Information: 2 8 4 C Information: Mirror Products, Inc. manufactures and sells several different products. Performance reports are prepared each month for each department. The cost formulas used for the Production Department are given below. q represents the number of direct-labor hours. Also reported below are the actual costs incurred by the Production Department in April. Although the company planned to work 4.200 direct labor-hours in April, it actually worked 4.100 direct labor-hours. 7 9 10 Variable Cost per 12 Cost Formulas: 13 Fixed Cost Planned direct labor-hours (g) for the 14 month 4,200 15 Direct labor 16 Indirect labor 4,000 + 17 Utilities 18 Supplies 1,400 - 18 Equipment depreciation 20,000 20 Factory rent 9,000 21 Property taxes 3,500 22 Factory administration 13,500 - 28 20 27 Actual Hours and Costs Incurred in April: 19.00 1.75 1.00 0.50 1.00 29 Actual direct labor-hours (a) worked 4,100 78,500 12,000 3.200 30 Direct labor 31 Indirect labor Utilities 33 Supplies 34 Equipment depreciation 36 Factory rent 36 Property taxes 37 Factory administration 38 20,500 3,400 18,000 40 Lab 4 Given Data + Ready 100% AutoSave OFF Lab 4 Brewer 8th Online Student Template Spring 2020 Home Insert Draw Page Layout Formulas Data Review View Tell me Share Comments v 12 Aral X LE ~ Al A Insert ab Wraa Text General 22 2T-O. 3 D Delete Pagic B 1 U - Av = = = Merge & Center % Sort & Y cas Conditional Format Cell Formatting as Table Styles Sensitivity Find & Select Farmat D26 T D E r 1 N 1 T Points Possible: 10 To receive full credit you must use cell references (linking) when possible and Excel formulas for all calculated amounts. a Vee the information on the Giren Dale worksheel to prepare a planning budget go 19 spending variances report for the Production Department for April 13 MIRROR PRODUCTS, INC. Production Department Planning Budget 11 Far the Month Ended April 30 15 Planning 18 Budget 12 Labor hours 4,200 12 Drect laber 3 79.000 20 Indire labor 11,350 1 Uilties 9,700 22 Supplies 3.500 2 Equipment cepreciation 20,000 24 Factory rent 9,000 25 Property 3,500 28 Factory admiration 17,700 37 Total expenses 51 In the report below. In the third column, use Excel to compute a spending variance for 5 Ach cest. Then, in the last column, select F for favorable or for unfavorable. De not s select a letter if I varlance. MIRROR PRODUCTS, INC. Production Department Spending Variances For the Month Ended April 30 Acbel Flexible Spending Variances Results Budget 42 Labonheur 44 Drech labor 46 Indirect labor 4 Ulties 17 Supplies 48 Equipment cepreciation 40 Factory rent 50 Poperty taxes Factory Adminlaration 52 Total expenses 54 38 Lab 4 Given Data + Ready 2 +
