Sweet Celebrations makes three products: cookies, cupcakes, and cakes. Copy the data from your exam into the chart below and answer the questions. Show all work using cell referencing and formulas. Product Price (per unit) Var Cost (per unit) Cookies $6.50 $2.35 Cupcakes $2.50 $0.85 Cakes $15.00 $7.40 a. Total 1,120 2,160 720 4,000 b. Sales Last Sales Mix c. Common Fixed Costs 4500 a. Sweet Celebrations has a target net income of $8,500 per month (refer to your exam). How much operating income must the company earn next month if the tax rate is 21%? Target Net Income Tax Rate Target Operating Income b. What is the total number of units the company must sell next month to achieve the target net income? How would you allocate these units across the three products? Total Q = Cookies Cupcakes Cakes Total Forecast Units c. Show your allocations using the Income Statement below: Cookies Cupcakes Cakes Total Revenue - Total Vc Contrib. - Fixed Costs Operating Inc - Taxes Net Income