or longer. How can Aluminaca minimize the material costs incurred in meeting required weekly demands? chat is 58000 cars. cars kon, ntly salary 000 to e during ut at the bot. in the com- w can the e next six 101. 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 102. Each day, Eastinghouse no ing the No template will be provided for this optional, extra credit problem. Please use the problem description from page 208 of your textbook to create the spreadsheet model. If you provide a correct solution then you will be awarded 7 extra bonus points for this homework assignment. There will be no partial bonus points awarded for a partial solution. Your answer must be fully correct to receive extra credit. Problem 4.101 - Ingor Production at Aluminaca (p. 208) 1 Production data (maximum production if fumaces are devoted entirely to a particular ingot length) Furnace 100-foot 200-foot 300-foot 230 340 350 2 230 260 280 3 240 300 310 4 200 280 300 Cost per foot Available Decisions (how many hours on each furnace to devote to each ingot length) Furnace 100-foot 200-foot 300-foot Sum 1 2 3 4 Ingots produced Furnace 200-foot 300-foot 100-foot 2 3 4 Total Demand constraints 100-foot Available 200-foot 300-foot Demand 700 300 150 Total cost