Docstoc

Sensuous Scents Starter File

Document Sample
Sensuous Scents Starter File Powered By Docstoc
					CV Fitness, Inc. Truck Loading Management Problem

Constraints Section
                                        Volume Cu. Operating Operating Available
                                            Ft.    Cost per mi. Cost per mi- Fleet
                                                                  Cu.Ft.
Truck                                      1500      $1.00      $0.000667     12
Tractor Trailer                            2350      $1.30      $0.000553      6

Exercise Bike (EB)                          12
Ellipitcal Crosstrainer (CT)                15
Treadmill (TM)                              22



Calculations & Results Section
                Distance/Demand Table                             Store Demand             Vehicle Loading


               Distance Table                                                               Volume
           (From Memphis Plant)            Miles            EB         CT         TM       Required
Philadelphia Store                         1010             140        96          86
Atlanta Store                              380               76        81          63
Miami Store                                1000              56        64          52
Chicago Store                              540              115       130         150
Los Angeles Store                          1810             150       135         180
                                                                                 Totals:
Fill Legend:                            Changing Cells
                                        Optimization Cell
Vehicle Loading                                                               Cost
                                             Volume                  % of
                                               for       Total     Vehicle
                      Volume      Tractor    Tractor    Vehicle    Capacity    Shipping
            Trucks   for Trucks   Trailers   Trailers   Capacity   Utilized      Cost




                                                                              Total Cost
CV Fitness, Inc. Truck Loading Management Problem

Constraints Section
                                        Volume Cu. Operating Operating Available
                                            Ft.    Cost per mi. Cost per mi- Fleet
                                                                  Cu.Ft.
Truck                                      1500      $1.00      $0.000667     12
Tractor Trailer                            2350      $1.30      $0.000553      6

Exdercise Bike (EB)                         12
Ellipitcal Crosstrainer (CT)                15
Treadmill ™                                 22



Calculations & Results Section
                Distance/Demand Table                             Store Demand             Vehicle Loading


               Distance Table                                                               Volume
           (From Memphis Plant)            Miles            EB         CT         TM       Required
Philadelphia Store                         1010             140        96          86           5012
Atlanta Store                              380               76        81          63           3513
Miami Store                                1000              56        64          52           2776
Chicago Store                              540              115       130         150           6630
Los Angeles Store                          1810             150       135         180           7785
                                                                                 Totals:      25716
Fill Legend:                            Changing Cells
                                        Optimization Cell
Vehicle Loading                                                                  Cost
                                                     Volume              % of
                                                       for      Total  Vehicle
                          Volume      Tractor        Tractor   Vehicle Capacity
            Trucks       for Trucks   Trailers       Trailers Capacity Utilized Shipping Cost
                     2         3000              1       2350     5350       94%   $3,333.00
                     1         1500              1       2350     3850       91%      $874.00
                     2         3000              0           0    3000       93%   $2,000.00
                     3         4500              1       2350     6850       97%   $2,322.00
                     1         1500              3       7050     8550       91%   $8,869.00
                     9       13500               6      14100    27600       93% $ 17,398.00
                                                                                 Total Cost
                                                Sensuous Scents Inc., Product Mix
Constants:
Sales Price per bttle
Conversion Cost per Unit (Direct Labor plus Manufacturing Overhead)
Minimum Sales Demand
Income Tax Rate                                                                 0.32
Sales, General and Administrative (SG&A) Expenses per Dollar Revenue             0.3
Available Ambergris (lbs)                                              $      20.00
Cost per lb, Deionized Water                                           $       0.50
Cost per lb, Ethanol                                                   $       1.00
Cost per lb, other Additives                                           $     182.00
Cost per lb, Ambergrs                                                  $   9,072.00
Bill of Materials:
Deionized Water (lb)
Ethanol (ib)
Other Additives (lb)
Ambergris (lb)
Quantity Manufactured (Changing Cells)
Units Produced
Calculations:
Lbs of Ambergris used
Manufacturing Cost per Unit (MATERIALS Cost Plus Conversion Cost)
Total Manufacturing Costs per Product Line
Sales Revenues per Product Line
Income Statement
Sales Revenues:
Sales Revenues Less Manufacturing Cost:
Gross Profit
Gross Profit Less SG&A
Net Income Before Taxes
Net Income Before Taxes Less Income Tax Expense
Net Income After Taxes
roduct Mix
       Body Spray   Cologne     Perfume
       $    11.95 $     21.00 $     53.00
       $     2.60 $      6.50 $     13.00
           60,000      25,000      12,000




                 0.4             0.1       0.05
                 0.1           0.02        0.01
                0.01          0.001     0.0001
             0.0001        0.00018     0.00055

             60,000        25,000      12,000
                                                  Totals




       Fill Legend:
       Changing Cells
       Optimization Cell
       No Entry

				
DOCUMENT INFO
Shared By:
Categories:
Tags:
Stats:
views:27
posted:11/11/2011
language:English
pages:6