NEED THE FORMULAS FOR THE BOLDED AND BLANK YELLOW CELLS PLEASE!

G K M N D P R S T. BreakEven Analysis 165,000 24000 Per Unit Information Break Even 29,354 () of Haxes 175,152 (9] Sales Revenue 23,500 150.000 23,000 7.50 [41 5.45 (51 2.05 [6]CM per unit 22.500 175.000 22,000 C170.00 21.500 21,320 IM Per Unit Information 6165,000 2015 Break Even 23,354 Nof Hoxes 175,152 Sales Revenue 20,000 100.000 7.50 (13) 5.45 (14) 2.05 [15]CM per unit 19.500 11 155.000 19000 16.646 16] #of Boxes 41.62% [17] [18+15)- 18,500 C 150.000 Hof Sales Revenue SE 1 S 21 175.252 Scenaria 2 2114 175,152 Schwin SE 2154 175,152 Scerris Scarins 20172 20072 181,579 C162,970 2007 173,049 Per Unit Information A D E 1 Insert formulas and cell references into the "gold" cells below. 2 3 Scenario 1 Contributian Margin Statement Ratios 30,000 boxes sald Sales Revenues t 225,000 7 Variable Expense 163,500 72.67% 121 8 Contribution Margin 61,500 27.33% [1] 9 Fixed Expenses 47.875 10 Net Operating Income 13,625 6.06% [3] 11 12 Scenario 2 13 Contribution Margin Statement Ratios 14 40,000 boxes sold 15 Sales Revenues 300,000 16 Variable Expense t 218.000 72.67% (10) 17 Contribution Mergin 92,000 27.32% 9) 18 Fixed Expenses 47,975 19 Net Operating Income[11] 34,125 11.38% [12] 20 21 Scenario 3 22 Contribution Margin Statement Ratios 23 20,000 boxes sold 24 Sales Revenues 150,000 25 Variable Expense 109,000 72.67% 26 Contribution Margin 41,000 27.33% 27 Fixed Expenses t 47.875 28 Net Operating Income (18) 6,975 4.58% (19) 29 30 Scenario 4 31 Contribution Margin Statement Ratios 32 33,000 boxes sold 33 Sales Revenues 244,200 34 Variable Expense 6186 450 76.35% 35 Contribution Margin 57,750 23.65% (24) 36 Fixed Expenses 47.875 37 Net Operating Income (22] 9,875 4.04% 38 39 Scenarios 40 Contribution Margin Statement Ratios 41 30,000 boxes sold 42 Sales Revenues 240,000 43 Variable Expense 169,000 44 Contribution Margin 45 Fixed Expenses 60 46 Net Operating income (25) 0.00% [27] Break Even 23,354 of Boxes 175,152 Sales Revenue 7.50 65.45 2.05 CM per unit Target Profit CS0,000 47,744 (20)#of Hoxes 358,079 21]Sales Revenue Net Operating Income Analysis 14.00% 12.00% 1000% Per Unit Information Break Even [23] 20,372 # of Boxes 181,679 Sales Revenue 8.00 . C 35,000 130,000 25,000 20,000 2000 15,000