Hello, please make an excel of this. Show all the cells thanks     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.

Marketing
20th Edition
ISBN:9780357033791
Author:Pride, William M
Publisher:Pride, William M
Chapter19: Pricing Concepts
Section: Chapter Questions
Problem 11DRQ
icon
Related questions
Question

Hello, please make an excel of this. Show all the cells thanks

 

 

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.

Expert Solution
steps

Step by step

Solved in 2 steps with 3 images

Blurred answer
Recommended textbooks for you
Marketing
Marketing
Marketing
ISBN:
9780357033791
Author:
Pride, William M
Publisher:
South Western Educational Publishing
Foundations of Business (MindTap Course List)
Foundations of Business (MindTap Course List)
Marketing
ISBN:
9781337386920
Author:
William M. Pride, Robert J. Hughes, Jack R. Kapoor
Publisher:
Cengage Learning
Foundations of Business - Standalone book (MindTa…
Foundations of Business - Standalone book (MindTa…
Marketing
ISBN:
9781285193946
Author:
William M. Pride, Robert J. Hughes, Jack R. Kapoor
Publisher:
Cengage Learning
MARKETING 2018
MARKETING 2018
Marketing
ISBN:
9780357033753
Author:
Pride
Publisher:
CENGAGE L
Contemporary Marketing
Contemporary Marketing
Marketing
ISBN:
9780357033777
Author:
Louis E. Boone, David L. Kurtz
Publisher:
Cengage Learning
Principles of Management
Principles of Management
Management
ISBN:
9780998625768
Author:
OpenStax
Publisher:
OpenStax College