A coffee manufacturing company has two different plants

Assignment Help Business Management

Reference no: EM13499310

A coffee manufacturing company has two different plants that roast imported coffee beans. After roasting, the plants produce three types of coffee beans, A, B, and C. The company has contracted with a chain of cafes to provide per week, 20 tons of coffee bean A, 11 tons of coffee bean B, and 18 tons of coffee bean C. The two plants have the same capacity, but diverse operational features as below:
Manufacturing Cost per Ton ($)
Plant A B C Capacity
P1 900 1125 875 25
P2 850 1200 950 25
Demand 20 11 18

Formulate and solve all-integer model that will determine how many tons of each type of coffee beans are produced in each plant by minimizing the total cost.

For this mathematical programming optimization problem:
Formulate and solve the model on Microsoft EXCEL Solver and prepare a Managerial Report that includes...

A detailed introduction and explanation of the setting. Embellish if you wish!
A complete formulation of the linear optimization model.
Explain all variables, the objective, and constraints well.
Provide the Microsoft EXCEL Solver output.
Answer any questions posed in the problem.
Provide and thoroughly interpret the reports from EXCEL Solver and note any interesting or more insightful output.

• After you have finished everything (described, formulated, solved, answered all questions, and written all of the report), create a one-page "Executive Summary" that indicates what the problem is, what you did to solve it, the final solution, and any other interesting results. This synopsis is for the busy executive who wants to see what is in the report and look at details further if interested.

Reference no: EM13499310

Questions Cloud

Prepare the project on history of periodic element table : Prepare the project on given topics -The history of the use of Scientific methods among the Arabs and interpretation of modern scientific research methods

Explain the dilemma for organizations : 1. Explain the dilemma for organizations that have particularly serious regulatory issues. How should Jay resolve the differences in requirements from the Federal agency, OSHA, versus the state?

What is the amount and direction of heat flow into system : Work of 1500 J is done on an ideal gas, but the internal energy increases by only 800 J. What is the amount and direction of heat flow into or out of the system

Compute rotational kinetic energy about its center of mass : A cylinder of mass10.0kg rolls without slipping on a horizontal surface. What is the rotational kinetic energy about its center of mass

A coffee manufacturing company has two different plants : A coffee manufacturing company has two different plants that roast imported coffee beans. After roasting, the plants produce three types of coffee beans, A, B, and C.

Calculate the new angular speed of the merry-go-round : A playground merry-go-round of radiusR=2.00m has a moment of inertiaI=255kg·m2and is rotating at9.0rev/min about a frictionless vertical axle. What is the new angular speed of the merry-go-round

Lack of ethics play in these failures of the banks : What role did a lack of ethics play in these failures of the banks,

What is the change in temperature of the water : Work of 600 J is done by stirring and insulated beaker containing 100 gm of water? What is the change in temperature of the water

Imagine you are a small business owner in orlando : Imagine you're a small business owner in Orlando, FL who makes custom machined parts and a customer from Mexico wants to purchase special metal part

User Account

All Pages