Larkin Industries manufactures several lines of decorative and functional metal items. The most recent order has been for 1200 door lock units for an apartment complex developer. 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 Key (each) Available Brass Alloy 12 5 1 15000 units Machining 18 20 10 36000 minutes Finishing 15 5 1 12000 minutes A quick look at the amounts available confirms that Larkin 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 Larkin Cost Knob and Plate 10.00 6.00 Lock 9.00 4.00 Keys (set of 2) 1.00 .50 Develop a linear programming model that would tell Larkin how to fill the order for 1200 lock sets at the minimum cost. Submit Excel Document with Your Template   BELOW IS A PICTURE OF THE QUESTION TO MAKE IT EASIER

MATLAB: An Introduction with Applications
6th Edition
ISBN:9781119256830
Author:Amos Gilat
Publisher:Amos Gilat
Chapter1: Starting With Matlab
Section: Chapter Questions
Problem 1P
icon
Related questions
Topic Video
Question

Larkin Industries manufactures several lines of decorative and functional metal items. The most recent order has been for 1200 door lock units for an apartment complex developer. 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 Key (each) Available Brass Alloy 12 5 1 15000 units Machining 18 20 10 36000 minutes Finishing 15 5 1 12000 minutes

A quick look at the amounts available confirms that Larkin 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 Larkin Cost Knob and Plate 10.00 6.00 Lock 9.00 4.00 Keys (set of 2) 1.00 .50

Develop a linear programming model that would tell Larkin how to fill the order for 1200 lock sets at the minimum cost.

Submit Excel Document with Your Template

 

BELOW IS A PICTURE OF THE QUESTION TO MAKE IT EASIER

Larkin Industries manufactures several lines of decorative and functional metal items. The most recent
order has been for 1200 door lock units for an apartment complex developer. 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.
Knob and Plate
Lock
Key (each)
Available
15000 units
36000 minutes
12000 minutes
Resource
Brass Alloy
Machining
Finishing
12
1
18
20
10
15
1
A quick look at the amounts available confirms that Larkin 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.
Larkin Cost
6.00
Subcontractor Cost
Component
Knob and Plate
10.00
Lock
9.00
4.00
Keys (set of 2)
1.00
.50
Develop a linear programming model that would tell Larkin how to fill the order for 1200 lock sets at the
minimum cost.
Submit Excel Document with Your Template
Transcribed Image Text:Larkin Industries manufactures several lines of decorative and functional metal items. The most recent order has been for 1200 door lock units for an apartment complex developer. 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. Knob and Plate Lock Key (each) Available 15000 units 36000 minutes 12000 minutes Resource Brass Alloy Machining Finishing 12 1 18 20 10 15 1 A quick look at the amounts available confirms that Larkin 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. Larkin Cost 6.00 Subcontractor Cost Component Knob and Plate 10.00 Lock 9.00 4.00 Keys (set of 2) 1.00 .50 Develop a linear programming model that would tell Larkin how to fill the order for 1200 lock sets at the minimum cost. Submit Excel Document with Your Template
Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 2 steps

Blurred answer
Knowledge Booster
Optimization
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, statistics and related others by exploring similar questions and additional content below.
Similar questions
Recommended textbooks for you
MATLAB: An Introduction with Applications
MATLAB: An Introduction with Applications
Statistics
ISBN:
9781119256830
Author:
Amos Gilat
Publisher:
John Wiley & Sons Inc
Probability and Statistics for Engineering and th…
Probability and Statistics for Engineering and th…
Statistics
ISBN:
9781305251809
Author:
Jay L. Devore
Publisher:
Cengage Learning
Statistics for The Behavioral Sciences (MindTap C…
Statistics for The Behavioral Sciences (MindTap C…
Statistics
ISBN:
9781305504912
Author:
Frederick J Gravetter, Larry B. Wallnau
Publisher:
Cengage Learning
Elementary Statistics: Picturing the World (7th E…
Elementary Statistics: Picturing the World (7th E…
Statistics
ISBN:
9780134683416
Author:
Ron Larson, Betsy Farber
Publisher:
PEARSON
The Basic Practice of Statistics
The Basic Practice of Statistics
Statistics
ISBN:
9781319042578
Author:
David S. Moore, William I. Notz, Michael A. Fligner
Publisher:
W. H. Freeman
Introduction to the Practice of Statistics
Introduction to the Practice of Statistics
Statistics
ISBN:
9781319013387
Author:
David S. Moore, George P. McCabe, Bruce A. Craig
Publisher:
W. H. Freeman