Tableau DA 25-2: Exercise, Sales mix selection LO P3 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 has a capacity of 352 machine hours per month. The Tableau Dashboard shows data from the recent month Selling Price & Variable Costs per Guitar Acoustic Variable cost Selling Price Acoustic Variable Cost: 595 Electric Variable Cost Selling Price 50 $50 $100 $150 $200 $250 $300 Machine Hours per Guitar Maximum Guitar Sales per Month 4 hrs. 250 guita. 225 guita.. 3 hrs 200 guita.. 175 guita 150 guita 2 hrs. 125 guita... 100 guita... 75 guitars 1 hrs. 50 guitars 25 guitars Ohrs. O guitars Acoustic Electric Acoustic Electric hces +obleau 1. Compute contribution margin per machine hour for (a) acoustic guitars and (b) electric guitars. 2. Determine the most profitable sales mix for the company, 3. Compute the month's total contribution margin for the most profitable sales mix. Complete this question by entering your answers in the tabs below. Required 1 Required 2 Required 3 Compute contribution margin per machine hour for (a) acoustic guitars and (b) electric guitars. Acoustic Electric Selling price per unit Contribution margin per unit Contribution margin per machine hour Required 2 > 175 guita... 150 guita... 2 hrs. 125 guita... 100 guita.. 75 guitars 1 hrs. 50 guitars 25 guitars Ohrs. O guitars Acoustic Electric Acoustic Electric *+ableau K as po 1. Compute contribution margin per machine hour for (a) acoustic guitars and (b) electric guitars. 2. Determine the most profitable sales mix for the company. 3. Compute the month's total contribution margin for the most profitable sales mix. Complete this question by entering your answers in the tabs below. Required 1 Required 2 Required 3 Determine the most profitable sales mix for the company. Acoustic Electric Number of units produced 175 guita... 150 guita... 2 hrs. 125 guita... 100 guita... 1 hrs. 75 guitars 50 guitars 25 guitars Ohrs. O guitars Acoustic Electric Acoustic Electric tableau 1. Compute contribution margin per machine hour for (a) acoustic guitars and (b) electric guitars. 2. Determine the most profitable sales mix for the company. 3. Compute the month's total contribution margin for the most profitable sales mix. Complete this question by entering your answers in the tabs below. Required 1 Required 2 Required 3 Compute the month's total contribution margin for the most profitable sales mix, Total contribution margin