PLEASE PROVIDE ANSWERS IN FORMULAS ONLY!

FORMULAS

FORMULAS!

File Home Insert Draw Page Layout Formulas Data Review View Help Search X Arial 11 A A 2 Wrap Text Paste BIU Merge de Center $ -% 88 Conditional fie Formatting Clipboard Font Alignment Number Sty C22 fr A D E B Name: F Your score Jozif Mansor G 0% 1 2 Jozif Mansor Company's fixed budget for the upcoming year is based on sales and production of 11,250 units. This represents 75% of its productive capacity of 15,000 units. The budgeted selling price is $280 per unit. Variable costs are budgeted to be $200 per unit. Total budgeted fixed costs are $590,000. Prepare a flexible budget at 65% and 85% of productive capacity 3 4 5 6 7 Jozit Mansor Company Fixed Budget For the year ended December 31, 2021 Per Unit Sales $280 Variable costs 200 Contribution margin $80 Fixed Expenses Operating Income 9 10 Total $3,150,000 2.250.000 900,000 590,000 $310.000 11 12 13 14 15 16 Productive Capacity 15,000 units Productive Capacity 15,000 units 5 7 8 9 Jozif Mansor Company Flexible Budget For the year ended December 31, 2021 % of productive capacity 65% Units produced and sold 85% 75% 11,250 0 1 22 23 24 25 26 27 28 29 30 31 32 Sales Variable costs Contribution margin Fixed expenses Operating income $3,150,000 2.250.000 900,000 590,000 $310,000