(5/5)

Question 1:

Graffeo Coffee Roasting Company is one of North Americas oldest artisan coffee roasters and sells the best coffee in San Francisco. Graffeo blends four beans into three final blends of coffee: one is sold to luxury hotels, another to restaurants, and the third to supermarkets for store-label brands. The company has four reliable bean supplies: Robusta, Javan Arabica, Liberica, and Brazilian Arabica. The table below summarizes the precise recipes for the final coffee blends, the costs and the availability information for the four components, and the wholesale price per pound of the final blends. The percentages indicate the fraction of each bean to be used in each blend. The roasting plant of the company can handle no more than 100,000 pounds per week. The minimum production levels for the hotel, restaurant, and supermarket blends are 15,000, 25,000 and 30,000 pounds. Please assume that there is plenty of demand for each blend, i.e. there are no demand constraints.

a. Develop a linear optimization model to help Graffeo Coffee decide how many pounds of each blend to produce to maximize its total profit. In doing so, assume that fractional values are acceptable. Write down your decision variables and formulas for the objective function and constraints below.

• [0.5 point] Decision variables (A):

• [0.5 point] Objective Function (B):

• [1 point] Constraints (C):

b. [1 point] Use the sheet named “Q1” in the solution template and setup your model in Excel Solver. Then solve it using Excel Solver to find the optimal production plan. Write down your optimal solution below.

Optimal value for each of your decision variables:

Maximum Profit: $

In answering the following questions, use Solver’s sensitivity report to give exact numerical answers whenever possible without rerunning the Solver. Include the sensitivity report sheet in your submission. If it is not possible to answer the question without rerunning Solver, please do so and report the answer and provide the excel model you ran in a separate sheet.

c. [0.5 point] By how much will the profit of Graffeo increase if the capacity of the roasting plant increases by an additional pound? Justify your answer.

d. [0.5 point] Suppose that Graffeo can purchase an additional 3000 lbs. of Liberica for $4.00/lb. Should Graffeo make this purchase? What is the impact on the profit? Justify your answer.

e. [0.5 point] Suppose that Graffeo has the option to decrease the minimum production level for one of the three blends by 5000 lbs per week. For which blend should Graffeo consider decreasing the production? If this reduction is made, what will be the new total profit? Justify your answer.

f. [0.5 point] How much can Graffeo increase the wholesale price for the supermarket blend without changing the current optimal solution? What will be the new total profit? Justify your answer.

Question 2:

Paul Bergey is in charge of loading cargo ships for International Cargo Company (ICC) at the port in Newport News, Virginia. Paul is preparing a loading plan for an ICC freighter destined for Ghana. An agricultural commodities dealer would like to transport the following products aboard the ship:

(5/5)

DescriptionIn this final assignment, the students will demonstrate their ability to apply two ma

Path finding involves finding a path from A to B. Typically we want the path to have certain properties,such as being the shortest or to avoid going t

Develop a program to emulate a purchase transaction at a retail store. Thisprogram will have two classes, a LineItem class and a Transaction class. Th

1 Project 1 Introduction - the SeaPort Project series For this set of projects for the course, we wish to simulate some of the aspects of a number of

1 Project 2 Introduction - the SeaPort Project series For this set of projects for the course, we wish to simulate some of the aspects of a number of

(5/5)

Buy Now
$35 USD