QUESTION 1The Brown family owns 420 acres of farmland in North Carolina on whichthey grow corn and tobacco. Each acre of corn costs $120 to plant,cultivate, and harvest; each acre of tobacco costs $240. They have abudget of $60,000 for next year. The government limits the number ofacres of tobacco that can be planted to 150. The profit from each acre ofcorn is $300; the profit from each acre of tobacco is $450. They want toknow how many acres of each crop to plant to maximize their profit.They have an opportunity to lease some extra land from a neighbor. Theneighbor is offering the land to them for $160 per acre. Based on thesensitivity analysis, you may suggest that the family the land at thatprice because the maximum price the Browns should pay their neighborfor the land isshould not lease; $150should lease; $160should lease; $450may lease; $80none of the above

Let acres of corn produced be x1 and tobacco produced be x2 The objective is to maximize the profit.…

Answered: QUESTION 1 The Brown family owns 420…

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

QUESTION 2 Samy Company manufactures two types of tables, model K and J. The production of a model K table requires a capital expenditure of RM 6 and 2 hours of labor. The production of a model J table requires a capital of RM 4 and 5 hours of labor. The company has RM 240 capital and 100 hours of labor available for the production of the two models of tables per week. A model K table contributes a profit of RM 30 while model J contributes RM 40. a. Formulate the problem using linear programming model. b. How many of each type of table should the firm produce to maximize the profit? c. What is the maximum profit?
Question 1 B A company produces 2 (two) different grades of gasoline – regular and premium from 3(three) components (1,2,3). The company wants to determine the optimal mix of the three components in each grade of the gasoline that will maximize profit. The maximum quantities available for each component and their cost per gallon are as follows:Component Cost per gallon maximum gallons available per day 1 2.50 5,000 2 2.60 10,000 3 2.84 10,000 In order to ensure the appropriate blend, each grade has certain specifications as follows: Grade Component Specs Selling Price per gallon Regular At most 30% component 1 At least 40% component 2 At most 20% component 3 2.90 Premium At least 25% component 1 At most 45% component 2 At Least 30% component 3 3.00 The company wants to produce at least 10,000 gallons of each grade of gasoline. Formulate a LP model including the ratio constraints, production constraints and the objective function for this question.
Question 1 PKG Electric makes two types of electric fans, ceiling fan and wall fans. Each ceiling fan requires two circuit boards and four hours assembly time. Each wall fan requires two circuit boards and one-hour assembly time. The profit of each ceiling fan and wall fan are RM25 and RM15 respectively. The company produces its own circuit boards and its capacity is 54 per week. Currently, the company has 48 hours of assembly time per week. The company wishes to maximize the profit. Let x = ceiling fan, y = wall fan Solve: 1. Formulate the problem as a linear programming model. 2. What is the maximum profit? 3. Later, the company was informed by its retailers that the demand for the wall fans is at most 12 units per week. What is the new maximum profit? Question 2 Lee Chong Wei has two photocopy machines P and Q. Machine P can make at most 16 copies per minute, while machine Q can make at most 20 copies per minute. Lee Chong Wei wants to make at least 150 copies in 5 minutes.…
Question 1 You may produce seven products by consuming three materials. The unit sales price and material consumption of each product are listed in Table 1. For each day, the supply of these three materials are limited. The supply limits are listed in Table 2. For each day, you need to determine the production quantity for each product. Product Price Material 1 Material 2 Material 3 1 100 0 3 10 2 120 5 10 10 3 135 5 3 9 4 90 4 6 3 5 125 8 2 8 6 110 5 2 10 7 105 3 2 7 Table 1: Product information for Problem 1 Material Supply limit 1 100 2 150 3 200 Table 2: Material information for Problem 1 Formulate a linear integer program that generates a feasible production plan to maximize the total profit (which is also the total revenue, as there is no cost in this problem). Then write a computer program…
Question 1. Busch Gardens Sweets is preparing for the Halloween rush. They prepare two sizes of Peanut/Raisin Ghoulish Delight and need to calculate how many bags of deluxe and standard mixes they can produce. • The deluxe mix takes 0.9 of a pound of raisins and 0.4 of a pound of peanuts.• The standard mix takes 0.7 of a pound of raisins and 0.6 of a pound of peanuts.The shop has 100 pounds of raisins and 70 pounds of peanuts. The profit on the deluxe mix is $1.80 and the standard mix profit is $1.60. The owner wants no more than 110 bags of each type prepared. Do not forget the non-negativity constraint and remember that you cannot sell partial bags (whole numbers only). Use Excel Solver Question 2. Take a screenshot (snip tool) of you excel spreadsheet and save it.
Question 2: Sunblessed Juice Company sells bags of oranges and cartons of orange juice. Sunblessed grades oranges on a scale of 1 (poor) to 10 (excellent). At present, Sunblessed has 220,000 pounds of grade 6 oranges and 150,000 pounds of grade 9 oranges on hand. The average quality of oranges sold in bags must be at least 7, and the average quality of oranges used to produce orange juice must be at least 8. Each pound of oranges that is used for juice yields a revenue of $2.25 and incurs a variable cost (consisting of labor costs, variable overhead costs, inventory costs and so on) of $1.35. Each pound of oranges sold in bags yields a revenue of $2.00 and incurs a variable cost of $1.20. Determine how Sunblessed can maximize its profit. Please include your answer report with the model, and a description of your recommendation. Use SolverTable to determine how a change in the cost per bag of oranges changes the optimal solution. Specifically, vary the cost from $1.00 to $1.50 in…
Question ThreeThe management of a supermarket wants to adopt a new promotional policy ofgiving free gift to every customer who spends more than a certain amount pervisit at this supermarket. The expectation of the management is that after thispromotional policy is advertised, the expenditure for all customers at thissupermarket will be normally distributed with mean 400 £ and a variance of900£2.1) If the management wants to give free gifts to at most 10% of the customers,what should the amount be above which a customer would receive a free gift?2) In a sample of 100 customers, what are the number of customers whoseexpenditure is between 420 £ and 485 £?3) What is a probability of selecting a customer whose expenditure is differ thanthe population mean expenditure by at most 50 £?4) What is the probability that the expenditure of the first customer exceeds theexpenditure of the second customer by at least 20 £?5) In a sample of 250, find the count that corresponds to the interquartile…
Question 4An investor is to purchase one of three types of real estate, as illustrated in Figure below. Theinvestor must decide among an apartment building, an office building, and a warehouse. Thefuture states of nature that will determine how much profit the investor will make are goodeconomic conditions and poor economic conditions. The profits that will result from eachdecision in the event of each state of nature are shown in Table below: a) Find the optimal act using Maxi-Max criteriab) Find the optimal act using Mini-Max criteria c) Find the optimal act using Maxi-Min criteria d) Find the optimal act using Min-Max regret table
Question 1 A A company manufactures two types of boxes, corrugated and ordinary cartons. The boxes undergo two major processes: cutting and pinning operations. The profits per unit are $6 and $4 respectively. Each corrugated box requires 2 minutes for cutting and each carton requires 3 minutesfor cutting, whereas each corrugated box requires 2 minutes for pinning and each carton requires 1 minute for pinning. The available cutting time is 120 minutes and total pinning time is 60 minutes. Determine the optimum quantities of the two boxes to maximize the profits. a. Formulate a linear programming model that can be used to determine the quantities of the two boxes that should be produced in order to maximize total profit contribution b. Graph the feasible region. c. Determine the coordinates of each extreme point. d. What is the optimal solution. e. Solve in excel.
Question 1 A company manufactures two types of boxes, corrugated and ordinary cartons. The boxes undergo two major processes: cutting and pinning operations. The profits per unit are $6 and $4 respectively. Each corrugated box requires 2 minutes for cutting and each carton requires 3 minutes for cutting, whereas each corrugated box requires 2 minutes for pinning and each carton requires 1 minute for pinning. The available cutting time is 120 minutes and total pinning time is 60 minutes. Determine the optimum quantities of the two boxes to maximize the profits. a. Formulate a linear programming model that can be used to determine the quantities of the two boxes that should be produced in order to maximize total profit contribution.b. Graph the feasible region.c. Determine the coordinates of each extreme point.
Question 2 A farmer in the Blue Mountains area of Jamaica wants to decide on the crop to plant next season. He wants to plant either ganja or coffee for export to the USA but need some help. He knows that if he plants ganja and the weather in the USA is predominantly cold he earns $10,000(US per month. If the weather is warm he earns $16,000. If he plants coffee and the weather is cold he earns 13,000 and if the weather is warm he earns $14000. In 40% of the years, the weather was cold and in 60 % the weather was warm. For $600, he could buy an expert weather forecast from CWD consulting. States of Nature with Profits ($) Does not include forecast cost Decision Alternatives Warm weather(W) Cold weather (C) Ganja $16,000 $10,000 Coffee $14,000 $13000 Prior Probabilities P(W) = 0.60 P(C) = .40 Conditional probability for a given state of nature where forecasts are either Good (G) or bad (B): That is: P (G|W) = 0.80; P (B|W) = 0.20; P (G|C) = 0.10; P (B|C) = 0.90 After you have computed…
Question 1The Rotary Club is holding a pizza sale to finance outreach projects. The Club made an agreement to purchase pizza from Pizza Hut at a 30% discount which the Rotary Club can then resell for a profit. It is expected that of the 500 families in the community, at most 70% will buy pizza. Based on a survey of their personal preferences, the students believe that they should orderno more than 120 cheese pizzas, no more than 150 pepperoni pizzas, and no more than 100 vegetarian pizzas. They also want to make sure that at least 20% of the total pizzas are cheese and at least 50% of the pizzas are pepperoni. The standard price (before discount) for the cheese, pepperoni and vegetarian is $12, $15 and $14, respectively. The Rotary Club makes a profit of 10%, 15% and 20%, respectively, for each cheese, pepperoni, and vegetarian pizza they resell. a) Formulate a linear programming model that would determine the optimal solution. An explanation for the derivation of EACH equation should…

SEE MORE QUESTIONS

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