Production schedule and loom assignments for each fabric

Assignment Help Operation Management

Reference no: EM131792515

A Textile Mill produces 5 different fabrics. each fabric can be woven on one or more of the mill's 38 looms. The sales department forecast of demand for the next month is shown below, along with data on selling price per a yard, variable cost per a yard, and purchase price per a yard. The mill operates 24hrs a day and is scheduled for 30 days during the coming month. The mill has two types of looms; dobbie and regular. The dobbie looms are more versatile and can be used for all five fabrics. The regular looms can produce only 3 of the fabrics. The mill has a total of 38 looms; 8 are dobbie and 30 regular. the rate of production for each fabric on each type of loom is shown below. The time required to change over from producing one fabric to another is negligible and does not need to be considered. The textile mill satisfies all demand with either its own fabric or fabric purchased from another mill. fabrics that cannot be woven because of limited loom capacity will be purchased from another mill. The purchase price of each fabric is also shown below. Monthly Demand Fabric Demand(yds) Selling price($/yrd) Variable Cost($/yrd) Purchase price($/yrd) 1 16500 .99 .66 .80 2 22000 .86 .55 .70 3 62000 1.10 .49 .60 4 7500 1.24 .51 .70 5 62000 .70 .50 .70 Production Rates Fabric Dobbie Regular 1 4.63 ---- 2 4.63 ---- 3 5.23 5.23 4 5.23 5.23 5 4.17 4.17 Questions; 1. The final production schedule and loom assignments for each fabric. 2. The projected total contribution profit. 3. A Discussion of the value of additional loom time. 4. A discussion of the objective coefficients' ranges. 5. A discussion how the objective of minimizing total costs would provide a different model than the objective of maximizing total profit contribution. This needs to be done on excel. I cant figure out on where everything goes. in terms of constraints and etc does if anyone can link the excel file that would be lovley.

Reference no: EM131792515

Questions Cloud

Prepare a presentation on triangular theory of love : Theories are important to the field of psychology for a number of reasons.The most important purpose that theories serve is to set the stage for research.

At what price does the common stock need to sell : At what price does the common stock need to sell for the conversion value to be equal to the current bond price?

Compute the corrected net income figures : At the end of 2010 (right-hand column above), the inventory was understated by $40,000, Compute the corrected net income figures for 2010 and 2011

What is the conversion value : Pittsburgh Steel Company has a convertible bond outstanding, trading in the marketplace at $930. The par value is $1,000, the coupon rate is 8 percent.

Production schedule and loom assignments for each fabric : The final production schedule and loom assignments for each fabric. The projected total contribution profit.

Write a recommendation letter : I have a recommendation letter from my boss, but he is too busy to write it for me. He wants me to write it for him, then he will sign the signature.

Principle and practices that can be used to manage diversity : Explain the basic principles and practices that can be used to manage diversity.

Should a stock split change price-earnings ratio for wilson : Wilson Pharmaceuticals' stock has done very well in the market during the last three years. It has risen from $45 to $70 per share.

Compare the criminal evaluations : Briefly describe the three types of evaluations you selected and explain when and under what circumstances you would use each.

User Account

All Pages