Please show full steps in excel with formulas, I will provide thumbs up! :) Please dont copy answer from another question

5. The senior management at BPR Watercraft would like to determine if it is possible to improve firm profitability by changing their existing product mix. Currently, the product mix is determined by giving resource priority to the highest contribution margin watercraft. BPR Watercraft always has a contingent of 10 workers on hand; each worker is paid $25 per hour. Overhead costs are $35,000 per week. The plant operates 18 hours per day and 6 days per week. Labor is considered a fixed expense because workers are paid for their time regardless of their utilization. The production manager has determined that workstation 1 is the bottleneck. Detailed production information is provided below. Model B C Price $450 $400 $500 $50 $40 $110 100 75 60 min Material Cost Weekly Demand Processing Time Station 1 Processing Time Station 2 Processing Time Station 3 Processing Time Station 4 O min O min O min 10 min 20 min 40 30 min 60 min Omin 40 min 60 min 30 min a) Using the traditional method, which bases decisions solely on a product's contribution to profits and overhead, what is the product mix that yields the highest total profit? What is the resulting profit? b) Using the bottleneck-based method, what is the product mix that yields the highest total profit? What is the resulting profit