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.

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		30

Required

Complete this question by entering your answers in the tabs below.

Required 1

Required 2

Required 3

Determine the months total contribution margin from the sales mix in part 2.

Total contribution margin