Zelmer Company manufactures tablecloths. Sales have grown rapidly over the past
ID: 2554119 • Letter: Z
Question
Zelmer Company manufactures tablecloths. Sales have grown rapidly over the past 2 years. As a result, the president has installed a budgetary control system for 2017. The following data were used in developing the master manufacturing overhead budget for the Ironing Department, which is based on an activity index of direct labor hours. Rate per Direct Labor Hour Annual Fixed Costs Variable costs Indirect labor Indirect materials Factory utilities Factory repairs $44,040 19,200 14,640 25,080 $0.44 Supervision 0.54 Depreciation 0.34 Insurance 0.24 Rent The master overhead budget was prepared on the expectation that 476,600 direct labor hours will be worked during the year. In June, 45,300 direct labor hours were worked. At that level of activity, actual costs were as shown below Variable-per direct labor hour: indirect labor $0.48, indirect materials $0.53, factory utilities $0.38, and factory repairs $0.29 Fixed: same as budgeted. (a) & (b) Your answer is partially correct. Try again. (a) Prepare a monthly manufacturing overhead flexible budget for the year ending December 31, 2017, assuming production levels range from 35,200 to 52,000 direct labor hours. Use increments of 5,600 direct labor hours. (List variable costs before fixed costs.) ZELMER COMPANY Monthly Overhead Flexible Budget For the Year 2017 Activity Level Activity Level 35,200 40800 46400 52000 Variable Costs Indirect Labor 16896 19584 22272 24960 Indirect Materials 8954.88 10379.52 11804.16 13228.8Explanation / Answer
Here in the Given Problem Rates are Variable Costs Master Budget $ Actual Budget $ Indirect Labour 0.44 Indirect Labour 0.48 Indirect Material 0.54 Indirect Material 0.53 Factory Utilities 0.34 Factory Utilities 0.38 Factory Repairs 0.24 Factory Repairs 0.29 Ans) A Note : Fixed Cost Total Constant and Variable Cost Per Unit Constant Let Us Calculate Total cost at Labour hours 35200 To 52000 by Incrimentals of 5600 here we are Taking Actual for calculation of variable Overheads Preparation of Budget Analysis of Zelmer Company Particulars Per Unit 35,200.00 40,800.00 46,400.00 52,000.00 Variable Cost(Per Unit Constant) Indirect Labour 0.48 16,896.00 19,584.00 22,272.00 24,960.00 Indirect Material 0.53 18,656.00 21,624.00 24,592.00 27,560.00 Factory Utilities 0.38 13,376.00 15,504.00 17,632.00 19,760.00 Factory Repairs 0.29 10,208.00 11,832.00 13,456.00 15,080.00 Total Variable Cost 59,136.00 68,544.00 77,952.00 87,360.00 Fixed Cost (Total Constant) Total P.Month Supervision (44040/12) 3,670.00 3,670.00 3,670.00 3,670.00 3,670.00 Depriciation(19200/12) 1,600.00 1,600.00 1,600.00 1,600.00 1,600.00 Insurance (14640/12) 1,220.00 1,220.00 1,220.00 1,220.00 1,220.00 Rent (25080/12) 2,090.00 2,090.00 2,090.00 2,090.00 2,090.00 Total Fixed Cost 8,580.00 8,580.00 8,580.00 8,580.00 Total Cost 67,716.00 77,124.00 86,532.00 95,940.00 Ans B Calculation of Variance analysis for the Budget and Actuals at 45300 Labour Hours Note : Fixed Cost Total Constant and Variable Cost Per Unit Constant No of Labour Hours 45300 Budgeted Actual Variance Particulars Per Unit Total Per Unit Total Variable Cost(Per Unit Constant) Indirect Labour 0.44 19,932.00 0.48 21,744.00 (1,812.00) UnFavourable Indirect Material 0.54 24,462.00 0.53 24,009.00 453.00 favourable Factory Utilities 0.34 15,402.00 0.38 17,214.00 (1,812.00) UnFavourable Factory Repairs 0.24 10,872.00 0.29 13,137.00 (2,265.00) UnFavourable Total Variable Cost 70,668.00 76,104.00 (5,436.00) Fixed Cost (Total Constant) Supervision (44040/12) 3,670.00 3,670.00 0 Neither Favourable Nor Unfavourable Depriciation(19200/12) 1,600.00 1,600.00 0 Neither Favourable Nor Unfavourable Insurance (14640/12) 1,220.00 1,220.00 0 Neither Favourable Nor Unfavourable Rent (25080/12) 2,090.00 2,090.00 0 Neither Favourable Nor Unfavourable Total Fixed Cost 8,580.00 8,580.00 0 Total Cost 79,248.00 84,684.00 (5,436.00)
Related Questions
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.