Tableau DA 23-2 (Static): 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 o tocus its sales eftorts. Iyler currently has a capacity of 352 machine hours per month. I he Iableau Uashb e recent month. Sellina Price \& Variahle Costs ner Guitar Selling Price \& Variable Costs per Guitar ment (Graded) i I Machine Hours per Guitar Prey Machine Hours per Guitar Mavimirm Ciritor Colac nar IVIaXIIIUIII Gultal Dales uel 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. Compute contribution margin per machine hour for (a) acoustic guitars and (b) electric guitars. 1. Compute contribution margin per machine hour for (a) acoustic gu 2. Determine the most profitable sales mix for the company. 3. Compute the month's total contribution margin for the most profit Complete this question by entering your answers in the tabs Determine the most profitable sales mix for the company. 3. Compute the month's total contribution margin for the most prof Complete this question by entering your answers in the tabs Compute the month's total contribution margin for the most profitab