case 4.1 - qt

44
INTRODU Quantitat

Upload: vishal-tomar

Post on 21-Nov-2014

878 views

Category:

Documents


164 download

TRANSCRIPT

Page 1: case 4.1 - QT

CASE 4.1INTRODUCTION TO OPERATIONS RESEARCH

HILLIER/LIEBERMAN7E

Quantitative TechniquesSemester 3ITBM 09-11

Page 2: case 4.1 - QT

CASE 4.1INTRODUCTION TO OPERATIONS RESEARCH

HILLIER/LIEBERMAN7E

Quantitative TechniquesSemester 3ITBM 09-11

Page 3: case 4.1 - QT

Clothing Item Materials Requirements Price Machine CostTailored wool slacks 3 yards of wool 300 160

2 yards of acetate for liningCashmere sweater 1.5 yards of cashmere 450 150Silk blouse 1.5 yards of silk 180 100Silk camisole 0.5 yard of silk 120 60Tailored skirt 2 yards of rayon 270 120

1.5 yards of acetate for liningWool blazer 2.5 yards of wool 320 140

1.5 yards of acetate for lining

The fall casual fashions include:

Clothing Item Materials Requirements Price Machine CostVelvet pants 3 yards of velvet 350 175

2 yards of acetate for liningCotton sweater 1.5 yards of cotton 130 60Cotton miniskirt 0.5 yard of cotton 75 40

Velvet shirt 1.5 yards of velvet 200 160Button-down blouse 1.5 yards of rayon 120 90

From the tenth floor of her office building, Katherine Rally watches the swarms of New Yorkers fight their way through the streets infested with yellow cabs and the sidewalks littered with hot dog stands. On this sweltering July day, she pays particular attention to the fashions worn by the various women and wonders what they will choose to wear in the fall. Her thoughts are not simply random musings; they are critical to her work since she owns and manages TrendLines, an elite women’s clothing company.

Today is an especially important day because she must meet with Ted Lawson, the production manager, to decide upon next month’s production plan for the fall line. Specifically, she must determine the quantity of each clothing item she should produce given the plant’s production capacity, limited resources, and demand forecasts. Accurate planning for next month’s production is critical to fall sales since the items produced next month will appear in stores during September, and women generally buy the majority of the fall fashions when they first appear in September.

She turns back to her sprawling glass desk and looks at the numerous papers covering it. Her eyes roam across the clothing patterns designed almost six months ago, the lists of materials requirements for each pattern, and the lists of demand forecasts for each pattern determined by customer surveys at fashion shows. She remembers the hectic and sometimes nightmarish days of designing the fall line and presenting it at fashion shows in New York, Milan, and Paris. Ultimately, she paid her team of six designers a total of $860,000 for their work on her fall line. With the cost of hiring runwaymodels, hair stylists, and makeup artists, sewing and fitting clothes, building the set, choreographing and rehearsing the show, and renting the conference hall, each of the three fashion shows cost her an additional $2,700,000.

She studies the clothing patterns and material requirements. Her fall line consists of both professional and casual fashions. She determined the prices for each clothing item by taking into account the quality and cost of material, the cost of labor and machining, the demand for the item, and the prestige of the TrendLines brand name.

The fall professional fashions include:

She knows that for the next month, she has ordered 45,000 yards of wool, 28,000 yards of acetate, 9,000 yards of cashmere, 18,000 yards of silk, 30,000 yards of rayon, 20,000 yards of velvet, and 30,000 yards of cotton for production. The prices of the materials are:

Page 4: case 4.1 - QT

Material Price per yardWool 9

Acetate 1.5Cashmere 60

Silk 13Rayon 2.25Velvet 12Cotton 2.5

Any material that is not used in production can be sent back to the textile wholesaler for a full refund, although scrap material cannot be sent back to the wholesaler. She knows that the production of both the silk blouse and cotton sweater leaves leftover scraps of material. Specifically, for the production of one silk blouse or one cotton sweater, 2 yards of silk and cotton, respectively, are needed. From these 2 yards, 1.5 yards are used for the silk blouse or the cotton sweater and 0.5 yard is left as scrap material. She does not want to waste the material, so she plans to use the rectangularscrap of silk or cotton to produce a silk camisole or cotton miniskirt, respectively. Therefore, whenever a silk blouse is produced, a silk camisole is also produced. Likewise, whenever a cotton sweater is produced, a cotton miniskirt is also produced. Note that it is possible to produce a silk camisole without producing a silk blouse and a cotton miniskirt without producing a cotton sweater.

The demand forecasts indicate that some items have limited demand. Specifically, because the velvet pants and velvet shirts are fashion fads, TrendLines has forecasted that it can sell only 5,500 pairs of velvet pants and 6,000 velvet shirts. TrendLines does not want to produce more than the forecasted demand because once the pants and shirts go out of style, the company cannot sell them. TrendLines can produce less than the forecasted demand, however, since the company is not required to meet the demand. The cashmere sweater also has limited demand because it is quite expensive,and TrendLines knows it can sell at most 4,000 cashmere sweaters. The silk blouses and camisoles have limited demand because many women think silk is too hard to care for, and TrendLines projects that it can sell at most 12,000 silk blouses and 15,000 silk camisoles.

The demand forecasts also indicate that the wool slacks, tailored skirts, and wool blazers have a great demand because they are basic items needed in every professional wardrobe. Specifically, the demand for wool slacks is 7,000 pairs of slacks, and the demand for wool blazers is 5,000 blazers. Katherine wants to meet at least 60 percent of the demand for these two items in order to maintain her loyal customer base and not lose business in the future. Although the demand for tailored skirts could not be estimated, Katherine feels she should make at least 2,800 of them.

Page 5: case 4.1 - QT

From the tenth floor of her office building, Katherine Rally watches the swarms of New Yorkers fight their way through the streets infested with yellow cabs and the sidewalks littered with hot dog stands. On this sweltering July day, she pays particular attention to the fashions worn by the various women and wonders what they will choose to wear in the fall. Her thoughts are not simply random musings; they are critical to her work since she owns and manages TrendLines, an elite women’s clothing company.

Today is an especially important day because she must meet with Ted Lawson, the production manager, to decide upon next month’s production plan for the fall line. Specifically, she must determine the quantity of each clothing item she should produce given the plant’s production capacity, limited resources, and demand forecasts. Accurate planning for next month’s production is critical to fall sales since the items produced next month will appear in stores during September, and women generally buy the majority of the fall fashions when they first appear in September.

She turns back to her sprawling glass desk and looks at the numerous papers covering it. Her eyes roam across the clothing patterns designed almost six months ago, the lists of materials requirements for each pattern, and the lists of demand forecasts for each pattern determined by customer surveys at fashion shows. She remembers the hectic and sometimes nightmarish days of designing the fall line and presenting it at fashion shows in New York, Milan, and Paris. Ultimately, she paid her team of six designers a total of $860,000 for their work on her fall line. With the cost of

models, hair stylists, and makeup artists, sewing and fitting clothes, building the set, choreographing and rehearsing the show, and renting the conference hall, each of the three fashion shows cost

She studies the clothing patterns and material requirements. Her fall line consists of both professional and casual fashions. She determined the prices for each clothing item by taking into account the quality and cost of material, the cost of labor and machining, the demand for the item, and the prestige of the TrendLines brand name.

She knows that for the next month, she has ordered 45,000 yards of wool, 28,000 yards of acetate, 9,000 yards of cashmere, 18,000 yards of silk, 30,000 yards of rayon, 20,000 yards of

Page 6: case 4.1 - QT

Any material that is not used in production can be sent back to the textile wholesaler for a full refund, although scrap material cannot be sent back to the wholesaler. She knows that the production of both the silk blouse and cotton sweater leaves leftover scraps of material. Specifically, for the production of one silk blouse or one cotton sweater, 2 yards of silk and cotton, respectively, are needed. From these 2 yards, 1.5 yards are used for the silk blouse or the cotton sweater and 0.5 yard is left as scrap material. She does not want to waste the

scrap of silk or cotton to produce a silk camisole or cotton miniskirt, respectively. Therefore, whenever a silk blouse is produced, a silk camisole is also produced. Likewise, whenever a cotton sweater is produced, a cotton miniskirt is also produced. Note that it is possible to produce a silk camisole without producing a silk blouse and a cotton miniskirt without

The demand forecasts indicate that some items have limited demand. Specifically, because the velvet pants and velvet shirts are fashion fads, TrendLines has forecasted that it can sell only 5,500 pairs of velvet pants and 6,000 velvet shirts. TrendLines does not want to produce more than the forecasted demand because once the pants and shirts go out of style, the company cannot sell them. TrendLines can produce less than the forecasted demand, however, since the company is not required to meet the demand. The cashmere sweater also has

and TrendLines knows it can sell at most 4,000 cashmere sweaters. The silk blouses and camisoles have limited demand because many women think silk is too hard to care for, and

The demand forecasts also indicate that the wool slacks, tailored skirts, and wool blazers have a great demand because they are basic items needed in every professional wardrobe. Specifically, the demand for wool slacks is 7,000 pairs of slacks, and the demand for wool blazers is 5,000 blazers. Katherine wants to meet at least 60 percent of the demand for these two items in order to maintain her loyal customer base and not lose business in the future. Although the demand for tailored skirts could not be estimated, Katherine feels she should

Page 7: case 4.1 - QT

b) Formulate and solve a linear programming problem to maximize profit given the production, resource, and demand constraints.

Before she makes her final decision, Katherine plans to explore the following questions independently except where otherwise indicated.

(a) Ted is trying to convince Katherine not to produce any velvet shirts since the demand for this fashion fad is quite low. He argues that this fashion fad alone accounts for $500,000 of the fixed design and other costs. The net contribution (price of clothing item - materials cost - labor cost) from selling the fashion fad should cover these fixed costs. Each velvet shirt generates a net contribution of $22. He argues that given the net contribution, even satisfying the maximum demand will not yield a profit. What do you think of Ted’s argument?

(c) The textile wholesaler informs Katherine that the velvet cannot be sent back because the demand forecasts show that the demand for velvet will decrease in the future. Katherine can therefore get no refund for the velvet. How does this fact change the production plan?

(d) What is an intuitive economic explanation for the difference between the solutions found in parts (b) and (c)?

(e) The sewing staff encounters difficulties sewing the arms and lining into the wool blazers since the blazer pattern has an awkward shape and the heavy wool material is difficult to cut and sew. The increased labor time to sew a wool blazer increases the labor and machine cost for each blazer by $80. Given this new cost, how many of each clothing item should Trend-Lines produce to maximize profit?

(f ) The textile wholesaler informs Katherine that since another textile customer canceled his order, she can obtain an extra 10,000 yards of acetate. How many of each clothing item should TrendLines now produce to maximize profit?

(g) TrendLines assumes that it can sell every item that was not sold during September and October in a big sale in November at 60 percent of the original price. Therefore, it can sell all items in unlimited quantity during the November sale. (The previously mentioned upper limits on demand concern only the sales during September and October.) What should the new production plan be to maximize profit?

Page 8: case 4.1 - QT

b) Formulate and solve a linear programming problem to maximize profit given the production, resource, and demand constraints.

Before she makes her final decision, Katherine plans to explore the following questions independently except where otherwise indicated.

(a) Ted is trying to convince Katherine not to produce any velvet shirts since the demand for this fashion fad is quite low. He argues that this fashion fad alone accounts for $500,000 of the fixed design and other costs. The net contribution (price of clothing item - materials cost - labor cost) from selling the fashion fad should cover these fixed costs. Each velvet shirt generates a net contribution of $22. He argues that given the net contribution, even satisfying the maximum demand will not yield a profit. What do you think of Ted’s argument?

(c) The textile wholesaler informs Katherine that the velvet cannot be sent back because the demand forecasts show that the demand for velvet will decrease in the future. Katherine can therefore get no

(d) What is an intuitive economic explanation for the difference between the solutions found in parts (b) and (c)?

(e) The sewing staff encounters difficulties sewing the arms and lining into the wool blazers since the blazer pattern has an awkward shape and the heavy wool material is difficult to cut and sew. The increased labor time to sew a wool blazer increases the labor and machine cost for each blazer by $80. Given this new cost, how many of each clothing item should Trend-Lines produce to maximize profit?

(f ) The textile wholesaler informs Katherine that since another textile customer canceled his order, she can obtain an extra 10,000 yards of acetate. How many of each clothing item should TrendLines now

(g) TrendLines assumes that it can sell every item that was not sold during September and October in a big sale in November at 60 percent of the original price. Therefore, it can sell all items in unlimited quantity during the November sale. (The previously mentioned upper limits on demand concern only the sales during September and October.) What should the new production plan be to maximize profit?

Page 9: case 4.1 - QT

PROFESSIONAL FASHIONS

Production Plan Silk Blouse Silk Camesole Tailored Skirt

Ans b 4200.00 4000.00 7000.00 15000.00 8067.00Ans c - I 4200.00 4000.00 7000.00 15000.00 8064.00Ans c - II 4200.00 4000.00 7000.00 15000.00 3177.78

Ans e 4200.00 4000.00 7000.00 15000.00 10065.00Ans f 4200.00 4000.00 7000.00 15000.00 14733.00Ans g 4200.00 6000.00 7000.00 15000.00 8067.00

Tailored Wool Slacks

Cashmere Sweater

Page 10: case 4.1 - QT

PROFESSIONAL FASHIONS CASUAL FASHIONS

Wool Blazer Velvet Pants Cotton Sweater Velvet Shirt

4999.00 0.00 0.00 60000.00 6000.00 9243.005000.00 2.00 0.00 60000.00 6000.00 9248.005000.00 3666.67 0.00 60000.00 6000.00 15762.963001.00 0.00 0.00 60000.00 6000.00 6579.005000.00 0.00 0.00 60000.00 6000.00 356.004999.00 0.00 0.00 60000.00 6000.00 9243.00

Cotton Miniskirt

Button-down Blouse

Page 11: case 4.1 - QT

Gross Profit

$3,793,914.75 (Optimal Solution)$3,530,090.00 -$263,824.75$3,633,922.22 -$159,992.53$3,503,884.75 -$290,030.00$4,512,331.50 $718,416.75$3,853,914.75 $60,000.00

Gain/Loss w.r.t Original Solution

Page 12: case 4.1 - QT

Fixed costs will not change with withholding dresses made from Velvet from production. Fixed costs are for the entire collection and must not be made the basis of deciding on dropping a product from production plan unless the product's net contribution Is in the negitive.

Page 13: case 4.1 - QT

Fixed costs will not change with withholding dresses made from Velvet from production. Fixed costs are for the entire collection and must not be made the basis of deciding on dropping a

Page 14: case 4.1 - QT

Wool Acetate Cashmere SilkPrice Per Yard 9 1.5 60 13

Wool Acetate Cashmere SilkQuantity Available 45000 28000 9000 18000

Tailored Wool Slacks 3 2 0 0Cashmere Sweater 0 0 1.5 0Silk Blouse 0 0 0 1.5Silk Camesole 0 0 0 0.5Tailored Skirt 0 1.5 0 0Wool Blazer 2.5 1.5 0 0Velvet Pants 0 2 0 0Cotton Sweater 0 0 0 0Cotton Miniskirt 0 0 0 0Velvet Shirt 0 0 0 0Button-down Blouse 0 0 0 0

Tailored Wool Slacks 12600 8400 0 0Cashmere Sweater 0 0 6000 0Silk Blouse 0 0 0 10500Silk Camesole 0 0 0 7500Tailored Skirt 0 12100.5 0 0Wool Blazer 12497.5 7498.5 0 0Velvet Pants 0 0 0 0Cotton Sweater 0 0 0 0Cotton Miniskirt 0 0 0 0Velvet Shirt 0 0 0 0Button-down Blouse 0 0 0 0Total Material Used 25097.5 27999 6000 18000

PRO

FESS

ION

AL

FASH

ION

CASU

AL

FASH

ION

SPR

OFE

SSIO

NAL

FA

SHIO

NCA

SUA

L FA

SHIO

NS

Page 15: case 4.1 - QT

Rayon Velvet Cotton2.25 12 2.5

Rayon Velvet Cotton30000 20000 30000 T Mat. Cost

0 0 0 300 0 0 900 0 0 19.50 0 0 6.52 0 0 6.750 0 0 24.750 3 0 390 0 1.5 3.750 0 0.5 1.250 1.5 0 18

1.5 0 0 3.375

Total Produced Selling Price L&M Cost0 0 0 4200 300 1600 0 0 4000 450 1500 0 0 7000 180 1000 0 0 15000 120 60

16134 0 0 8067 270 1200 0 0 4999 320 1400 0 0 0 350 1750 0 0 0 130 600 0 30000 60000 75 400 9000 0 6000 200 160

13864.5 0 0 9243 120 9029998.5 9000 30000

Designer Fee = $860,000.00Fashion Show Costs = $2,700,000.00

Total Fixed Costs = $3,560,000.00

Page 16: case 4.1 - QT

Manufacturing LimitsProfit on Product Total Profit Upper limit Lower Limit

110 462000 7000 4200210 840000 4000

60.5 423500 1200053.5 802500 15000

143.25 1155597.75 2800155.25 776094.75 5000 3000

136 0 550066.25 033.75 2025000

22 132000 600026.625 246094.875

Total Revenue = $16,706,930.00Fixed Cost = $3,560,000.00L&M Cost = $9,844,142.63Returns Cost= $491,127.38Gross Profit= $3,793,914.75 (Maximize)

Page 17: case 4.1 - QT

Wool Acetate Cashmere SilkPrice Per Yard 9 1.5 60 13

Wool Acetate Cashmere SilkQuantity Available 45000 28000 9000 18000

Tailored Wool Slacks 3 2 0 0Cashmere Sweater 0 0 1.5 0Silk Blouse 0 0 0 1.5Silk Camesole 0 0 0 0.5Tailored Skirt 0 1.5 0 0Wool Blazer 2.5 1.5 0 0Velvet Pants 0 2 0 0Cotton Sweater 0 0 0 0Cotton Miniskirt 0 0 0 0Velvet Shirt 0 0 0 0Button-down Blouse 0 0 0 0

Tailored Wool Slacks 12600 8400 0 0Cashmere Sweater 0 0 6000 0Silk Blouse 0 0 0 10500Silk Camesole 0 0 0 7500Tailored Skirt 0 12096 0 0Wool Blazer 12500 7500 0 0Velvet Pants 0 4 0 0Cotton Sweater 0 0 0 0Cotton Miniskirt 0 0 0 0Velvet Shirt 0 0 0 0Button-down Blouse 0 0 0 0Total Material Used 25100 28000 6000 18000

PRO

FESS

ION

AL

FASH

ION

CASU

AL

FASH

ION

SPR

OFE

SSIO

NAL

FA

SHIO

NCA

SUA

L FA

SHIO

NS

Page 18: case 4.1 - QT

Rayon Velvet Cotton2.25 12 2.5 Remaining velvet is not used in poduction in this case.

Rayon Velvet Cotton30000 20000 30000 T Mat. Cost

0 0 0 300 0 0 900 0 0 19.50 0 0 6.52 0 0 6.750 0 0 24.750 3 0 390 0 1.5 3.750 0 0.5 1.250 1.5 0 18

1.5 0 0 3.375

Total Produced Price L&M Cost0 0 0 4200 300 1600 0 0 4000 450 1500 0 0 7000 180 1000 0 0 15000 120 60

16128 0 0 8064 270 1200 0 0 5000 320 1400 6 0 2 350 1750 0 0 0 130 600 0 30000 60000 75 400 9000 0 6000 200 160

13872 0 0 9248 120 9030000 9006 30000

Designer Fee = $860,000.00Fashion Show Costs = $2,700,000.00

Total Fixed Costs = $3,560,000.00

G. Profit w/o Waste Mat. Cost=Waste Material Cost =

I30
Remaining velvet is not returned
Page 19: case 4.1 - QT

Remaining velvet is not used in poduction in this case.

Manufacturing LimitsProfit on Product Total Profit Upper limit Lower Limit

110 462000 7000 4200210 840000 4000

60.5 423500 1200053.5 802500 15000

143.25 1155168 2800155.25 776250 5000 3000

136 272 550066.25 033.75 2025000

22 132000 600026.625 246228

Total Revenue = $16,707,740.00Fixed Cost = $3,560,000.00L&M Cost = $9,844,822.00Returns Cost= $359,100.00

G. Profit w/o Waste Mat. Cost= $3,662,018.00 (Maximize)Waste Material Cost = $131,928.00

Gross Profit= $3,530,090.00 (Optimized)

Page 20: case 4.1 - QT

Wool Acetate Cashmere SilkPrice Per Yard 9 1.5 60 13

Wool Acetate Cashmere SilkQuantity Available 45000 28000 9000 18000

Tailored Wool Slacks 3 2 0 0Cashmere Sweater 0 0 1.5 0Silk Blouse 0 0 0 1.5Silk Camesole 0 0 0 0.5Tailored Skirt 0 1.5 0 0Wool Blazer 2.5 1.5 0 0Velvet Pants 0 2 0 0Cotton Sweater 0 0 0 0Cotton Miniskirt 0 0 0 0Velvet Shirt 0 0 0 0Button-down Blouse 0 0 0 0

Tailored Wool Slacks 12600 8400 0 0Cashmere Sweater 0 0 6000 0Silk Blouse 0 0 0 10500Silk Camesole 0 0 0 7500Tailored Skirt 0 4766.666667 0 0Wool Blazer 12500 7500 0 0Velvet Pants 0 7333.333333 0 0Cotton Sweater 0 0 0 0Cotton Miniskirt 0 0 0 0Velvet Shirt 0 0 0 0Button-down Blouse 0 0 0 0Total Material Used 25100 28000 6000 18000

PRO

FESS

ION

AL

FASH

ION

CASU

AL

FASH

ION

SPR

OFE

SSIO

NAL

FA

SHIO

NCA

SUA

L FA

SHIO

NS

Page 21: case 4.1 - QT

Rayon Velvet Cotton2.25 12 2.5 Remaining velvet is used in poduction in this case.

Rayon Velvet Cotton30000 20000 30000 T Mat. Cost

0 0 0 300 0 0 900 0 0 19.50 0 0 6.52 0 0 6.750 0 0 24.750 3 0 390 0 1.5 3.750 0 0.5 1.250 1.5 0 18

1.5 0 0 3.375

Total Produced Price L&M Cost0 0 0 4200 300 1600 0 0 4000 450 1500 0 0 7000 180 1000 0 0 15000 120 60

6355.555556 0 0 3177.77777777778 270 1200 0 0 5000 320 1400 11000 0 3666.66666666667 350 1750 0 0 0 130 600 0 30000 60000 75 400 9000 0 6000 200 160

23644.44444 0 0 15762.962962963 120 9030000 20000 30000

Designer Fee = $860,000.00Fashion Show Costs = $2,700,000.00

Total Fixed Costs = $3,560,000.00

K19
Making use of all the Velvet
I30
Velvet is not returned, so for solver the value of total used is set to maximum.
Page 22: case 4.1 - QT

Remaining velvet is used in poduction in this case.

Manufacturing LimitsProfit on Product Total Profit Upper limit Lower Limit

110 462000 7000 4200210 840000 4000

60.5 423500 1200053.5 802500 15000

143.25 455216.666666667 2800155.25 776250 5000 3000

136 498666.666666667 550066.25 033.75 2025000

22 132000 600026.625 419688.888888889

Total Revenue = $17,452,888.89Fixed Cost = $3,560,000.00L&M Cost = $10,618,066.67Returns Cost= $359,100.00Gross Profit= $3,633,922.22 (Maximize)

Page 23: case 4.1 - QT

Wool Acetate Cashmere SilkPrice Per Yard 9 1.5 60 13

Wool Acetate Cashmere SilkQuantity Available 45000 28000 9000 18000

Tailored Wool Slacks 3 2 0 0Cashmere Sweater 0 0 1.5 0Silk Blouse 0 0 0 1.5Silk Camesole 0 0 0 0.5Tailored Skirt 0 1.5 0 0Wool Blazer 2.5 1.5 0 0Velvet Pants 0 2 0 0Cotton Sweater 0 0 0 0Cotton Miniskirt 0 0 0 0Velvet Shirt 0 0 0 0Button-down Blouse 0 0 0 0

Tailored Wool Slacks 12600 8400 0 0Cashmere Sweater 0 0 6000 0Silk Blouse 0 0 0 10500Silk Camesole 0 0 0 7500Tailored Skirt 0 15097.5 0 0Wool Blazer 7502.5 4501.5 0 0Velvet Pants 0 0 0 0Cotton Sweater 0 0 0 0Cotton Miniskirt 0 0 0 0Velvet Shirt 0 0 0 0Button-down Blouse 0 0 0 0Total Material Used 20102.5 27999 6000 18000

PRO

FESS

ION

AL

FASH

ION

CASU

AL

FASH

ION

SPR

OFE

SSIO

NAL

FA

SHIO

NCA

SUA

L FA

SHIO

NS

Page 24: case 4.1 - QT

Rayon Velvet Cotton2.25 12 2.5

Rayon Velvet Cotton30000 20000 30000 T Mat. Cost

0 0 0 300 0 0 900 0 0 19.50 0 0 6.52 0 0 6.750 0 0 24.750 3 0 390 0 1.5 3.750 0 0.5 1.250 1.5 0 18

1.5 0 0 3.375

Total Produced Price L&M Cost0 0 0 4200 300 1600 0 0 4000 450 1500 0 0 7000 180 1000 0 0 15000 120 60

20130 0 0 10065 270 1200 0 0 3001 320 2200 0 0 0 350 1750 0 0 0 130 600 0 30000 60000 75 400 9000 0 6000 200 160

9868.5 0 0 6579 120 9029998.5 9000 30000

Designer Fee = $860,000.00Fashion Show Costs = $2,700,000.00

Total Fixed Costs = $3,560,000.00

Page 25: case 4.1 - QT

Manufacturing LimitsProfit on Product Total Profit Upper limit Lower Limit

110 462000 7000 4200210 840000 4000

60.5 423500 1200053.5 802500 15000

143.25 1441811.25 280075.25 225825.25 5000 3000

136 0 550066.25 033.75 2025000

22 132000 600026.625 175165.875

Total Revenue = $16,287,350.00Fixed Cost = $3,560,000.00L&M Cost = $9,759,547.63Returns Cost= $536,082.38Gross Profit= $3,503,884.75 (Maximize)

Page 26: case 4.1 - QT

Wool Acetate Cashmere SilkPrice Per Yard 9 1.5 60 13

Wool Acetate Cashmere SilkQuantity Available 45000 38000 9000 18000

Tailored Wool Slacks 3 2 0 0Cashmere Sweater 0 0 1.5 0Silk Blouse 0 0 0 1.5Silk Camesole 0 0 0 0.5Tailored Skirt 0 1.5 0 0Wool Blazer 2.5 1.5 0 0Velvet Pants 0 2 0 0Cotton Sweater 0 0 0 0Cotton Miniskirt 0 0 0 0Velvet Shirt 0 0 0 0Button-down Blouse 0 0 0 0

Tailored Wool Slacks 12600 8400 0 0Cashmere Sweater 0 0 6000 0Silk Blouse 0 0 0 10500Silk Camesole 0 0 0 7500Tailored Skirt 0 22099.5 0 0Wool Blazer 12500 7500 0 0Velvet Pants 0 0 0 0Cotton Sweater 0 0 0 0Cotton Miniskirt 0 0 0 0Velvet Shirt 0 0 0 0Button-down Blouse 0 0 0 0Total Material Used 25100 37999.5 6000 18000

PRO

FESS

ION

AL

FASH

ION

CASU

AL

FASH

ION

SPR

OFE

SSIO

NAL

FA

SHIO

NCA

SUA

L FA

SHIO

NS

Page 27: case 4.1 - QT

Rayon Velvet Cotton2.25 12 2.5

Rayon Velvet Cotton30000 20000 30000 T Mat. Cost

0 0 0 300 0 0 900 0 0 19.50 0 0 6.52 0 0 6.750 0 0 24.750 3 0 390 0 1.5 3.750 0 0.5 1.250 1.5 0 18

1.5 0 0 3.375

Total Produced Price L&M Cost0 0 0 4200 300 1600 0 0 4000 450 1500 0 0 7000 180 1000 0 0 15000 120 60

29466 0 0 14733 270 1200 0 0 5000 320 1400 0 0 0 350 1750 0 0 0 130 600 0 30000 60000 75 400 9000 0 6000 200 160

534 0 0 356 120 9030000 9000 30000

Designer Fee = $860,000.00Fashion Show Costs = $2,700,000.00

Total Fixed Costs = $3,560,000.00

Page 28: case 4.1 - QT

Manufacturing LimitsProfit on Product Total Profit Upper limit Lower Limit

110 462000 7000 4200210 840000 4000

60.5 423500 1200053.5 802500 15000

143.25 2110502.25 2800155.25 776250 5000 3000

136 0 550066.25 033.75 2025000

22 132000 600026.625 9478.5

Total Revenue = $17,440,630.00Fixed Cost = $3,560,000.00L&M Cost = $9,859,399.25Returns Cost= $491,100.75Gross Profit= $4,512,331.50 (Maximize)

Page 29: case 4.1 - QT

Wool Acetate Cashmere SilkPrice Per Yard 9 1.5 60 13

Wool Acetate Cashmere SilkQuantity Available 45000 28000 9000 18000

Tailored Wool Slacks 3 2 0 0Cashmere Sweater 0 0 1.5 0Silk Blouse 0 0 0 1.5Silk Camesole 0 0 0 0.5Tailored Skirt 0 1.5 0 0Wool Blazer 2.5 1.5 0 0Velvet Pants 0 2 0 0Cotton Sweater 0 0 0 0Cotton Miniskirt 0 0 0 0Velvet Shirt 0 0 0 0Button-down Blouse 0 0 0 0

Tailored Wool Slacks 12600 8400 0 0Cashmere Sweater 0 0 6000 0Silk Blouse 0 0 0 10500Silk Camesole 0 0 0 7500Tailored Skirt 0 12100.5 0 0Wool Blazer 12497.5 7498.5 0 0Velvet Pants 0 0 0 0Cotton Sweater 0 0 0 0Cotton Miniskirt 0 0 0 0Velvet Shirt 0 0 0 0Button-down Blouse 0 0 0 0Total Material Used 25097.5 27999 6000 18000

Wool Acetate Cashmere SilkQuantity Available 19902.5 1 3000 0

Tailored Wool Slacks 0 0 0 0

CONSIDERING PRODUCTION FOR FALL PERIODPR

OFE

SSIO

NAL

FA

SHIO

NCA

SUA

L FA

SHIO

NS

PRO

FESS

ION

AL

FASH

ION

CASU

AL

FASH

ION

S

CONSIDERING PRODUCTION FOR SALE PERIOD

PRO

FESS

ION

AL

FASH

ION

Page 30: case 4.1 - QT

Cashmere Sweater 0 0 3000 0Silk Blouse 0 0 0 0Silk Camesole 0 0 0 0Tailored Skirt 0 0 0 0Wool Blazer 0 0 0 0Velvet Pants 0 0 0 0Cotton Sweater 0 0 0 0Cotton Miniskirt 0 0 0 0Velvet Shirt 0 0 0 0Button-down Blouse 0 0 0 0Total Material Used 0 0 3000 0

Product Total ProducedTailored Wool Slacks 4200Cashmere Sweater 6000Silk Blouse 7000Silk Camesole 15000Tailored Skirt 8067Wool Blazer 4999Velvet Pants 0Cotton Sweater 0Cotton Miniskirt 60000Velvet Shirt 6000Button-down Blouse 9243

PRO

FESS

ION

AL

FASH

ION

CASU

AL

FASH

ION

S

Page 31: case 4.1 - QT

Rayon Velvet Cotton2.25 12 2.5

Rayon Velvet Cotton30000 20000 30000 T Mat. Cost

0 0 0 300 0 0 900 0 0 19.50 0 0 6.52 0 0 6.750 0 0 24.750 3 0 390 0 1.5 3.750 0 0.5 1.250 1.5 0 18

1.5 0 0 3.375

Total Produced Selling Price L&M Cost0 0 0 4200 300 1600 0 0 4000 450 1500 0 0 7000 180 1000 0 0 15000 120 60

16134 0 0 8067 270 1200 0 0 4999 320 1400 0 0 0 350 1750 0 0 0 130 600 0 30000 60000 75 400 9000 0 6000 200 160

13864.5 0 0 9243 120 9029998.5 9000 30000

Designer Fee = $860,000.00Fashion Show Costs = $2,700,000.00

Total Fixed Costs = $3,560,000.00

Rayon Velvet Cotton1.5 11000 0 Total Produced Selling Price L&M Cost0 0 0 0 300 160

CONSIDERING PRODUCTION FOR FALL PERIOD

CONSIDERING PRODUCTION FOR SALE PERIOD

Page 32: case 4.1 - QT

0 0 0 2000 450 1500 0 0 0 180 1000 0 0 0 120 600 0 0 0 270 1200 0 0 0 320 1400 0 0 0 350 1750 0 0 0 130 600 0 0 0 75 400 0 0 0 200 1600 0 0 0 120 90

0 0 0Revenue from Sale=

Returns Cost=Profit from Sale =

Profit from Fall = $3,793,914.75Profit from Sale = $60,000.00

Gross Profit = $3,853,914.75 (Optimized)

Page 33: case 4.1 - QT

Manufacturing LimitsProfit on Product Total Profit Upper limit Lower Limit

110 462000 7000 4200210 840000 4000

60.5 423500 1200053.5 802500 15000

143.25 1155597.75 2800155.25 776094.75 5000 3000

136 0 550066.25 033.75 2025000

22 132000 600026.625 246094.875

Total Revenue = $16,706,930.00Fixed Cost = $3,560,000.00L&M Cost = $9,844,142.63Returns Cost= $491,127.38Profit from Fall= $3,793,914.75 (Maximize)

Profit on Product Total Profit-10 0

Page 34: case 4.1 - QT

30 60000-11.5 0

5.5 035.25 027.25 0

-4 014.25 0

3.75 0-58 0

-21.375 0

Revenue from Sale= $60,000.00Returns Cost= $0.00

Profit from Sale = $60,000.00 (Maximize)

Page 35: case 4.1 - QT

Clothing Item Materials Requirements Price Machine CostTailored wool slacks 3 yards of wool 300 160

2 yards of acetate for liningCashmere sweater 1.5 yards of cashmere 450 150Silk blouse 1.5 yards of silk 180 100Silk camisole 0.5 yard of silk 120 60Tailored skirt 2 yards of rayon 270 120

1.5 yards of acetate for liningWool blazer 2.5 yards of wool 320 140

1.5 yards of acetate for lining

Clothing Item Materials Requirements Price Machine CostVelvet pants 3 yards of velvet 350 175

2 yards of acetate for liningCotton sweater 1.5 yards of cotton 130 60Cotton miniskirt 0.5 yard of cotton 75 40

Velvet shirt 1.5 yards of velvet 200 160Button-down blouse 1.5 yards of rayon 120 90

Material Price per yardWool 9

Acetate 1.5Cashmere 60

Silk 13Rayon 2.25Velvet 12Cotton 2.5