Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Home Station is a retail hardware and home goods store that offers installation for some of the products it sells. For example, it hires
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?
Step by Step Solution
★★★★★
3.35 Rating (161 Votes )
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started