Question 1:A manufacturer is trying to determine the combination of two products, A and B, that should beproduced. Each product passes through a three-stage production process: Stages I, II and III.For product A: Stage I takes 3 hours of labour, Stage II takes 4 hours and Stage III takes 1 hour.For product B: Stage I takes 4 hours, Stage II takes 2 hours and Stage III takes 3 hours.Product A sells for £38 each unit and B for £40 each unit.At present 11 people are employed on Stage 1, 12 on Stage II and 10 on Stage III, with all employeesworking 40 hours each week.(a) Formulate this problem in terms of determining the sales-maximising combination of the twoproducts on a weekly basis.(b) Solve the problem graphically.(c) Confirm the solution using simultaneous equations.(d) Identify the binding and non-binding constraints.(e) Undertake sensitivity analysis on each of the binding constraints and evaluate themanagement information that this generates.(f) If you know that the Labour hours currently cost £4.50 per hour, determine the profit-maximising combination of the two products. (Profit = sales - cost).

Here, for this question, we could see two products and three stages, I would formulate an LP that…

Answered: (a) Formulate this problem in terms of…

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 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 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 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 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 #4 - Jerry Smith is thinking about opening a bicycle shop in his hometown. Jerry loves to take his own bike on 50-mile trips with his friends, but he believes that any small business should be started only if there is a good chance of making a profit. Jerry can open a small shop, a large shop, or no shop at all. The profits will depend on the size of the shop and whether the market is favorable or unfavorable for his products. Because there will be a 5-year lease on the building that Jerry is thinking about using, he wants to make sure that he makes the correct decision. Jerry is also thinking about hiring his old marketing professor to conduct a marketing research study. If the study is conducted, the study could be favorable (i.e., predicting a favorable market) or unfavorable (i.e., predicting an unfavorable market). Develop a decision tree for Jerry.
Question 3: A catering company must have the following number of clean napkins available at the beginning of each of the next four days: day 1: 15, day 2: 12, day 3: 18, and day 4: 6. After being used, a napkin can be cleaned by one of two methods: fast service or slow service. Fast service costs $0.10 per napkin, and a napkin cleaned via fast service is available for use the day after it is last used. Slow service costs $0.06 per napkin, and a napkin cleaned via slow service is available two days after they were last used. New napkins can be purchased for a cost of $0.20 per napkin. Part A: Formulate the problem as a minimum cost transportation problem. Part B: Use Excel Solver to solve the problem (provide exact values for all variables and the optimal objective function).
Question 1: The Best Person for the Job After 25 years, Kevin is finally ready to retire and take it easy. Kevin teaches accounting and general business courses at Youngstown Community College. Kevin over the years has taught hundreds of accounting students and helped them obtain internships and find employment in the community. Kevin’s golfing buddy sometimes jokes that every bookkeeper in town has been through Kevin’s accounting classes. Besides, the regular accounting classes and internships, Youngstown maintains an accounting lab where students can get tutoring help if needed. The current lab tutor is David, who was hired two years ago when Dianne retired after nearly 10 years as the accounting tutor. David is a former student of Kevin and holds an associate’s degree from Youngstown and a bachelor’s from State. The lab job is part-time, which works out perfectly for David, leaving him plenty of time to pursue his MBA in accounting at State. David wants to teach accounting at…
Question 1: Should the marketing budget be maintained or increased during a recession or economic downturn? During a recession, the immediate desire of many companies is often to simply cut costs. The marketing department can be selected for this cut and in some cases is the first area cut. One could argue that the marketing spend is the one spend or investment in a company which should be maintained or even increased during a recession or economic downturn. Take a position: Marketing spend should be maintained or increased during a recession or economic downturn versus Marketing spend should be cut along with all the other spending in the organisation.
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 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…
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 Primer Inc. offers plumbing and air conditioning services to customers in Kumasi, Ghana. The company’s product strategy is to solve the customer’s problem irrespective of what it takes, at the time the customer needs it solved. The company provides same day service for customers, and theaim is to make the customer happy before leaving.The services of the company are available 24 hours a day, 7 days a week for customers. There is no extra charge for requests made on holidays, odd hours of the day, or in festive seasons. The company aims to be available at the call of customers without charging a pesewa extra, even at times when rival firms won’t get out of bed. The company fixes the price of the service before it begins, and customers can be assured of no extra charges. Irrespective of the customer’s location in the city, Primer Inc. does not charge additional fees for transportation. For all services, the company provides a one year guarantee on all parts and labour used,…

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

(a) Formulate this problem in terms of determining the sales-maximising combination of the two products on a weekly basis. (b) Solve the problem graphically. (c) Confirm the solution using simultaneous equations.