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. Selling Price & Variable Costs per Guitar Acoustic Variable Cost Selling Price Electric Variable Cost Acoustic Selling Price: $225 Selling Price $50 $100 $150 $200 $250 $300 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 Acoustic Variable Cost Selling Price Electric Variable Cost Electric Selling Price: $300 50 $50 $100 $150 $200 $250 $300 Machine Hours per Guitar 4 hrs. Maximum Guitar Sales per Month 250 guita... 225 guita... 3 hrs. 200 guita... 175 guita... 150 gulta... 2 hrs. 125 guita... 100 gulta... 75 guitars 1 hrs. - 50 guitars 25 guitars Ohrs. O guitars Acoustic Electric Acoustic Electric 1. Compute contribution margin per machine hour for (a) acoustic guitars and (b) electric guitars. 2. 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? 3. Determine the month's total contribution margin from the sales mix in part 2. Complete this question by entering your answers in the tabs below. Required 1 Required 2 Required 3 Compute contribution margin per machine hour for (a) acoustic guitars and (b) electric guitars. Acoustic Electric Selling price per unit Contribution margin per unit Contribution margin per machine hour 1. Compute contribution margin per machine hour for (a) acoustic guitars and (b) electric guitars. 2. 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? 3. Determine the month's total contribution margin from the sales mix in part 2. 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 1. Compute contribution margin per machine hour for (a) acoustic guitars and (b) electric guitars. 2. 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? 3. Determine the month's total contribution margin from the sales mix in part 2. 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 < 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