Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Can someone please help me with this assignment below. Thanks so much! Using the Flexible Budget sample in Chapter 23 as your guide, create a
Can someone please help me with this assignment below. Thanks so much!
Using the Flexible Budget sample in Chapter 23 as your guide, create a flexible budget with two levels of activity.
At a minimum, each level of activity in your budget should have: Sales, Variable Costs, Contribution Margin, Fixed Costs, Operating Income."
I have attached the Chapter 23 Flexible Budget Example:
Exhibit 23-3 Flexible Budget CHEERFUL COLORS Flexible Budget For the Year Ended December 31, 2019 Budget Amounts per Unit Units (Batches of 100) 48,000 50,000 52,000 $7.50 $360,000 375,000 $390,000 Sales Revenue Variable Costs Manufacturing: Direct Materials 1.75 84,000 87,500 91,000 Direct Labor 3.00 144,000 150,000 156,000 Variable Overhead 0.75 36,000 37,500 39,000 Selling and Administrative Supplies 5% of sales 18,000 18,750 19,500 Total Variable Costs 282,000 293,750 305,500 Contribution Margin 78,000 81,250 84,500 Fixed Costs: Manufacturing 25,000 25,000 25,000 Selling and Administrative 22,500 22,500 22,500 Total Fixed Costs 47,500 47,500 47,500 $ 30,500 $ 33,750 37,000 Operating Income Exhibit 23-3 Flexible Budget CHEERFUL COLORS Flexible Budget For the Year Ended December 31, 2019 Budget Amounts per Unit Units (Batches of 100) 48,000 50,000 52,000 $7.50 $360,000 375,000 $390,000 Sales Revenue Variable Costs Manufacturing: Direct Materials 1.75 84,000 87,500 91,000 Direct Labor 3.00 144,000 150,000 156,000 Variable Overhead 0.75 36,000 37,500 39,000 Selling and Administrative Supplies 5% of sales 18,000 18,750 19,500 Total Variable Costs 282,000 293,750 305,500 Contribution Margin 78,000 81,250 84,500 Fixed Costs: Manufacturing 25,000 25,000 25,000 Selling and Administrative 22,500 22,500 22,500 Total Fixed Costs 47,500 47,500 47,500 $ 30,500 $ 33,750 37,000 Operating IncomeStep by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started