Docstoc

Business Operations, Finance, and Demand Management Schedule

Document Sample
Business Operations, Finance, and Demand Management Schedule Powered By Docstoc
					                                                                                                              PL Sum




SUMMARY
                                                                         5-YEAR PROJECTION ($)                                                                        5-YR PROJECTION (%)
Annual Summary                     CY               CY +1               CY +2            CY +3                   CY +4              CY +5            CY       CY +1      CY +2     CY +3    CY +4    CY +5
Revenue
  Customer Category 1          $        1,936   $           1,975   $      43,538     $      656,438      $         854,470     $      925,390        44.4%     44.4%     44.4%     44.4%    44.4%    44.4%
  Customer Category 2          $          484   $             494   $      10,885     $      164,109      $         213,617     $      231,348        11.1%     11.1%     11.1%     11.1%    11.1%    11.1%
  Customer Category 3          $          726   $             741   $      16,327     $      246,164      $         320,426     $      347,021        16.7%     16.7%     16.7%     16.7%    16.7%    16.7%
  Customer Category 4          $          726   $             741   $      16,327     $      246,164      $         320,426     $      347,021        16.7%     16.7%     16.7%     16.7%    16.7%    16.7%
  Customer Category 5          $          242   $             247   $       5,442     $       82,055      $         106,809     $      115,674         5.6%      5.6%      5.6%      5.6%     5.6%     5.6%
  Customer Category 6          $          242   $             247   $       5,442     $       82,055      $         106,809     $      115,674         5.6%      5.6%      5.6%      5.6%     5.6%     5.6%
  Total Gross Revenue          $        4,355   $           4,443   $      97,962     $    1,476,985      $       1,922,556     $    2,082,128       100.0%    100.0%    100.0%    100.0%   100.0%   100.0%
  Less
  DIF and Testers              $          (44) $              (44) $         (980) $         (14,770) $             (19,226) $         (20,821)       -1.0%     -1.0%     -1.0%     -1.0%    -1.0%    -1.0%
  Net Revenue                  $        4,312 $             4,399 $        96,982 $        1,462,215 $            1,903,331 $        2,061,306        99.0%     99.0%     99.0%     99.0%    99.0%    99.0%
COGS
  Product Costs                $    210,155     $       69,500      $    1,173,773    $    17,343,267     $       21,898,057    $    23,004,117     4825.1%    1564.1% 1198.2% 1174.2% 1139.0% 1104.8%
  Freight In/Out               $     21,015     $        6,950      $      117,377    $     1,734,327     $        2,189,806    $     2,300,412      482.5%     156.4%   119.8%   117.4%   113.9%   110.5%
  Total COGS                   $    231,170     $       76,450      $    1,291,151    $    19,077,594     $       24,087,863    $    25,304,529     5307.6%    1720.5% 1318.0% 1291.7% 1252.9% 1215.3%
Gross Margin                   $   (226,858)    $      (72,051)     $   (1,194,169)   $   (17,615,378)    $      (22,184,532)   $   (23,243,223)   -5208.6%   -1621.5% -1219.0% -1192.7% -1153.9% -1116.3%
Operating Expenses
  Commissions                  $      8,892     $        9,072      $      200,005    $     3,015,512     $        3,925,219    $     4,251,011       204.2%    204.2%   204.2%   204.2%   204.2%   204.2%
  Royalties                    $      3,201     $        2,799      $       61,716    $       775,417     $          807,474    $       655,870        73.5%     63.0%    63.0%    52.5%    42.0%    31.5%
  3PL                          $        261     $          267      $        4,898    $        73,849     $           76,902    $        99,942         6.0%      6.0%     5.0%     5.0%     4.0%     4.8%
  Selling Expenses             $     51,379     $      181,839      $      236,459    $       334,873     $          400,451    $       403,643      1179.6%   4092.4%   241.4%    22.7%    20.8%    19.4%
  Marketing                    $    123,654     $      151,901      $      302,910    $       567,478     $          614,726    $       631,321      2839.0%   3418.6%   309.2%    38.4%    32.0%    30.3%
  New Product Development      $        622     $        3,022      $       10,906    $       164,885     $          216,863    $       217,661        14.3%     68.0%    11.1%    11.2%    11.3%    10.5%
  Operations                   $         33     $           33      $          735    $        55,077     $          146,419    $       147,616         0.8%      0.8%     0.8%     3.7%     7.6%     7.1%
  General and Administrative   $    110,792     $      190,644      $      556,897    $       688,920     $          701,866    $       703,461      2543.7%   4290.5%   568.5%    46.6%    36.5%    33.8%
  Total Operating Expenses     $    298,834     $      539,577      $    1,374,525    $     5,676,012     $        6,889,920    $     7,110,525      6861.1% 12143.4% 1403.1%     384.3%   358.4%   341.5%
Operating Profit / (loss)      $   (525,692)    $     (611,628)     $   (2,568,694)   $   (23,291,390)    $      (29,074,451)   $   (30,353,747)   -12069.7% -13764.9% -2622.1% -1577.0% -1512.3% -1457.8%




                                                                                                         Page 1 of 555
                                                                                                                PL mo




                                                                                                                              CURRENT YEAR
Monthly P&L Summary                          Inputs       Jan          Feb          Mar           Apr           May          Jun          Jul           Aug           Sep           Oct           Nov          Dec


Revenue
  Customer Category 1                                 $     160    $     160    $     160     $     161     $     161    $     161    $     161     $     162     $     162     $     162     $     163    $      163
  Customer Category 2                                 $      40    $      40    $      40     $      40     $      40    $      40    $      40     $      40     $      40     $      41     $      41    $       41
  Customer Category 3                                 $      60    $      60    $      60     $      60     $      60    $      60    $      61     $      61     $      61     $      61     $      61    $       61
  Customer Category 4                                 $      60    $      60    $      60     $      60     $      60    $      60    $      61     $      61     $      61     $      61     $      61    $       61
  Customer Category 5                                 $      20    $      20    $      20     $      20     $      20    $      20    $      20     $      20     $      20     $      20     $      20    $       20
  Customer Category 6                                 $      20    $      20    $      20     $      20     $      20    $      20    $      20     $      20     $      20     $      20     $      20    $       20
  Total Gross Revenue                                 $     360    $     360    $     361     $     361     $     362    $     363    $     363     $     364     $     364     $     365     $     366    $      366
  Less
    DIF and Testers                            -1.0% $       (4) $        (4) $        (4) $         (4) $         (4) $        (4) $        (4) $         (4) $         (4) $         (4) $         (4) $         (4)
  Net Revenue                                        $      356 $        357 $        357 $         358 $         358 $        359 $        360 $         360 $         361 $         361 $         362 $         363
COGS
  Product Costs                                      $ 14,385      $ 16,826     $ 21,529      $ 49,400      $ 11,819     $ 15,763     $ 15,296      $ 20,883      $    7,254    $    7,350    $ 13,289     $    16,358
  Freight Out (included above)                   10% $   1,439     $   1,683    $   2,153     $   4,940     $   1,182    $   1,576    $   1,530     $   2,088     $      725    $      735    $   1,329    $     1,636
  Total COGS                                         $ 15,824      $ 18,509     $ 23,682      $ 54,341      $ 13,001     $ 17,340     $ 16,826      $ 22,972      $    7,980    $    8,085    $ 14,618     $    17,993
Gross Margin                                         $ (15,468)    $ (18,152)   $ (23,325)    $ (53,983)    $ (12,643)   $ (16,981)   $ (16,466)    $ (22,611)    $   (7,619)   $   (7,724)   $ (14,256)   $   (17,631)
Operating Expenses
  Commissions                                         $     734    $     735    $     737     $     738     $     739    $     740    $     742     $     743     $     744     $     745     $     747    $       748
  Royalties                                           $     264    $     265    $     265     $     266     $     266    $     267    $     267     $     267     $     268     $     268     $     269    $       269
  3PL                                                 $      22    $      22    $      22     $      22     $      22    $      22    $      22     $      22     $      22     $      22     $      22    $        22
  Selling Expenses                                    $   1,591    $   1,591    $   1,591     $   1,591     $   1,591    $   4,216    $   4,216     $   3,049     $   7,341     $   6,174     $   9,216    $     9,216
  Marketing                                           $   7,159    $   7,159    $ 12,159      $   8,159     $ 10,659     $   9,159    $   7,659     $   7,659     $ 19,159      $ 13,409      $ 11,659     $     9,659
  New Product Development                             $      52    $      52    $      52     $      52     $      52    $      52    $      52     $      52     $      52     $      52     $      52    $        52
  Operations                                          $       3    $       3    $       3     $       3     $       3    $       3    $       3     $       3     $       3     $       3     $       3    $         3
  General and Administrative                          $   9,319    $   9,319    $   9,319     $   9,319    
				
DOCUMENT INFO
Shared By:
Tags:
Stats:
views:500
posted:12/14/2011
language:Latin
pages:555
Description: This Business Operations, Finance, and Demand Management Schedule provides a template spreadsheet to help a business create a preliminary profit and loss statement, balance sheet, cash flow statement, and other key planning and financial documents. Users should customize the products in the "Products" tab, customers in each "Customer" tab, and customer categories in the "Cust" tab-each in red. Within the tabs, any cell with a red value should be input by the user; all other cells will auto populate. Once the red value cells are input, key forecast projections will populate on the various tabs. This schedule is intended to provide five-year projections.