Please show work... preferably not through excel but anything is fine.

21. The senior management at Davis 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 profit margin watercraft. Each of 10 workers is paid $25 per hour. Variable overhead costs are $35,000 per week. The plant operates 18 hours per day and 6 days per week. The production manager has determined that workstation 1 is the bottleneck. Detailed production information is provided below. Price Material Cost Weekly Demand Processing Time Station 1 Processing Time Station 2 Processing Time Station 3 Processing Time Station 4 A $450 $45 100 60 min O min 10 min 20 min Model B $400 $40 75 O min O min 60 min 30 min $500 $100 40 30 min 60 min O min 40 min A. What is the product mix and resulting profit utilizing the bottleneck method