2. EMORY ALUMINUM The Emory Aluminum company rolls and sells aluminum foil in several widths. (Length...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
2. EMORY ALUMINUM The Emory Aluminum company rolls and sells aluminum foil in several widths. (Length is the same for all orders). Customers can order rolls of foil 24 inches, 20 inches, 12 inches, or 8 inches wide. The foil is manufactured in a standard width of 54 inches, and the smaller widths are slit(cut) from the standard roll. There are many ways the smaller widths can be cut, as shown in the table below: CUTTING METHOD 1 2 4 5 6 7 8 9 10 11 12 13 24 inches 2 1 1 1 1 20 inches 1 2 1 1 1 12 inches 1 1 1 4 8 inches 1 2 3 1 1 2 4 3 SCRAP 6. 2 2 6 6 2 6. 2 6. 2 6 6. (inches) For example, using method 3, one roll 24 inches wide, one roll 12 inches wide and two rolls 8 inches wide are cut from the standard roll. This leaves 2 inches of scrap [54 – 24- 12- 2(8) = 2]. Because some scrap is generated by the slitting process, it is not possible to cut certain combinations (not shown). All rolls for cutting are a standard 54-inch width, and all orders are for the standard widths in the table. Emory has received the following orders for the month of July: WIDTH ROLLS ORDERED 24 INCHES 330 20 INCHES 120 12 INCHES 480 8 INCHES 160 How should Emory cut rolls to fill these orders and minimize scrap? Formulate a linear programming model for the problem in a word document and then use solver to find a solution. 66 2. 2. 3. 2. EMORY ALUMINUM The Emory Aluminum company rolls and sells aluminum foil in several widths. (Length is the same for all orders). Customers can order rolls of foil 24 inches, 20 inches, 12 inches, or 8 inches wide. The foil is manufactured in a standard width of 54 inches, and the smaller widths are slit(cut) from the standard roll. There are many ways the smaller widths can be cut, as shown in the table below: CUTTING METHOD 1 2 4 5 6 7 8 9 10 11 12 13 24 inches 2 1 1 1 1 20 inches 1 2 1 1 1 12 inches 1 1 1 4 8 inches 1 2 3 1 1 2 4 3 SCRAP 6. 2 2 6 6 2 6. 2 6. 2 6 6. (inches) For example, using method 3, one roll 24 inches wide, one roll 12 inches wide and two rolls 8 inches wide are cut from the standard roll. This leaves 2 inches of scrap [54 – 24- 12- 2(8) = 2]. Because some scrap is generated by the slitting process, it is not possible to cut certain combinations (not shown). All rolls for cutting are a standard 54-inch width, and all orders are for the standard widths in the table. Emory has received the following orders for the month of July: WIDTH ROLLS ORDERED 24 INCHES 330 20 INCHES 120 12 INCHES 480 8 INCHES 160 How should Emory cut rolls to fill these orders and minimize scrap? Formulate a linear programming model for the problem in a word document and then use solver to find a solution. 66 2. 2. 3.
Expert Answer:
Answer rating: 100% (QA)
Lets formulate the LP Let ABCDEFGHIJKLand M be the number of each type of cut made Here our objectiv... View the full answer
Related Book For
Chemistry The Central Science
ISBN: 978-0321696724
12th edition
Authors: Theodore Brown, Eugene LeMay, Bruce Bursten, Catherine Murphy, Patrick Woodward
Posted Date:
Students also viewed these accounting questions
-
A piece of aluminum foil 1.00 cm square and 0.550 mm thick is allowed to react with bromine to form aluminum bromide. (a) How many moles of aluminum were used? (The density of aluminum is 2.699...
-
A package of aluminum foil contains 50 ft2 of foil, which weighs approximately 8.0 oz. Aluminum has a density of 2.70 g/cm3. What is the approximate thickness of the foil in millimeters?
-
In how many ways can 12 different books be distributed among four children so that (a) Each child gets three books? (b) The two oldest children get four books each and the two youngest get two books...
-
The specific activity of a preparation consisting of radioactive Co58 as and non-radioactive Co59 ao is equal to 2.2.1012 dis /(s g). The half-life of Co58 as is 71.3 days. Find the ratio of the mass...
-
Find the following binomial probabilities using the normal approximation. a. n = 70, p = .30, P(x = 18) b. n = 200, p = .70, P(133 < x < 145) c. n = 85, p = .40, P(x > 30) d. n = 150, p = .38, P(x <...
-
What are some of the problems associated with air traffic control commercialization?
-
A new project introducing a new product that is complementary to a firm's existing products would cause: a. Both incremental revenues and costs to be higher than if the new product was being...
-
Sanchez incurred the following items. Business income ....................................................................................80,000 Tax-exempt interest income...
-
A dog food producer reduced the price of a dog food. With the price at $12 the average monthly sales has been 21000. When the price dropped to $11, the average monthly sales rose to 28000. Assume...
-
Managers at DeJohn Corporation are analyzing a potential investment of $2,000,000 in equipment and the processes needed to manufacture and market MyHelperBotz, a product line of robots designed to...
-
1. To what extent does the choice to take a company public affect the owner's strategic planning for the firm's growth and success during the IPO (initial public offering) process? 2. Will the firm's...
-
In a time-series plot, the horizontal axis represents _______________. In Exercises 36, fill in each blank with the appropriate word or phrase.
-
A large online retailer sells thousands of products. The retailer has detailed data on the products purchased by each of its customers. Explain how you would use these data to predict the next...
-
In a time-series plot, the vertical axis represents time. In Exercises 710, determine whether the statement is true or false. If the statement is false, rewrite it as a true statement.
-
In a dotplot, the number of dots in a vertical column represents the number of times a certain value appears in a data set. In Exercises 710, determine whether the statement is true or false. If the...
-
Mean and standard deviation for a binary random variable One of the simplest discrete random variables is a binary random variable (sometimes called a Bernoulli random variable). It takes on only two...
-
1. Dual dating refers to when the auditor _ A. shows two dates on the same audit report B. shows two dates on two different audit reports C. also includes the date that the internal control function...
-
What does non-recourse financing mean?
-
The following data where measured for the reaction BF3(g) + NH3(g) -- F3BNH3(g): (a) What is the rate law for the reaction? (b)What is the overall order of the reaction? (c) Calculate the rate...
-
In what two ways can an object possess energy? How do these two ways differ from one another?
-
Using Appendix D, calculate the molar solubility of AgBr in (a) Pure water,
-
The three criteria for effective negotiation are ____________. (a) harmony, efficiency, and quality (b) quality, efficiency, and effectiveness (c) ethical behavior, practicality, and...
-
Which statement is true? (a) Principled negotiation leads to accommodation. (b) Hard distributive negotiation leads to collaboration. (c) Soft distributive negotiation leads to accommodation or...
-
Both ____________ goals should be considered in any negotiation. (a) performance and evaluation (b) task and substance (c) substance and relationship (d) task and performance
Study smarter with the SolutionInn App