please I want all Required a,b,c and d

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. $2,600,000 (= $2,000 X 1,300 units) $1,040,000 (= $800 x 1,300 units) Sales Variable costs Cost of goods sold Selling and administrative costs Total variable costs Contribution margin Fixed costs Cost of goods sold 390,000 ( = $300x1300 units) 1,430,000 $1,170,000 $800,000 Selling and 400.000 administrative costs Total fixed costs Operating loss 1,200,000 ($ 30,000) 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. 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. Required: Form groups of two to four students and assign one of the three options listed previously to each group. Each group must perform the following requirements: 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. As a dass, discuss each option based on the findings of your group. d. Refer to the information for Performance Sports in Skill-Building Case 60. Prepare an Excel spreadsheet to calculate the operating profit (loss). Students are required to submit a written report. Summary of the report content and due dates are given below