needs excel solver 3. Minimizing Scrap. STAR Co. provides paper to smaller companies with volumes that are not largeenough to warrant dealing directly with the paper mill. STAR receives 100-feet-wide paper rollsfrom the mill and cuts the rolls into smaller rolls of widths 12, 15, and 30 feet. The demands forthese widths vary from week to week. The following cutting patterns have been established:Pattern Number1234512-ft0082715-ft6001130-ft03020Trim Loss (ft)1010411Trim loss is the leftover paper from a pattern (e.g., for pattern 4, 2(12) + 1(15) + 2(30) = 99 feet usedresults in 100 - 99 = 1 foot of trim loss). Orders in hand for the coming week are 5,670 12-footrolls, 1,680 15-foot rolls, and 3,350 30-foot rolls. Any of the three types of rolls produced in excessof the orders in hand will be sold on the onen market at the selling price No inventory is held esults in 100 – 99 = 1 foot of trim loss). Orders in hand for the coming week are 5,670 12-footolls, 1,680 15-foot rolls, and 3,350 30-foot rolls. Any of the three types of rolls produced in excessof the orders in hand will be sold on the open market at the selling price. No inventory is held.a.Formulate an integer programming model that will determine how many 100-foot rolls to cutinto each of the five patterns in order to minimize trim loss.b. Solve the model formulated in part (a). What is the minimal amount of trim loss? How manyof each pattern should be used and how many of each type of roll will be sold on the openmarket?

Given data is Pattern 12-ft 15-ft 30-ft Trim loss(ft) 1 0 6 0 10 2 0 0 3 10 3 8 0 0 4 4 2…

Answered: esults in 100 – 99 = 1 foot of trim…

Practical Management Science

6th Edition

ISBN:9781337406659

Author:WINSTON, Wayne L.

Publisher:WINSTON, Wayne L.

Chapter4: Linear Programming Models

Section: Chapter Questions

Problem 91P

See similar textbooks

Similar questions

STAR Co. provides paper to smaller companies with volumes that are not large enough to warrant dealing directly with the paper mill. STAR receives 100-feet-wide paper rolls from the mill and cuts the rolls into smaller rolls of widths 12, 15, and 30 feet. The demands for these widths vary from week to week. The following cutting patterns have been established. Pattern Number 12‐ft 15‐ft 30‐ft Trim Loss (ft) 1 0 6 0 10 2 0 0 3 10 3 8 0 0 4 4 3 0 2 4 5 7 1 0 1 Trim loss is the leftover paper from a pattern (e.g., for pattern 4, 3(12) + 0(15) + 2(30) = 96 feet used results in 100 − 96 = 4 foot of trim loss). Orders in hand for the coming week are 5,680 12-foot rolls, 1,670 15-foot rolls, and 3,340 30-foot rolls. Any of the three types of rolls produced in excess of the orders in hand will be sold on the open market at the selling price. No inventory is held. (a) Formulate an integer programming model that will determine how many 100-foot rolls to cut into each of the…
STAR Co. provides paper to smaller companies whose volumes are not large enough to warrant dealing directly with the paper mill. STAR receives 100-feet-wide paper rolls from the mill and cuts the rolls into smaller rolls of widths 12, 15, and 30 feet. The demands for these widths vary from week to week. The following cutting patterns have been established: Number of: Pattern 12ft. 15ft. 30ft. Trim Loss 1 0 4 1 10 ft. 2 4 3 0 7 ft. 3 8 0 0 4 ft. 4 2 1 2 1 ft. 5 2 3 1 1 ft. Trim loss is the leftover paper from a pattern (e.g., for pattern 4, 2(12) + 1(15) + 2(30) = 99 feet used resulting in foot of trim loss). Orders in hand for the coming week are 5,670 12-foot rolls, 1,680 15-foot rolls, and 3,350 30-foot rolls. Any of the three types of rolls produced in excess of the orders in hand will be sold on the open market at the selling price. No inventory is held. (a) Formulate an integer programming model that will determine how many 100-foot rolls to cut into…
Rajan wanted a radio from Jacky's. It appears that Rajan is particularly interested in purchasing a Radio from the inexpensive retailer's sales manager for consumer electronics. He tells Jacky, the salesperson at the inexpensive store where he thinks he'll get the best deal, that his old radio died and he wants to listen to his favourite tunes. He wants a replacement radio as quickly as possible. In three and a half weeks, Rajan's favourite model will be 10% off.He suspects Rajan won't wait and will find another job. Jacky will earn less on the lowered price. He thinks that telling Rajan of the sale makes little sense.When Jacky tells Rajan that the radio set he wants is no longer available and won't be for another week, Rajan is enraged. Fearing losing the business, Jacky begs his sales manager, Michelle, to speed up delivery. Michelle says it's impossible and suggests Jacky tell Rajan the store can get the set in 24 hours and sell him the demo model. Michelle says the sample is new…
An urn contains 10 red balls and 30 blue balls.a Suppose you draw 4 balls from the urn. Let Xi bethe number of red balls drawn on the ith ball (Xi 0 or1). After each ball is drawn, it is put back into the urn. Are the random variables X1, X2, X3, and X4 indepen-dent random variables? b Repeat part (a) for the case in which the balls are notput back in the urn after being drawn.
Make an np chart for the following data: n non-conforming 400 12 400 10 400 8 400 14 400 21 400 16 400 18 400 15 400 12 400 17
Alcohol Dragster On board most alcohol dragsters is a computer that compiles datainto a number of different categories during each race. The table below shows someof the actual data from a past race.Time inseconds The front wheels, at each end of the front axle, are 22.07 inches in diameter. Derive aformula that will convert rpm’s from a 22.07-inch wheel into miles per hour. Test yourformula on all six rows of the table. Explain any discrepancies between the table valuesand the values obtained from your formula.
Clippers Inc. (CI) manufactures two types of garden clippers. A light-duty model, called the “half-inch,”is intended for clipping branches and stems up to one-half inch thick. The “one-inch” model is designedfor heavier stems and branches. To boost sales, CI decided at the beginning of the current year to reducethe price of the half-inch model to better position its price relative to some key competitors. On the otherhand, CI felt that the one-inch model was technically superior to competitors’ models and decided that asmall price increase was appropriate. The data for the current and prior year are as follows:Current Year Prior YearSales units 7,200 6,500Sales mix for each productHalf-inch model 50% 30%One-inch model 50% 70%PriceHalf-inch model $12.00 $14.00One-inch model $36.00 $32.00Variable cost per unitHalf-inch model $6.00 $6.00One-inch model $8.00 $8.00Fixed cost $35,000 $35,000Required1. Prepare a comparative contribution income statement for CI for the current year that shows…
Nutri-Jenny is a weight-management center. It produces a wide variety of frozen entrées for consumption by its clients. The entrées are strictly monitored for nutritional content to ensure that the clients are eating a balanced diet. One new entrée will be a beef sirloin tips dinner. It will consist of beef tips and gravy, plus some combination of peas, carrots, and a dinner roll. Nutri-Jenny would like to determine what quantity of each item to include in the entrée to meet the nutritional requirements, while costing as little as possible. The nutritional information for each item and its cost are given in the table on the bottom of the preceding page. The nutritional requirements for the entrée are as follows: (1) it must have between 280 and 320 calories, (2) calories from fat should be no more than 30 percent of the total number of calories, and (3) it must have at least 600 IUs of vitamin A, 10 milligrams of vitamin C, and 30 grams of protein. Furthermore, for practical reasons,…
Whcih of the following is NOT false a. Service Quality and Customer Satisfaction are interchangebale terms O b. Service Quality is one of the input to achieving Customer Satisfaction Service Quality is the only input to achieving Customer Satisfaction O d. Service Quality and Customer satisfaction are not co related
A logistics manager wants to assess how varied the weight of lorry loads is over a period of time. He takes a 5 samples of 20 lorry loads (n) and notes the average load (tonnes) and the range within each sample. Sample Weight average in tonnes (x) Range (R) 1 15.5 4.5 2 12.3 5.3 3 8.8 6.2 4 10.3 5.2 5 13.1 3.8 What are the population means for the mean and the range? What are the upper and lower control limits for the sample means chart? What are the upper and lower controls for the range chart?
Prove the following using strong induction. Suppose you are gifted a collection of 3n pokéballs; all of the the pokéballs have the same size and weight except for one which is slightly heavier, and otherwiselook and feel exactly the same as the others. You are tasked with identifying theheavy pokéball and have at your disposal a set of balancing scales which can be usedto compare the weights of two collections of pokéballs. The scales can show whetherthe two collections have the same weight, or can show which collection is heavier if theweights are different. Prove using strong induction that you can identify the heavypokéball out of 3n pokéballs using n weighing operations.
Lefola Limited is the only manufacturer of product G_Easy in the Popa Land. It has provided documented levels of demand at certain selling prices for product G_Easy which are as follows:Price per unit 7 0006 000Demand Units 01Total costs 3 0005 000875 000 2 4 000 3 3 000 4 2 000 5 1 000 68 000 12 000 17 000 23 000 30 000Required:MGA40AT/POF117V – 2020 Instructional Teaching manual packUsing a tabular approach, calculate the marginal revenues and marginal costs for product G_Easy at the different levels of demand, and so determine the selling price at which Lefola Limited’s profits are maximized.

SEE MORE QUESTIONS

Recommended textbooks for you

Practical Management Science

Operations Management

ISBN:

9781337406659

Author:

WINSTON, Wayne L.

Publisher:

Cengage,

Practical Management Science

Operations Management

ISBN:

9781337406659

Author:

WINSTON, Wayne L.

Publisher:

Cengage,

SEE MORE TEXTBOOKS