(Solved): Tableau DA 23-2 (Algo): Exercise, Sales mix selection LO P3 Tyler Guitars makes acoustic and electr ...

Tableau DA 23-2 (Algo): 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 guttar 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. \begin{tabular}{|l|l|l|l|l|l|l|l|l|l|l|} Select Year $$?$$ & Year 1 & Year 2 & Year 3 & Year 4 & Year 5 & Year 6 & Year 7 & Year 8 & Year 9 & Year 10 \\ \hline \end{tabular} Maximum Guitar Sales Der Month * Answer is not complete. Complete this question by entering your answers in the tabs below. For Year 5 ; compute contribution margin per machine hour for (a) acoustic guitars and (b) electric guitars. Tmgortant be sure to dick the corred Year at the top of the dashboard. Tyler Guitars makes acoustic and electric guitars it is strugging to determine the profitability of each guitar and deciding on which guitar to focus its sales efforts. Tyler currently has a capacty of 352 machine hours per month. The Tableau Dashboard shows data from the recent month. W???? inacmine nours per surtar Maximum Guitar Sales per Month tobleou Q Answer is not complete. Complete this question by entering your answers in the tabs below. For Year 5 , compute contribution margin per machne hour for (a) acoustic guitars and (b) electric guitars. Importankf be gure to dick the correct year at the top of the dashboard For Year 5, compute contribution margin per machine hour for (a) acoustic guitars and Important! Be sure to click the correct Year at the top of the dashboard. Complete this question by entering your answers in the tabs below. For Year 5, determine the most profitable sales mix for the company. Importanti Be sure to click the correct Year at the top of the dashboard. Complete this question by entering your answers in the tabs below. For Year 5 , compute the month's total contribution margin for the most profitable sales mix. Importanti Be sure to click the correct Year at the top of the dashboard.