Question

Hello!

Please answer the following USING EXCEL SOLVER, Show steps:
Georgia Cabinets manufactures kitchen cabinets that are sold to local dealers throughout the Southeast. The company has a large backlog of orders for oak andcherry cabinets and has decided on contract with three smaller cabinet makersto do the final finishing operation. For the three cabinet makers, the # of hrsrequired to complete all the oak cabinets, the # of hrs required the complete the cherry cabinets, the # of hrs available for the final finishing operation and thecost per hr to perform the work are shown here:
Cabinetmaker1 Cabinetmaker2 Cabinetmaker 3
Hrs required to complete 50 42 30
all the oak cabinets
Hrs to complete all the cherry 60 48 35
cabinets
Hrs available 40 30 35
Cost Per Hr 36 42 55

For example, Cabinetmaker 1 estimates it will take 50 hrs to complete all the oak cabinets and 60 hrs to complete all the cherry cabinets. However, Cabinetmaker 1only has 40 hrs available for the final finishing operation. Thus cabinet maker 1 can only complete 40/50=80% of the Oak cabinet if it worked only on Oak cabinets.Similarly, Cabinetmaker 1 can only complete 40/60=67% of the cherry cabinets if it worked only on cherry cabinets.

1. Formulate a linear programming model that can be used to determine the percentage
of oak cabinets and the percentage of the cherry cabinets that should be assigned to
each of the three cabinetmakers in order to minimize the total cost of completing both
projects.
2. Solve the model formulated in (1). What percentage of the oak cabinets and what
percentage of the cherry cabinets should be assigned to each cabinetmaker? What is
the total cost of completing both projects?
3. Suppose Cabinetmaker 2 reduced its cost to $38 per hour, what effect would this haveon the optimal solution? Explain.

Answer 1

Your question:-
http://s2.postimage.org/58zel3na4/image.png

Solution:

Part E of the question and Solution starts here:-
http://s2.postimage.org/58ztgxrq4/image.png

Part 2:-
http://s2.postimage.org/58zv4h47w/image.png

Part 3:-
http://s2.postimage.org/58zws0gpo/image.png

Please rate:-liFesaVEr