Travel Pros make two types of luggage sets (FeatherLite and RuggedTuff). Manufacturing time requirements for each luggage set is given below.

FeatherLite Model

RuggedTuff Model

Hours Available

Molding Time

2

4

39

Internal Assembly

2

5

44

Accessory Add-ons

5

3

34

The profit for the FeatherLite model is $85 per luggage set and the profit for the RuggedTuff model is $150 per set.

Solve using Solver.Answer all questions in Excel and then upload your completed Excel file here.

a.What is the linear programming model for this problem? (Refer toformulation from M2: Quiz)b.Find the optimal solution using Excel Solver.c.Will there be excess capacity (time) in any area (eg. slack)?