Pickson Luthiers Corporation makes four models of electric guitars, ScarCT, Dela Mort, Warax, and Invazen. Each guitar must flow through five departments, assembly, painting, sound testing, inspection, and packaging. The table below shows the relevant data. Production rates are shown in units/hour. (ScarCT is assembled elsewhere). Pickson wants to determine how many guitars to make to maximize monthly profit.Pickson Luthiers Corporation Data Guitar ModelSelling price/UnitVariable cost/UnitMin SalesMax Sales ScarCT750.00660.0002500 Dela Mort788.00680.0002000 Warax800.00700.001001000 Invazen850.00800.0080500 Production rates (units/hour)ScarCTDela MortWaraxInvazenHours AvailableAssembly-352520220Painting35201510220Sound Testing20102018220Inspection101285220Packaging91058220Use a linear optimization model based on the data to answer the following question.According to the linear optimization model, what would be the total time spent for sound testing the Warax model?Group of answer choices6 10.5 5 4

Here, to answer the given question, I would use the linear optimization model, The Ms Excel solver…

Answered: According to the linear optimization…

Practical Management Science

6th Edition

ISBN:9781337406659

Author:WINSTON, Wayne L.

Publisher:WINSTON, Wayne L.

Chapter2: Introduction To Spreadsheet Modeling

Section: Chapter Questions

Problem 20P: Julie James is opening a lemonade stand. She believes the fixed cost per week of running the stand...

See similar textbooks

Related questions

Question

Pickson Luthiers Corporation makes four models of electric guitars, ScarCT, Dela Mort, Warax, and Invazen. Each guitar must flow through five departments, assembly, painting, sound testing, inspection, and packaging. The table below shows the relevant data. Production rates are shown in units/hour. (ScarCT is assembled elsewhere). Pickson wants to determine how many guitars to make to maximize monthly profit.

Pickson Luthiers Corporation

Data
Guitar Model	Selling price/Unit	Variable cost/Unit	Min Sales	Max Sales
ScarCT	750.00	660.00	0	2500
Dela Mort	788.00	680.00	0	2000
Warax	800.00	700.00	100	1000
Invazen	850.00	800.00	80	500

Production rates (units/hour)	ScarCT	Dela Mort	Warax	Invazen	Hours Available
Assembly	-	35	25	20	220
Painting	35	20	15	10	220
Sound Testing	20	10	20	18	220
Inspection	10	12	8	5	220
Packaging	9	10	5	8	220

Use a linear optimization model based on the data to answer the following question.

According to the linear optimization model, what would be the total time spent for sound testing the Warax model?

Group of answer choices

10.5

Expert Solution