Reference no: EM131437623

Goethe’s Co., produces Brute and Chanelle perfumes. The raw material needed to manufacture each type of perfume can be purchased for $3 per pound. Processing 1 lb of raw material requires 1 hour of laboratory time. Each pound of processed raw material yields 3 oz of Regular Brute perfume and 4 oz of Regular Chanelle Perfume. Regular Brute can be sold for $7/ oz and Regular Chanelle for $6/oz. Goethe’s also has the option of further processing of both types to produce Luxury Brute, i.e., sold at $18/oz and Luxury Chanelle sold at $14/oz. Each ounce of regular brute processed further requires an additional 3 hours of laboratory time and $4 processing cost and yields 1 oz of luxury Brute. Each ounce of regular Chanelle processed further requires an additional 2 hours of laboratory time and $4 processing cost and yields 1 oz of Luxury Chanelle. Each year Goethe’s co has 6,000 hours of laboratory time available and can purchase up to 4,000 lb of raw material. Formulate an LP that can be used to determine how Goethe’s Co can maximize profits. Assume that the cost of laboratory hours is a fixed cost. Solve and show work in excel including formulas and everything please.