Mountain produces snowboards. The prices charged affects the quantity sold. The following equation captures the relation between price and quantity each month (i.e., the demand curve) in the $200-$400 range of pricing:

Quantity Sold = 2,650 (5 x Sales Price)

In other words, if the price is set at $300, projected sales are 1,150 boards per month (2,650 (5 x 300)).Fixed costs of producing the boards are $70,000 per month and the variable costs per board are $90.

On your Excel file, prepare a table with sales prices ranging between $200 and $400 per board, in increments of $10, that calculates the unit sales, total revenue, total costs, and profits for each price-quantity in the range. Based on your table results, what is the profit-maximizing Sales Price Quantity combination?

If fixed costs increase from $70,000 to $90,000 a month, should Blue Mountain change its pricing decision?

Using the original information from (a), if variable costs fall from $90 to $75 per unit, should Blue Mountain change its pricing decision?

If both (b) and (c) occur, i.e., fixed costs increase from $70,000 to $90,000 a month AND variable costs fall from $90 to $75 per unit, should Blue Mountain change its pricing decision?

Consider your responses to (b) and (d) above, what can you say about the impact of fixed costs on the Sales Price Quantity decision?

DEMAND FUNCTION: Quantity Sold = 2,650 - (5 x Sales Price) Sales Price / unit Variable Cost / unit $ $ 300 90 Total Fixed Costs $ 70,000 Contribution Margin Income Statement @ $300 SP Quantity (use the demand function) Total Revenues Variable Costs Contribution Mgn Fixed Costs Operating Profit