Purchase Solution

Linear Programming Model of Food Prices

Not what you're looking for?

Ask Custom Question

See attached file.

Romans Food Market, located in Saratoga, New York, carries a variety of specialty foods from around the world. Two of the store's leading products use the Romans Food Market name: Romans Regular Coffee and Romans DeCaf Coffee. These coffees are blends of Brazilian Natural and Colombian Mild coffee beans, which are purchased from a distributor located in New York City. Because Romans purchases large quantities, the coffee beans may be purchased on an as-needed basis for a price 10% higher than the market price the distributor pays for the beans. The current market price is $0.47 per pound for Brazilian Natural and $0.62 per pound for Colombian Mild. The compositions of each coffee blend are as follows:
BEAN REGULAR DECAF
Brazilian Natural 75% 40%
Colombian Mild 25% 60%

Romans sells the Regular blend for $3.60 per pound and the DeCaf blend for $4.40 per pound. Romans would like to place an order for the Brazilian and Colombian coffee beans that will enable the production of 1000 pounds of Romans Regular coffee and 500 pounds of Romans DeCaf coffee. The production cost is $0.80 per pound for the Regular blend. Because of the extra steps required to produce DeCaf, the production cost for the DeCaf blend is $1.05. Packaging costs for both products are $0.25 per pound. Formulate a linear programming model that can be used to determine the pounds of Brazilian Natural and Colombian Mild that will maximize the total contribution to profit. What is the optimal solution and what is the contribution to profit?

Attachments
Purchase this Solution
Solution Summary

The word document contains mathematical formulation with complete explanations. The excel file contains optimal solution using Excel Solver. Please open Solver toolbox to see the formulation in action.

Solution Preview

Hi,

Please refer attachments for complete response to your posting. The ...

Purchase this Solution
Free BrainMass Quizzes
Change and Resistance within Organizations

This quiz intended to help students understand change and resistance in organizations

Employee Orientation

Test your knowledge of employee orientation with this fun and informative quiz. This quiz is meant for beginner and advanced students as well as professionals already working in the HR field.

Organizational Leadership Quiz

This quiz prepares a person to do well when it comes to studying organizational leadership in their studies.

Organizational Behavior (OB)

The organizational behavior (OB) quiz will help you better understand organizational behavior through the lens of managers including workforce diversity.

Basic Social Media Concepts

The quiz will test your knowledge on basic social media concepts.

View More Free Quizzes
Related BrainMass Solutions

  • Linear Programming Case Study : Julia's Food Booth(V2)

    regards This solution uses a linear programming model to advise Julia's decisions, and shows step-by-step calculations to determine modified cost values for each of the food items to make a decision.

  • Linear Programming (4 Problems)

    Formulate a linear programming model for this problem b. Solve the model by using the computer c.

  • Simplex method

    The company has developed the following linear programming model to determine the number of ounces of liver (X1) and milk (X2) to include in each jar of baby food to meet the requirements for protein and iron at the minimum cost.

  • Formulate a linear programming model for Julia

    Formulate a linear programming model for Julia that will help you to advise her if she should lease the booth. Formulate the model for the first home game.

  • Quantitative Methods: True/False

    The linear programming model for a transportation problem has constraints for supply at each source and demand at each destination.

  • Formulating a cost minimizing LP Model

    Linear Programming Models play an important role in decision making. Solution to given problem depict the steps to formulate a cost minimizing linear programming model for a given product mix.

  • linear programming model

    333303 Formulate and solve a linear programming model for Julia. Please read the Case Problem below and address each of the issues A-D according to the instruction given. (A) Formulate and solve a Linear Programming model for this case.

  • Linear programming model

    The solution illustrates the determination of optimum solution of a linear programming model using Excel Solver.

  • 38 MCQs, True/False and Fill in the blanks on LPP,IPP

    A linear programming model consists of decision variables, constraints, but no objective function. 2. In a linear programming model, the number of constraints must be less than the number of decision variables. 3.

  • Graphical solution of linear programming problem.

    b) Using manual methods, QM for Windows, determine the shadow prices for additional hours of product time on line 1 and line 2. Please see the attached file. Graphical solution of linear programming problem.

View More Related Solutions