Please use Excel

Tyler Guitars makes acoustic and electric guitars. It is struggling to determine the profitability of each guitar and deciding on which guitar to focus its sales efforts. Tyler currently operates a single 8-hour shift for 22 days per month. The Tableau Dashboard shows data from the recent month. Selling Price & Variable Costs per Guitar Acoustic Variable Cost Selling Price Electric Variable Cost Selling Price 50 $50 $100 $150 $200 $250 $300 Machine Hours per Guitar Maximum Guitar Sales per Month 4 hrs 150 guita... 3 hrs. 125 guita... 100 guita... 2 hrs. 75 guitars 50 guitars 1 hrs. 25 guitars O hrs. O guitars Acoustic Electric Acoustic Electric 1. Compute the most profitable sales mix for the company. 2. Determine the month's total contribution margin for the most profitable sales mix. (Leave no cells blank - be certain to enter "O" wherever required.) Total Answer is complete but not entirely correct. Acoustic Electric Hours dedicated to the production of each product 88 Units produced for most profitable sales mix Contribution margin per unit 130 Total contribution margin-one shift 11,440 $ 1. 88 0 $ 180 2. S 0 IS 11,440 Tyler Guitars makes acoustic and electric guitars. It is struggling to determine the profitability of each guitar and deciding on which guitar to focus its sales efforts. Tyler currently operates a single 8-hour shift for 22 days per month. The Tableau Dashboard shows data from the recent month. Selling Price & Variable Costs per Guitar Acoustic Variable Cost Selling Price Electric Variable Cost Selling Price 50 $50 $100 $150 $200 $250 $300 Machine Hours per Guitar Maximum Guitar Sales per Month 4 hrs 150 guita... 3 hrs. 125 guita... 100 guita... 2 hrs. 75 guitars 50 guitars 1 hrs. 25 guitars O hrs. O guitars Acoustic Electric Acoustic Electric 1. Compute the most profitable sales mix for the company. 2. Determine the month's total contribution margin for the most profitable sales mix. (Leave no cells blank - be certain to enter "O" wherever required.) Total Answer is complete but not entirely correct. Acoustic Electric Hours dedicated to the production of each product 88 Units produced for most profitable sales mix Contribution margin per unit 130 Total contribution margin-one shift 11,440 $ 1. 88 0 $ 180 2. S 0 IS 11,440