Q4. (10 points) When new homes are built, frequently parts such as the handle/valve units used...

Transcribed Image Text:

Q4. (10 points) When new homes are built, frequently parts such as the handle/valve units used in bathroom sinks are bought as closeout items from a manufacturer. When they need to be replaced, a sample must be sent to a machine shop so that they can be duplicated. Although this may seem like a costly process, some bathrooms have two or three sinks, each with two handles. Thus, if one unit becomes inoperative or damaged, unless the owner wishes to replace all 4-6 handle/valve units or have one handle that does not match the others, a special order is needed. When Northumberland Homes (NH) built the 250 tract houses of the River View Subdivision in Miramichi, N.B., it used a closeout handle/valve unit from Farmon Industries. Farmon Industries has since gone bankrupt, and many homeowners in the River View Subdivision are reporting problems with their handles. Northumberland has sent a sample to Total Bathworks Mfg. (TBM) and placed an order for at least 50 of the handle/valve units. TBM scheduled 8 hours on each of two machines required to produce the handles on June 15 to process the order. There are two different processes that Total Bathworks Mfg. can use to produce the units. The first, resulting in a cost of $15 per unit, requires 12 minutes on machine 1 and 5 minutes on machine 2. The second, resulting in a cost of $11 per unit requires 7 minutes on machine 1 and 13 minutes on machine 2. Required: Solve this LP model by using Excel and computer How many handle/valve units should Total Bathworks Mfg. produce using each process on June15? Q4. (10 points) When new homes are built, frequently parts such as the handle/valve units used in bathroom sinks are bought as closeout items from a manufacturer. When they need to be replaced, a sample must be sent to a machine shop so that they can be duplicated. Although this may seem like a costly process, some bathrooms have two or three sinks, each with two handles. Thus, if one unit becomes inoperative or damaged, unless the owner wishes to replace all 4-6 handle/valve units or have one handle that does not match the others, a special order is needed. When Northumberland Homes (NH) built the 250 tract houses of the River View Subdivision in Miramichi, N.B., it used a closeout handle/valve unit from Farmon Industries. Farmon Industries has since gone bankrupt, and many homeowners in the River View Subdivision are reporting problems with their handles. Northumberland has sent a sample to Total Bathworks Mfg. (TBM) and placed an order for at least 50 of the handle/valve units. TBM scheduled 8 hours on each of two machines required to produce the handles on June 15 to process the order. There are two different processes that Total Bathworks Mfg. can use to produce the units. The first, resulting in a cost of $15 per unit, requires 12 minutes on machine 1 and 5 minutes on machine 2. The second, resulting in a cost of $11 per unit requires 7 minutes on machine 1 and 13 minutes on machine 2. Required: Solve this LP model by using Excel and computer How many handle/valve units should Total Bathworks Mfg. produce using each process on June15?