SpikLock makes several lines of 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 faceplate, 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 SpikLock 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 SpikLock Cost Knob and Plate 10.00 6.00 Lock 9.00 4.00 Keys (set of 2) 1.00 .50 What is the value of the optimal solution to this problem? (Round your answer to the nearest dollar)

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

Concept explainers

Question

100%

SpikLock makes several lines of 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 faceplate, 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 SpikLock 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	SpikLock Cost
Knob and Plate	10.00	6.00
Lock	9.00	4.00
Keys (set of 2)	1.00	.50

What is the value of the optimal solution to this problem? (Round your answer to the nearest dollar).

Expert Solution

Trending now

This is a popular solution!

Step by step

Solved in 2 steps

SEE SOLUTION Check out a sample Q&A here

Knowledge Booster

Learn more about

Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, operations-management and related others by exploring similar questions and additional content below.

Similar questions