CVP analysis

Sales Revenue Per Unlt S40 Variable costs Per Unit $31 Fixed Costs S151,875 @yr . Create formulas in the appropriate locations forall remaining elements except Units Sold which should remain blank. Use Goal Seek to determine the breakeven unit sales. - Create a second CVP Analysis tab (namedappropriately) and use Goal Seek to deter mine unit sales necessary to generate a net income of $72,000. . Create a third CVP Analysis tab (named appropriately) and use Solver to determine the maximum net income if all of the following apply: unit sales remain the samme as those in the second CVP analysis, sales revenue per unit cannot exceed $43, variable costs per unit cannot fall below $28, fixed costs cannot fall below $150,000, and contribution margin as a percentage of sales revemue cannot exceed 34% Total Per Unit Sales Revenue Variable Costs Contribution Margin Fixed Costs Net Income Units Sold