Linear programming model to minimize the operating costs

Assignment Help Operation Management

Reference no: EM13822329

Field A and field B of a mining company produce two types of coals. Both fields can produce coal-1 and coal-2. The operating cost ($ per day) for field A and field B are $55,000 and $45,000, respectively. Mining field A can produce 250 tons of coal-1 along with 300 tons of coal-2 coal per day whereas the mining field B can produce 200 tons of coal-1 along with 450 tons of coal-2 per day. The demand for coal-1 is expected to be 120,000 tons and for coal-2, it is expected to be 170,000 tons. The expected demand should be met.

a. Write out a linear programming model to minimize the operating costs of the mining fields and decide how many days the company needs to operate each of these fields.

b. Solve the model using Excel Solver and give the optimal days to operate each of the fields.

Please also be sure to show formulas in excel!

Reference no: EM13822329

Questions Cloud

Observed differences over time are important : How can you or your department decide whether or not the observed differences over time are important? How could using a mean difference test help?

How curt flood changed baseball : How Curt Flood Changed Baseball and Killed His Career in the Process

Write an informative essay about domestic violence : Write an informative Essay about DOMESTIC VIOLENCE. This should be an objective, detailed overview of the issue you have chosen.

Revolutionize an inventory management system : How can (RFID) Radio Frequency Identification tags revolutionize an Inventory Management System? Explain.

Linear programming model to minimize the operating costs : Field A and field B of a mining company produce two types of coals. Both fields can produce coal-1 and coal-2. The operating cost ($ per day) for field A and field B are $55,000 and $45,000, respectively. Write out a linear programming model to minim..

Annotated bibliography and reference list : Submit your annotated bibliography and reference list for the project on The Kantianism Theory. The references used in your research should address value dilemmas that health care providers confront as well as reflect and support your chosen theory.

Some fears-concerns in regard to universal health care : The United States government does not offer universal health care. Is universal health care a good or bad thing? Canada's health care system is one model of universal health care. Is Canada a good model for the United States? What are the pros and co..

Discuss the primary ethical dilemmas : Determine the level of trust that you would place in information provided by the following: a salesman at the car lot, the dealer's Website, social media (i.e. Facebook), an associate from work, and finally a close friend. Discuss the key factors inv..

Why a need analysis is a critical component of evaluation : Explain why a needs analysis is a critical component of evaluation

User Account

All Pages