Puma produces portable soccer goals. Its total fixed cost for the following year is expected to be
Question:
Puma produces portable soccer goals. Its total fixed cost for the following year is expected to be $490,000, while its variable cost per unit is expected to be $33 per soccer goal. Assume the selling price is $40 per soccer goal. (This question doesnt require a text box with written answers, but you need to clearly label your answers to parts a and b.)
a. Calculate the contribution margin per unit (the contribution to profit from each soccer goal sold).
b. Calculate the number of soccer goals that RC Sport needs to sell to break even (to make zero profit).
c. Construct a table with Number of units sold, Total Revenue, Total Cost, and Profit in its 4 columns. Fill the units sold column with the following values: 0, 10000, 20000, 30000, 40000, 50000, 60000, 70000, 80000, 90000, and 100000. Fill in the remaining 3 columns with formulas and cell references, calculating the correct values (use dollar signs to lock cell references and copy from the first row to the other rows of the table). Insert two Excel Charts (select the Line type), one showing the number of units (x) and profit (y), the other showing number of units (x), Total Revenue (y1), and Total Cost (y2). Use labels in your charts and make them look good for full credit!