The Blue Mountain Coffee Shop blends coffee on the premises for its customers. It sells three basicblends in 1-pound bags, Special, Mountain Dark, and Mill Regular. It uses four different types of coffeeto produce the blends Brazilian, mocha, Columbian, and mild. The shop has the following blend reciperequirements:BlendMix RequirementsSelling Price/PoundSpecial At least 40% Columbian, at least 30% mocha$6.50DarkAt least 60% Brazilian, no more than 10% mild5.25Regular No more than 60% mild, at least 30% Brazilian3.75The cost of Brazilian coffee is $2.00 per pound, the cost of mocha is $2.75 per pound, the cost ofColumbian is $2.90 per pound, and the cost of mild is $1.70 per pound. The shop has 110 pounds ofBrazilian coffee, 70 pounds of mocha, 80 pounds of Columbian, and 150 pounds of mild coffee availableper week. The shop wants to know the amount of each blend it should prepare each week to maximizeprofit.Formulate a linear programming model for this problem and the model should include the objectivefunction, decision variables, ratio/ percentage constraints.(

Profit maximization is expressed as a function to compute the profit at various levels of…

Answered: Formulate a linear programming model…

Practical Management Science

6th Edition

ISBN:9781337406659

Author:WINSTON, Wayne L.

Publisher:WINSTON, Wayne L.

Chapter2: Introduction To Spreadsheet Modeling

Section: Chapter Questions

Problem 20P: Julie James is opening a lemonade stand. She believes the fixed cost per week of running the stand...

See similar textbooks

Similar questions

Oriole Company manufactures and sells high-priced motorcycles. The Engine Division produces and sells engines to other motorcycle companies and internally to the Production Division. It has been decided that the Engine Division will sell 25000 units to the Production Division at 1050 a unit. The Engine Division, currently operating at capacity, has a unit sales price of $2750 and unit variable costs and fixed costs of $1050 and $1700, respectively. The Production Division is currently paying $2600 per unit to an outside supplier. $100 per unit can be saved on internal sales from reduced selling expenses.What is the increase/decrease in overall company profits if this transfer takes place? Decrease $1250000 Increase $38750000 Increase $2363636 Decrease $3750000
The Scottville "Mill" produces five different fabrics. Each fabric can be woven on one or more of the mill's 38 looms. The sales department has forecast demand for the next month. The demand data are shown in Table 1.0 below along with data on the selling price per yard, variable cost per yard, and purchase price per yard. The mill operates 24 hours a day and is scheduled for 30 days during the coming month. The Mill has two types of looms: dobbie and regular. The dobbie looms are more versatile and can be used for all five fabrics. The regular looms can produce only three of the fabrics. The Mill has a total of 38 looms: 8 are dobbie and 30 are regular. The rate of production for each fabric on each type of loom is given in Table 1.1. The time to change over from producing one fabric to another is negligible and does not have to be considered. The Scottsville Mill satisfies all demand with either its own fabric or fabric purchased from another mill. Fabrics that cannot be woven at…
Tri-County Utilities, Inc., supplies natural gas to customers in a three-county area. The company purchases natural gas from two companies: Southern Gas and Northwest Gas. Demand forecasts for the coming winter season are as follows: Hamilton County, 400 units; Butler County, 200 units; and Clermont County, 300 units. Contracts to provide the following quantities have been written: Southern Gas, 500 units; and Northwest Gas, 400 units. Distribution costs for the counties vary, depending upon the location of the suppliers. The distribution costs per unit (in thousands of dollars) are as follows: a. Develop a network representation of this problem. b. Develop a linear programming model that can be used to determine the plan that will minimize total distribution costs. c. Describe the distribution plan and show the total distribution cost. d. Recent residential and industrial growth in Butler County has the potential for increasing demand by as much as 100 units. Which supplier should…
Tri-County Utilities, Inc., supplies natural gas to customers in a three-county area. The company purchases natural gas from two companies: Southern Gas and Northwest Gas. Demand forecasts for the coming winter season are Hamilton County, 400 units; Butler County, 200 units; and Clermont County, 300 units. Contracts to provide the following quantities have been written: Southern Gas, 500 units; and Northwest Gas, 400 units. Distribution costs for the counties vary, depending upon the location of the suppliers. The distribution costs per unit (in thousands of dollars) are as follows: From To Hamilton Butler Clermont Southern Gas 10 20 15 Northwest Gas 12 15 18 Develop a network representation of this problem. Develop a linear programming model that can be used to determine the plan that will minimize total distribution costs. Describe the distribution plan and show the total distribution cost. (First determine initial transportation cost then use…
Bugs Bunny and Daffy Duck are contestants on a game show called Split or Steal. On the show, Bugs and Daffy have to pick one of two cards and decide to split the prize money of $100,000 or steal it from the other contestant. The decisions are made simultaneously so neither player knows what the other will do. The table below represents the result of the contestants’ choices. See attached What should a rational player do in this game? Is this a zero-sum game?
Tri-County Utilities, Inc., supplies natural gas to customers in a three-county area. The company purchases natural gas from two companies: Southern Gas and Northwest Gas. Demand forecasts for the coming winter season are Hamilton County, 400 units; Butler County, 200 units; and Clermont County, 300 units. Contracts to provide the following quantities have been written: Southern Gas, 500 units; and Northern Gas, 400 units. Distribution costs for the counties vary, depending upon the location of the suppliers. The distribution costs per units (in thousands of dollars) are as follows: To From Hamilton Butler Clermont Southern Gas 10 20 15 Northern Gas 12 15 18 What is the optimal function value of this problem? a. 900 units b. $13,600 c. none of the answers proposed apply d. 1,200 units e. $11,900
Tri-County Utilities, Inc., supplies natural gas to customers in a three-county area. The company purchases natural gas from two companies: Southern Gas and Northwest Gas. Demand forecasts for the coming winter season are Hamilton County, 400 units; Butler County, 200 units; and Clermont County, 300 units. Contracts to provide the following quantities have been written: Southern Gas, 500 units; and Northern Gas, 400 units. Distribution costs for the counties vary, depending upon the location of the suppliers. The distribution costs per units (in thousands of dollars) are as follows: To From Hamilton Butler Clermont Southern Gas 10 20 15 Northern Gas 12 15 18 At optimality, how many units of natural gas are shipped from Southern Gas to Clermont? a. none of the answers proposed apply b. 100 units c. 300 units d. 250 units e. 200 units

Recommended textbooks for you

Practical Management Science

Operations Management

ISBN:

9781337406659

Author:

WINSTON, Wayne L.

Publisher:

Cengage,

Operations Management

ISBN:

9781259667473

Author:

William J Stevenson

Publisher:

McGraw-Hill Education

Operations and Supply Chain Management (Mcgraw-hi…

Operations Management

ISBN:

9781259666100

Author:

F. Robert Jacobs, Richard B Chase

Publisher:

McGraw-Hill Education

Practical Management Science

Operations Management

ISBN:

9781337406659

Author:

WINSTON, Wayne L.

Publisher:

Cengage,

Operations Management

ISBN:

9781259667473

Author:

William J Stevenson

Publisher:

McGraw-Hill Education

Operations and Supply Chain Management (Mcgraw-hi…

Operations Management

ISBN:

9781259666100

Author:

F. Robert Jacobs, Richard B Chase

Publisher:

McGraw-Hill Education

Business in Action

Operations Management

ISBN:

9780135198100

Author:

BOVEE

Publisher:

PEARSON CO

Purchasing and Supply Chain Management

Operations Management

ISBN:

9781285869681

Author:

Robert M. Monczka, Robert B. Handfield, Larry C. Giunipero, James L. Patterson

Publisher:

Cengage Learning

Production and Operations Analysis, Seventh Editi…

Operations Management

ISBN:

9781478623069

Author:

Steven Nahmias, Tava Lennon Olsen

Publisher:

Waveland Press, Inc.

SEE MORE TEXTBOOKS

Formulate a linear programming model for this problem and the model should include the objective function, decision variables, ratio/ percentage constraints.(