a spreadsheet: Construct an Excel spreadsheet to solve requirements 1, 2 and above Show how the solution will change if the following information changes the selling price is $17 and the annual fixed costs are $640.000 (CMA adapted Problem 7-35 Basic CVP Computations (LO 7-1,7-2, 7-4) 2. Sales units required for $180,000 income: 54,000 units College Pak Company produced and sold 60,000 backpacks during the year just ended at an average price of $20 per unit. Variable manufacturing costs were per unit, and variable marketing costs were $4 per unit sold. Fixed costs amounted to $180,000 for manufacturing and $72,000 for marketing. There was no year-end work-in-process inventory. (Ignore income taxes.) Required: 1. Compute CollegePak's break-even point in sales cours for the year. 2. Compute the number of sales units required to earn a net income of $180,000 during the year, 3. College Pak's variable manufacturing costs are expected to increase by 10 percent in the coming year. Compute the firm's break-even point in sales dollars for the coming year. 4. If College Pak's variable manufacturing costs do increase by 10 percent, compute the selling price that would yield the same contribution-margin ratio in the coming year. CMA adapted) Problem 7-36 Corrigan Enterprises is studying the acquisition of two electrical component insertion systems for Datelevant to the Systems follow