preview

Scottsville Textile Mill

Satisfactory Essays

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 are

Get Access