Aluminaca produces 100-foot-long, 200-foot-long,and 300-foot-long ingots for customers. This week’sdemand for ingots is listed in the file P04_101.xlsx.Aluminaca has four furnaces in which ingots canbe produced. During one week, each furnace can beoperated for 50 hours. Because ingots are produced bycutting up long strips of aluminum, longer ingots takeless time to produce than shorter ingots. If a furnaceis devoted completely to producing one type of ingot,the number it can produce in one week is listed in thesame file. For example, furnace 1 could produce 350300-foot ingots per week. The material in an ingotcosts $10 per foot. A customer who wants a 100-footor 200-foot ingot will accept an ingot of that lengthor longer. How can Aluminaca minimize the materialcosts incurred in meeting required weekly demands?
Aluminaca produces 100-foot-long, 200-foot-long,
and 300-foot-long ingots for customers. This week’s
demand for ingots is listed in the file P04_101.xlsx.
Aluminaca has four furnaces in which ingots can
be produced. During one week, each furnace can be
operated for 50 hours. Because ingots are produced by
cutting up long strips of aluminum, longer ingots take
less time to produce than shorter ingots. If a furnace
is devoted completely to producing one type of ingot,
the number it can produce in one week is listed in the
same file. For example, furnace 1 could produce 350
300-foot ingots per week. The material in an ingot
costs $10 per foot. A customer who wants a 100-foot
or 200-foot ingot will accept an ingot of that length
or longer. How can Aluminaca minimize the material
costs incurred in meeting required weekly demands?
Trending now
This is a popular solution!
Step by step
Solved in 2 steps