A factory makes scooters and bicycles. In the manufacturing process, two machines areused, the lathe, and the assembler. The lathe uses two hours for each scooter and ninehours for each bicycle. The assembler uses four hours for each scooter and three hours foreach bicycle. There are 36 hours available on the lathe and 42 hours available on theassembler. Each bicycle gives a profit of $6 and each scooter gives a profit of $8.The aim is to determine the number of scooters and bicycles the factory should make inorder to maximise profit.Formulate a linear programming model for this problem.b. Draw a neat sketch of the feasible region.c. Use your sketch to determine how many of each product should be produced tomaximise profit and include a brief concluding sentence summarising your findings.The numbers of units are not required to be integers.d. Perform a sensitivity analysis to determine the range each profit per unit can takewithout affecting the solution from (c).

Since you have posted a question with multiple sub-parts, we will solve the first three sub-parts…

Answered: a. 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

The manager of a small firm is considering whether to produce a new product that would require leasing some special equipment at a cost of$20,000 per month. In addition to this leasing cost, a production cost of$10 would be incurred for the first 1000 units (including the 1000th unit). After that, a production cost of$15 would be incurred for the rest. Each unit sold generates$20 in revenue. Determine how many units should be produced each month to make it profitable to produce this product.
(A little sensitivity analysis.) You are given the final chart, with the optimal solution, for a transportation problem; note that the cell in the (4, 2) position is blank, i.e., the variable x42, with an objective coefficient (unit cost) of C42 = 18, is nonbasic. What range of values of c42 will keep the solution in the chart optimal? Hints: In this method, how do we tell that our latest solution is optimal? Temporarily replace the cost of 18 with C42. 10 (3 15 14 12 4 4 18 14 3 12 26 5 20
Develop a spreadsheet for the question. The vice president of finance has looked at your ooriginal scoring model and feels that tax considerations should be included in teh model with a weight of 15. In addition, the VP has scored the methods on tax considerations as follows: method A recieved a score of 3, method B recieved a score of 2, and Method C recieved a score of 1. How would this additional information affect your recommendation?
I need solution of 2.34 as possible as please
1. University Ceramics manufactures plates, mugs, and steins that include the campus name and logo for sale in campus bookstores. The time required for each item to go through the two stages of production (molding and finishing), the material required (clay), and the corresponding unit profits are given in the following table, along with the amount of each resource available for tomorrow's eight-hour shift. Available Plates Mugs Steins Molding (minutes) Finishing (minutes) 4 6 3 2,400 8 14 12 7,200 Clay (ounces) 5 4 3 3,000 Unit Profit $3.10 $4.75 $4.00 A linear programming model has been formulated in a spreadsheet to determine the production levels that would maximize profit. The solved spreadsheet model and corresponding sensitivity report are shown below. A 1 B C D E F G Plates 2 3 Unit Profit $3.10 Mugs $4.75 Steins $4.00 4 Resource Required per Unit Used Available 5 Molding (minutes) 3 2,400 <= 2.400 6 Finishing (minutes) 8 14 12 7.200 <<= 7.200 7 Clay (ounces) 5 4 3 2,700 <=…
PLEASE USE SIMPLEX METHOD. Thank you! Suppose a company manufactures different electronic components for computers. Component A requires 2 hours of fabrication and an hour of assembly. Component B requires 3 hours of fabrication and an hour of assembly, and component C requires 2 hours of fabrication and 2 hours of assembly. The company has upto 1,000 labor-hours for fabrication, 800 labor-hours of assembly time each work. If the profit on each component A, B, and C is $7, $8, and $10 respectively, how many of each should be produced to maximize profit?
Answer V. Statement of the problem. The second picture is the problem or basis for this study analysis.
Explain the following CATEGORIES OF SPREADSHEET ANALYSIS 1-Base-case analysis 2-What-if analysis 3-Breakeven analysis 4-Optimization analysis 5-Risk analysis

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