5. A machine shop makes pipes for the oil and gas industry in lengths of 250...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
5. A machine shop makes pipes for the oil and gas industry in lengths of 250 cm and 400 cm. The shorter pipes give a profit of $140 each, while each long pipe gives a profit of $270. They can sell at most 900 of the 250 cm pipes and at most 300 of the longer ones. Each pipe spends time on three machines as follows: Machine Lathe Polisher Grinder Minutes per Pipe Short Long 5 7 8 2 10 8 Minutes Available 6300 4000 8100 In addition to the minutes available given in the above table, they can purchase up to 500 minutes (all, none, or any fraction of this amount) of additional polishing time at a cost of $2 per minute, and can purchase an unlimited amount of extra grinding time at a cost of $3 per minute. For every long pipe made, there must be at least two short pipes made. For every pair of long pipes made, there can be at most seven short pipes made. (a) Formulate an algebraic model for the problem. Submit this in Word or pdf. (b) Use LINGO or the Excel Solver to solve this model, including your name and student number on the model. If using LINGO, submit files for the model and the solution for each question. If using the Excel Solver, submit one file for all questions, using tabs for the model and the Answer Report (a total of ten tabs.) (c) State the solution in words. Submit this in Word or pdf. 5. A machine shop makes pipes for the oil and gas industry in lengths of 250 cm and 400 cm. The shorter pipes give a profit of $140 each, while each long pipe gives a profit of $270. They can sell at most 900 of the 250 cm pipes and at most 300 of the longer ones. Each pipe spends time on three machines as follows: Machine Lathe Polisher Grinder Minutes per Pipe Short Long 5 7 8 2 10 8 Minutes Available 6300 4000 8100 In addition to the minutes available given in the above table, they can purchase up to 500 minutes (all, none, or any fraction of this amount) of additional polishing time at a cost of $2 per minute, and can purchase an unlimited amount of extra grinding time at a cost of $3 per minute. For every long pipe made, there must be at least two short pipes made. For every pair of long pipes made, there can be at most seven short pipes made. (a) Formulate an algebraic model for the problem. Submit this in Word or pdf. (b) Use LINGO or the Excel Solver to solve this model, including your name and student number on the model. If using LINGO, submit files for the model and the solution for each question. If using the Excel Solver, submit one file for all questions, using tabs for the model and the Answer Report (a total of ten tabs.) (c) State the solution in words. Submit this in Word or pdf.
Expert Answer:
Related Book For
Introduction to Operations Research
ISBN: 978-1259162985
10th edition
Authors: Frederick S. Hillier, Gerald J. Lieberman
Posted Date:
Students also viewed these accounting questions
-
The oil and gas industry is often in the news these days as consumers look for ways to deal with the large increases in fuel prices in recent years. Some concerns have been expressed about the...
-
Managing Scope Changes Case Study Scope changes on a project can occur regardless of how well the project is planned or executed. Scope changes can be the result of something that was omitted during...
-
Mrs. B, recently widowed and in her mid to late 40s, is a senior executive working for a Singapore-based multi-national corporation with SGD 10 billion in global sales. She has a son aged 20 and a...
-
Tom Lamont, age 30, and Lin Lamont, age 31, have been married for six years. They got married right after Tom graduated from college. They have come to you for help in planning their financial...
-
Calculate Apples gross margin per unit and gross margin as a percentage of sales for the 16 GB iPad. What is Apples gross margin if the company sells 10 million iPads? The base Wi-Fi 16 GB iPad was...
-
Use Figure 12.28 to estimate the boiling point of water at an external pressure of 200 torr. (a) 66 C (b) 84 C (c) 100 C (d) 0 C Vapor pressure (torr) 800- 760 600- 400- 200 0- 0 34.6 C Diethyl ether...
-
The aerodynamic drag on a car depends on the "shape" of the car. For example, the car shown in Fig. P9.42 has a drag coefficient of 0.35 with the windows and roof closed. With the windows and roof...
-
Two automatic systems for dispensing maps are being compared by the state highway department. The accompanying breakeven chart of the comparison of these systems (System I vs System II) shows total...
-
What are the challenges associated with heat transfer in compact heat exchangers, and how do innovations in materials science and additive manufacturing contribute to overcoming these challenges ?
-
Using the information presented in Problem 13.4B, prepare a partial statement of cash flows for the current year, showing the computation of net cash flows from operating activities using the...
-
An item is ________ if it is likely to influence the decision of an investor or creditor.
-
Ram Ltd. which depreciates its machinery at 10% p.a. on Diminishing Balance Method had on 1.1.2016, Rs 9,72,000 on the debit side of Machinery Account. During the year 2016, Machinery purchased on...
-
You have just been hired as the bookkeeper for Roll With It, a food truck and catering company. During the month of November, the following transactions occurred: purchase for cash from Freshly...
-
Breaking down the work for building the requirements Accounting for any amount of work twice Copying previous functional and technical requirements from an archived work statement Focusing on...
-
Preparing a chart of accounts and opening an account Lillian Deters owns a service business called Deters Duplicating, which uses the following accounts. Instructions: 1. Prepare a chart of accounts...
-
When using context to infer the meaning of a word, you can look for: a. All of the answer choices b. Definitions of key terms in the text c. Antonyms of the word d. Synonyms of the word e. Lists that...
-
The Timberland Company, headquartered in Stratham, New Hampshire, makes and markets footwear, apparel, and accessories. Its footwear includes hiking boots, boat shoes, sandals, outdoor casual...
-
What are the 5 Cs of marketing channel structure?
-
Jessica Williams, manager of Kitchen Appliances for the Midtown Department Store, feels that her inventory levels of stoves have been running higher than necessary. Before revising the inventory...
-
For each of the following statements regarding service times modeled by the exponential distribution, label the statement as true or false and then justify your answer by referring to specific...
-
At the Forrester Manufacturing Company, one repair technician has been assigned the responsibility of maintaining three machines. For each machine, the probability distribution of the running time...
-
Donna Corporation manufactures custom cabinets for kitchens. It uses a normalcosting system with two direct-cost categoriesdirect materials and direct manufacturing laborand one indirect-cost pool,...
-
Donna Corporation manufactures custom cabinets for kitchens. It uses a normalcosting system with two direct-cost categoriesdirect materials and direct manufacturing laborand one indirect-cost pool,...
-
Donna Corporation manufactures custom cabinets for kitchens. It uses a normalcosting system with two direct-cost categoriesdirect materials and direct manufacturing laborand one indirect-cost pool,...
Study smarter with the SolutionInn App