please include formulas

A B E F 1 0% Name: johnny Your score: Johnny 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 8 Johnny Company Fixed Budget For the year ended December 31, 2021 Per Unit Sales $280 Variable costs 200 Contribution margin $80 Fixed Expenses Operating Income Total $3,150,000 2,250,000 900,000 590,000 $310,000 Productive Capacity 15,000 units 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 Johnny Company Flexible Budget For the year ended December 31, 2021 % of productive capacity 65% Units produced and sold 85% 75% 11,250 Sales Variable costs Contribution margin Fixed expenses Operating income $3,150,000 2.250,000 900,000 590,000 $310.000