Scottsville Textile Mill - 858 Words

Assignment 1 Scottsville Textile Mill As per the report a model has been developed which can be used to schedule production for the Scottsville Textile Mill and at the same time how many yards of each fabric must be purchased from another mill has been determined. All the discussion and analysis of the report has been included below. Table 4.16 Monthly demand, selling price, variable cost, and purchase price data for Scottsville Textile Mill Fabrics Fabric | Demand (yards) | Selling price ($/yard) | Variable Cost ($/yard) | Purchase Price ($/yard) | 1 | 16500 | 0.99 | 0.66 | 0.80 | 2 | 22000 | 0.86 | 0.55 | 0.70 | 3 | 62000 | 1.10 | 0.49 | 0.60 | 4 | 7500 | 1.24 | 0.51 | 0.70 | 5 | 62000 | 0.70 | 0.50 | 0.70 | Table†¦show more content†¦A discussion of the value of additional loom time. (The mill is considering purchasing a ninth dobbie loom. What is your estimate of the monthly profit contribution of this additional loom?) If an additional dobbie loom is purchased, the total profit is $62998.19, an increase of $466.70. Depending on the cost of the loom, we should make sure whether is really necessary. 4. A discussion of the objective coefficients ranges. The following are range of variable cost Cell | Name | Range | Fabric | 1 Dobbie | 0.65 | 0.68 | Fabric | 1 Regular | 0.52 | 1E+30 | Fabric | 2 Dobbie | -0.14 | 0.56 | Fabric | 2 Regular | 0.41 | 1E+30 | Fabric | 3 Dobbie | 0.48 | 1E+30 | Fabric | 3 Regular | 0.48 | 0.6 | Fabric | 4 Dobbie | 0.50 | 1E+30 | Fabric | 4 Regular | -0.11 | 0.52 | Fabric | 5 Dobbie | 0.48 | 1E+30 | Fabric | 5 Regular | -0.14 | 0.52 | Fabric | 1 y_i:=number of yard product i is purchased | 0.78 | 0.81 | Fabric | 2 y_i:=number of yard product i is purchased | 0.69 | 1E+30 | Fabric | 3 y_i:=number of yard product i is purchased | 0.49 | 0.61 | Fabric | 4 y_i:=number of yard product i is purchased | 0.62 | 1E+30 | Fabric | 5 y_i:=number of yard product i is purchased | 0.64 | 1E+30 | There are no range of selling cost and purchasing cost, since the total selling profit only depends on the demands, which areShow MoreRelatedScottsville Textile Mill Case747 Words   |  3 PagesScottsville Textile Mill Case MGM 350 Production Schedule and loom assignment Decision Variable X1: Yards of fabric 1 on dobbie loom X2: Yards of fabric 2 on dobbie loom X3: Yards of fabric 3 on dobbie loom X4: Yards of fabric 4 on dobbie loom X5: Yards of fabric 5 on dobbie loom X6: Yards of fabric 3 on regular loom X7: Yards of fabric 4 on regular loom X8: Yards of fabric 5 on regular loom X9: Yards of fabric 1 purchased X10: Yards of fabric 2Read MoreManagement Science1375 Words   |  6 Pages The Scottsville Textile Mill produces five different fabrics. Each fabric can be woven on one or more of the mill’s 38 looms. The sales department’s forecast of demand for the next month is shown below, along with data on the selling price per yard, variable cost per yard and the purchase price per yard. The mill operates 24 hours a day and is scheduled to work 30 days during the coming month. Monthly Demand, Selling Price, Variable Cost, and Purchase Price Data for the Scottsville Textile Read MoreTextile Mill Scheduling760 Words   |  3 PagesTextile Mill Scheduling Problem formulation †¢ Variable assignment on the length of each fabric produced and purchased: X1 - Length of fabric 1 in Yards produced as dobbie looms X2 - Length of fabric 2 in Yards produced as dobbie looms X3 - Length of fabric 3 in Yards produced as dobbie looms X4 - Length of fabric 4 in Yards produced as dobbie looms X5 - Length of fabric 5 in Yards produced as dobbie looms X6 - Length of fabric 3 in Yards produced as regular looms X7 - Length of fabric 4 in Yards