- PREPARE Annual Income Statements, Cash Flow Statements, and Year End Balance Sheet for Years 3-6 (use BPG Reports file)- **YEAR 6 ONLY!!** Create Variance Analysis for actual vs formatted numbers...

Yea
     Please read the Instructions work sheet first.
             THE BUSINESS POLICY GAME
         CONSOLIDATED INCOME STATEMENT (000s)
    World:    28    Year:    3    4    5    6    7
    Company:    2                                                Assumptions
    =    =    =                =    =                        Average
    Net Sales: to Customers            15358    20225    22201    19307    21238            32%    10%    -13%    9%        0%
     to Affiliates (cost + 20%)            0    0    0    0    0
     to Liquidators (at cost)            0    0    0    662    0
     Total Sales            15358    20225    22201    19969    21238
    =    =    =                =    =
     Beginning Inventory                        0    0
     Goods Manufactured                        0    0
     Purchases from Affiliates                        0    0
    -    -    -                -    -
     Goods Available                        0    0
    -    -    -                -    -
     Ending Inventory                        0    0
    -    -    -                -    -
     Cost of Goods Sold            7405    9378    9362    8722    9770            48%    46%    42%    46%
     Less Value Added Tax            329    398    472    499    129
    =    =    =                =    =
     Gross Profit            7624    10449    12367    10748    11340
    =    =    =                =    =
    Advertising Expense            641    819    1109    1019    1070            28%    35%    -8%    5%
    Sales Salaries            508    599    608    633    665                        5%
    Sales Commissions            425    654    740    671    704                        5%
    General Selling Expense            1690    1932    2056    2137    2244                        5%
    Transportation Expense            857    1147    878    903    948                        5%
    Sales Office Depreciation            47    45    45    45    45                        5%
    -    -    -                -    -
     Total Selling Expense            4168    5195    5436    5408    5676
    =    =    =                =    =
    Research & Development            245    270    230    280    288                        3%
    Total Training Expense            448    408    529    872    898                        3%
    Storage Expense            57    93    296    270    283                        5%
    Executive Compensation            604    803    839    883    909                        3%
    Other Expense            633    77    262    425    446                        5%
    -    -    -                -    -
     Total Admin. and Gen. Exp.            1986    1651    2156    2730    2826
    =    =    =                =    =
     Total Operating Expense            6155    6847    7592    8138    8502
     Operating Profit (Loss)            1469    3602    4775    2610    2838
    -    -    -                -    -
    CD...