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 $200 $250 $150 $300 $0 $50 $100 Machine Hours per Guitar Maximum Guitar Sales per Month 4 hrs. 150 guitars 3 hrs. 125 guitars 100 guitars 2 hrs. 75 guitars 50 guitars 1 hrs. 25 guitars Ohrs. O guitars Acoustic Electric Acoustic Electric Prey 1 of 1 Next ences 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 Om wherever required.) Acoustic Total Electric 90 225 Hours dedicated to the production of each product 1. Units produced for most profitable sales mix Contribution margin per unit 2. Total contribution margin-one shit + $ $ 131 130$ 30 180 5.400$ 17030 22.430 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 $200 $250 $150 $300 $0 $50 $100 Machine Hours per Guitar Maximum Guitar Sales per Month 4 hrs. 150 guitars 3 hrs. 125 guitars 100 guitars 2 hrs. 75 guitars 50 guitars 1 hrs. 25 guitars Ohrs. O guitars Acoustic Electric Acoustic Electric Prey 1 of 1 Next ences 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 Om wherever required.) Acoustic Total Electric 90 225 Hours dedicated to the production of each product 1. Units produced for most profitable sales mix Contribution margin per unit 2. Total contribution margin-one shit + $ $ 131 130$ 30 180 5.400$ 17030 22.430