Question

(PLEASE SHOW MICROSOFT EXCEL STEPS) A manufacurer of bathroom fixtures produces fiberglass bathtubs in an assebly operations consisting of three processes: moldinig, smoothing, and painting. The number of units that can be put throught each process in an hour is shown below. (Note: the three processes are contious ans sequential; thus, no more units can be smoothed or painted than have been molded.) The labor cost Each bathtub requires 90 pounds of fiberglass, and the company has a total of 10,000 pounds of fiberglass available each week Each bathtub earns a profit of $175. The manager of the company wants to know how many hours per week to run each process in order to maximize profit. USING MICROSOFT EXCEL, formulate and solve a linear programing model for this problem Process, Output, and Cost as Follows--- (Modeling: 7units/hr @ $8/hr) (Smoothing: 12units/hr @ $5/hr) (Painting: 10units/hr @ $6.50/hr)

Answer 1

Name the three processess Molding (M), Smoothing (S), Painting (P) as.M, S, P respectively. These would represent the hours respectively.

Equation would be Max 175*7M - 8M - 5S - 6.5P

Upon solving it

7M = 12S or, 7M - 12S = 0 .

This would be the number of batchtubs smoothed is equal to number of batchtubs molded

7M = 10P or, 7M - 10P = 0   

This would be the number of batchtubs painted is equal to number of batchtubs molded

90*7M <= 10000

M, S, P >= 0

Observe theSolution of LP model using LINDO in the following screenshot:

Optimal solution is highlighted in the above screenshot.