Question

In: Accounting

Assuming the rotomolded line is treated as a cost center, prepare a flexible budget report for...

Assuming the rotomolded line is treated as a cost center, prepare a flexible budget report for manufacturing for the quarter ended March 31, 2020, when 1,050 units were produced. (List variable costs before fixed costs. Round answers to 2 decimal places, e.g. 5,275.25.)The Current Designs staff has prepared the annual manufacturing budget for the rotomolded line based on an estimated annual production of 4,000 kayaks during 2020. Each kayak will require 54 pounds of polyethylene powder and a finishing kit (rope, seat, hardware, etc.). The polyethylene powder used in these kayaks costs $1.50 per pound, and the finishing kits cost $170 each. Each kayak will use two kinds of labor—2 hours of type I labor from people who run the oven and trim the plastic, and 3 hours of work from type II workers who attach the hatches and seat and other hardware. The type I employees are paid $15 per hour, and the type II are paid $12 per hour.

Manufacturing overhead is budgeted at $396,000 for 2020, broken down as follows.

Variable costs
   Indirect materials $40,000
   Manufacturing supplies 53,800
   Maintenance and utilities 88,000
181,800
Fixed costs
   Supervision 90,000
   Insurance 14,400
   Depreciation 109,800
214,200
Total $396,000


During the first quarter, ended March 31, 2020, 1,050 units were actually produced with the following costs.

Polyethylene powder $87,000
Finishing kits 178,840
Type I labor 31,500
Type II labor 39,060
Indirect materials 10,500
Manufacturing supplies 14,150
Maintenance and utilities 26,000
Supervision 20,000
Insurance 3,600
Depreciation 27,450
   Total $438,100

Assuming the rotomolded line is treated as a cost center, prepare a flexible budget report for manufacturing for the quarter ended March 31, 2020, when 1,050 units were produced. (List variable costs before fixed costs. Round answers to 2 decimal places, e.g. 5,275.25.)

Solutions

Expert Solution

Answer is given below


Related Solutions

P11.51B   Prepare a flexible budget, budget report, and graph for manufacturing overhead. (LO 2, 3) Finesse...
P11.51B   Prepare a flexible budget, budget report, and graph for manufacturing overhead. (LO 2, 3) Finesse Company manufactures tablecloths. Sales have grown rapidly over the past two years. As a result, the president has installed a budgetary control system for 2020. The following data were used in developing the master manufacturing overhead budget for the ironing department. The budget is based on an activity index of direct labour hours. Variable Costs Rate per Direct Labour Hour Annual Fixed Costs Indirect...
Determine the budget for the department, assuming that it uses flexible budgeting.
At the beginning of the period, the Assembly Department budgeted direct labor of $120,000 and property tax of $16,000 for 5,000 hours of production. The department actually completed 5,600 hours of production. Determine the budget for the department, assuming that it uses flexible budgeting.
How do you prepare a flexible budget?
How do you prepare a flexible budget?
Prepare a flexible budget and show variances for the year that passed. Indicate whether the flexible...
Prepare a flexible budget and show variances for the year that passed. Indicate whether the flexible budget variances are favorable or unfavorable. Headquarters are contemplating charging each store a 5% marketing expense based on sales. How will that affect the operating profit of the store and the money available for managerial bonuses based on actual results for the past year? Summarize the information in a table. (INFORMATION PROVIDED BELOW) T&P Fashion Shops is a new chain that operates 10 stores...
Exercise 9-14 Prepare a Flexible Budget Performance Report [LO9-4] Lavage Rapide is a Canadian company that...
Exercise 9-14 Prepare a Flexible Budget Performance Report [LO9-4] Lavage Rapide is a Canadian company that owns and operates a large automatic car wash facility near Montreal. The following table provides data concerning the company’s costs: Fixed Cost per Month Cost per Car Washed Cleaning supplies $ 0.80 Electricity $ 1,200 $ 0.09 Maintenance $ 0.15 Wages and salaries $ 4,500 $ 0.40 Depreciation $ 8,200 Rent $ 1,800 Administrative expenses $ 1,600 $ 0.02 For example, electricity costs are...
How to prepare a flexible budget for different levels of activity
How to prepare a flexible budget for different levels of activity
Peter’s Pretzels is preparing their 2018 budget. They want to prepare a flexible budget for use...
Peter’s Pretzels is preparing their 2018 budget. They want to prepare a flexible budget for use each month. They estimate sales/production will be between 700,000 and 900,000 boxes of pretzels per month. Monthly budget data                      Selling price of pretzels $5.00    per box Ingredient cost $1.50    per box Packaging cost   $0.50    per box Salary and wages cost    $270,000.00 per month Overtime for production over 800,000 units         $1.00    per box Fringe benefits 50% of wages and overtime...
Exercise 9-14 (Algo) Prepare a Flexible Budget Performance Report [LO9-4] Lavage Rapide is a Canadian company...
Exercise 9-14 (Algo) Prepare a Flexible Budget Performance Report [LO9-4] Lavage Rapide is a Canadian company that owns and operates a large automatic car wash facility near Montreal. The following table provides data concerning the company’s costs: Fixed Cost per Month Cost per Car Washed Cleaning supplies $ 0.60 Electricity $ 1,100 $ 0.10 Maintenance $ 0.15 Wages and salaries $ 4,900 $ 0.30 Depreciation $ 8,100 Rent $ 2,200 Administrative expenses $ 1,800 $ 0.03 For example, electricity costs...
Exercise 9-4 Prepare a Flexible Budget Performance Report [LO9-4] Vulcan Flyovers offers scenic overflights of Mount...
Exercise 9-4 Prepare a Flexible Budget Performance Report [LO9-4] Vulcan Flyovers offers scenic overflights of Mount St. Helens, the volcano in Washington State that explosively erupted in 1982. Data concerning the company’s operations in July appear below: Vulcan Flyovers Operating Data For the Month Ended July 31 Actual Results Flexible Budget Planning Budget Flights (q) 57 57 55 Revenue ($355.00q) $ 16,400 $ 20,235 $ 19,525 Expenses: Wages and salaries ($3,500 + $89.00q) 8,535 8,573 8,395 Fuel ($30.00q) 1,880 1,710...
Exercise 9-4 Prepare a Flexible Budget Performance Report [LO9-4] Vulcan Flyovers offers scenic overflights of Mount...
Exercise 9-4 Prepare a Flexible Budget Performance Report [LO9-4] Vulcan Flyovers offers scenic overflights of Mount St. Helens, the volcano in Washington State that explosively erupted in 1982. Data concerning the company’s operations in July appear below: Vulcan Flyovers Operating Data For the Month Ended July 31 Actual Results Flexible Budget Planning Budget Flights (q) 55 55 53 Revenue ($355.00q) $ 16,300 $ 19,525 $ 18,815 Expenses: Wages and salaries ($3,200 + $86.00q) 7,898 7,930 7,758 Fuel ($31.00q) 1,873 1,705...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT