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...

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 aluminium, 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 cost $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?