Home Station is a retail hardware and home goods store that offers installation for some of...

Transcribed Image Text:

Home Station is a retail hardware and home goods store that offers installation for some of the products it sells. For example, it hires five local carpentry contractors to erect tool sheds in the yards of customers who buy them. Since the price Home Station charges its customers for tool shed installation is fixed, the company wants to minimize the cost of the installations. This week five customers have ordered shed installation, and each of the carpentry contractors can send out a crew to perform one of them. The cost of each contractor installing a shed is different for each customer: Crew Antonini Branigan Chiu D'Entremont Edelman Ikemba $300 $250 $230 $260 $260 Jong $440 $320 $400 $380 $340 Customer Kirk $380 $450 $370 $370 $440 Luzinski $470 $440 $390 $450 $430 Mikkelsen $310 $250 $290 $280 $280 a. Formulate a linear program to determine which contractor should send a crew to which customer. b. Create an Excel spreadsheet of the program and use it to find the solution. c. Edelman has informed Home Station that it now must charge $350 to install a shed for Mikkelsen. Should Home Station now change which contractor sends a crew to which customer? Home Station is a retail hardware and home goods store that offers installation for some of the products it sells. For example, it hires five local carpentry contractors to erect tool sheds in the yards of customers who buy them. Since the price Home Station charges its customers for tool shed installation is fixed, the company wants to minimize the cost of the installations. This week five customers have ordered shed installation, and each of the carpentry contractors can send out a crew to perform one of them. The cost of each contractor installing a shed is different for each customer: Crew Antonini Branigan Chiu D'Entremont Edelman Ikemba $300 $250 $230 $260 $260 Jong $440 $320 $400 $380 $340 Customer Kirk $380 $450 $370 $370 $440 Luzinski $470 $440 $390 $450 $430 Mikkelsen $310 $250 $290 $280 $280 a. Formulate a linear program to determine which contractor should send a crew to which customer. b. Create an Excel spreadsheet of the program and use it to find the solution. c. Edelman has informed Home Station that it now must charge $350 to install a shed for Mikkelsen. Should Home Station now change which contractor sends a crew to which customer?