Copy of Adm 2302 Assignment 2 !!!

Microsoft Excel 14.0 Answer Report Worksheet: [adm 202 Assi!nment 2.xlsx"#heet1 Report $reated: 2%&10&2014 %:24:0' (M Res)lt: #ol*er fo)nd fo)nd a sol)tion. All $onstraints and and optimalit+ conditions conditions are sati #ol*er En!ine Engine: Simplex LP Solution Time: 0.015 Seconds. Iterations: 14 Subproblems: 0 #ol*er -ptions Max Time nlimited! Iterations nlimited! Precisio Precision n 0.000001! se "utomatic Scaling Scaling Max Subproblems nlimited! Max Integer Sols nlimited! Integer Tolerance 1#! "ssume

&b'ecti%e (ell )Max* $ell ame +M+4 ,e%enue Total ,e%enue

-ri!inal /al)e 54-5--./54

inal /al)e 1000

2ariable (ells $ell +3+/ $umber o +(+/ $umber o +7+/ $umber o +E+/ $umber o +8+/ $umber o +9+/ $umber o ++/ $umber o +I+/ $umber o +;+/ $umber o +<+/ $umber o

-ri!inal /al)e 5000 5000 4000 -65-.0/15 1000 65 666.66666666 -65.-0/15 11-5 0

inal /al)e 1 1/0.6/0 1 1/0.6/0 6000 6000 4 461.5/-46154 15 15/-.4615/-46 16000 600 0 0

bottle bottle bottle bottle bottle bottle bottle bottle bottle bottle

ame 1  / 4 "1 " "/ "4 M1 M

(onstraints $ell ame +L+1/ Production 8irst =ear LS +L+14 Production Second =ear LS +L+15 (?inon Production @rst Aear LS +L+16 (?ardonnaA P Prroduction 8i 8irst =e =ear L LS +L+1 (?inon Production Second Aear LS +L+1- (?ardonnaA Production Second =ear LS +L+6 8irst =ear Total used +L+ Second =ear Total used +L+ MarDeting (ost 1 LS +L+10 Ma MarDeting (ost  LS +L+11 MarDeting (ost / LS

$ell /al)e

orm)la 0 +L+1/>+$+1/ 0 +L+14>+$+14 1/0.6/0 +L +L+15B>+$+15 1/0.6/0 +L+16B>+$+16 6000 +L +L+1B>+$+1 6000 +L +L+1-B>+$+10000 +L+6>+$+6 C.5465-5EC011 +L+>+$+ C1.-1--EC01 +L+>+$+ 0 +L+10>+$+10 C1.4551EC011 +L+11>+$+11

+L+1 MarDeting (ost 4 LS

C.10/-/EC011 +L+1>+$+1

 

s,ed.

  on$egati%e

nte!er (ontin (ontin (ontin (ontin (ontin (ontin (ontin (ontin (ontin (ontin

#tat)s 3inding 3inding $ot 3inding $ot 3inding $ot 3inding $ot 3inding 3inding 3inding 3inding 3inding 3inding

#lack   0 0 -/0.6/0 /0.6/0 000 1000 0 0 0 0 0

3inding

0

Microsoft Excel 14.0 #ensiti*it+ Report Worksheet: [adm 202 Assi!nment 2.xlsx"#heet1 Report $reated: 2%&10&2014 %:24:0 (M

2ariable (ells

$ell +3+/ +(+/ +7+/ +E+/ +8+/ +9+/ ++/ +I+/ +;+/ +<+/

$umber o $umber o $umber o $umber o $umber o $umber o $umber o $umber o $umber o $umber o

bottle bottle bottle bottle bottle bottle bottle bottle bottle bottle

ame 1  / 4 "1 " "/ "4 M1 M

inal Red)ced /al)e $ost 1/0.6/00 1/0.6/00 6000 0 6000 0 461.5/-4615 0 15/-.4615/-5 0 16000 0 600 0 0 C55.65 0 C6.5

(onstraints

$ell +L+1/ +L+14 +L+15 +L+16 +L+1 +L+1+L+6 +L+ +L+ +L+10 +L+11 +L+1

ame Production 8irst =ear LS Production Second =ear LS (?inon Production @rst Aear LS (?ardonnaA Production 8irst =ear LS (?inon Production Second Aear LS (?ardonnaA Production Second =ear LS 8irst =ear Total used Second =ear Total used MarDeting (ost 1 LS MarDeting (ost  LS MarDeting (ost / LS MarDeting (ost 4 LS

inal /al)e 0 0 1/0.6/01/0.6/06000 6000 0000 C.5465EC011 C1.-1-EC01 0 C1.4551EC011 C.10/-EC011

#hadow (rice C1.5 0.55 0 0 0 0 6/.6 .5 1. .5 1./5 0.5

-3ecti*e Allowa3le Allowa3le $oe5cient ncrease 6ecrease 0 1.00000EF0/0 0.4/15 0 1.00000EF0/0 0.4/15 .51.00000EF0/0 11.5-/////// 6 1.00000EF0/0 11.5-/////// 0 .56/15- 45.1565 0 6-. /.45 0 -.-///////// 6.5 0 -.45446-0-5 115.-/////// 0 55.65 1.00000EF0/0 1 6.5 1.00000EF0/0

$onstraint Allowa3le Allowa3le R.7. #ide ncrease 6ecrease 0 1/14.444444 1-60.6-655 0 1-514.-51 1-0/.156-6 4000 -/0.6/0 1.00000EF0/0 5000 /0.6/0 1.00000EF0/0 4000 000 1.00000EF0/0 5000 1000 1.00000EF0/0 0000 1.00000EF0/0 11-5 0 1.00000EF0/0 151666.6666 0 140/5.0-1 5/5 0 1////.////// 5000 0 106666.6666 10000 0 101.655 1516666.666

$umber o bottle ,e%enue 8irst =ear Second =ear MarDeting (ost 1 MarDeting (ost  MarDeting (ost / MarDeting (ost 4 Production 8irst =ear Production Second =ear (?inon Production @rst Aear (?ardonnaA Production 8irst =ear (?inon Production Second Aear (?ardonnaA Production Second =ear

8irst =ear (?inon 8irst =ear (?ardonn  1  5000 5000 0 0 0. C

0.6 C6

1 0 0 0 1 0 1 0 0 0

0 1 0 0 C1 0 0 1 0 0

Second =ear Second =ear MarDeting (osMarDeting (o MarDeting ( MarDeting (ost / 4 "1 " "/ "4 /000 /000 1000 65 6500 /00 .5 6 0 0 0 0 0 0.65

0 0.5

1 0

1 0

0 1

0 1

0 0 1 0 0 1 0 0 1 0

0 0 0 1 0 C1 0 0 0 1

C5 0 0 0 0 0 0 0 0 0

0 C0 0 0 0 0 0 0 0

0 0 C6 0 0 0 0 0 0 0

0 0 0 C10 0 0 0 0 0 0

MoneA let MoneA let in Second Aea Total ,e%enue M1 M 11-5 0 0 1 51650  Total used 1 0 0000 0000 C1 1 C11-5 > 0 LS 0 0 0 > 0 0 0 0 > 0 0 0 0 > 0 0 0 0 > 0 0 0 0 > 0 0 0 0 > 0 0 0 5000 >B 4000 0 0 5000 >B 5000 0 0 /000 >B 4000 0 0 /000 >B 5000