- 1 Refer To Dcdesserts Com S Activity Based Flexible Budget In Exhibit 11 11 Suppose That The Company S Activity In June 1 (19.49 KiB) Viewed 10 times
- 1 Refer To Dcdesserts Com S Activity Based Flexible Budget In Exhibit 11 11 Suppose That The Company S Activity In June 2 (52.42 KiB) Viewed 10 times
- 1 Refer To Dcdesserts Com S Activity Based Flexible Budget In Exhibit 11 11 Suppose That The Company S Activity In June 3 (72.81 KiB) Viewed 10 times
- 1 Refer To Dcdesserts Com S Activity Based Flexible Budget In Exhibit 11 11 Suppose That The Company S Activity In June 4 (23.85 KiB) Viewed 10 times
- 1 Refer To Dcdesserts Com S Activity Based Flexible Budget In Exhibit 11 11 Suppose That The Company S Activity In June 5 (27.88 KiB) Viewed 10 times
- 1 Refer To Dcdesserts Com S Activity Based Flexible Budget In Exhibit 11 11 Suppose That The Company S Activity In June 6 (27.86 KiB) Viewed 10 times
Exhibit 11-11 Activity-Based Flexible Budget DCdesserts.com DC4 desserts Budgeted Cost Nonstick cooking spray Waxed paper Other paper products Cost Pool I (cost driver: process hours) Indirect material: Miscellaneous supplies Indirect labor: maintenance Utilities: Monthly Flexible Overhead Budget DCDESSERTS.COM Electricity Natural gas Total of cost pool I Cost Pool II (cost driver: production runs) Indirect labor: Inspection Setup Total of cost pool II Cost Pool III (cost driver: new products tested) Test kitchen Total of cost pool IV Cost Pool V (facility level costs) Total of cost pool III Cost Pool IV (cost driver: pounds of material handled) Material handling Indirect labor: production supervisors Depreciation: plant and equipment Insurance and property taxes Total of cost pool V Total overhead cost Q 6,000 $12,000 $15,000 2,000 2,500 2.000 2,500 6,000 7.500 4.000 5.000 3,000 1,000 $30,000 8 Level of Activity 7,500 $ 2.200 3,000 $ 5,200 20 $ 1.200 $ 1.200 20,000 $ 2.000 $ 2.000 $ 6,000 500 100 $ 6.600 $45,000 3,750 1,250 $37,500 12 $ 3,300 4.500 $ 7,800 30 $ 1.800 $ 1,800 30,000 $ 3,000 $ 3.000 $ 6,000 500 100 $ 6.600 $56,700 9,000 $18,000 3,000 3,000 9,000 6,000 4.500 1.500 $45,000 16 $ 4.400 6,000 $10,400 40 $ 2.400 $ 2,400 40,000 $ 4,000 $ 4,000 $ 6,000 500 100 S 6.600 $68,400
Exhibit 11-3 Flexible Overhead Budget DC desserts 08 FILE F29 12345678 HOME INSERT PAGE LAYOUT FORMULAS 9 10 11 12 13 14 15 16 17 1 X ✓ fx-17-28 5 Budgeted Overhead Costs A 7 Variable overhead costs: Indirect material: READY Nonstick cooking spray Waxed paper Other paper products Miscellaneous supplies Indirect labor: maintenance Utilities Electricity Natural gas Total variable overhead cost 18 19 Fixed overhead costs: 20 Indirect labor. 21 Inspection 22 Production supervisors 23 24 25 Depreciation: plant and equipment 26 Insurance and property taxes 27 Setup specialists Material handling Test kitchen 28 Total fixed overhead cost 29 Total overhead cost 30 B DCDESSERTS.COM Monthly Flexible Overhead Budget Flexible Overhead Budget DCdesserts-Excel DATA REVIEW VIEW C Cost per Hour 0.33 1.00 0.67 0.50 0.17 $ D $ 6,000 $ 2.00 $ 12,000 $ 15,000 $18,000 0.33 1 01 Process Hours 7,500 2,000 2,000 6,000 4,000 E 2,200 $ 6,000 3,000 2,000 500 100 1,200 $ 15,000 $ 45,000 $ $ H 2,500 2,500 7,500 5,000 3,000 1,000 30,000 $37,500 $45,000 9,000 3,750 1,250 3,000 3,000 9,000 6,000 4,500 1,500 2,200 $2,200 6,000 6,000 3,000 3,000 2,000 2,000 500 500 100 100 1,200 1,200 15,000 $15,000 52,500 $60,000 D 145%
Complete this question by entering your answers in the tabs below. Req 2A Determine the flexible budgeted cost for each item in the table below. a. b. C. d. e. f. Req 1 Indirect material Utilities Inspection Test kitchen Material handling Total overhead cost Req 28 $ 33,000 $ 6,000 $ 4,400 $ 1,800 $ 2,000 $ 47,200 <Req1 Req 2A >
Complete this question by entering your answers in the tabs below. Reg 1 Reg 2A Variance Answer is not complete. Req 2B Compute the variance for setup cost during the month, assuming that the actual setup cost was $3,000. Use the activity- based flexible budget. (Indicate the effect of each variance by selecting "Favorable" or "Unfavorable". Select "None" and enter "0" for no effect (i.e., zero variance).) < Req 1 Req 2B >
Complete this question by entering your answers in the tabs below. Req 1 Answer is not complete. Reg 2A Compute the variance for setup cost during the month, assuming that the actual setup cost was $3,000. Use the activity- based flexible budget. (Indicate the effect of each variance by selecting "Favorable" or "Unfavorable". Select "None" and enter "0" for no effect (i.e., zero variance).) Req 2B- Variance < Req 1 Req 28 >