Solve the attached simplex problem • 2) A company produces 3 diferente bookshelves: a luxury, a regular and na exportaticmodel. Consider the maximum demand for each model to be 500, 750 and 400respectively. The working hours at the carpentry and finishing sections have theworking time limitations below:SectioncarpentryfinishingTotal numberof hours(thousands)1.41.2Number of hours needed to produce each modelluxuryregularexportation0.50.51.00.50.52.0Assuming the selling profit for the luxury, regular and exportation models is 1500, 13002500 respectively, formulate the LP problema in order to maximize the profit.Interpret the results detailling the optimal number of bookshelves of each type produceddiscussing the total amount of hours used in each section. How far from meeting themaximum demands were we?

Linear programming is a mathematical technique that is also used in operations management…

Answered: Assuming the selling profit for the…

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

Model A B C Labor Hours Used Hours Available Tubing Pumps A B C Blue Ridge Hot Tubs Total Profit Pumps Tubing Number to Assembl Require Require Make y hours d Resources Used Demand Min 15 12 10 322 Max 130 Available 650 88 30 40 45 d 112 A B C 11 10 12 Profit/Unit $ 96.00 $ 75.00 $ 116.00 Blue Ridge Hot Tubs is a local company that just received a donation of tubes and pumps used for hot tubs. The company wants to know how many of each model they should make in order to maximize their profits. They need to stay within the amount of available hours, can't make more than what they have the resources for, and want to stay within the minimum and maximum demand.
Chairs Tables Selling price per unit ＄80 ＄400 Variable cost per unit ＄30 ＄200 Board feet per unit 　　　　　　2 10 Monthly demand 600 100 The company's supplier of hardwood will only be able to supply 2,000 board feet this month. What plan would maximize profits? a. 500 chairs and 100 tables b. 600 chairs and 80 tables c. 500 chairs and 80 tables d. 600 chairs and 100 tables Note:- Do not provide handwritten solution. Maintain accuracy and quality in your answer. Take care of plagiarism. Answer completely. You will get up vote for sure.
Using the information in Problem(The demand for subassembly Sis 100 units in week 7.Each unit ofS requires 1 unit ofT and 2 units ofU. Each unit ofT requires I unit ofY, 2 units ofW, and 1 unit of X. Finally, eachunit of U requires 2 units of Y and 3 units of Z. One firm manufacturesall items. It takes 2 weeks to make S, 1 week to make T, 2 weeks to make U, 2 weeks to make Y, 3 weeks to make W,I week to make X, 2 weeks to make Y, and I week to make Z.a) Construct a product structure. Identify all levels, parents, and components.b) Prepare a time-phased product structure. ), construct agross material requirements plan.
Old Pueblo Engineering Contractors creates six-month “rolling” schedules, which are recomputed monthly. For competitive reasons (it would need to divulge proprietary design criteria, methods, and so on), Old Pueblo does not subcontract. Therefore, its only options to meet customer requirements are (1) work on regular time; (2) work on overtime, which is limited to 30 percent of regular time; (3) do customers’ work early, which would costan additional $5 per hour per month; and (4) perform customers’ work late, which would cost an additional $10 per hour per month penalty, as provided by their contract. Old Pueblo has 25 engineers on its staff at an hourly rate of $30. The overtime rate is $45. Customers’ hourly requirements for the six months from January to June are January 5000 February 4000 March 6000 April 6000 May 5000 June 4000 Develop an aggregate plan using a spreadsheet. Assume 20 working days in each month. 12. Alan Industries is expanding its product line to include three…
Using the information in Problem (The demand for subassembly Sis 100 units in week 7.Each unit ofS requires 1 unit ofT and 2 units ofU. Each unit ofT requires I unit ofY, 2 units ofW, and 1 unit of X. Finally, eachunit of U requires 2 units of Y and 3 units of Z. One firm manufacturesall items. It takes 2 weeks to make S, 1 week to make T, 2 weeks to make U, 2 weeks to make Y, 3 weeks to make W,I week to make X, 2 weeks to make Y, and I week to make Z.a) Construct a product structure. Identify all levels, parents, and components.b) Prepare a time-phased product structure. ), construct a netmaterial requirements plan using the following on-hand inventory.
JAN FEB MAR APR MAY BEGINNING INV PERIOD JUN TOTAL BEGINNING WORKERS AVGE. MONTHLY OUTPUT PER WORKER INV. HOLDING COSTS COST/CATEGORY TOTAL COST PER CATEGORY 5,000 8 4,000 0.3 DEMAND 24,000.00 32,000.00 32,000.00 48,000.00 60,000.00 44,000.00 240,000.00 UNITS WORKERS UNITS/WORKER PER CASE/MONTH REG. PROD 0.00 $0.80 CHASE- HIRE/FIRE HIRING COST SUBCONTRACTING FIRING/LAYOFF $1.15 COST COST OVERTIME/ SUBCONTRACT ENDING INV. $1,000 $1.15 $1,500 0.00 $0.30 PER WORKER PER CASE PER WORKER WORKERS HIRE FIRE 0.00 $1,000.00 COST OF PLAN= 0.00 $1,500.00 $
II. Financial information of the business which produces and sells three types of electronical motors is given below: Production Sale Direct Model Quantity (U) Price ($) Material($) Norm 5.000 800 120 Pluger 4.000 1.500 450 Elevator 1.000 2.500 700 Direct Production Labor ($) Time (DLH/U) 80 250 300 4 5 8 Total fixed costs are only 1.750.000$. a. Calculate the BEP for each model, b. Choose the model to prioritize with reasons, c. Compute the common BEP of all models, d. Compute the profit if all the capacity is sold, e. Compute the sale price of each model to get a profit of 5.150.000$.
Q3: FIND INITIAL FEASIRLE SOLUTION COST FOR GIVEN PROBLEM by using A north-west oomer rule Bleast cost method e-Vogels approvimation method D1 D2 D3 D4 SUPPLE P1 2. 11 P2 1. 1. Pa 8. 15 6. 10 Demand 2. A* JIS O 11600 O 11300 O 11200 O 11000
1. Inventory management for a tyre company? 2. Process management for a tyre company?
2.17 For the following data, calculate the number of workers required for level production and the resulting month-end inventories. Each worker can produce 14 units per day, and the desired ending inventory is 9000 units. Month Working Days Forecast Demand Planned Production Planned Inventory 11,500 1 2 3 4 Total 20 24 12 19 28,000 27,500 28,500 28,500
Shown below is a partially completed MPS record for ball bearings. Part 2 a. Develop the MPS for ball bearings. (Enter your responses as integers. A response of "0" is equivalent to being not applicable.) Item: Ball bearings Order Policy: 500 units Lead Time: 1 week Quantity on Hand: 400 Week 1 2 3 4 5 6 7 8 9 10 Forecast 550 350 350 450 250 300 250 350 400 350 Customer orders (booked) 300 350 250 300 150 150 150 150 100 50 Projected on-hand inventory enter your response here enter your response here enter your response here enter your response here enter your response here enter your response here enter your response here enter your response here enter your response here enter your response here MPS quantity 500 enter your response here enter your response here enter your response here enter your…
What are the advantages and disadvantages of varyingthe size of the workforce to meet demand requirementseach period?

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