Solution-How much of the demand at each of the warehouses

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?

User Account

All Pages

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

Reference no: EM131323228

Reference no: EM131323228

Questions Cloud

Reviews

Write a Review

Supply Chain Management Questions & Answers

Supply chain network design for cwc

Criteria when making new location decisions

Draw the project network

Compare and contrast economic - market, and relevancy

Brushing up on inventory control

Supply chain strategy

What is the economic order quantity for fans in units

What factors reduce the capacity of the organization

What is the total annual cost

Supply chain management questions

Explain the supply chain management concept

How warehouses can add value in the supply chain

Assured A++ Grade

Academics

Major Subjects

Majors

Get In Touch

TERMS & POLICIES

HELP & SUPPORT