Add the excel formulas to the answers

Mendina, Incorporated produces an advanced type of coffee ma er. n o Total Variable Cost at 200 units Total Cost per Unit Sales Price Target Profit Required: $24,000 $235.00 $270 $120,000 Fill in the chart and then use it to answer the questions. Volume Total Cost Variable Cost Fixed Cost Total Costs Per Unit Cost Variable Cost per Unit Fixed Cost per Unit Total Cost er Unit Contribution Margin Contribution Margin Ratio Break Even Units Break Even Dollars Target Profit Units Target Profit $ 200 24,000 450 235.00 1100