Dr. Thompson makes three bean mixes for coffee shops located in the Austin. The three mixes, referred to as the Tameka Mix, the Christian Mix, and the Tamia Mix, are made by mixing different percentages of five types of beans. In preparation for the fall season, Dr. Thompson just purchased the following shipments of beans at the prices shown: Type of Beans Shipment Amount in pounds Cost Per Shipment in dollars Arabica 6000 7500 Robusta 7500 7125 Liberica 7500 6750 Excelsa 6000 7200 Juno 7500 7875 The Tameka Mix consists of 15% Arabica, 25% Robusta beans, 25% Liberica, 10% Excelsa, and 25% Juno. The Christian Mix consists of 20% of each type of beans, and the Tamia Mix consists of 25% Arabica, 15% Robusta beans, 15% Liberica, 25% Excelsa, and 20% Juno. Dr. Thompson analyzed the cost to get the beans ready and determined that the profit contribution per pound is $1.65 for the Tameka Mix, $2.00 for the Christian Mix, and $2.25 for the Tamia Mix. Customer orders already received are summarized here: Type of Bean Mix Orders in pounds Tameka 10000 Christian 3000 Tamia 5000 Because Austin is a big coffee town, demand is running high for the beans, and it is expected that Dr Thompson will receive many more orders than can be satisfied. Dr. Thompson is committed to using the available beans to maximize profit. All customer orders must be satisfied. Perform an analysis to answer the following questions: EXPLAIN THE ANSWERS USINE EXCEL. The cost per pound of the beans included in the Tameka, Christian and Tamia Mix. The optimal bean mix and the total profit contribution (Use excel solver) Recommendations regarding how the total profit contribution can be increased if additional quantities of beans can be purchased. Should Dr. Thompson purchase an additional 1000 pounds of Arabica for $1000 from another bean supplier who had extra?
Dr. Thompson makes three bean mixes for coffee shops located in the Austin. The three mixes, referred to as the Tameka Mix, the Christian Mix, and the Tamia Mix, are made by mixing different percentages of five types of beans. In preparation for the fall season, Dr. Thompson just purchased the following shipments of beans at the prices shown:
|
Type of Beans |
Shipment Amount in pounds |
Cost Per Shipment in dollars |
|
Arabica |
6000 |
7500 |
|
Robusta |
7500 |
7125 |
|
Liberica |
7500 |
6750 |
|
Excelsa |
6000 |
7200 |
|
Juno |
7500 |
7875 |
The Tameka Mix consists of 15% Arabica, 25% Robusta beans, 25% Liberica, 10% Excelsa, and 25% Juno. The Christian Mix consists of 20% of each type of beans, and the Tamia Mix consists of 25% Arabica, 15% Robusta beans, 15% Liberica, 25% Excelsa, and 20% Juno.
Dr. Thompson analyzed the cost to get the beans ready and determined that the profit contribution per pound is $1.65 for the Tameka Mix, $2.00 for the Christian Mix, and $2.25 for the Tamia Mix.
Customer orders already received are summarized here:
|
Type of Bean Mix |
Orders in pounds |
|
Tameka |
10000 |
|
Christian |
3000 |
|
Tamia |
5000 |
Because Austin is a big coffee town, demand is running high for the beans, and it is expected that Dr Thompson will receive many more orders than can be satisfied.
Dr. Thompson is committed to using the available beans to maximize profit. All customer orders must be satisfied.
Perform an analysis to answer the following questions:
EXPLAIN THE ANSWERS USINE EXCEL.
- The cost per pound of the beans included in the Tameka, Christian and Tamia Mix.
- The optimal bean mix and the total profit contribution (Use excel solver)
- Recommendations regarding how the total profit contribution can be increased if additional quantities of beans can be purchased.
- Should Dr. Thompson purchase an additional 1000 pounds of Arabica for $1000 from another bean supplier who had extra?
Trending now
This is a popular solution!
Step by step
Solved in 2 steps
