Hello, please make an excel of this. Show all the cells thanks. some replied with a paper answer thank you I just cant understand the way the did it. Can someone show me all screenshots o fthis problem solved and in excel? i need to solver too for the constraints. I seen multiple times across other platforms that one of the chairs optimal solutions is 0 but they both have to be higher than 1 The Heinrich Company manufactures two types of plastic hangerracks (Foldaways and Straightaways) especially suited for mountingnear clothes dryers. Because permanent press clothing must be hungon hangers immediately after removal from the dryer, these items havebeen especially popular. However, there is some concern that thePreppie movement (popularized by its own handbook) will extinguishpolyester clothing; Heinrich is terribly interested in doing the best withthe resources it has while its products are still in demand. The firsttype of hanger rack, the Foldaway, requires 10 ounces of plasticmaterial and 0.3 hours of labor. Plastic costs Heinrich 10 cents anounce; labor costs Heinrich $20 per hour. The second type of hangerrack, the Straightaway, requires 15 ounces of plastic and 0.175 hoursof labor. The prices of these resources are the same as those for theFoldaway. Under current market conditions, Heinrich can sell theFoldaway for $12 and the Straightaway for $11. Heinrich is unable tohire more than 350 hours of labor a week, or buy more than 50,000ounces of plastic a week. How many Foldaways and Straightawaysshould Heinrich produce to maximize their profit.
Hello, please make an excel of this. Show all the cells thanks. some replied with a paper answer thank you I just cant understand the way the did it. Can someone show me all screenshots o fthis problem solved and in excel? i need to solver too for the constraints. I seen multiple times across other platforms that one of the chairs optimal solutions is 0 but they both have to be higher than 1
The Heinrich Company manufactures two types of plastic hanger
racks (Foldaways and Straightaways) especially suited for mounting
near clothes dryers. Because permanent press clothing must be hung
on hangers immediately after removal from the dryer, these items have
been especially popular. However, there is some concern that the
Preppie movement (popularized by its own handbook) will extinguish
polyester clothing; Heinrich is terribly interested in doing the best with
the resources it has while its products are still in demand. The first
type of hanger rack, the Foldaway, requires 10 ounces of plastic
material and 0.3 hours of labor. Plastic costs Heinrich 10 cents an
ounce; labor costs Heinrich $20 per hour. The second type of hanger
rack, the Straightaway, requires 15 ounces of plastic and 0.175 hours
of labor. The prices of these resources are the same as those for the
Foldaway. Under current market conditions, Heinrich can sell the
Foldaway for $12 and the Straightaway for $11. Heinrich is unable to
hire more than 350 hours of labor a week, or buy more than 50,000
ounces of plastic a week. How many Foldaways and Straightaways
should Heinrich produce to maximize their profit.
Step by step
Solved in 2 steps
