Breckenridge Manufacturing produces a snowboard. Prices and costs are as follows:

Selling priceVariable costs

Snowboard$500$300

Breckenridge incurs $12,500 in monthly fixed costs related to its ski operations. Breckenridge is currently earning $20,000 per year in operating income.

REQUIREMENTS

1. Compute the breakeven point in terms of numbersnowboards that must be sold per year.

2. Breckenridges management requires operating income of $30,000 per year. How many snowboardsmust Breckenridge sell per year to achieve this goal? How many additional snowboards is this compared to what Breckenridge is currently selling?

3. If Breckenridge can reduce its fixed costs to $10,000 per month, what total sales dollars are needed to achieve the target operating income?

4. Breckenridge wants to run an advertising campaign costing $10,000 related to the sale of the snowboard. What quantity of sales are needed to pay for the advertising campaign and to achieve the $30,000 in target income required by management? If Breckenridge can increase sales 15% due to the advertising campaign, should it run it?

5. Based on your work above, write a paragraph explaining

A. Breckenridges current situation;

B. What you think Breckenridge should do to increase its operating income (compare 3 and 4). Explain why you chose your strategy.

Worksheet Format

1. Set up your Excel workbook with 4 worksheets

Input / Conclusion (requirement 5)

Breakeven analysis (requirement 1 above)

Operating income (requirements 2, 3 above)

Advertising campaign (requirement 4 above)

2. For the input area, include your prices, variable costs, fixed costs and changes as outlined above. Also include your conclusion here.

3. The breakeven, operating income and advertising campaign worksheets should link to the input tab. You will also need to prepare some calculations using excel in these worksheets.

Objective: - Increase understanding of cost-volume-profit analysis; - Practice using Excel, including linking; - Formulate well-written conclusion using proper writing techniques. Breckenridge Manufacturing produces a snowboard. Prices and costs are as follows: Breckenridge incurs $12,500 in monthly fixed costs related to its ski operations. Breckenridge is currently earning $20,000 per year in operating income. REQUIREMENTS 1. Compute the breakeven point in terms of number snowboards that must be sold per year. 2. Breckenridge's management requires operating income of $30,000 per year. How many snowboards must Breckenridge sell per year to achieve this goal? How many additional snowboards is this compared to what Breckenridge is currently selling? 3. If Breckenridge can reduce its fixed costs to $10,000 per month, what total sales dollars are needed to achieve the target operating income? 4. Breckenridge wants to run an advertising campaign costing $10,000 related to the sale of the snowboard. What quantity of sales are needed to pay for the advertising campaign and to achieve the $30,000 in target income required by management? If Breckenridge can increase sales 15% due to the advertising campaign, should it run it? 5. Based on your work above, write a paragraph explaining A. Breckenridge's current situation; B. What you think Breckenridge should do to increase its operating income (compare 3 and 4 ). Explain why you chose your strategy. Worksheet Format 1. Set up your Excel workbook with 4 worksheets 5. Based on your work above, write a paragraph explaining A. Breckenridge's current situation; B. What you think Breckenridge should do to increase its operating income (compare 3 and 4). Explain why you chose your strategy. Worksheet Format 1. Set up your Excel workbook with 4 worksheets - Input / Conclusion (requirement 5) - Breakeven analysis (requirement 1 above) - Operating income (requirements 2, 3 above) - Advertising campaign (requirement 4 above) 2. For the input area, include your prices, variable costs, fixed costs and changes as outlined above. Also include your conclusion here. 3. The breakeven, operating income and advertising campaign worksheets should link to the input tab. You will also need to prepare some calculations using excel in these worksheets. GRADING 1. Excel set up properly with separate worksheets within the workbook. Uses linking appropriately 4 2. Correct calculations for requirements 1 through 4.13 4. Well worded conclusion, correct spelling and grammar and logical reasoning. Total points available