Docstoc

Shop Spreadsheet

Document Sample
Shop Spreadsheet Powered By Docstoc
					Ch 12 No 10
                                                     Golf Shop
                                                  -0.57154
   Salvage Value             $45

                          May          June        July       August   September    October
   Mean                       60           90          70           50         30          40
   Selling Price            $145         $140        $130         $110        $80         $60
   Purchase Cost             $75       $71.25      $67.69       $64.30     $61.09      $58.03

   Beginning Inventory             0          0           0          0          0          0
   Order
   Free
   Demand
   Sold
   Ending Inventory                0          0           0          0          0          0

   Sales Revenue                $0
   Surplus Revenue              $0 = October Inventory @ Salvage Value
   Purchase Cost                $0
   Profit                       $0

   Service Level         #DIV/0!
10   See file: Prb12_10.xls
     a.
     b.
     c.
     d.
     e.
See file: Prb12_10.xls
             May=70, June=100, July=80, August=46, September=33, October=32, Expected Profit = $15,916.5
             Min = 11,027 , Max = 18,648
             About 18.8%
             About 6.5%
             About 99.5% to 100%
< Should be somewhat close to this max profit
< approximate
< very approximate

< very approximate

				
DOCUMENT INFO
Shared By:
Categories:
Tags:
Stats:
views:10
posted:8/23/2011
language:English
pages:4
Description: Shop Spreadsheet document sample