Selling Price & Variable Costs per Guitar coustic Variable Cos elling Price Acoustic Variable Cost: $95 Electric Variable Cost Selling Price $100 $150 $200 $250 $300 Machine Hours per Guitar Maximum Guitar Sales per Month 4 hrs. 150 guitars Selling Price & Variable Costs per Guitar Justic Variable Cost Selling to Acoustic Selling Price: $225 lectric Variable Cost Selling Price $100 $150 $200 $250 $300 Machine Hours per Guitar Maximum Guitar Sales per Month 4 hrs. 150 guitars Selling Price & Variable Costs per Guitar Acoustic Variable Cost Variable Cost Selling Price Variable cos Electric Selling Price Electric Variable Cost: $120 $300 $250 $150 $100 $200 $50 Machine Hours per Guitar 4 hrs. Maximum Guitar Sales per Month 150 guitars 1 of 1 !!! Next Selling Price & Variable Costs per Guitar Acoustic Variable Cost Selling Price Electric Variable Cost Selling Price Electric Selling Price: $300 $150 $200 $100 $ $300 $50 Machine Hours per Guitar Maximum Guitar Sales per Month 4 hrs. 150 guitars Machine Hours per Guitar Maximum Guitar Sales per Month 4 hrs. 150 guitars 3 hrs. 125 guitars 100 guitars 2 hrs.- Acoustic: 131 guitars 75 guitars 50 guitars 25 guitars O guitars O hrs. Acoustic Electric Electric Acoustic 150 guitars 125 guitars 100 guitars 75 guitars 50 guitars 25 guitars Electric: 65 guitars O guitars Acoustic Electric Acoustic Electric 1 hrs. 25 guitars Ohrs O guitars Acoustic Electric Acoustic Electric tableau FT 1. Compute the most profitable sales mix for the company. 2. Determine the month's total contribution margin for the most profitable sales mix. (Leave no cells blank.be certain wherever required.) & Answer is not complete. Electric Total Hours dedicated to the production of each product Units produced for most profitable sales mix Contribution margin per unit Total contribution margin-one shift Acoustic 2x 131 $ 130 $ 17,030 $ $ 30 X 180 5.400 IUCIIIII UNIBHUTI M 4 hrs. 150 guitars 3 hrs. 125 guitars eBook 100 guitars Ask 2 hrs. Acoustic 2 machine hours 75 guitars Print 50 guitars References 1 hrs 25 guitars O hrs. O guitars Electric Acoustic 150 guitars 3 hrs. 125 guitars Electric 3 machine hours 1J0 guitars 2 hrs. + 75 guitars 50 guitars 1 hrs. 25 guitars CHUCK HY WUIR HUUU. THIS STUWS WIIJLIS LUMULUI HICUITULLIO your com m on Tableau DA 23-2: Exercise, Selection of sales mix LO 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 operates a single 8-hour shift for 22 days per month. The Tableau Dashboard shows data from the recent month. Selling Price & Variable Costs per Guitar Acoustic Variable Cost Selling Price Electric Variable Cost Selling Price $150 $100 5200 $300 $250 Prev 1 of 1 Next
