(a) Formulate a model for this problem, taking care to define each of the variables used....
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
(a) Formulate a model for this problem, taking care to define each of the variables used. (b) Solve the model using Excel. (c) State the recommendation. A machine shop makes pipes for the oil and gas industry in lengths of 240 cm and 400 cm. The shorter pipes give a profit of $150 each, while each long pipe gives a profit of $270. They can sell at most 900 of the 240 cm pipes and at most 800 of the longer ones. Each pipe spends time on three machines as follows: Minutes per Pipe Short Long 7 2 8 Machine Lathe 5 Polisher 8 Grinder 10 Minutes Available 4900 4500 7200 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 five short pipes made. (a) Formulate a model for this problem, taking care to define each of the variables used. (b) Solve the model using Excel. (c) State the recommendation. A machine shop makes pipes for the oil and gas industry in lengths of 240 cm and 400 cm. The shorter pipes give a profit of $150 each, while each long pipe gives a profit of $270. They can sell at most 900 of the 240 cm pipes and at most 800 of the longer ones. Each pipe spends time on three machines as follows: Minutes per Pipe Short Long 7 2 8 Machine Lathe 5 Polisher 8 Grinder 10 Minutes Available 4900 4500 7200 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 five short pipes made.
Expert Answer:
Answer rating: 100% (QA)
a Formulate a model for this problem taking care to define each of the varia... View the full answer
Related Book For
Global Marketing management
ISBN: 978-0470505748
5th edition
Authors: Masaaki Kotabe, Kristiaan Helsen
Posted Date:
Students also viewed these general management questions
-
Planning is one of the most important management functions in any business. A front office managers first step in planning should involve determine the departments goals. Planning also includes...
-
1. How strong are the competitive forces confronting J. Crew in the market for specialty retail? Do a [Michael Porter] five-forces analysis to support your answer. (see chapter 3 in the textfor...
-
Read the case study and answer the question below with a one page response. What does a SWOT analysis reveal about the overall attractiveness of Under Armours situation? Founded in 1996 by former...
-
Q1-Mutual funds provide the following for their shareholders. A. diversification B. professional management C. record keeping and administration D. all of these options
-
The human eye contains aqueous humor, which separates the external cornea and the internal iris-lens structure. It is hypothesized that, in some individuals, small flakes of pigment are...
-
The auditor gathers evidence regarding the amounts shown in a bank reconciliation. Indicate the evidence he or she would gather or examine in support of a. The bank balance. c. Deposits in transit....
-
Eager Beaver, Inc., started 2011 with total assets of \($24,000\) and total liabilities of \($11,000\). At the end of 2011, the businesss total assets stood at \($34,000\), and its total liabilities...
-
The Cinco Centavo Company (CCC), a U.S. company, made credit sales to four customers in Asia on September 15, 2018, and received payment on October 15, 2018. Information related to these sales is as...
-
Discuss the integration of advanced materials science principles, including nanotechnology and self-healing materials, in the development of innovative construction materials with enhanced...
-
Anchovy acquired 90 percent of Yelton on January 1, 2009. Of Yeltons total acquisition-date fair value, $60,000 was allocated to undervalued equipment (with a 10-year life) and $80,000 was attributed...
-
Find the complete solution set to the equation (D+31)^(y) Explain your reasoning carefully. 0.
-
What New techniques in the production of computers make it possible to produce them at a lower cost. What do you think would happen in the market for computers?
-
Why do industries choose Islamic banking (IB) over conventional banking(CB)?
-
Reflect on a group interview you've had: * Was there anything you struggled with in preparing for the peer interviews? * What would you have changed about your interview? What would you have kept the...
-
A new pop-up restaurant serving high-end street tacos just opened and is expected to have high demand based on the chef's prior restaurant experience. The pop-up restaurant has only one window where...
-
How do financial institutions optimize risk-weighted asset allocation under the Basel II standardized approach, and what are the implications for systemic risk mitigation ?
-
Find and Upload a Job Ad/Description Find a position you are qualified for today . You will upload an actual job posting (retype, scan or photograph the actual ad, cite the location of the ad) - make...
-
Figure displays a 12.0 V battery 3 four uncharged capacitors of capacitances C1 = 4.00F, C2 = 6.00F, and C3 = 3.00F. The switch is thrown to the left side until capacitor 1 is fully charged. Then the...
-
Since the early 1980s, the benefits of globalization have been acknowledged by researchers in academia and by business practitioners. However, practitioners have continually indicated the constraints...
-
How is the WTO different from GATT? What functions is the WTO expected to perform?
-
How do host country macroeconomic and fiscal policies affect foreign company operations?
-
The man has a mass of 78 kg and stands motionless at the end of the diving board. If the board has the cross section shown, determine the maximum normal strain developed in the board. The modulus of...
-
The steel rod having a diameter of 1 in. is subjected to an internal moment of M = 300lbft. Determine the stress created at points A and B. Also, sketch a three-dimensional view of the stress...
-
The steel beam has the cross-sectional area shown. If w=5 kip/ft, determine the absolute maximum bending stress in the beam. W 8 8 ft- 8 ft W ft- -8 ft- .8 in. 0.30 in. 0.3 in.- 10 in. 0.30 in.
Study smarter with the SolutionInn App