The following static budget is provided: Static Budget Per Unit Total at 15,000 units Sales $60...

The following static budget is provided:

Static Budget	Per Unit	Total at 15,000 units
Sales	$60	$900,000
Less variable costs:
Manufacturing costs	(30)	(450,000)
Selling and administrative costs	(10)	(150,000)
Contribution margin	$20	$300,000
Less fixed costs:
Manufacturing costs		(75,000)
Selling and administrative costs		(125,000)
Total fixed costs		(200,000)
Net income		$100,000

A. What will be the net income at flexible budget at 13,000 units produced and sold?

B. What will be the flexible budget contribution margin when 13,000 units are produced and sold?

C. What will be the flexible budget sales variance if 13,000 units are produced and sold?

Expert Solution

a)Net Income = [Number of units *contribution margin per unit ]-Fixed cost

= [13000 * 20] -200000

= 260000-200000

= $ 60000

b)Contribution margin = Number of units *contribution margin per unit

= 13000 * 20

= 260000

c)Flexible budget sales variance = Sales in flexible budget -sales in static budget

= (13000*60)- 900000

= 780000-900000

= -120000 U (enter as 120000 U ,if needs to be entered as positive value)

ekkarill92 answered 1 year ago

Problem 2 Total Per Unit Percent of Sales Sales (40,000 units) 2,400,000 60 100% Variable expenses...

Problem 2 Total Per Unit Percent of Sales Sales (40,000 units) 2,400,000 60 100% Variable expenses 1,600,000 40 ? % Contribution margin 800,000 ? % Fixed expenses 500,000 Net operating income 300,000 Calculate variable expense ratio. Calculate contribution margin ratio. Calculate break even sales in units (show your work). Calculate break even sales in Dollars. How many units must be sold to make a profit of SAR 200,000. Management is considering increasing quality of its units by spending SAR 3...

Rickard Enterprises—March Budget FACTS Total Sales per Quarter (sales are even per month) Quarter Units Price/Unit...

Rickard Enterprises—March Budget FACTS Total Sales per Quarter (sales are even per month) Quarter Units Price/Unit Q1 4,200 $18 Q2 6,600. $21 Q3 5,900 $20 Q4 9,700 $22 March Inventory Beginning Desired Ending Raw materials inventory (in lbs.) 1,120 1,760 Raw materials inventory (in $) $8,960 $14,080 Finished goods (FG) inventory (in units) 280 440 Finished goods inventory (in $) $41,500 $34,500 20% (safety stock desired) Other Information: Pounds of materials needed to produce each unit of FG 4...

You are given the following static budget report: Budget Actual Variance Unit Sales &nbsp

You are given the following static budget report: Budget Actual Variance Unit Sales 10,000 15,000 5,000 F Variable Expenses: Commissions $30,000 $33,000 $3,000 U Advertising $1,000 $1,200 $200 U Travel $10,000 $11,000 $1,000 U Samples $2,500 $2,300 $200 F Total Variable $43,500 47,500 $4,000 U Fixed Expenses Rent $5,000 $5,000 0 Salaries – Sales $2,000 $2,000 0 Salaries – Office $1,200 $1,200 0 Depreciation $1,500 $1,500 0 Total Fixed $9,700 $9,700 0 Total Expenses $53,200 $57,200 $4,000 U Prepare a flexible budget analysis and explain whether you believe that costs were controlled. How do the results of...

CVP Analysis Data Unit sales 20,000 units Selling price per unit $60 per unit Variable...

CVP Analysis Data Unit sales 20,000 units Selling price per unit $60 per unit Variable expenses per unit $45 per unit Fixed expenses $240,000 Enter a formula into each of the cells marked with a ? below Review Problem: CVP Relationships Compute the CM ratio and variable expense ratio Selling price per unit ? per unit Variable expenses per unit ? per unit Contribution margin per unit ? per unit CM ratio ? Variable expense ratio ? Compute the...

Data 4 Unit sales 30,000 units 5 Selling price per unit $60 per unit 6 Variable...

Data 4 Unit sales 30,000 units 5 Selling price per unit $60 per unit 6 Variable expenses per unit $30 per unit 7 Fixed expenses $810,000 What is the break-even in dollar sales? (b) What is the margin of safety percentage? (c) What is the degree of operating leverage? (Round your answer to 2 decimal places.) 3. Using the degree of operating leverage and without changing anything in your worksheet, calculate the percentage change in net operating...

No of units Fixed costs Total variable costs Total Costs Total Sales 0 15,000 0 15,000 ...

No of units Fixed costs Total variable costs Total Costs Total Sales 0 15,000 0 15,000 0 50 15,000 10,500 25,500 15,000 100 15,000 21,000 36,000 30,000 150 15,000 31,500 46,500 45,000 200 15,000 42,000 57,000 60,000 250 15,000 52,500 67,500 75,000 300 15,000 63,000 78,000 90,000 Create a CVP graph.

1.A company has provided the following data: Sales 12,000 units Sales price $100 per unit Variable...

1.A company has provided the following data: Sales 12,000 units Sales price $100 per unit Variable cost $50 per unit Fixed cost $300,000 If the dollar contribution margin per unit is increased by 10%, total fixed cost is decreased by 20%, and all other factors remain the same, by how much will net income increase? 2. Hamada Company sells a single product. The product has a selling price of $100 per unit and variable expenses of 80% of sales. If the...

Cash Budget: Estimated sales January February March April May Total Coffee sales (units) 15,000 16,000 17,500...

Cash Budget: Estimated sales January February March April May Total Coffee sales (units) 15,000 16,000 17,500 18,000 14,500 Your friend, Chris Coffee, has been running a successful coffee shop for the last couple of years. He has asked you to put together a cash budget. His regular accountant was too busy to help, but told Chris his depreciation expense was going to be $1,800 per year, using the straight-line method. He has supplied you with the following information (above) to...

The current sales of a company are 5000 units at $65 per unit. Total variable expenses...

The current sales of a company are 5000 units at $65 per unit. Total variable expenses and fixed expenses are $200,000 and $104,800 respectively. If sales unit increase by 4% and fixed expenses remain unchanged, estimate the percentage change in net operating income. a. 80.16% b. 24.75% c. 25% d. 4%

Reflector Glass Company prepared the following static budget for the year: Static Budget Units/Volume 6 comma...

Reflector Glass Company prepared the following static budget for the year: Static Budget Units/Volume 6 comma 0006,000 Per Unit Sales Revenue $ 5.00$5.00 $ 30 comma 000$30,000 Variable Costs 1.501.50 9 comma 0009,000 Contribution Margin 21 comma 00021,000 Fixed Costs 4 comma 0004,000 Operating Income/(Loss) $ 17 comma 000$17,000 If a flexible budget is prepared at a volume of 8 comma 9008,900 units, calculate the amount of operating income. The production level is within the relevant range. A. $ 4...

Question