TCC also makes high-end dorm room door locks. The most recent order has been for 1400 door lock units for the new college dormitory. The sales and production departments must work together to determine delivery schedules. Each lock unit consists of three components: the knob and face plate, the actual lock itself, and a set of two keys. Although the processes used in the manufacture of the three components vary, there are three areas where the production manager is concerned about the availability of resources. These three areas, their usage by the three components, and their availability are detailed in the table. Resource Knob and Plate Lock Keys (set of 2) Available at TCC Nickel Plating 13 5 2 17,000 units Machining 19 20 20 39,000 minutes Finishing 16 5 2 14,000 minutes A quick look at the amounts available confirms that TCC does not have the resources to fill this contract. A subcontractor, who can make an unlimited number of each of the three components, quotes the prices below. Component Subcontractor Cost TCC Cost Knob and Plate 11.00 7.00 Lock 10.00 5.00 Keys (set of 2) 1.00 .50 Develop a linear programming model that would tell TCC how to fill the order for 1400 dorm room door lock sets at the minimum cost. while using worksheet on excel How many of each of the components will be completed by TCC and how many will be completed by the contractor? What will be the final price of the full order? Please copy this number and include it on the executive summary (the first worksheet).
TCC also makes high-end dorm room door locks. The most recent order has been for 1400 door lock units for the new college dormitory. The sales and production departments must work together to determine delivery schedules. Each lock unit consists of three components: the knob and face plate, the actual lock itself, and a set of two keys. Although the processes used in the manufacture of the three components vary, there are three areas where the production manager is concerned about the availability of resources. These three areas, their usage by the three components, and their availability are detailed in the table.
Resource |
Knob and Plate |
Lock |
Keys (set of 2) |
Available at TCC |
|
Nickel Plating |
13 |
5 |
2 |
17,000 units |
|
Machining |
19 |
20 |
20 |
39,000 minutes |
|
Finishing |
16 |
5 |
2 |
14,000 minutes |
A quick look at the amounts available confirms that TCC does not have the resources to fill this contract. A subcontractor, who can make an unlimited number of each of the three components, quotes the prices below.
|
Component |
Subcontractor Cost |
TCC Cost |
|
Knob and Plate |
11.00 |
7.00 |
|
Lock |
10.00 |
5.00 |
|
Keys (set of 2) |
1.00 |
.50 |
Develop a linear programming model that would tell TCC how to fill the order for 1400 dorm room door lock sets at the minimum cost.
while using worksheet on excel
- How many of each of the components will be completed by TCC and how many will be completed by the contractor?
- What will be the final price of the full order? Please copy this number and include it on the executive summary (the first worksheet).
Trending now
This is a popular solution!
Step by step
Solved in 2 steps with 16 images
