Question

need the formulas

and budget Bumblebee Company estimates that 300,000 direct labor hours will be worked during the coning year, 2017, in the Packaging Departmemt. On this basis, the budgeted manufacturing overhend cost data, shown below, ire computed for the year 2 3 Fixed Overhead Costs Variable Overhead Costs Variable Per Unit 7Supervision Indirect labor Indirect materials Repairs Utilities Lubricants $126,000 90,000 69,000 S0.42 30,000 24,000 18,000 $240,000 10 Rent 1Property taces 12 S0.24 $0.06 $1.25 18,000 $375,000 14 I is estimated that direct labor hours worked each month will range from 27,000 to 36,000 hours 15 16 Fixed Overhead Costs Variable Overhead Costs $8,250 6,000 2,460 Indirect labor Indirect materials $12,432 7,680 6,100 6,840 19 20 Depreciation Insurance Rent Utilities 22 Property taxes 1,280 $19,990 534,972 25 26 a) Prepare a monthly manufacturing overbead flexible budget for each increment of 3,000 direct labor 27 hours over the relevant range for the year ending December 31, 2017 2s D) Prepare a flexible budget report for October Note from Carter: This assigament "looks" huge. But it really Isn't In part (a) you can create your formulas at 27.000 units and then paste them into 30,000 units, 33,000 units, and 36,000 un may want to Google how to do an Absolute Cell Reference by using the 'S' as part of your formulas İnpart Brou can manu -and-U TerG de "conditional formatting- Prepare a monthly manufacturing overhead flexible budget for each increment of 3,000 direct labor bours over the relevant range for the year ending December 31, 2017 BUMBLEBEE COMPANY Packaging Department Introduction Module 10 Module 12+ Mac

Answer 1

(a)Monthly manufacturing overhead flexible budget for year ending 31 dec 2017 BUMBLEBEE COMPANY Packaging department Monthly Manufacturing Overhead Flexible Budget For the Year 2017 (S) Activity Level Direct Labour Hours 33000 36000 Variable Cost ()Variable P.U.($) Indirect Labour Indirect Material repairs Utilities Lubricants Total Variable Costs 12600 9000 6900 7200 1800 37500 0.42 11340 8100 6210 1386015120 990010800 8280 0.23 0.24 0.06 7590 7920 1980 1620 33750 2160 41250 45000 Fixed Cost (S) Supervision Depreciation Insurance Rent 8000 2500 Taxes Total Fixed Cost Total Cost 53750 57500 6125065000 (b) Flexible budget repoet for October BUMBLEBEE COMPANY Packaging department Manufacturing Overhead Flexible Budget Report For the Month ended 31 october 2017 (S) Direct Labour Hours Variable Cost Indirect Labour Indirect Material repairs Utilities Lubricants Total Variable Costs Budget at Actual at Difference Favourable(F VC P.U Unfavourable(U) 27000 DLH 27000 DLH 12432 7680 6100 6840 1920 34972 11340 8100 6210 0.42 1092 0.23 0.24 0.06 110 360 1620 33750 Fixed Cost (S) Supervision Depreciation Insurance Rent 8250 2460 2000 1280 19990 Taxes 1500 Total Fixed Cost 10 Total cost 54962 53750 1212