Submit the completed Marketing Arithmetic Exercise Calculations spreadsheet. In addition, submit a separate Word document in which you answer the following questions:

  • If the retail price is fixed at $1.00, what effect does increasing the retail and wholesale margins have on the manufacturer’s selling price? Explain why this is the case.
  • Define unit contribution in your own words. Is a high or low unit contribution preferable for profitability? Justify your answer.
  • How do increases in the retail and wholesale margins (again, with a fixed retail price) affect the unit contribution? Be sure to explain why.
  • If you increase any of the fixed cost factors, what happens to 1) the number of units the company needs to sell to break even and 2) the market share necessary to break even? If fixed costs rise, is this good, bad, or of no importance? Explain your answer.
  • What change (increase or decrease) to the following factors increases the profit impact and why?
    • Retail margin/unit
    • Brand market share
    • Advertising budget
  • Many marketing decisions have multiple implications. For example, while increasing price improves profit per unit, too large a price increase may decrease unit sales, ultimately decreasing profits overall. Keeping this kind of tradeoff in mind, explain how changes to the three factors mentioned in the prior question could potentially conflict with one another in terms of strategy for increasing the profit impact.

Tips for working with the spreadsheet:

  • The sheet has been set up so the initial data values remain at the top while you scroll down through the remainder of the sheet. For this exercise, you should only need to edit initial data values, not the formulas in the cells below.
  • Read the cell comments to the right of cells C25, C32, and C40 for tips on understanding the formulas.

Guidance on Assignment Length: Your Word document will typically be 3–4 pages in length (1.5 to 2 pages, if single spaced). Refer to the Week 7 Assignment Rubric for specific grading elements and criteria for this assignment. Your Instructor will use this rubric to assess your work.

Leave a Reply