Submit as an excel document and show your work with formulas

Fill$-$in$-$the$-$Blank Equations

Fill$-$in$-$the$-$Blank Equations

$1.\_\_\_\_\_\_\_\_\_\_=$ Difference in Total Cost $-$: Difference in Units Produced

Variable Cost per Unit

$2.$ Contribution Margin $=$ Sales $\_\_\_\_\_\_\_\_\_\_$

Variable Costs

$3.$ Contribution Margin Ratio $=\_\_\_\_\_\_\_\_\_\_-$: Sales

Contribution Margin

$4.\_\_\_\_\_\_\_\_\_\_=$ Fixed Costs $-$: Unit Contribution Margin

Break$-$Even Sales $($units$)$

$5.$ Sales $($units$)=(\_\_\_\_\_\_\_\_\_\_+$ Target Profit$)-$: Unit Contribution Margin

Fixed Costs

$6.$ Operating Leverage $=$ Contribution Margin $-$: $\_\_\_\_\_\_\_\_\_\_$

Operating Income

$7.$ Margin of Safety $($percent of current sales$)=($Sales $$ Sales at Break$-$Even Point$)-$:$\_\_\_\_\_\_\_\_\_\_$

Sales

$8.$ Margin of Safety $($SAR$)=$ Sales $($SAR$)\_\_\_\_\_\_\_\_\_\_$

Break$-$Even Sales $($SAR$)$

$9.$ The total cost of production for the last four quarters for Moore$$s Mowers is as follows. Use the high$-$low method to determine the variable cost per unit and the fixed cost.

Total Cost Units Produced

Quarter $151,000$ SAR $2,000$

Quarter $256,400$ SAR $2,300$

Quarter $349,200$ SAR $1,900$

Quarter $453,700$ SAR $2,150$

Variable Cost $=\_\_\_\_\_\_\_\_\_\_\_\_\_18$ SAR per unit

Fixed Cost $=\_\_\_\_\_\_\_\_\_\_\_\_15,000$ SAR

$10.$ During $2023,$ Caps by Huely sold $50,000$ finished products with a contribution margin of $55\%.$ The variable costs totaled $40,500$ SAR for the year. Determine the sales, contribution margin, and unit contribution margin.

Sales $=\_\_\_\_\_\_\_\_\_\_\_\_90,000$ SAR

Sales price per unit $=\_\_\_\_\_\_\_\_\_\_\_\_1\mathrm{.}80$ SAR

Variable cost per unit $=\_\_\_\_\_\_\_\_\_\_\_\_(0\mathrm{.}81)$

Contribution margin per unit$=\_\_\_\_\_\_\_\_\_\_\_\_0\mathrm{.}99$ SAR

Contribution margin$=\_\_\_\_\_\_\_\_\_\_\_\_49,500$ SAR

$11.$ If a manufacturing company had a contribution margin of $$65,700$ for $20$Y$5$ from selling $25,000$ products at $6$ SAR each, determine the variable cost per unit, contribution margin ratio, and unit contribution margin. Round unit answers to two decimal places and percentages to the nearest whole percent.

Sales $($SAR$)=\_\_\_\_\_\_\_\_\_\_\_\_$ $$150,000$

Contribution margin $=\_\_\_\_\_\_\_\_\_\_\_\_(65,700)$

Total variable cost$=\_\_\_\_\_\_\_\_\_\_\_\_$ $ $84,300$

Variable cost per unit$=\_\_\_\_\_\_\_\_\_\_\_\_$ $$3\mathrm{.}37$

Unit contribution margin$=\_\_\_\_\_\_\_\_\_\_\_\_$ $$2\mathrm{.}63$

Contribution margin ratio $=\_\_\_\_\_\_\_\_\_\_\_\_44\%$

$12.$ Determine the change in operating income for each situation for a company that has an increase in total sales of $$52,000.$

a$.$ Unit contribution margin of $$4\mathrm{.}50$ and each product selling for $$8.$

$=\_\_\_\_\_\_\_\_\_\_\_\_$$$29,250$

b$.$ Contribution margin ratio of $24\%$ and each product selling for $$10.$

$=\_\_\_\_\_\_\_\_\_\_\_\_$$$12,480$

c$.$ Unit contribution margin of $$6,$ with total variable costs of $$25,000$ at $$5$ per unit.

$=\_\_\_\_\_\_\_\_\_\_\_\_$$$30,000$

$13.$ After incurring an operating loss of $$(6,000)$ in $20$Y$5,$ the production manager would like to know the break$-$even point in sales and units for the company. During $2023,$ the company sold $6,000$ at $$3$ each. Variable costs for the year totaled $$10,800.$ Determine the sales and units sold that were needed to break even.

Sales $=\_\_\_\_\_\_\_\_\_\_\_\_200,000$ SAR

Variable costs $=\_\_\_\_\_\_\_\_\_\_\_\_(80,000)$

Contribution margin $=\_\_\_\_\_\_\_\_\_\_\_\_120,000$ SAR

Fixed costs$=\_\_\_\_\_\_\_\_\_\_\_\_(50,400)$

Operating income $=\_\_\_\_\_\_\_\_\_\_\_\_69,600$ SAR

$14.$ A tire manufacturer sells its finished goods for $80$ SAR each. The variable cost to manufacture each product is $20$ SAR, while fixed costs equal $20,700$ SAR. In $2022,$ the company earned operating income of $32,100$SAR. In $2023,$ the CEO would like to increase operating income by $5\%.$ Determine the sales in dollars and units needed to achieve the CEO$$s goal. Round answers to the nearest whole number.

Target Profit $=\_\_\_\_\_\_\_\_\_\_\_\_33,705$SAR $=32,100$SAR $\backslash$times $1\mathrm{.}05$

Sales $($units$)=\_\_\_\_\_\_\_\_\_\_\_\_907$ units $=(20,700$SAR $+33,705$SAR$)-$: $$60$

Sales $($dollars$)=\_\_\_\_\_\_\_\_\_\_\_\_$ $$72,540=(20,700$SAR $+33,705$SAR$)-$: $75\%,$ or $907$ units $\backslash$times $80$SAR per unit

Submit as an excel document for faculty grading.

$*$Due to rounding, the two methods will differ by $$20$ in sales.

$15.$Prepare a cost$-$volume$-$profit chart for a company that has an $80\%$ contribution margin for goods that it sells for $$150$ each. The company$$s fixed costs total $$54,000.$ Also, determine the break$-$even point in units and sales.

Break$-$Even Point $($units$)=\_\_\_\_\_\_\_\_\_\_\_\_450$ units $=$ $$54,000-$: $$120$ per unit

Break$-$Even Point $($sales$)=\_\_\_\_\_\_\_\_\_\_\_\_$ $$67,500=$ $$54,000-$: $80\%,$ or $450$ units $\backslash$times $$150$ per unit

Submit as an excel document with cost$-$volume$-$profit chart for faculty grading. please soleve it and make sure iscorrect