Also enter the necessary formulas but leave the Units Sol mine the breakeven number of units. Create a second CVP analysis tab and use Goal Seek determine the required unit sales to achieve a net income of $8,500. Create a third CVP analysis tab that assumes unit sales equal to those calculated in the second CVP analysis. Assume that fixed costs cannot change, sales revenue per unit cannot exceed $54, variable costs per unit cannot fall below $30, and contribution margin as a percentage of sales revenue cannot exceed 40%. Name each CVP tab appropriately. Lastly, for each CVP analysis, freeze the three-line header at the top EA10-E2 Prepare Budgets and a CVP Analysis for KPF Industries In this exercise, you will prepare cash and purchases budgets and CVP analyses for KPF Industries. You will first create a cash budget, adjusting its appearance to facilitate data examination. You will then create a purchases budget and adjust print settings to ensure readability and ease of use. Lastly, you will use Goal Seek and Solver to create three CVP analyses. Open EA10-E2-Budget. On the Cash Budget tab, create a cash budget based on a beginning cash balance of $9.400 and this data: Quarter #4 Quarter #3 Quarter #1 Quarter #2 $37.200 $23,100 $28,600 $31,300 $3,700 $6,300 $1,300 $5,100 $1,200 $4,200 $1,300 $1,550 $850 SO SO Cash Receipts from In-Store Customer Sales Cash Receipts from Online Sales Cash Receipts from Services Rendered Sale of Fixed Assets Cash Disbursements for Merchandise Purchases Cash Disbursements for Operating Expenses Loan Payments (Principal) Loan Payments Interest) $0 $13,500 $21,600 $22,700 $23,200 $15,000 $16,200 $18.500 $18,000 SO $1,500 $1,500 SO $1,500 $320 $320 $320