Tableau DA 10-3 (Static): Mini-Case, Analyzing sales mix strategies 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 5 Acoustic Varlab Cost 95 Selling Price 225 Electric Variable Cost 120 Selling Price 300 $0 $50 $100 $150 $200 $250 $300 www Machine Hours per Guitar 4 hrs. 3 hrs. 2 hrs. 1 hrs. 2. Maximum Guitar Sales per Month 3 250 guita... 225 guita... 200 guita... 175 guita... 150 guita... 200 125 guita... 100 guita... 75 guitars 50 guitars 25 guitars 65 O hrs. O guitars Acoustic Electric Acoustic Electric Answer is complete but not entirely correct. Complete this question by entering your answers in the tabs below. Required 1 Required 2 Required 3 Assume the maximum demand for acoustic guitars is 131 units (not 200 units). How many units of each type of guitar should the company produce? Acoustic Electric Number of units produced 29,475 19,500 < Required 1 Required 3 > Answer is complete but not entirely correct. Complete this question by entering your answers in the tabs below. Required 1 Required 2 Required 3 Determine the month's total contribution margin from the sales mix in part 2. Total contribution margin S 60 x