Home Station is a retail hardware and home goods store that offers installation for some of...
Fantastic news! We've Found the answer you've been seeking!
Question:
![Home Station is a retail hardware and home goods store that offers installation for some of the products it](https://dsd5zvtm8ll6.cloudfront.net/questions/2024/01/659b860d8e6bd_1704691096608.jpg)
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?
Expert Answer:
Related Book For
Posted Date:
Students also viewed these general management questions
-
Consider the following simplified financial statements for the Phillips Corporation assuming no income taxes. Income Statement Statement of Financial Position Sales Costs P23,000 16,700 Assets...
-
After the Internet investment bubble burst, the original concept of easyInternetcaf? (eIc) was just not working out. The management decided to retrench, closing and downsizing some of the original...
-
Falcor Supplies is a distributor of high tech teaching equipment. Its primary target customers are schools in the region who purchase the teaching equipment for classrooms and online use. The...
-
A two block system with weights W and Wo is shown above. Wo is pulling W over the table at a steady velocity U. Derive the algebraic expression for this velocity as it slides on a film of oil with a...
-
Men spend an average of 29 minutes per day on weekends and holidays exercising and playing sports. They spend an average of 23 minutes per day reading. A random sample of 25 men resulted in a mean of...
-
Consider a cylindrical enclosure with A 1 , A 2 , and A 3 representing the internal base, top, and side surfaces, respectively. Using the length to diameter ratio, K = L/D, determine (a) The...
-
The vitality of Suffolk lambs. The neonatal period is crucial for a lambs survival. Newborn lambs require milk and immunological protection, which are dependent on mutual maternalfilial behavior. A...
-
Sentinel Security Services was established on March 15, 2012, to provide security services. The services provided during the remainder of the month are listed below. Mar. 18. Issued Invoice No. 1 to...
-
The minimum amount of contributed capital that must remain in the corporation as a margin of protection for creditors is called the: Select one: A. Retained earnings B. Paid-in capital C. Legal...
-
Throughout the course, you will be working on a Wealth Management Analyst Project For this project, imagine you are a new hire at a wealth management firm and tasked with determining the location of...
-
For the following situation, find the mean and standard deviation of the population. List all samples ( with replacement ) of the given size from that population and find the mean of each. Find the...
-
The problem I have identified is that healthcare leaders could benefit from addressing the issue of stress and burnout, which impact revenue (Scott, 2022). I have found a peer-reviewed article...
-
Facebook, Inc is the company Complete a 3-5 year forecast for your target company assuming a 10% average growth rate for the duration of the forecast period Assuming a long-term growth rate of 5%...
-
BSC-It is important for healthcare leaders to link their departmental balanced scorecard (BSC) to a corporate BSC because it facilitates alignment with the overall strategic objectives of the...
-
Hebert Company adds material at the beginning of production. The following production information is available for March: Beginning Work in Process Inventory (40% complete as to conversion) Started...
-
What modifications would you suggest the leaders of the steel organization when dealing with the use of more efficient technology, carbon emissions, and negative economic impacts in order tomake in...
-
The Sisyphean Company is planning on investing in a new project. This will involve the purchase of some new machinery costing $225,000. The Sisyphean Company expects cash inflows from this project as...
-
(a) Bright Sdn Bhd (BSB) is a tax resident manufacturing company in Johor, which involves in ceramic tiles. Currently, BSBs annual sales turnover has been forecasted to be around RM 300,000 for the...
-
Many companies must determine whether to internally produce their component parts or to outsource them. Further, some companies now outsource key components or business processes to international...
-
After recording the transactions of Exercise C-6 in T-accounts and calculating the balance of each account, prepare a trial balance. Use May 31, 2009, as its report date.
-
Best Buy offers services to customers that help them use products they purchase from Best Buy. One of these services is its Geek Squad, which is Best Buys 24-hour computer support task force. As you...
-
Describe the difference between accounting for governmental funds and proprietary funds. AppendixLO1
-
What is the difference between an enterprise fund and an internal service fund? AppendixLO1
-
What is the difference between a permanent fund and a private-purpose trust fund? AppendixLO1
![Mobile App Logo](https://dsd5zvtm8ll6.cloudfront.net/includes/images/mobile/finalLogo.png)
Study smarter with the SolutionInn App