Revenues | Variable Costs | Contribution Margin | Fixed Costs | Budgeted Operating Income | |
Original | $10300000 | $7700000 | $2600000 | $1500000 | $1100000 |
1. | $10300000 | (10300000-2834000)= 7466000 | (2600000*1.09)= 2834000 | 1500000 | 1334000 |
2. | $10300000 | (10300000-2366000)= 7934000 | (2600000*0.91)= 2366000 | 1500000 | 866000 |
3. | $10300000 | 7700000 | 2600000 | (1500000*1.03)= 1545000 | 1055000 |
4. | $10300000 | 7700000 | 2600000 | (1500000*0.97)= 1455000 | 1145000 |
5. | (10300000*1.08)= 11124000 | (7700000*1.08)= 8316000 | 2808000 | 1500000 | 1308000 |
6. | (10300000*0.92)= 9476000 | (7700000*0.92)= 7084000 | 2392000 | 1500000 | 892000 |
7. | (10300000*1.09)= 11227000 | (7700000*1.09)= 8393000 | 2834000 | (1500000*1.09)= 1635000 | 1199000 |
8. | $10300000 | (7700000*0.97)= 7469000 | 2831000 | (1500000*1.03)= 1545000 | 1286000 |
Alternative 1 yields the highest budgeted operating income because it has highest contribution margin margin without any increase in fixed costs.
Variable costs change based on the number of doughnuts sold. The Amazing Donut owns and operates...
please complete all 9 parts and highlight answer key. Thank you The Ultimate Donut owns and operates sex doughnut outlets in and around Kansas City. You are given the Variable costs change based on the number of doughnuts sold following corporate budget data for next year Requirement Click the icon to view the corporate budget data) Compute the budgeted operating income for each of the following deviations from the original budget data Consider cach case independently) Click the icon to...
i Cost-Volume-Profit Analysis CVP exercises The Dell-Sub Shop owns and operates six stores in and around Minneapolis. You are given the following corporate budget data for next year: Revenues Fixed costs Variable costs $11,000,000 $3,000,000 $7,500,000 10 Variable costs change based on the number of subs sold. 12 Use the blue shaded areas on the ENTERANSWERS tab for inputs. Always use cell references and formulas where appropriate to receive full credit. Cell references and formulas should be based on the...
Revenues $ 500,000 250,000 250,000 $ Cost of goods sold (all variable costs) Gross margin Operating costs: Salaries fixed Sales commissions (9% of sales) Depreciation on equipment and fixtures Store rent ($4,500 per month) Other operating costs 190,000 45,000 14,000 54,000 50,000 353,000 $ (103,000) Operating income (loss) Neylon Men's Clothing's revenues and cost data for 2017 are as follows: Click the icon to view the data.) Mr. Neylon, the owner of the store, is unhappy with the operating results....
Variable Fixed Total Operating Contribution Case Revenues Costs Costs Costs Income Margin Percentage a. $400 $900 $1,100 b. $2,800 $500 $700 c. $1,200 $700 $1,200 d. $1,800 $500 50 % (For entries with a $0 balance, make sure to enter "0" in the appropriate cell. Round the contribution margin percentage to the nearest whole percent.) Variable Fixed Total Operating Contribution Case Revenues Costs Costs Costs Income Margin Percentage a. $400 $900 $1,100 % Fill in the blanks for each of...
Problem Company prepared the following budget for the year based on 1,000 units sold: Variable costs 450,000 Contribution margin 300,000 Fixed costs 200,000 Operating income 100,000 Actual results for the year were : Units sold 950 Sales $703,000 Variable costs 432,250 Contribution margin 270,750 Fixed costs 185,000 Operating income 5, 750 Required: prepare a static and flexible budget for the year. Prepare a budget for the next year with 1,100 units sols and a 10% increase in fixed costs
400 600 750 Number of Canoes Produced and Sold Total costs Variable costs Fixed costs Total costs Cost per unit Variable cost per unit Fixed cost per unit Total cost per unit $ 54,000 60,000 $114,000 $ 81,000 60,000 $ 141,000 $ 101,250 60,000 $ 161,250 $ 135.00 150.00 $ 285.00 $ 135.00 $ 135.00 100.00 80.00 $ 235.00 $ 215.00 Riverside sells its canoes for $370 each. Next year Riverside expects to sell 1,000 canoes. Required: Complete the Riverside's...
Number of Canoes Produced and Sold 450 650 800 Total costs Variable costs $ 63,000 $ 91,000 $112,000 Fixed costs 187,200 187,200 187,200 Total costs $250,200 $278,200 $299,200 Cost per unit Variable cost per unit $ 140.00 $ 140.00 $ 140.00 Fixed cost per unit 416.00 288.00 234.00 Total cost per unit $ 556.00 $ 428.00 S 374.00 Riverside sells its canoes for $700 each. Next year Riverside expects to sell 1,000 canoes. Required: Complete the Riverside's contribution margin income...
7) Total Variable cost = Number of units sold x variable cost per unit 8) Operating Leverage = Contribution Margin / Net Income Complete the below table: Sales Variable Cost Total Contribution Margin Fixed Costs Operating Income Break-even Sales Revenue 150,000 125,000 50,000 B 85,000 35,000 15,000 75,000 65,000 113,750 D 180,000 50,000 144,000 Remember: 1) Variable costs rise and fall with an increase or decrease in revenue 2) Fixed costs do not rise and fall with an increase or...
400 600 750 Number of Canoes Produced and sold Total costs Variable costs Fixed costs Total costs Cost per unit Variable cost per unit Fixed cost per unit Total cost per unit $ 54,000 60,000 $114,000 $81,000 60,000 $ 141,000 $101,250 60,000 $161,250 $ 135.00 150.00 $ 285.00 $135.00 100.00 $ 235.00 $135.00 80.00 $ 215.00 Riverside sells its canoes for $370 each. Next year Riverside expects to sell 1,000 canoes. Required: Complete the Riverside's contribution margin income statement for...
Chapter 2: Applying Excel Data Sales $12,000 Variable costs: Cost of goods sold Variable selling $6,000 $600 $400 Variable administrative Fixed costs: Fixed selling $2,500 $1,500 Fixed administrative Enter a formula into each of the cells marked with a ? below Exhibit 2-9 Traditional Format Income Statement Sales Cost of goods sold Gross margin Selling and administrative expenses: Selling Administrative Net operating income Contribution Format Income Statement Sales Variable expenses: Cost of goods sold Variable selling Variable administration Contribution margin...