solution in excel

a A G EXERCISE 511 Missing Data; Basic CVP Concepts L05-1205-9 Fill in the missing amounts in each of the eight case situations below. Each case is independent of the others. (Hint. One way to find the missing amounts would be to prepare a contribution format income statement for each case, enter the known data, and then compute the missing items.) a. Assume that only one product is being sold in each of the four following case situations: 4 Units Variable Case Sold Sales Expenses 1 15,000 $180,000 $120,000 Contribution Margin per Unit Net Operating Income (Loss) Fixed Expenses $50,000 $32,000 ? 2 ? $100,000 2 $10 $8.000 3 10,000 2 $70,000 $13 2 $12,000 6,000 $300,000 2 ? $100,000 S(10.000) b. Assume that more than one product is being sold in each of the four following case situations: Activate Windows b. Assume that more than one product is being sold in each of the four following case situations: Average Contribution Margin Ratio Variable Expenses Case Net Operating Income (Loss) Fixed Expenses Sales 1 $500,000 ? 20% ? $7,000 2 $400,000 $260.000 ? $100.000 ? 3 ? ? 60% $130,000 $20,000 4 $600,000 $420,000 S(5,000)