What is the cheapest way to fill the orders

Assignment Help Operation Management

Reference no: EM131801310

(Using excel) A quarry uses five types of rocks to fulfill four orders. The gypsum content, availability of each type of rock, and the production cost per pound for each rock, as well as the size of each order and the minimum and maximum gypsum percentage in each order, are given below.

Rock type-------Cost-------% gypsum-------Amount

1-------------------$1.00-----------2.0%-----------500

2-------------------$5.00-----------5.0%-----------600

3-------------------$5.50-----------4.5%-----------700

4-------------------$2.00-----------3.0%-----------400

5-------------------$1.20-----------6.0%-----------450

Order No.--------------------1----------2----------3---------4

Order Size------------------500------600------500------350

Min % gypsum-----------3.5%-----3.8%-----4.0%-----3.6%

Max % gypsum----------4.4%-----4.6%-----4.7%-----4.8%

What is the cheapest way to fill the orders?

Reference no: EM131801310

Questions Cloud

The prototypical example of divestiture socialization : the prototypical example of divestiture socialization.

Four levels of managers who use planning : Which of the following is one of the four levels of managers who use planning. Which of the following is one of the four levels of managers who use planning

Types of teams produce one-time outputs and are time-limited : These types of teams produce one-time outputs and are time-limited. One disadvantage of impromptu verbal RJPs is that the organization has no way to.

Statements is true of bureaucratic control : Which of the following statements is true of market control? Which of the following statements is true of bureaucratic control?

What is the cheapest way to fill the orders : A quarry uses five types of rocks to fulfill four orders. What is the cheapest way to fill the orders?

Appropriate emotions are displayed for customers : When you are practicing______ , the appropriate emotions are displayed for customers to see but not actually felt by the employee.

What are the common negotiation pitfalls : What is negotiation? What are the common negotiation pitfalls? What are the strategies to overcome them?

What is the duration of the critical path : A project has eight activities: A, B, C, D, E, F, G, and H. Activities A, B can start anytime. What is the duration of the critical path?

Requirements discovered during systems analysis : What are the three categories that systems analysts use to organize all the requirements discovered during systems analysis?

User Account

All Pages