How much of the demand at each of the warehouses must be met

Assignment Help Supply Chain Management
Reference no: EM131323228

There are production facilities in Battle Creek, Cherry Creek, and Dee Creek with annual capacities of 500 units, 400 units, and 600 units, respectively. The annual demands at warehouses in Worchester, Dorchester, and Rochester are 300 units, 700 units, and 400 units, respectively. The table below gives the unit transportation costs between the production facilities and the warehouses.

 

Worchester

Dorchester

Rochester

Battle Creek

$20/unit

$30/unit

$13/unit

Cherry Creek

$10/unit

$5/unit

$17/unit

Dee Creek 

$15/unit

$12/unit

$45/unit

How much of the demand at each of the warehouses must be met by each of the production facilities?

By using Excel Solver (Excel Solver is an Add-in that does not come standard with Excel. Installing it is quick and easy with the right instructions. (I'll provide two PDFs which will help the tutor (once the task is assigned ) to understand the question and they are MUST to review )).

Remember that you must show all work for this assignment and interpret your result.

Reference no: EM131323228

Questions Cloud

Evaluate an application implementation plan : Given a set of organizational resource and timing constraints, evaluate an application implementation plan that balances multiple stakeholder considerations such as time, scope, quality, risk, and change.
Can a company ensure the integrity of its employees : Do you feel that it is effective for a company to rely on the integrity of its employees? Why or why not? Can a company ensure the integrity of its employees? Explain.
Construct the amortization schedule for loan : Molina healthcare has just borrowed $25,000,000 on a 7 year, annual payment term loan at a 12 percent interest rate. The first payment is due one year from now. Construct the amortization schedule for this loan.
Improve the performance of a supplier in a service : Define the elements necessary to evaluate and improve the performance of a supplier in a service or manufacturing setting. These elements should address both the individual "product or service" that is supplied as well as the elements needed to ev..
How much of the demand at each of the warehouses must be met : How much of the demand at each of the warehouses must be met by each of the production facilities? The annual demands at warehouses in Worchester, Dorchester, and Rochester are 300 units.
Interest rate component and exchange gain-loss component : Outline the steps for CIA with the appropriate computation thereof and compute the profit. Compute the Return on Investment of $1 million and identify its components: Interest Rate Component and Exchange Gain/Loss Component.
How many such checks would have to be made : How many such checks would have to be made in a search of the tree to depth d?
Immediacy and urgency of the pollution problems : The immediacy and urgency of the pollution problems in the 1950s and 1960s led to an air quality strategy that focused mainly on cleaning up existing problems. The remediation that was needed allowed little time and effort devoted to preventing th..
Measure performance of a project : - What other ways can you track and measure performance of a project other than Earned Value Measurement (EVM)? - Are some better given the right scenario? What have you seen?

Reviews

Write a Review

Supply Chain Management Questions & Answers

  Discuss about the future of retail supply chains

Case Study :The future of retail supply chains(By Nitin Chaturvedi, Mirko Martich, Brian Ruwadi, Nursen Ulker)Discuss about the future of retail supply chains.explain in brief.

  Moving his senior managers to new positions-case study

Do you feel that it was the right thing to do letting all of the tenured senior management go and Why?

  Contrast and comment on the performance

1.Pasquist Water Company (PWC) operates a 24 hour facility designed to efficiently fill water hauling tanker trucks.

  Supply chain practices of two or more different companies

Compare the supply chain practices of two or more different companies in the same industry or similar industries.Should one firm adopt another's superior practices, or are their situations sufficiently different that each is already optimised?Why?

  Discuss the logistical implication

Discuss the logistical implication associated with the increased emphasis on the convenience associated with a family's shopping experience

  Assume there are no time value of money concerns

A high school student is trying to decide what to do after high school. She could get a job, where she expects to make an average of $25,000 per year over the next 10 years. She assumes she will have no problems finding a job. Assume there are no tim..

  How erp systems impact effectiveness of supply chain

Describe how ERP systems impact the effectiveness of internal and external supply chain integration. I need 4 slides with some speaker notes for a given company that i provide at time if handshake.

  Advantages and disadvantages for sme to implement greer

What are the advantages and disadvantages for SME to implement Greer, Supply Chain Management? Explain with relevant example of a SME that has successfully implemented green supply chain in their business process

  How the airline industry can improve the processes

How the Airline Industry can improve the processes of handling baggage and flight planning. Improvements to the luggage process could be achieved by the use of RFID and other technologies to achieve six-sigma.

  Analyze apple computer - customer relationship management

How Apple Inc, uses each of the following business activities::"business intelligence", "enterprise resource planning (ERP)", "customer relationship management (CRM)", "data mining", and "intelligent systems", and assesses the results in the repor..

  Importance of leadership in bringing about necessary changes

Assess importance of leadership in bringing about the necessary changes at Porsche. Describe answer with examples.

  Build a combination west coast manufacturing location

Provide a detailed recommendation as to whether you should open a West Coast distribution center, add on to the existing East Coast factory and warehouse, or build a combination West Coast manufacturing location and warehouse

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd