Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Tyler Guitars makes acoustic and electric guitars. It is struggling to determine the profitability of each guitar and deciding on which guitar to focus
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. Select Year Year 1 Year 2 Year 3 Year 4 Year 5 Year 6 Year 7 Year 8 Year 9 Year 10 Selling Price & Variable Costs per Guitar 209 Acoustic Variable Cost Selling Price 264 Electric Variable Cost 495 660 Selling Price $0 $50 $100 $150 $200 $250 $300 $350 $400 $450 $500 $550 $600 $650 Machine Hours per Guitar Maximum Guitar Sales per Month 4 hrs. 3 hrs. 2- 300 guitars 3 250 guitars 200 guitars 2 hrs. 150 guitars 100 guitars 1 hrs. 0 hrs. 50 guitars O guitars Acoustic Electric +ableau Complete this question by entering your answers in the tabs below. 200 65 Acoustic Electric Required 1 Required 2 Required 3 For Year 6, compute contribution margin per machine hour for (a) acoustic guitars and (b) electric guitars. Important! Be sure to click the correct Year at the top of the dashboard. Acoustic Electric Selling price per unit Contribution margin per unit Contribution margin per machine hour < Required 1 Required 2 > Required 1 Required 2 Required 3 For Year 6, determine the most profitable sales mix for the company. Important! Be sure to click the correct Year at the top of the dashboard. Number of units produced Acoustic Electric < Required 1 Required 3> Required 1 Required 2 Required 3 For Year 6, compute the month's total contribution margin for the most profitable sales mix. Important! Be sure to click the correct Year at the top of the dashboard. Total contribution margin < Required 2 Required 3 >
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started