Question: Tableau DA 23-2: Exercise, Sales mix selection LO P3 Tyler Guitars makes acoustic and electric guitars. It is struggling to determine the profitability of each





Tableau DA 23-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 gultar 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 Machine Hours per Guitar Maximum Guitar Sales per Month Machine Hours per Guitar Maximum Guitar Sales per 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. Determine the most profitable sales mix for the company. Compute the month's total contribution margin for the most profitable sales mix
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
