Last Modified 03/29/06 Hits=  Hit Counter

College Level Homework Assignments CS 15 Code  CS 17 Code CS 60 Code Discussion
Inputs		 Final Schedule Email to Instructor  Student Sign-up Form
 

 

Proforma                          
Production   Price Growth Rate   Base Quantity 2000 2000.25 2000.5 2000.75 2001 2001.25 2001.5 2001.75
Singles 80 1.3   100000 130000 169000          219,700          285,610          371,293            482,681            627,485            815,731
Grosses 40 1.05   144000 151200 158760          166,698          175,033          183,785            192,974            202,622            212,754
Revenue   327760          386,398          460,643          555,078            675,655            830,108         1,028,484
Singles   10400000      13,520,000      17,576,000      22,848,800        29,703,440        38,614,472        50,198,814
Grosses   6048000        6,350,400        6,667,920        7,001,316         7,351,382         7,718,951         8,104,898
Total Revenue         16,448,000     19,870,400     24,243,920     29,850,116       37,054,822       46,333,423       58,303,712
1999.75 2000 2000.25 2000.5 2000.75 2001 2001.25 2001.5 2001.75
Cost of Goods Price  
  Shells 0.5           163,880        193,199          230,321          277,539          337,827          415,054            514,242                      -  
Electronics 6         1,966,560     2,318,388        2,763,857        3,330,465        4,053,928        4,980,646         6,170,906                      -  
Keyboards 1           327,760        386,398          460,643          555,078          675,655          830,108         1,028,484                      -  
Displays 2           655,520        772,796          921,286        1,110,155        1,351,309        1,660,215         2,056,969                      -  
Boxes 0.5           163,880        193,199          230,321          277,539          337,827          415,054            514,242                      -  
Gross Boxes 2               2,205           2,315              2,431              2,553              2,680              2,814               2,955                      -                      -
Total Cost of Goods    $   3,279,805  $ 3,866,295  $    4,608,860  $    5,553,328  $    6,759,227  $    8,303,891  $    10,287,798  $                  -  $                  -
Expenses   Factor Quantity Cost/qtr  
Rent 3 2000 6000 6000 6000 6000 6000 6000 6000 6000 6000 6000
Utilities 3 1000 3000 3000           3,000              3,000              3,000              3,000              3,000               3,000 3000 3000
Assembly labor 4671 6 28026 28026         28,026            28,026            28,026            28,026            28,026              28,026 28026 28026
Shipping UPS grosses 5 1 5 11025         11,576            12,155            12,763            13,401            14,071              14,775 0 0
Shipping Singles 1 1 1 163880        193,199          230,321          277,539          337,827          415,054            514,242 0 0
Transportation 1200 3 3600 3600           3,600              3,600              3,600              3,600              3,600               3,600 3600 3600
Overhead 0.35 34632 12121.2           75,436         85,890            99,086          115,825          137,149          164,413            199,375              14,219              14,219
Total Expenses           290,967        331,292     382,188          446,752          529,003          634,164            769,018              54,845              54,845
Net Income    $(3,570,772)  $(4,197,587)  $ 11,456,952  $ 13,870,320  $ 16,955,690  $ 20,912,062  $   25,998,006  $   46,278,578  $   58,248,867
FIT    $4,926,489.19  $5,964,237.49  $7,290,946.61  $8,992,186.61  $11,179,142.66  $19,899,788.45  $25,047,012.78
Earnings AFIT    $    6,530,462  $    7,906,082  $    9,664,743  $  11,919,875  $    14,818,864  $    26,378,789  $    33,201,854
Dividends   0.25    $    1,632,616  $    1,976,521  $    2,416,186  $    2,979,969  $      3,704,716  $      6,594,697  $      8,300,464
Retained Earnings    $    4,897,847  $    5,929,562  $    7,248,557  $    8,939,906  $    11,114,148  $    19,784,092  $    24,901,391
Bank Balance     8000000  $   4,429,228  $    231,641  $   5,129,488  $ 11,059,050  $ 18,307,607  $ 27,247,514  $   38,361,661  $   58,145,753  $   83,047,144
                           
College Level Homework Assignments CS 15 Code  CS 17 Code CS 60 Code Discussion
Inputs		 Final Schedule Email to Instructor  Student Sign-up Form