A manufacturing company produces fourparts that require the use of a lathe and a drillpress. The two machines operate 10 hours aday each. The following table provides thetime in minutes required by each part:Production time in minProductLatheDrill press36.23.4.4.4Additionally, the number of units of part 1may not exceed that of part 2.Assuming thatx; : number of units need to be produced from product i, wherei e (1,2,3,4)Additionally, the number of units of part 1 may not exceed that of part 2.Assuming that z, : number of units need to be produced from product i, where i e {1,2,3,4}The constraints and the objectives that are used to formulate "The market demand for each part is at least 10 units per day", are:O a Minimize Ez +s-= 10, ViOb. Minimize s4, 824 $3,4 4,4I+84-84 = 10, ViO. Minimize mar(s,4, 82,4 $3,4 $44)zi +8-s = 10, ViOd. Minimize si, 24 34 $i$4= 10, ViOe.none of the mentioned

Assume that Xj is the number of Part-js to be created for j=1,2,3,4 and that di+ and di- are the…

Answered: A manufacturing company produces four…

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

A machine shop manufactures two types of bolts. The bolts require time on each of the three groups of machines, but the time required on each group differs, as shown in the table below. Type I Type IIMachine 1 0.2 min 0.2 minMachine 2 0.6 min 0.2 minMachine 3 0.04 min. 0.08 min Production schedules are made up one day at a time. In a day, 300, 720, and 100 minutes are available, respectively, on these machines. Type I bolts sell for 15¢ and type II bolts for 20¢. (a) How many of each type of bolt should be manufactured per day to maximize revenue?(b) What is the maximum revenue?(c) Suppose the selling price of type I bolts began to increase. Beyond what amount would this price have to increase before a different number of each type of bolts should be produced to maximize revenue?
A manufacturing process has 12 workers and 6 stations. The process iscompleted in the order given below. Where there are multiple workers within a station,each worker works independently on his/her own unit. Assume inventory buffers areallowed between each station.Station Staffing Processing time (hoursper unit per worker)A 2 2.20B 1 1.25C 3 2.00D 2 2.60E 3 3.00F 1 0.75What is the maximum number of units per hour that can be produced? Assume they startthe day with inventory at each station to work on
A manufacturing fi rm has discontinued production of a certain unprofi table product line.Considerable excess production capacity was created as a result. Management is consideringdevoting this excess capacity to one or more of three products: X1, X2, and X3.Machine hours required per unit areProductMachine Type X1 X2 X3Milling machine 8 2 3Lathe 4 3 0Grinder 2 0 1The available time in machine hours per week isMachine Hours per WeekMilling machines 800Lathes 480Grinders 320The salespeople estimate they can sell all the units of X1 and X2 that can be made. Butthe sales potential of X3 is 80 units per week maximum.Unit profi ts for the three products areUnit ProfitsX1 $20X2 6X3 8a. Set up the equations that can be solved to maximize the profi t per week.b. Solve these equations using the Excel Solver.c. What is the optimal solution? How many of each product should be made, and whatshould the resultant profi t be?d. What is this situation with respect to the machine groups? Would they…
2. A machine part can be exhausted either from aluminum or steel. There is an order of 8,000 units.Steel costs 3.80Php/kg, while aluminum cost 8.70Php/kg. If steel is used, the steel per unit weighs110g and 30g for aluminum. In production, steel is 50 units/hr and 80units/hr with an aid of a toolcosting 640Php, which will be useless after the 8,000 units are finished. The cost of the machineoperator is 10.80Php/hr. if all other costs are identical, which material is more economical?a. Aluminum, by 1,264Php cost difference.b. Aluminum, by 1,653Php cost differencec. Steel, by 640Php cost difference.d. Steel, by 1,088Php cost difference.e. None of the above
A producer has three products, A, B, and C, which are composed from many of the same raw materials and subassemblies by the same skilled workforce. Each unit of product A uses 15 units of Raw Material X, one Purge System Subassembly, one Case, one Power Cord, three Labour Hours in the Assembly Department, and one Labour Hour in the Finishing Department. Each unit of product B uses 10 units of Raw Material X, five units of Raw Material Y, two Purge System Subassemblies, one Case, one Power cord, five Labour Hours in the Assembly Department, and 90 minutes in the Finishing Department. Each unit of product C uses five units of Raw Material X, 25 units of Raw Material Y, two Purge System Subassemblies, one Case, a Power Cord, seven Labour Hours in the Assembly Department, and Three Labour Hours in the Finishing Department. Labour between the Assembly and Finishing departments is not transferable, but workers within each department work on any of the three products. There are three…
A producer has three products, A, B, and C, which are composed from many of the same raw materials and subassemblies by the same skilled workforce. Each unit of product A uses 15 units of Raw Material X, one Purge System Subassembly, one Case, one Power Cord, three Labour Hours in the Assembly Department, and one Labour Hour in the Finishing Department. Each unit of product B uses 10 units of Raw Material X, five units of Raw Material Y, two Purge System Subassemblies, one Case, one Power cord, five Labour Hours in the Assembly Department, and 90 minutes in the Finishing Department. Each unit of product C uses five units of Raw Material X, 25 units of Raw Material Y, two Purge System Subassemblies, one Case, a Power Cord, seven Labour Hours in the Assembly Department, and Three Labour Hours in the Finishing Department. Labour between the Assembly and Finishing departments is not transferable, but workers within each department work on any of the three products. There are three…
A product can be produced on four different machines.Each machine has a fixed setup cost, variable productioncosts per-unit-processed, and a production capacity given inTable 15. A total of 2,000 units of the product must beproduced. Formulate an IP whose solution will tell us howto minimize total costs.Machine Fixed Cost ($) per Unit (S) Capacity1 1,000 20 9002 920 24 1,0003 800 16 1,2004 700 28 1,600
The Electrocomp Corporation manufactures two electrical products: air conditioners and large fans. The assembly process for each is similar in that both rquire a certain amount of wiring and drilling. Each air condtioner takes 3 hours of wiring and 2 hours of drilling. During the next production period, 240 hours of wiring time are available, and up to 140 hours of drilling time may be used. Each air conditioner sold yieds a profit of $25. Each fan assembled may be sold for a $15 profit. Formulate the best combination of air conditioners and fans that yiedls the highest profit. Use the corner point graphical approach.
How much influence can the employee requirements for one, two, or three days have on the weekly sched-ule in the employee scheduling example? Explore this in the following questions:a. Let Monday’s requirements change from 17 to 25in increments of 1. Use SolverTable to see how thetotal number of employees changes.b. Suppose the Monday and Tuesday requirementscan each, independently of one another, increasefrom 1 to 8 in increments of 1. Use a two-waySolverTable to see how the total number ofemployees changes. c. Suppose the Monday, Tuesday, and Wednes-day requirements each increase by the same amount, where this increase can be from 1 to 8in increments of 1. Use a one-way SolverTableto investigate how the total number of employeeschanges.
A factory works 8 hours a day, producing three products namely A, B and C. each of these products is processed in three different operations namely 1, 2 and 3. The processing times in minutes for each of these products in each of the operations are given below along with utilization of the processes and the cost and price in kwachas for each of these three products which have unlimited demand. Product Processing time (mins) in operation Cost/unit Price/unit (K) (K) 1 2 3 A 4 3 1 10 16 B 2 1 4 8 12 C 3 4 5 5 10 Utilisation 80% 70% 90% i. Formulate a linear programming model for this problem. ii. Determine the optimal product mix using the simplex method. Give the interpretations for the values obtained in the…
A) What is the theoretical minimum number of workstations? a. 3 workstations b. 3.5 workstations c. 3.83 workstations d. 4 workstations e. 5 workstations B) Which of the following statements is FALSE? a. Tasks A, B, and C can be started as soon as possible. b. All of the tasks A, B and C should be finished first before task F can be started. c. All of the tasks A through H should be finished first before task I can be started. d.All of the tasks B, E, C and F should be finished first before task H can be started. Answer the two questions please.
Vollmer Manufacturing makes three components for sale to refrigeration companies. The components are processed on two machines: a shaper and a grinder. The times (in minutes) required on each machine are as follows: Machine Component Shaper Grinder 1 6 4 2 4 5 3 4 2 The shaper is available for 120 hours, and the grinder is available for 110 hours. No more than 200 units of component 3 can be sold, but up to 900 units of each of the other components can be sold. In fact, the company already has orders for 600 units of component 1 that must be satisfied. The profit contributions for components 1, 2, and 3 are $8, $6, and $9, respectively. (a) Formulate and solve for the recommended production quantities. component 1 unitscomponent 2 unitscomponent 3 units (b) What are the objective coefficient ranges for the three components? (If there is no upper or lower limit, enter NO LIMIT. Round your answers to the nearest integer.) component 1 to unitscomponent 2 to…

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 manufacturing company produces four parts that require the use of a lathe and a drill press. The two machines operate 10 hours a day each. The following table provides the time in minutes required by each part: Production time in min Product Lathe Drill press 6 32 2.