Question

Sensitivity Analysis and Decision Making. Performance Sports produces inflatable rafts used for river rafting. Sales have grown slowly over the years, and cost increases are causing Performance Sports to incur losses. Financial data for the most recent year are shown.

Sales Variable costs $2,600,000 Cost of goods sold Selling and administrative costs $2,000 x 1.300 units) ($800 x 1,300 units) ( $300 x 1,300 units) $1,040,000 390,000 Total variable costs Contribution margin Fixed costs 1.430,000 $1,170,000 Cost of goods sold Selling and administrative costs $800,000 400,000 Total fixed costs Operating loss 1,200,000 30

Members of the management group at Performance Sports arrived at these three possible courses of action to return the company to profitability (each scenario is independent of the others):

1. Increase the sales price for each raft by 10 percent, which will cause a 5 percent drop in sales volume. Although sales volume will drop 5 percent, the group believes the increased sales price will more than offset the drop in rafts sold.

2. Decrease the sales price for each raft by 10 percent, which will cause an 8 percent increase in sales volume. Although the sales price will drop by 10 percent, the group believes an increase in rafts sold will more than offset the sales price reduction.

3. Increase advertising costs by $200,000, which will increase sales volume by 15 percent. Although fixed selling and administrative costs will increase by $200,000, the group believes the increase in rafts sold will more than offset the increase in advertising costs.

a. Calculate the projected operating profit (loss) for the option assigned, and determine whether the option is acceptable.

b. Discuss and document the advantages and disadvantages of the option assigned.

c. Discuss which option in the best.

Answer 1

Answer:

PoUp PoDn Insert Delete Home End Ortion' 1,581500 dvor* in Sale volumé (leo Seling 22.00) (units sold -t400 2000-t lot 12.35 uniti OPHon mount itvoje in Sales volume- (lew Lelin Sale Vaviable Cost -Amount Cot of os Sold 988,600 2152키 200 Selling and adminiStation 370,500 Variable CoJ -Total Vaviaba Cos 358, 500 ,23 1106 Sold ontibuo main 358 500 Sellinj end 42リ200 Cost o 90od Total fixcd Coyt- Sold ating naome (Lo Selsing and (- la.20) . 400) 000 odminiStialion Cost> Total ixed Co 200) 00D

」.orase adverí sina Costs by f 200灬 -16tal fixed cest. ion (54500) «ni) (Se and akminijlnaion Cos- tOOOD +200000 -6ooooo tby lo Pesant) Amount Sale, 2,1 40 0oo Advontge vaviable Cost Advantae Sot d Selting and 41500 OPtion 2: Total vanable Cest Advontage 64560 4 em of Volume (onvibution mavin 1, 345.50 & o0) ooo Opion J: Sold Advanta9e. Mavtet Shave oF Compani is tnccajel ^n -levmS o volu» Setlrn and Adminitation