Crackers

Document Sample
Crackers Powered By Docstoc
					                                             Mileage Between Cities in Georgia
            Albany       Atlanta   Augusta     Cass    Columbus    Dalton   Harlem   Lexington   Macon
Albany            0
Atlanta         165            0
Augusta         207          148          0
Cass            212           43        193        0
Columbus         89          102        214      137           0
Dalton          254           85        225       42         179        0
Harlem          192          128         21      174         193      206        0
Lexington       195           83         79      114         179      146       60           0
Macon           102           77        121      128          95      170      100          93        0
McIntyre        124          104        101      153         127      195       86          88       32
Savannah        210          243        123      292         247      332      138         186      170
Senoia          142           33        169       76          71      118      148         115       70

            Albany       Atlanta   Augusta   Cass   Columbus   Dalton   Harlem   Lexington   Macon
Albany               0        165       207    212         89      254       192        195     102
Atlanta                          0      148     43        102       85       128         83      77
Augusta                                    0   193        214      225        21         79     121
Cass                                              0       137       42       174        114     128
Columbus                                                     0     179       193        179      95
Dalton                                                                0      206        146     170
Harlem                                                                         0         60     100
Lexington                                                                                  0     93
Macon                                                                                              0
McIntyre
Savannah
Senoia


            Albany       Atlanta   Augusta   Cass   Columbus   Dalton   Harlem   Lexington   Macon
Albany           0            165       207    212         89      254       192        195     102
Atlanta        165               0      148     43        102       85       128         83      77
Augusta        207            148          0   193        214      225        21         79     121
Cass           212             43       193       0       137       42       174        114     128
Columbus        89            102       214    137           0     179       193        179      95
Dalton         254             85       225     42        179         0      206        146     170
Harlem         192            128        21    174        193      206         0         60     100
Lexington      195             83        79    114        179      146        60           0     93
Macon          102             77       121    128         95      170       100         93        0
McIntyre       124            104       101    153        127      195        86         88      32
Savannah       210            243       123    292        247      332       138        186     170
Senoia         142             33       169     76         71      118       148        115      70
              1892           1211      1601   1564       1633    1952      1446        1338    1158
McIntyre    Savannah Senoia




        0
      145         0
      101       240       0

McIntyre   Savannah Senoia
      124      210     142
      104      243      33
      101      123     169
      153      292      76
      127      247      71
      195      332     118
       86      138     148
       88      186     115
       32      170      70
         0     145     101
                 0     240
                         0


McIntyre   Savannah Senoia
      124      210     142
      104      243      33
      101      123     169
      153      292      76
      127      247      71
      195      332     118
       86      138     148
       88      186     115
       32      170      70
         0     145     101
      145        0     240
      101      240       0
    1256      2326    1283
          A                 B           C            D               E                  F          G                H                        I               J             K                  L          M        N      O
1         Georgia Cracker Company: Minimize Transportation Cost




                                                                              Columbus




                                                                                                                                                                                    Savannah
                                                                                                                              Lexington




                                                                                                                                                                 McIntyre
                                             Augusta




                                                                                                             Harlem
                                Atlanta




                                                                                                                                                                                                  Senoia
                    Albany




                                                                                                                                                  Macon
                                                                                            Dalton
                                                               Cass
2 Miles
3 Albany                    0         165          207             212                89          254              192                195              102              124                210          142
4 Atlanta                 165           0          148              43               102           85              128                 83               77              104                243           33
5




                                                                              Columbus




                                                                                                                                                                                    Savannah
                                                                                                                              Lexington




                                                                                                                                                                 McIntyre
                                             Augusta

   Cost




                                                                                                             Harlem
                                Atlanta




                                                                                                                                                                                                  Senoia
                    Albany




                                                                                                                                                  Macon
                                                                                            Dalton
                                                               Cass
   per Case
 6 per Mile
 7 Albany                $.05        $.05         $.05             $.05             $.05         $.05             $.05              $.05              $.05             $.05               $.05         $.05
 8 Atlanta               $.05        $.05         $.05             $.05             $.05         $.05             $.05              $.05              $.05             $.05               $.05         $.05
 9
10
                                                                              to Columbus




                                                                                                                                                                                    to Savannah
                                                                                                                              to Lexington




                                                                                                                                                                 to McIntyre
                                             to Augusta




                                                                                                             to Harlem
                                to Atlanta




                                                                                                                                                                                                  to Senoia
                    to Albany




                                                                                                                                                  to Macon
                                                                                            to Dalton
                                                               to Cass




                                                                                                                                                                                                                 Total
11   Cases                                                                                                                                                                                                       From Capacity
12   From Albany          100           0                  0              0          100                 0                0                   0          0                      0          180                 0 380      500
13   From Atlanta           0         200                 75             50            0                90               50                  60        200                     40            0                75 840     1000
14   Total to             100         200                 75             50          100                90               50                  60        200                     40          180                75
15   Demand               100         200                 75             50          100                90               50                  60        200                     40          180                75
16
17        101,015 Total miles
18   $   5,050.75 Transportation cost
     A         B                 C            D           E               F                 G            H                    I                   J           K                  L             M            N       O
1              Georgia Cracker Company: Minimize Total Cost




                                                                                   Columbus




                                                                                                                                                                                      Savannah
                                                                                                                                   Lexington




                                                                                                                                                                   McIntyre
                                                  Augusta




                                                                                                                  Harlem
                                     Atlanta




                                                                                                                                                                                                    Senoia
                         Albany




                                                                                                                                                       Macon
                                                                                                 Dalton
                                                                    Cass
2        Miles
3         Albany                 0          165 207                      212                89         254              192                 195              102           124                210         142
4         Atlanta              165            0 148                       43               102          85              128                  83               77           104                243          33
5




                                                                                   Columbus




                                                                                                                                                                                      Savannah
                                                                                                                                   Lexington




                                                                                                                                                                   McIntyre
                                                  Augusta




                                                                                                                  Harlem
                                     Atlanta




                                                                                                                                                                                                    Senoia
                         Albany




                                                                                                                                                       Macon
                                                                                                 Dalton
                                                                    Cass
 6       Cost Per Mile
 7        Albany              $.05         $.05 $.05                    $.05              $.05        $.05             $.05               $.05              $.05          $.05               $.05        $.05
 8        Atlanta             $.05         $.05 $.05                    $.05              $.05        $.05             $.05               $.05              $.05          $.05               $.05        $.05
 9
10
                                                                                   to Columbus




                                                                                                                                                                                      to Savannah
                                                                                                                                   to Lexington




                                                                                                                                                                   to McIntyre
                                                  to Augusta




                                                                                                                  to Harlem
                                     to Atlanta




                                                                                                                                                                                                    to Senoia
                         to Albany




                                                                                                                                                       to Macon
   Var.
                                                                                                 to Dalton
                                                                    to Cass




   Cost
   per                                                                                                                                                                                                             Total
11 Case                                                                                                                                                                                                            From
12 $ 22 From Albany            100            0                 0              0           100                0                0                   0          80                 40           180                0 500
13 $ 24 From Atlanta             0          200                75             50             0               90               50                  60         120                  0             0               75 720
14      Total to               100          200                75             50           100               90               50                  60         200                 40           180               75
15      Demand                 100          200                75             50           100               90               50                  60         200                 40           180               75
16
17           103,815     Total miles
18       $ 5,190.75      Tramsportation Cost
19       $ 28,280.00     Manufacturing Variable Cost
20       $ 33,470.75     Total VariableCost
       P
1




2
3
4
5




 6
 7
 8
 9
10




11 Capacity
12       500
13     1000
14
15
16
17
18
19
20
     A         B                 C            D                E         F             G            H               I                  J          K                  L            M            N   O
1             Georgia Cracker Company: Maximize Contribution




                                                                              Columbus




                                                                                                                                                                         Savannah
                                                                                                                        Lexington




                                                                                                                                                       McIntyre
                                                  Augusta




                                                                                                        Harlem
                                     Atlanta




                                                                                                                                                                                       Senoia
                         Albany




                                                                                                                                           Macon
                                                                                            Dalton
                                                                   Cass
2        Miles
3         Albany                 0          165            207          212            89         254         192                195             102           124               210         142
4         Atlanta              165            0            148           43           102          85         128                 83              77           104               243          33
5




                                                                              Columbus




                                                                                                                                                                         Savannah
                                                                                                                        Lexington




                                                                                                                                                       McIntyre
                                                  Augusta




                                                                                                        Harlem
                                     Atlanta




                                                                                                                                                                                       Senoia
                         Albany




                                                                                                                                           Macon
                                                                                            Dalton
                                                                   Cass
 6       Cost Per Mile
 7        Albany              $.05         $.05           $.05         $.05          $.05        $.05        $.05              $.05             $.05          $.05              $.05        $.05
 8        Atlanta             $.05         $.05           $.05         $.05          $.05        $.05        $.05              $.05             $.05          $.05              $.05        $.05
 9
10
                                                                              to Columbus




                                                                                                                                                                         to Savannah
                                                                                                                        to Lexington




                                                                                                                                                       to McIntyre
                                                  to Augusta




                                                                                                        to Harlem
                                     to Atlanta




                                                                                                                                                                                       to Senoia
                         to Albany




                                                                                                                                           to Macon
   Var.
                                                                                            to Dalton
                                                                   to Cass




   Cost
   per                                                                                                                                                                                          Total
11 Case                                                                                                                                                                                         From
12 $ 22 From Albany          100     0    0    0 100     0    0    0 200    40    0                                                                                                           0 440
13 $ 24 From Atlanta            0 200     0   50    0   90   50   60    0    0    0                                                                                                          75 525
14       Total to            100 200      0   50 100    90   50   60 200    40    0                                                                                                          75
15       Demand              100 200     75   50 100    90   50   60 200    40 180                                                                                                           75
16       Price              $ 31 $ 31 $ 31 $ 31 $ 31 $ 31 $ 31 $ 31 $ 31 $ 31 $ 31                                                                                                        $ 31
17      Unmet Demand                     75                                    180
18
19              57,915   Total miles                                                                                    It turns out not to be profitable
20        $ 2,895.75     Tramsportation Cost                                                                            to serve Augusta or
21        $ 22,280.00    Manufacturing Variable Cost                                                                    Savannah.
22        $ 25,175.75    Total Variable Cost
23        $ 29,915.00    Total Revenue
24        $ 4,739.25     Contribution to Profit and Overhead
      P
1




2
3
4
5




 6
 7
 8
 9
10




11 Capacity
12     500
13    1000
14
15
16
17
18
19
20
21
22
23
24
     A         B                 C            D                E          F                 G            H                    I                   J           K                  L            M            N       O      P
1




                                                                                                                                                                                     Savannah
                                                                                   Columbus




                                                                                                                                   Lexington




                                                                                                                                                                   McIntyre
                                                  Augusta




                                                                                                                  Harlem
                                     Atlanta




                                                                                                                                                                                                   Senoia
                         Albany




                                                                                                                                                       Macon
                                                                                                 Dalton
                                                                    Cass
2        Miles
3         Albany                 0          165            207           212                89         254              192                 195              102           124               210         142
4         Atlanta              165            0            148            43               102          85              128                  83               77           104               243          33
5         Macon                102           77            121           128                95         170              100                  93                0            32               170          70
6




                                                                                                                                                                                     to Savannah
                                                                                   to Columbus




                                                                                                                                   to Lexington




                                                                                                                                                                   to McIntyre
                                                  to Augusta




                                                                                                                  to Harlem
                                     to Atlanta




                                                                                                                                                                                                   to Senoia
                         to Albany




                                                                                                                                                       to Macon
                                                                                                 to Dalton
                                                                    to Cass
7        Cost Per Mile
8        From Albany         0.05 0.05 0.05 0.05 0.05 0.05 0.05 0.05 0.01 0.05 0.05 0.05
9        From Atlanta        0.05 0.05 0.05 0.05 0.05 0.05 0.05 0.05 0.01 0.05 0.05 0.05
10       From Macon          0.05 0.05 0.05 0.05 0.05 0.05 0.05 0.05 0.05 0.05 0.05 0.05
11




                                                                                                                                                                                     to Savannah
                                                                                   to Columbus




                                                                                                                                   to Lexington




                                                                                                                                                                   to McIntyre
                                                  to Augusta




                                                                                                                  to Harlem
                                     to Atlanta




                                                                                                                                                                                                   to Senoia
                         to Albany




                                                                                                                                                       to Macon
   Var.
                                                                                                 to Dalton
                                                                    to Cass




   Cost
   per                                                                                                                                                                                                            Total
12 Case                                                                                                                                                                                                           From Capacity
13 $ 22 From Albany            100            0                 0    300     0 0  0        100                0                0                   0                                                            0 500       500
14 $ 24 From Atlanta             0          200                 0      65    050  0          0               90                0                  60                                                           75 540      1000
15       From Macon              0            0                75       0   40 0  0          0                0               50                   0                                                            0 165       400
16       Total To              100          200                75    365    4050  0        100               90               50                  60                                                           75
17       Total From                                                  165
18       Net To              100 200     75   50 100    90   50   60 200    40    0   75
19       Demand              100 200     75   50 100    90   50   60 200    40 180    75
20       Price              $ 31 $ 31 $ 31 $ 31 $ 31 $ 31 $ 31 $ 31 $ 31 $ 31 $ 31 $ 31
21      Unmet Demand                                                           180
22
23              77,115   Total miles                                                                                               Using the rail link to Macon and
24        $ 2,431.55     Tramsportation Cost                                                                                       transshipping from there to trucks makes it
25        $ 23,960.00    Manufacturing Variable Cost                                                                               profitable to serve Augusta. Savannah still
26        $ 26,391.55    Total Cost                                                                                                loses out.
27        $ 32,240.00    Total Revenue
28        $ 5,848.45     Contribution to Profit and Overhead

				
DOCUMENT INFO
Shared By:
Categories:
Tags:
Stats:
views:5
posted:12/28/2011
language:Latin
pages:8