Tasteez is preparing their 2018 budget. They want to prepare a flexible budget for use each...

 

Transcribed Image Text:

Tasteez is preparing their 2018 budget. They want to prepare a flexible budget for use each month. They estimate sales/production will be between 1,500,000 and 2,000,000 boxes of frozen TV dinners per month. Monthly Budget Data for Question 1: Selling price per unit: Ingredient Costs Packaging Costs Salary and Wages Costs OT for production over 1,750,000 units Fringe Benefits Electricity Waste and Other Costs Rent Costs Insurance Costs Depreciation Costs $6.00 per box $2.00 per box $0.75 per box $300,000 per month $1.00 per box 50% of Wages and OT $0.20 per box $0.15 per box $350,000 per month $50,000 per month $150,000 per month Question 1: Prepare a flexible budget in Excel for Tasteez. a) show the flexible budget based on 1,500,000 units (boxes) produced. b) show the flexible budget based on 2,000,000 units (boxes) produced. c) Show the flexible budget cost formulas for Tasteez TV dinners. d) Explain the benefit of flexible budgets and when they should be used. Tasteez is preparing their 2018 budget. They want to prepare a flexible budget for use each month. They estimate sales/production will be between 1,500,000 and 2,000,000 boxes of frozen TV dinners per month. Monthly Budget Data for Question 1: Selling price per unit: Ingredient Costs Packaging Costs Salary and Wages Costs OT for production over 1,750,000 units Fringe Benefits Electricity Waste and Other Costs Rent Costs Insurance Costs Depreciation Costs $6.00 per box $2.00 per box $0.75 per box $300,000 per month $1.00 per box 50% of Wages and OT $0.20 per box $0.15 per box $350,000 per month $50,000 per month $150,000 per month Question 1: Prepare a flexible budget in Excel for Tasteez. a) show the flexible budget based on 1,500,000 units (boxes) produced. b) show the flexible budget based on 2,000,000 units (boxes) produced. c) Show the flexible budget cost formulas for Tasteez TV dinners. d) Explain the benefit of flexible budgets and when they should be used.