I HAVE POSTED THIS QUESTION TWICE ALREADY PLEASE CAN TO SHOW

I HAVE POSTED THIS QUESTION TWICE ALREADY... PLEASE CAN TO SHOW THE FORMULAS YOU HAVE USED TO GET THE ANSWERS, I NEED THEM TO COMPLETE THE ASSIGNMENT. AND COMPLETE THE WHOLE EXERCISE. THANK YOU I REALLY REALLY APPRECIATE IT.

Solution

Answer a. BUMBLEBEE COMPANY Packaging Department Monthly Manufacturing Overhead Flexible Budget For the Year 2017 Activity Level Direct Labor Hours                           27,000                           30,000                           33,000                           36,000 Variable Costs Indirect Labor ($0.42)                           11,340                           12,600                           13,860                           15,120 27,000 dlh X $0.42 30,000 dlh X $0.42 33,000 dlh X $0.42 36,000 dlh X $0.42 Indirect Material ($0.30)                              8,100                              9,000                              9,900                           10,800 27,000 dlh X $0.30 30,000 dlh X $0.30 33,000 dlh X $0.30 36,000 dlh X $0.30 Repairs ($0.23)                              6,210                              6,900                              7,590                              8,280 27,000 dlh X $0.23 30,000 dlh X $0.23 33,000 dlh X $0.23 36,000 dlh X $0.23 Utilities ($0.24)                              6,480                              7,200                              7,920                              8,640 27,000 dlh X $0.24 30,000 dlh X $0.24 33,000 dlh X $0.24 36,000 dlh X $0.24 Lubricants ($0.06)                              1,620                              1,800                              1,980                              2,160 27,000 dlh X $0.06 30,000 dlh X $0.06 33,000 dlh X $0.06 36,000 dlh X $0.06 A. Total Variable Costs ($1.25)                           33,750                           37,500                           41,250                           45,000 Fixed Costs: Supervision ($96,000 /12)                              8,000                              8,000                              8,000                              8,000 Depreciation ($72,000 /12)                              6,000                              6,000                              6,000                              6,000 Insurance ($30,000 /12)                              2,500                              2,500                              2,500                              2,500 Rent ($24,000 /12)                              2,000                              2,000                              2,000                              2,000 Property Tax ($18,000 /12)                              1,500                              1,500                              1,500                              1,500 B. Total Fixed Cost                           20,000                           20,000                           20,000                           20,000 Total Costs (A + B)                           53,750                           57,500                           61,250                           65,000 Answer b. BUMBLEBEE COMPANY Packaging Department Monthly Manufacturing Overhead Flexible Budget For the Month Ended Oct 31, 2017 Budget at Actual Costs Difference Direct Labor Hours            27,000            27,000 Variable Costs Indirect Labor ($0.42)      11,340.00      12,432.00    1,092.00 (U) Indirect Material ($0.30)         8,100.00        7,680.00       420.00 (F) Repairs ($0.23)         6,210.00        6,100.00       110.00 (F) Utilities ($0.24)         6,480.00        6,840.00       360.00 (U) Lubricants ($0.06)         1,620.00        1,920.00       300.00 (U) A. Total Variable Costs ($1.25)      33,750.00      37,500.00    3,750.00 (U) Fixed Costs: Supervision         8,000.00        8,000.00                 -   Depreciation         6,000.00        6,000.00                 -   Insurance         2,500.00        2,460.00          40.00 (F) Rent         2,000.00        2,000.00                 -   Property Tax         1,500.00        1,500.00                 -   B. Total Fixed Cost      20,000.00      19,960.00          40.00 (F) Total Costs (A + B)      53,750.00      57,460.00    3,710.00 (U) Answer 3. The managers have been largely unable to control variable manufacturing costs in October.