Answered step by step
Verified Expert Solution
Link Copied!

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

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

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Managerial Accounting

Authors: John J. Wild, Ken W. Shaw

2010 Edition

9789813155497, 73379581, 9813155493, 978-0073379586

More Books

Students also viewed these General Management questions