Purchase Solution

Newport manufactures coffee by blending 3 types of coffee

Not what you're looking for?

Ask Custom Question

***Please see the attached file for details***

Newport manufactures coffee by blending 3 types of coffee beans.
The cost per pound and the number of pounds used per hour are listed below.
The coffees individually meet the following ratings:

Bean Cost/lb
1 0.95
2 1.35
3 0.89

The Newport blend requires an aroma rating of at least 75 and a taste
rating of at least 80. The blended ratings are a weighted average
of the attributes of those for the three bean types.

a. What is the minimum cost blend that will produce 1000
pounds of blend and meet the required ratings?

b. What are the aroma and taste ratings for this blend?

Attachments
Purchase this Solution
Solution Summary

The solution provides step-by-step explanations and calculations, including complete Excel Solver code.

Solution Preview

Below is the model using Excel Solver function.

Here the variable cells are the number of pound of each ...

Purchase this Solution
Free BrainMass Quizzes
Probability Quiz

Some questions on probability

Solving quadratic inequalities

This quiz test you on how well you are familiar with solving quadratic inequalities.

Geometry - Real Life Application Problems

Understanding of how geometry applies to in real-world contexts

Exponential Expressions

In this quiz, you will have a chance to practice basic terminology of exponential expressions and how to evaluate them.

Know Your Linear Equations

Each question is a choice-summary multiple choice question that will present you with a linear equation and then make 4 statements about that equation. You must determine which of the 4 statements are true (if any) in regards to the equation.

View More Free Quizzes
Related BrainMass Solutions

  • Statistical Analysis: Linear Optimization

    532652 Statistical Analysis: Linear Optimization Hilltop Coffee manufactures a coffee product by blending three types of coffee beans. The cost per pound and the available pounds of each bean are given in the following table.

  • Activity base costing

    Mona Loa Malaysian Expected sales 100,000 pounds 2,000 pounds Batch size 10,000 pounds 500 pounds Setups 3 per batch 3 per batch Purchase order size 20,000 pounds 500 pounds Roasting time per 100 pounds 1 hour 1 hour Blending

  • Activity-Based Costing System for Coffee

    Develop a new product cost, using an activity-based costing approach, for one pound of Jamaican coffee and one pound of Colombian coffee. 3. What are the implications of the activity-based costing system with respect to: a.

  • Ohori's Coffee case study

    The company also offers different types of grinds for different types of coffee, helping to make the coffee and experience and not just a product.

  • Production Schedule

    Olsen uses two types of coffee beans, Columbian and Mexican, in her coffee. The following chart lists the compositions of the blends.

  • strategic use of counter trade schemes as a marketing weapon to generate export revenue

    To help illustrate this better, let's consider an example of a company that manufactures printers.

  • HR Business Strategy- Making an Industry

    The majority of these coffees are coming out of Vietnam where the production of low quality and low cost coffee has risen by 200% over the past 10 years in response to the increase in demand globally for a cheaper alternative (Greenfield, 2010).

  • Gourmet Specialty Coffee Company -Activity based costing

    Develop a new product cost, using an activity-based costing approach, for one pound of Jamaican coffee and one pound of Colombian coffee. 3. What are the implications of the activity-based costing system with respect to: a.

  • Activity based costing

    Develop a new product cost, using an activity-based costing approach, for one pound of Kona coffee and one pound of Malaysian coffee. 3. What are the implications of the activity-based costing system wiht respect to a.

View More Related Solutions