ITM309-Assignment3 - Fairways Woods Company Shipping...

Info iconThis preview shows pages 1–4. Sign up to view the full content.

View Full Document Right Arrow Icon

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
This is the end of the preview. Sign up to access the rest of the document.

Unformatted text preview: Fairways Woods Company Shipping Analysis Spring2011 Number to ship from plant to warehouse: Plants Total Sacramento Salt Lake Chicago Albeq New York Denver 300 80 100 120 Phoenix 260 40 220 Dallas 280 180 100 Totals: 180 80 200 160 220 Demands by Whse --> 180 80 200 160 220 Plants Supply Shipping costs from plant to warehouse: Denver 310 $7 $3 $6 $6 $11 Phoenix 260 $6 $4 $7 $3 $6 Dallas 280 $5 $7 $5 $9 $10 Shipping: $4,400 $900 $240 $1,100 $840 $1,320 THESE (in yellow) are the fields that that you want to change THIS is the field you want to minimize using Solver. Sum - Profit SalesRep Customer (empty) PJ Helgoth Frank White Roberta Cross Loraine Schultz Total Result (empty) Bert's Bistro $996.00 $11,075.00 $6,846.00 $18,917.00 Carmens $1,063.00 $346.00 $1,188.00 $5,151.00 $7,748.00 Flagstaff House $279.00 $6,524.00 $7,677.00 $14,480.00 Laudisio $2,265.00 $3,704.00 $3,962.00 $9,931.00 Mamm'a Pasta Palace $1,960.00 $252.00 $1,364.00 $8,721.00 $12,297.00 Pierce Arrow $108.00 $2,624.00 $650.00 $3,382.00 Smoke House $2,544.00 $8,844.00 $6,957.00 $18,345.00 The Dandelion $1,126.00 $839.00 $644.00 $6,406.00 $9,015.00 The Station $506.00 $200.00 $98.00 $1,836.00 $2,640.00 Two Bitts $2,550.00 $1,127.00 $1,397.00 $10,704.00 $15,778.00 Total Result $7,205.00 $8,956.00 $37,462.00 $58,910.00 $112,533.00 O r d e r D a t e P r o d u c t ID P r o d u c t N a m e Q u a n t it y U n it P r ic e T o t a l Sa le s U n it C o s t T o t a l C o s t P r o fit C u s t o m e r ID C u s t o m e r Sa le s R e p 0 4 - J a n- 0 9 2 M o z a re l a c he s e 4 1 $ 24 .0 $ 9 8 4 .0 $ 18 .0 $ 738 .0 $ 24 6 .0 315 T he S ta tio n P J H e lg o th 0 4 - J a n- 0 9 16 R o m a ine le t uc e 9 0 $ 15 .0 $ 1,35 0 .0 $ 14 .0 $ 1,26 0 .0 $ 9 0 .0 315 T he S ta tio n R o b e rta C ro s 0 5 - J a n- 0 9 30 R e d o nio ns 27 $ 12.0 $ 324 .0 $ 8 .0 $ 216 .0 $ 10 8 .0 23 P ie rc e A r o w F ra nk W hite 0 6 - J a n- 0 9 16 R o m a ine le t uc e 6 7 $ 15 .0 $ 1,0 5 .0 $ 14 .0 $ 9 38 .0 $ 6 7.0 14 S m o k e H o us e R o b e rta C ro s 0 7- J a n- 0 9 2 B la c k o liv e s 79 $ 12.0 $ 9 4 8 .0 $ 6 .0 $ 4 74 .0 $ 4 74 .0 5 72 T w o B it s F ra nk W hite 0 7- J a n- 0 9 16 R o m a ine le t uc e 4 6 $ 15 .0 $ 6 9 0 .0 $ 14 .0 $ 6 4 .0 $ 4 6 .0 23 F la g s ta f H o us e F ra nk W hite 0 7- J a n- 0 9 16 R o m a ine le t uc e 5 2 $ 15 .0 $ 78 0 .0 $ 14 .0 $ 728 .0 $ 5 2.0 6 B e rt's B is tro R o b e rta C ro s 0 8 - J a n- 0 9 30 R e d o nio ns 39 $ 12.0 $ 4 6 8 .0 $ 8 .0 $ 312.0 $ 15 6 .0 9 5 M a m m 'a P a s ta P a la c e F ra nk W hite 0 9 - J a n- 0 9 16 R o m a ine le t uc e 6 $ 15 .0 $ 9 0 .0 $ 14 .0 $ 9 24 .0 $ 6 .0 8 4 6 T he D a nd e lio n F ra nk W hite 10 - J a n- 0 9 16 R o m a ine le t uc e 5 8 $ 15 .0 $ 8 70 .0 $ 14 .0 $ 8 12.0 $ 5 8 .0 5 7 C a rm e ns F ra nk W hite 10 - J a n- 0 9 39 P ine a p le 4 0 $ 3 .0 $ 1,320 .0 $ 28 .0 $ 1,120 .0 $ 20 .0 315 T he S ta tio n F ra nk W hite 1 - J a n- 0 9 39 P ine a p le 71 $ 3 .0 $ 2,34 3.0 $ 28 .0 $ 1,9 8 .0 $ 35 .0 8 4 6 T he D a nd e lio n F ra nk W hite...
View Full Document

Page1 / 6

ITM309-Assignment3 - Fairways Woods Company Shipping...

This preview shows document pages 1 - 4. Sign up to view the full document.

View Full Document Right Arrow Icon
Ask a homework question - tutors are online