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 | 6 | 0 | 10 ft. |
2 | 0 | 0 | 3 | 10 ft. |
3 | 8 | 0 | 0 | 4 ft. |
4 | 2 | 1 | 2 | 1 ft. |
5 | 7 | 1 | 0 | 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 100-99 = 1 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.
Optimal Solution:
(a) | Formulate an integer programming model that will determine how many 100-foot rolls to cut into each of the five patterns in order to minimize trim loss. If your answer is zero enter “0” and if the constant is "1" it must be entered in the box. | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
|
|||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
(b) | Solve the model formulated in part a. What is the minimal amount of trim loss? | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
Trim Loss: feet | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
How many of each pattern should be used and how many of each type of roll will be sold on the open market? If your answer is zero enter “0”. | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
|
Please show how to solve using excel if possible, thanks.
STAR Co. provides paper to smaller companies whose volumes are not large enough to warrant dealing...
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 6 0 10 ft. 2 0 0 3 10 ft....
All I need is the Trim loss in part b 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 5...
0 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 0 3 10 ft. 2 0 6 0 10...
Problem 12-1 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 6 0 10 ft. 2 5 2 0...
****Solve the model formulated in part a. What is the minimal amount of trim loss?**** Trim Loss: ____ feet STAR Co. provides paper to smaller companies whose volumes are not large enough to warrant dealing directly with the paper mil. 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...
3. Description of each X and data for 27 franchise stores are given below The data (X1, X2, X3, X4, X5, X6) are for each franchise store. X1 annual net sales/$1000 X2 number sq. ft/1000 X3 - inventory I$1000 X4- amount spent on advertising /$1000 X5 size of sales district/1000 families X6 number of competing stores in distric X1 X2 X3 X4 X5 X6 231 3 294 8.2 8.2 11 156 2.2 232 6.9 4.1 12 10 0.5 149 3...
can you answer question 9 please Problems 473 results from parts (a), (b), and (c). What model seems most plausible? How do the data limit your conclusions? tle the data from Freund (1979), presented in Problem 22 in Chapter 14. Taking be model discussed there as the maximum model, repeat parts (a) through (h) of Problem 6. In part (h), note the possible role of collinearity. A random sample of data was collected on residential sales in a large city....
1. COMPUTER PRODUCTION. MVC Enterprises can manufacture four different computer models; the Student, Plus, Net, and Pro models. The following gives the configurations of each model Student Celeron 20 gb Plus Pentium 20 gb Net Celeron 20 gb Pro Pentium 30 gb NO YES CD R/W YES DVD DVD + CD R/W Processor Hard Drive Floppy Drives Zip Drive Audio/Video Monitor Case Production Times (hrs.) Unit Profit YES DVD + CD R/W 17" Tower 15" 15 17" Tower Mini-Tower Mini-Tower...
Western Home Inspections is a home inspection service that provides prospective homebuyers with a thorough assessment of the major systems in a house prior to the execution of the purchase contract. Prospective homebuyers often ask the company for an estimate of the average monthly heating cost of the home during the winter. To answer this question, the company wants to build a regression model to help predict the average monthly heating cost (Y) as a function of the average outside...