Red brand

Páginas: 3 (537 palabras) Publicado: 1 de diciembre de 2011
Red branAnswers to Red Brand Canners Part II

1. Alternative Formulation:
First define the following additional variables:
wC= weigh of tomato grade C allocated to produce whole tomatoes (lbs),jC=weight of tomato grade C allocated to produce tomato juice (lbs),
pC=weight of tomato grade C allocated to produce tomato paste (lbs).
The update formulation is then:
Maximize((1.20+3.24)*100)/18)*(wA+ wB + wC) + ((0.36+3.60)*100)/20)*( jA+ jB+ jC) + ((1.05+4.50)*100)/25)*( pA+ pB+ pC)
9wA+ 6wB +3wC ≥ 8(wA+ wB +wC) wA - 2wB - 5wC ≥ 0 (whole tomatoes quality constraint)
9jA+ 6jB +3jC ≥6(jA+ jB +jC) jA - jC ≥ 0 (tomato juice quality constraint)
wA+ wB + wC ≤ 800,000*18 (whole tomatoes production less than demand)
jA+ jB + jC ≤ 50,000*20 (tomato juice production less than demand)pA+ pB + pC ≤ 80,000*25 (tomato paste production less than demand)
wA+ jA+ pA ≤ 600,000 (grade A tomatoes usage less than available amount)
wB+ jB+ pB ≤ 1,600,000 (grade B tomatoes usage less thanavailable amount)
wC+ jC+ pC ≤ 800,000 (grade B tomatoes usage less than available amount)
wA, wB, wC, jA, jB, jC, pA, pB , pC ≥ 0

The new model solution puts all 800 thousand lbs. of Grade Ctomatoes into Paste (see spreadsheet)

2. The income from selling the tomatoes is $685,000 (from the Excel spreadsheet solution). The cost of the tomatoes used is $0.18*3,000,000 = $540,000. The netincome is $145,000.

3. First make sure to change the formatting of the Shadow price column to allow for 3 decimal places. The shadow price for Grade A tomato supply is 27.1 cents/lb. and theallowable increase is 200 thousand lbs. This means a purchase of 80,000 lbs. at 25.5 cents/lb. should be undertaken

4 From the Sensitivity Report below, the shadow price on the Paste demand constraintis $0.024/lb and the allowable increase is 100 thousand lbs. The proposed increase is 3 thousand cases @25 lbs per case or 75 thousand lbs. which is within the allowable increase. Red Brand would...
Leer documento completo

Regístrate para leer el documento completo.

Estos documentos también te pueden resultar útiles

  • Red brand
  • Caso red brand canners
  • Caso Red Bull Branded Content
  • brando
  • Brand
  • Brando
  • Brando
  • Brand

Conviértase en miembro formal de Buenas Tareas