# Question

A fertilizer manufacturer has to fulfill supply contracts to its two main customers (650 tons to Customer A and 800 tons to Customer B). It can meet this demand by shipping existing inventory from any of its three warehouses. Warehouse 1 (W1) has 400 tons of inventory on hand, Warehouse 2(W2) has 500 tons, and Warehouse 3 (W3) has 600 tons. The company would like to arrange the shipping for the lowest cost possible, where the per-ton transit costs are as follows:

(a) Explain what each of the six decision variables (V) is:

V A1: ________________________________________

V A2: ________________________________________

V A3: ________________________________________

V B1: ________________________________________

V B2: ________________________________________

V B3: ________________________________________

(b) Write out the objective function in terms of the variables (V A1, V A2, etc.) and the objective coefficients.

(c) Aside from nonnegativity of the variables, what are the five constraints? Write a short description for each constraint, and write out the formula (and circle the type of equality/inequality).

After you formulate and enter the linear program for Problem B.27 in Excel, the Solver given you the following sensitivity report:

(d) How many of the constraints are binding?

(e) How much slack/surplus is there with the nonbinding constraint(s)

(f) What is the range of optimality on variable V A3?

(g) If we could shop 10 tons less to Customer a, how much money might we be able to save? If we could chose to short either Customer A or Customer B by 10 tons, which would we prefer to short?Why?

(a) Explain what each of the six decision variables (V) is:

V A1: ________________________________________

V A2: ________________________________________

V A3: ________________________________________

V B1: ________________________________________

V B2: ________________________________________

V B3: ________________________________________

(b) Write out the objective function in terms of the variables (V A1, V A2, etc.) and the objective coefficients.

(c) Aside from nonnegativity of the variables, what are the five constraints? Write a short description for each constraint, and write out the formula (and circle the type of equality/inequality).

After you formulate and enter the linear program for Problem B.27 in Excel, the Solver given you the following sensitivity report:

(d) How many of the constraints are binding?

(e) How much slack/surplus is there with the nonbinding constraint(s)

(f) What is the range of optimality on variable V A3?

(g) If we could shop 10 tons less to Customer a, how much money might we be able to save? If we could chose to short either Customer A or Customer B by 10 tons, which would we prefer to short?Why?

## Answer to relevant Questions

New Orleans’s Mt. Sinai Hospital is a large, private, 600-bed facility complete with laboratories, operating rooms, and X-ray equipment. In seeking to increase revenues, Mt. Sinai’s administration has decided to make a ...What are the steps in the intuitive lowest-cost method?(a) Use the northwest-corner method to find an initial feasible solution to the following problem. What must you do before beginning the solution steps?(b) Use the intuitive lowest-cost approach to find an initial feasible ...Lawson Mill Works (LMW) ships pre-cut lumber to three building-supply houses from mills in Mountpelier, Nixon, and Oak Ridge. Determine the best shipment schedule for LMW from the data provided by James Lawson, the traffic ...State the assumptions of the “basic” single-channel queuing model (Model A, or M/M/1).Post your question

0