How to minimize the sum of penalty and shipping costs

Assignment Help Operation Management

Reference no: EM132162953

Q1 : Allied Freight supplies goods to three customers, who each require 30 units. The company has two warehouses. In warehouse 1, 40 units are available, and shipping one unit from each warehouse to each customer are shown in the file P05-67.xlsx. There is a penalty for each unsatisfied customer unit of demand: with customer 1, a penalty cost of $90 is incurred; with customer 2, $80; and with customer 3, $110.

a. Determine how to minimize the sum of penalty and shipping costs.

b. Use Solver Table to see how a change in the unit penalty cost of customer 3 affects the optimal cost.

c. Use Solver Table to see how a change in the capacity of warehouse 2 affects the optimal cost.

Q2 : In the United Copiers service center model, we assumed that the potential locations of service centers are the same as existing customer locations.

Change the model so that the customer locations are the ones given, but the only potential service center locations are in Memphis, Houston, Cleveland, Buffalo, Minneapolis, St. Louis, and Kansas City. Use Solver to find the optimal solution.

Reference no: EM132162953

Questions Cloud

Find payback period if solar water heater system installed : Tom Sewel has gathered data on the relative costs of a solar water heater system and a conventional electric water heater. The data are based on statistics.

Write a professional statement of your ethics in workplace : Frame your statement for the work context. Who are you as an employee? If an employer were to hire you, what would he or she get as a professional person?

Involving off-budget taxation and spending : Explain why a military draft can be thought of as involving off-budget taxation and spending?

Calculate the total equivalent investment cost : A large project requires an investment of $200 million. The construction will take 3 years: $30 million will be spent during the first year.

How to minimize the sum of penalty and shipping costs : In the United Copiers service center model, we assumed that the potential locations of service centers are the same as existing customer locations.

Should Congress legislate in response to Citizens United : Read the First Ammendment and study the Citizens United vs Federal Election Commission case - Should Congress legislate in response to Citizens United

What is the payback period : A car dealer leases a small computer with software for $5000 per year. As an alternative he could buy the computer for $7000 and lease the software for $3500.

Compare and contrast the three models of culture : Compare and contrast the three (3) models of culture. Next, select one (1) of the researched international competitors.

Give an example of an event in the last few years : Give an example of an event in the last few years where the actions in the event increased our (U.S.A.) GDP number

User Account

All Pages