Exercise 3-12B Comprehensive CVP Analysis, BT Use Exhibit 3.3 shown in the body of the chapter to answer the following questions. Required a. Determine the mix of sales volume, fixed cost, and variable cost per unit required to produce a desired profit of $82,000. b. Determine the expected profit if Bright Day projects the following data for Delatine: sales, 5,000 bottles; fixed cost, $30,000; and variable cost per unit, $12. c. Bright Day is considering new circumstances that would change the conditions described in Requirement b. Specifically the company has an opportunity to decrease fixed cost to $20,000 if it agrees to conditions that will increase variable cost to $13. Volume is expected to remain constant at 5,000 bottles. Determine the effects on the company's profitability if this opportunity is accepted. Spreadsheet Report to Facilitate "What-It Analysis De 1-A wote Co- to outer - EU BY - R Cena - S.% Con est ogwe Dede for - 619 ETE G H A B C D Selling Price = $ 28.00 While Variable Cost 2,000 Fixed Cost And Sales Volume is 3,000 4,000 5,000 Then Profitability Will Be 6,000 M99 ON 20,000 20,000 20,000 30,000 30,000 30,000 40,000 40,000 40,000 $14,000 12,000 10,000 4,000 2,000 - (6,000) (8,000) (10,000) $31,000 $48,000 $65,000 28,000 44,000 60,000 25,000 40,000 55,000 21,000 38,000 55,000 18,000 34,000 50,000 15,000 30,000 45,000 11,000 28,000 45,000 8,000 24,000 40,000 5,000 20,000 35,000 $82,000 76,000 70,000 72,000 66,000 60,000 62,000 56,000 50,000