Docstoc

excel

Document Sample
excel Powered By Docstoc
					                  A                       B                   C                     D                        E                                    F                             G              H
 1                                                                                 Smoothie Palace
 2
 3                                                       Smoothie Types Supplemental Costs                                    Projected Decrease in Cost for 2009                             8.00%
 4                               Patrick Kulick         Sweet Strawberry      $1.00                                           Projected Increase in Price for 2009                           10.50%
 5                               CIS1055 Section 10        Mango Tango        $1.50                                           Projected Increase in Sales for 2009                            6.50%
 6                               16-Apr-09                Banana Colada       $1.75
 7                                                          Protein Blast     $3.00
 8                                                            Five Berry      $2.00
 9                                                        Orange Cream        $1.25
10                                                              Red Bull      $4.75
11
12                                                                              Summer 2008 Numbers
13
14   Sales Item                         Cost                 Price                Profit              Smoothies Sold                    Total Profit for 2008            % of Total Sales
15
16   Sweet Strawberry Smoothie                  $2.50                $3.50                  $1.00       210,000.00                                         $210,000.00              18.65%
17   Mango Tango Smoothie                       $3.00                $4.20                  $1.20       95,000.00                                          $114,000.00              10.12%
18   Banana Colada Smoothie                     $3.25                $4.55                  $1.30       65,000.00                                           $84,500.00               7.50%
19   Protein Blast Smoothie                     $4.50                $6.30                  $1.80       120,000.00                                         $216,000.00              19.18%
20   Five Berry Smoothie                        $3.50                $4.90                  $1.40       150,000.00                                         $210,000.00              18.65%
21   Orange Cream Smoothie                      $2.75                $3.85                  $1.10       38,000.00                                           $41,800.00               3.71%
22   Red Bull Smoothie                          $6.25                $8.75                  $2.50       100,000.00                                         $250,000.00              22.20%
23
24   Total                                     $25.75             $36.05                   $10.30            $778,000.00                                 $1,126,300.00
25   Average                                    $3.68              $5.15                    $1.47            $111,142.86                                   $160,900.00
26   Median                                     $3.25                $4.55                  $1.30            $100,000.00                                   $210,000.00
27
28                                                                              Summer 2009 Numbers
29
                                                                                                    Projected Smoothies                                                  Projected % of
30   Sales Item                    Projected Cost       Projected Price      Projected Profit          Sold For 2009               Total Projected Profit for 2009        Total Sales
31
32   Sweet Strawberry Smoothie                  $2.30                $3.87                  $1.57                223,650.00                                $350,571.38              18.65%
33   Mango Tango Smoothie                       $2.76                $4.64                  $1.88                101,175.00                                $190,310.18              10.12%
34   Banana Colada Smoothie                     $2.99                $5.03                  $2.04                 69,225.00                                $141,063.24               7.50%
35   Protein Blast Smoothie                     $4.14                $6.96                  $2.82                127,800.00                                $360,587.70              19.18%
36   Five Berry Smoothie                        $3.22                $5.41                  $2.19                159,750.00                                $350,571.38              18.65%
37   Orange Cream Smoothie                      $2.53                $4.25                  $1.72                 40,470.00                                 $69,780.40               3.71%
38   Red Bull Smoothie                          $5.75                $9.67                  $3.92                106,500.00                                $417,346.88              22.20%
39
40   Total                                     $23.69             $39.84                   $16.15            $828,570.00                                 $1,880,231.14
41   Average                                    $3.38              $5.69                    $2.31            $118,367.14                                   $268,604.45
42   Median                                     $2.99                $5.03                  $2.04            $106,500.00                                   $350,571.38

				
DOCUMENT INFO
Shared By:
Categories:
Tags:
Stats:
views:9
posted:10/2/2012
language:Unknown
pages:1