Melnick enterprises manufactures two products boat wax and

Reference no: EM13378616

Melnick Enterprises manufactures two products, boat wax and car wax, in two departments, the Mixing Department and the Packaging Department. The Mixing Department has 800 production hours per month available, and the Packaging Department has 1,200 hours per month available. Production of the two products cannot exceed 36,000 pounds. Data on the two products follow:

1331_Objective function and the mixing constraints.png

Required:

Use Excel to calculate the optimal monthly production mix (per 100 pounds) of Boat Wax and Car Wax that Melnick should produce? Clearly show the objective function and the mixing constraints for the linear program that Melnick would use to determine the optimal monthly production of each wax.

Reference no: EM13378616

Questions Cloud

1suppose the equilibrium price in a competitive price taker : 1.suppose the equilibrium price in a competitive price taker market is 10 and a firm in the industry charges 9 which of

Brewer corp is considering dropping its talking dog product : brewer corp. is considering dropping its talking dog product line due to continuing losses. revenue and cost data for

Pricefeedernbsp quantity demandednbsp quantity supplied300 : pricefeedernbsp quantity demandednbsp quantity supplied300 nbsp nbsp nbsp nbsp nbsp nbsp nbsp 500 nbsp nbsp nbsp nbsp

Hirams lakeside is a popular restaurant located on lake : hirams lakeside is a popular restaurant located on lake washington in seattle. the owner of the restaurant has been

Melnick enterprises manufactures two products boat wax and : melnick enterprises manufactures two products boat wax and car wax in two departments the mixing department and the

1 which of the following is always truewhen marginal costs : 1. which of the following is always true?when marginal costs are less than average total costs average total costs will

Rum company has developed a new product that will be : rum company has developed a new product that will be marketed for the first time during the next fiscal year. although

United states has absolute advantage over many countries in : united states has absolute advantage over many countries in production of most goods and services. yet the country is

Question no1 mac company manufactures and sells adjustable : question no.1 mac company manufactures and sells adjustable canopies that attach to motor homes and trailers. the

User Account

All Pages