Powerhouse capacitors produces capacitors

Assignment Help Operation Management

Reference no: EM131485365

Powerhouse Capacitors produces capacitors at three locations – Los Angeles, Chicago, and New York. Each plant has an annual production capacity of 100,000 capacitors. Capacitors are shipped from these locations to public utilities in five regions of the country: Northeast (NE), Northwest (NW), Midwest (MW), Southeast (SE), and Southwest (SW). The annual demands for capacitors in each region are as follows: 55,000 in NE, 50,000 in NW, 60,000 in MW, 60,000 in SE, and 45,000 in SW. The costs of producing and shipping a capacitor from each plant to each region of the country are given in the file “Powerhouse_data.” (This file also includes the above demand data, in ‘000s of units).

(a) Formulate the problem of minimizing the total cost, this year, of producing and shipping capacitators to meet all demands from the current three plants.

(b) Implement in Excel, and report the optimal solution and minimum annual cost.

Reference no: EM131485365

Questions Cloud

How can information systems be used in five porter model : How can Information Systems be used in Five Porter Model?

Longer in order to completely cure it : Why does Tuberculosis take 6-9 months or maybe even longer in order to completely cure it?

Revive the dead zone from a microbiologist : What solution(s) would you suggest to revive the dead zone from a microbiologist's view? Include in your answers some microbial process(es).

How training-development are seen as different in culture : Write an argumentative essay about How training and development are seen as different in any culture.

Powerhouse capacitors produces capacitors : Formulate the problem of minimizing the total cost, this year, of producing and shipping capacitators to meet all demands from the current three plants.

Calculate the equilibrium price and quantity : The producer of a cosmetic product needs to decide the optimal price to charge and the optimal quantity to supply in the market.

Implementation and integration of the desktop application : CIS8000 Assignment 2 - ENTERPRISE DESKTOP APPLICATION PROPOSAL. Implementation and integration of the application within the existing organizational

Real world it security breach and perform a case study : Choose a real world IT security breach, and perform a case study. Within this study, analyze the method the attackers used to gain access.

Maximize profits for its shareholders : In our free-market economy we commonly hear that a business' is its' primary responsibility to maximize profits for its shareholders.

User Account

All Pages