Docstoc

CapSim Trends

Document Sample
CapSim Trends Powered By Docstoc
					Round                                                    0    1   2   3
Financial Statistics
ROS                                                 4.10%
Asset Turnover                                        1.05
ROA                                                 4.40%
Leverage (Assets/Equity)                                 2
ROE                                                 8.70%
Emergency Loan                                         $0
Sales                                        $101,073,437
EBIT                                          $11,996,365
Profits                                        $4,188,507
Cumulative Profit                              $4,188,507
SG&A / Sales                                        8.90%
Contrib. Margin %                                  28.30%
Market Share                                          $17
Stocks & Bonds
Close                                        $       34.25
 Change                                      $         -
 Shares                                          2,000,000
 MarketCap ($M)                              $          69
 Book Value                                  $       23.97
 EPS                                         $        2.09
 Dividend                                    $        2.00
 Yield                                                5.8%
 P/E                                                   16.4
Bond Market Summary

Financial Summary
Cash flows from operating activities
Net Income (Loss)                                  $4,189
Adjustment for non-cash items:
  Depreciation                                     $7,587
  Extraordinary gains/losses/writeoffs                 $0
Changes in current assets and liabilities:
  Accounts payable                                  $3,583
  Inventory                                        ($8,617)
  Accounts receivable                                ($307)
Net cash from operations                            $6,434

Cash flows from investing activities
Plant improvements (net)                               $0
Cash flows from financing activities
Dividends paid                                     ($4,000)
Sales of common stock                                   $0
Purchase of common stock                                $0
Cash from long term debt issued                         $0
Early retirement of long term debt                      $0
Retirement of current debt                      $0
Cash from current debt borrowing                $0
Cash from emergency loan                        $0
Net cash from financing activities         ($4,000)

Net change in cash position                 $2,434
Balance Sheet Survey
Cash                                        $3,434
Accounts Receivable                         $8,307
Inventory                                   $8,617
Total Current Assets                       $20,358

Plant and equipment                       $113,800
Accumulated Depreciation                  ($37,933)
Total Fixed Assets                         $75,867

Total Assets                               $96,225

Accounts Payable                            $6,583
Current Debt                                    $0
Long Term Debt                             $41,700
Total Liabilities                          $48,283

Common Stock                               $18,360
Retained Earnings                          $29,582
Total Equity                               $47,942

Total Liabilities & Owners' Equity         $96,225
Income Statement Survey
Sales                                     $101,073
Variable Costs (Labor, Material, Carry)    $72,513
Depreciation                                $7,587
SGA (R&D, Promo, Sales, Admin)              $8,978
Other (Fees, Writeoffs, TQM, Bonuses)           $0
EBIT                                       $11,996
Interest (Short term, Long term)            $5,421
Taxes                                       $2,301
Profit Sharing                                 $85
Net Profit                                  $4,189

Traditional Market
Number of Products                               1
Units Sold                                     999
Inventory                                      189
Age                                             3.1
MTBF                                         17500
Performance                                     5.5
Size                              14.5
Price                    $      28.00
Material Cost            $      11.59
Labor Cost               $       7.49
Contribution Margin               29%
2nd Shift & Over Time              0%
Automation Next Round             4.0
Capacity Next Round              1800
Plant Utilization                 66%
Promo Budget             $   1,000.00
Sales Budget             $   1,000.00
Customer Awareness                55%
Customer Accessibility            54%

Low Market
Number of Products                  1
Units Sold                      1763
Inventory                          39
Age                               4.6
MTBF                           14000
Performance                       3.0
Size                             17.0
Price                    $     21.00
Material Cost            $      7.81
Labor Cost               $      7.12
Contribution Margin              27%
2nd Shift & Over Time            30%
Automation                       5.0
Capacity Next Round             1400
Plant Utilization               129%
Promo Budget             $    900.00
Sales Budget             $    900.00
Customer Awareness               52%
Customer Accessibility           40%

High Market
Number of Products                  1
Units Sold                       366
Inventory                          40
Age                               1.7
MTBF                           23000
Performance                       8.0
Size                             12.0
Price                    $     38.00
Material Cost            $     15.98
Labor Cost               $      8.57
Contribution Margin              33%
2nd Shift & Over Time            0%
Automation                       3.0
Capacity Next Round             900
Plant Utilization               45%
Promo Budget             $   800.00
Sales Budget             $   800.00
Customer Awareness              49%
Customer Accessibility          48%

Performance Market
Number of Products                 1
Units Sold                      358
Inventory                         78
Age                              2.5
MTBF                          25000
Performance                      9.4
Size                            15.5
Price                    $    33.00
Material Cost            $    15.87
Labor Cost               $     8.57
Contribution Margin             23%
2nd Shift & Over Time            0%
Automation                       3.0
Capacity Next Round             600
Plant Utilization               73%
Promo Budget             $   700.00
Sales Budget             $   700.00
Customer Awareness              46%
Customer Accessibility          37%

Size Market
Number of Products                 1
Units Sold                      314
Inventory                         62
Age                              2.6
MTBF                          19000
Performance                      4.0
Size                            11.0
Price                    $    33.00
Material Cost            $    13.62
Labor Cost               $     8.57
Contribution Margin             30%
2nd Shift & Over Time            0%
Automation                       3.0
Capacity Next Round             600
Plant Utilization               63%
Promo Budget             $   700.00
Sales Budget                    $   700.00
Customer Awareness                     46%
Customer Accessibility                 42%

Human Resources Summary
Needed Complement                       701
Complement                              700
1st Shift Complement                    640
2nd Shift Complement                     60

Overtime%                             0.20%
Turnover Rate                        10.00%
New Employees                             70
Separated Employees                        0
Recruiting Spend                         $0
Training Hours                             0
Productivity Index                  100.00%

Recruiting Cost                        $70
Separation Cost                         $0
Training Cost                           $0
Total HR Admin Cost                    $70

Labor Contract Next Year
Wages                               $21.00
Benefits                              2,500
Profit Sharing                       2.00%
Annual Raise                         5.00%

Starting Negotiation Position
Wages
Benefits
Profit Sharing
Annual Raise

Ceiling Negotiation Position
Wages
Benefits
Profit Sharing
Annual Raise

Adjusted Labor Demands
Wages
Benefits
Profit Sharing
Annual Raise
Strike Days

TQM Summary
Process Mgt Budgets Last Year
CPI Systems                              $0
Vendor/JIT                               $0
Quality Initiative Training              $0
Channel Support Systems                  $0
Concurrent Engineering                   $0
UNEP Green Programs                      $0

TQM Budgets Last Year
Benchmarking                             $0
Quality Function Deployment Effort       $0
CCE/6 Sigma Training                     $0
GEMI TQEM Sustainability Initiatives     $0
Total Expenditures                       $0

Cumulative Impacts
Material Cost Reduction                0.00%
Labor Cost Reduction                   0.00%
Reduction R&D Cycle Time               0.00%
Reduction Admin Costs                  0.00%
Demand Increase                        0.00%
4
Round                                                    0    1   2   3
Financial Statistics
ROS                                                 4.10%
Asset Turnover                                        1.05
ROA                                                 4.40%
Leverage (Assets/Equity)                                 2
ROE                                                 8.70%
Emergency Loan                                         $0
Sales                                        $101,073,437
EBIT                                          $11,996,365
Profits                                        $4,188,507
Cumulative Profit                              $4,188,507
SG&A / Sales                                        8.90%
Contrib. Margin %                                  28.30%
Market Share                                          $17
Stocks & Bonds
Close                                        $       34.25
 Change                                      $         -
 Shares                                          2,000,000
 MarketCap ($M)                              $          69
 Book Value                                  $       23.97
 EPS                                         $        2.09
 Dividend                                    $        2.00
 Yield                                                5.8%
 P/E                                                   16.4
Bond Market Summary

Financial Summary
Cash flows from operating activities
Net Income (Loss)                                  $4,189
Adjustment for non-cash items:
  Depreciation                                     $7,587
  Extraordinary gains/losses/writeoffs                 $0
Changes in current assets and liabilities:
  Accounts payable                                  $3,583
  Inventory                                        ($8,617)
  Accounts receivable                                ($307)
Net cash from operations                            $6,434

Cash flows from investing activities
Plant improvements (net)                               $0
Cash flows from financing activities
Dividends paid                                     ($4,000)
Sales of common stock                                   $0
Purchase of common stock                                $0
Cash from long term debt issued                         $0
Early retirement of long term debt                      $0
Retirement of current debt                      $0
Cash from current debt borrowing                $0
Cash from emergency loan                        $0
Net cash from financing activities         ($4,000)

Net change in cash position                 $2,434
Balance Sheet Survey
Cash                                        $3,434
Accounts Receivable                         $8,307
Inventory                                   $8,617
Total Current Assets                       $20,358

Plant and equipment                       $113,800
Accumulated Depreciation                  ($37,933)
Total Fixed Assets                         $75,867

Total Assets                               $96,225

Accounts Payable                            $6,583
Current Debt                                    $0
Long Term Debt                             $41,700
Total Liabilities                          $48,283

Common Stock                               $18,360
Retained Earnings                          $29,582
Total Equity                               $47,942

Total Liabilities & Owners' Equity         $96,225
Income Statement Survey
Sales                                     $101,073
Variable Costs (Labor, Material, Carry)    $72,513
Depreciation                                $7,587
SGA (R&D, Promo, Sales, Admin)              $8,978
Other (Fees, Writeoffs, TQM, Bonuses)           $0
EBIT                                       $11,996
Interest (Short term, Long term)            $5,421
Taxes                                       $2,301
Profit Sharing                                 $85
Net Profit                                  $4,189

Traditional Market
Number of Products                               1
Units Sold                                     999
Inventory                                      189
Age                                             3.1
MTBF                                         17500
Performance                                     5.5
Size                              14.5
Price                    $      28.00
Material Cost            $      11.59
Labor Cost               $       7.49
Contribution Margin               29%
2nd Shift & Over Time              0%
Automation                        4.0
Capacity Next Round              1800
Plant Utilization                 66%
Promo Budget             $   1,000.00
Sales Budget             $   1,000.00
Customer Awareness                55%
Customer Accessibility            54%

Low Market
Number of Products                  1
Units Sold                      1763
Inventory                          39
Age                               4.6
MTBF                           14000
Performance                       3.0
Size                             17.0
Price                    $     21.00
Material Cost            $      7.81
Labor Cost               $      7.12
Contribution Margin              27%
2nd Shift & Over Time            30%
Automation                       5.0
Capacity Next Round             1400
Plant Utilization               129%
Promo Budget             $    900.00
Sales Budget             $    900.00
Customer Awareness               52%
Customer Accessibility           40%

High Market
Number of Products                  1
Units Sold                       366
Inventory                          40
Age                               1.7
MTBF                           23000
Performance                       8.0
Size                             12.0
Price                    $     38.00
Material Cost            $     15.98
Labor Cost               $      8.57
Contribution Margin              33%
2nd Shift & Over Time            0%
Automation Next Round            3.0
Capacity Next Round             900
Plant Utilization               45%
Promo Budget             $   800.00
Sales Budget             $   800.00
Customer Awareness              49%
Customer Accessibility          48%

Performance Market
Number of Products                 1
Units Sold                      358
Inventory                         78
Age                              2.5
MTBF                          25000
Performance                      9.4
Size                            15.5
Price                    $    33.00
Material Cost            $    15.87
Labor Cost               $     8.57
Contribution Margin             23%
2nd Shift & Over Time            0%
Automation                       3.0
Capacity Next Round             600
Plant Utilization               73%
Promo Budget             $   700.00
Sales Budget             $   700.00
Customer Awareness              46%
Customer Accessibility          37%

Size Market
Number of Products                 1
Units Sold                      314
Inventory                         62
Age                              2.6
MTBF                          19000
Performance                      4.0
Size                            11.0
Price                    $    33.00
Material Cost            $    13.62
Labor Cost               $     8.57
Contribution Margin             30%
2nd Shift & Over Time            0%
Automation                       3.0
Capacity Next Round             600
Plant Utilization               63%
Promo Budget             $   700.00
Sales Budget                    $   700.00
Customer Awareness                     46%
Customer Accessibility                 42%

Human Resources Summary
Needed Complement                       701
Complement                              700
1st Shift Complement                    640
2nd Shift Complement                     60

Overtime%                             0.20%
Turnover Rate                        10.00%
New Employees                             70
Separated Employees                        0
Recruiting Spend                         $0
Training Hours                             0
Productivity Index                  100.00%

Recruiting Cost                        $70
Separation Cost                         $0
Training Cost                           $0
Total HR Admin Cost                    $70

Labor Contract Next Year
Wages                               $21.00
Benefits                              2,500
Profit Sharing                       2.00%
Annual Raise                         5.00%

Starting Negotiation Position
Wages
Benefits
Profit Sharing
Annual Raise

Ceiling Negotiation Position
Wages
Benefits
Profit Sharing
Annual Raise

Adjusted Labor Demands
Wages
Benefits
Profit Sharing
Annual Raise
Strike Days

TQM Summary
Process Mgt Budgets Last Year
CPI Systems                              $0
Vendor/JIT                               $0
Quality Initiative Training              $0
Channel Support Systems                  $0
Concurrent Engineering                   $0
UNEP Green Programs                      $0

TQM Budgets Last Year
Benchmarking                             $0
Quality Function Deployment Effort       $0
CCE/6 Sigma Training                     $0
GEMI TQEM Sustainability Initiatives     $0
Total Expenditures                       $0

Cumulative Impacts
Material Cost Reduction                0.00%
Labor Cost Reduction                   0.00%
Reduction R&D Cycle Time               0.00%
Reduction Admin Costs                  0.00%
Demand Increase                        0.00%
4
Round                                                    0                   1    2   3
Financial Statistics
ROS                                                 4.10%                4.80%
Asset Turnover                                        1.05                 1.05
ROA                                                 4.40%                5.10%
Leverage (Assets/Equity)                                 2                  1.9
ROE                                                 8.70%                9.50%
Emergency Loan                                         $0                   $0
Sales                                        $101,073,437         $132,884,420
EBIT                                          $11,996,365          $16,565,470
Profits                                        $4,188,507           $6,411,067
Cumulative Profit                              $4,188,507          $10,559,575
SG&A / Sales                                        8.90%                7.70%
Contrib. Margin %                                  28.30%               28.40%
Market Share                                       16.67%               19.44%
Stock Market Summary
Close                                        $       34.25    $          42.58
 Change                                      $         -      $           8.32
 Shares                                          2,000,000           2,379,521
 MarketCap ($M)                              $          69    $            101
 Book Value                                  $       23.97    $          28.31
 EPS                                         $        2.09    $           2.69
 Dividend                                    $        2.00    $            -
 Yield                                                5.8%                   0%
 P/E                                                   16.4                15.8
Bond Market Summary

Financial Summary
Cash flows from operating activities
Net Income (Loss)                                  $4,189               $6,411
Adjustment for non-cash items:
  Depreciation                                     $7,587               $9,747
  Extraordinary gains/losses/writeoffs                 $0                   $0
Changes in current assets and liabilities:
  Accounts payable                                  $3,583              $1,065
  Inventory                                        ($8,617)             $1,204
  Accounts receivable                                ($307)            ($2,615)
Net cash from operations                            $6,434             $15,812

Cash flows from investing activities
Plant improvements (net)                               $0             ($32,400)
Cash flows from financing activities
Dividends paid                                     ($4,000)
Sales of common stock                                   $0             $13,000
Purchase of common stock                                $0
Cash from long term debt issued                         $0             $10,000
Early retirement of long term debt                      $0
Retirement of current debt                      $0
Cash from current debt borrowing                $0
Cash from emergency loan                        $0
Net cash from financing activities         ($4,000)    $23,000

Net change in cash position                 $2,434      $6,412
Balance Sheet Survey
Cash                                        $3,434      $9,845
Accounts Receivable                         $8,307     $10,922
Inventory                                   $8,617      $7,414
Total Current Assets                       $20,358     $28,181

Plant and equipment                       $113,800    $146,200
Accumulated Depreciation                  ($37,933)   ($47,680)
Total Fixed Assets                         $75,867     $98,520

Total Assets                               $96,225    $126,701

Accounts Payable                            $6,583      $7,648
Current Debt                                    $0          $0
Long Term Debt                             $41,700     $51,700
Total Liabilities                          $48,283     $59,348

Common Stock                               $18,360     $31,360
Retained Earnings                          $29,582     $35,993
Total Equity                               $47,942     $67,353

Total Liabilities & Owners' Equity         $96,225    $126,701
Income Statement Survey
Sales                                     $101,073    $132,884
Variable Costs (Labor, Material, Carry)    $72,513     $95,145
Depreciation                                $7,587      $9,747
SGA (R&D, Promo, Sales, Admin)              $8,978     $10,277
Other (Fees, Writeoffs, TQM, Bonuses)           $0      $1,150
EBIT                                       $11,996     $16,565
Interest (Short term, Long term)            $5,421      $6,501
Taxes                                       $2,301      $3,523
Profit Sharing                                 $85       $131
Net Profit                                  $4,189      $6,411

Traditional Market
Number of Products                               1            1
Units Sold                                     999        1826
Inventory                                      189         145
Age                                             3.1         2.4
MTBF                                         17500       17500
Performance                                     5.5         5.8
Size                              14.5            14.2
Price                    $      28.00    $      28.00
Material Cost            $      11.59    $      10.95
Labor Cost               $       7.49    $       7.85
Contribution Margin               29%             31%
2nd Shift & Over Time              0%              0%
Automation Next Round             4.0              6.0
Capacity Next Round              1800            1800
Plant Utilization                 66%             99%
Promo Budget             $   1,000.00    $   1,000.00
Sales Budget             $   1,000.00    $   1,000.00
Customer Awareness                55%             58%
Customer Accessibility            54%             51%

Low Market
Number of Products                  1                1
Units Sold                      1763             2019
Inventory                          39                0
Age                               4.6              5.6
MTBF                           14000            14000
Performance                       3.0              3.0
Size                             17.0             17.0
Price                    $     21.00     $      19.00
Material Cost            $      7.81     $       7.05
Labor Cost               $      7.12     $       7.68
Contribution Margin              27%              21%
2nd Shift & Over Time            30%              43%
Automation                       5.0               7.0
Capacity Next Round             1400             1600
Plant Utilization               129%             141%
Promo Budget             $    900.00     $   1,200.00
Sales Budget             $    900.00     $   1,200.00
Customer Awareness               52%              62%
Customer Accessibility           40%              38%

High Market
Number of Products                  1               1
Units Sold                       366             429
Inventory                          40               8
Age                               1.7             2.7
MTBF                           23000           23000
Performance                       8.0             8.0
Size                             12.0            12.0
Price                    $     38.00 $         38.00
Material Cost            $     15.98 $         14.84
Labor Cost               $      8.57 $          8.97
Contribution Margin              33%             36%
2nd Shift & Over Time            0%       0%
Automation                       3.0      3.0
Capacity Next Round             900      900
Plant Utilization               45%      44%
Promo Budget             $   800.00 $   8.00
Sales Budget             $   800.00 $   8.00
Customer Awareness              49%      48%
Customer Accessibility          48%      41%

Performance Market
Number of Products                 1       1
Units Sold                      358
Inventory                         78
Age                              2.5
MTBF                          25000
Performance                      9.4
Size                            15.5
Price                    $    33.00
Material Cost            $    15.87
Labor Cost               $     8.57
Contribution Margin             23%
2nd Shift & Over Time            0%
Automation                       3.0
Capacity Next Round             600
Plant Utilization               73%
Promo Budget             $   700.00
Sales Budget             $   700.00
Customer Awareness              46%
Customer Accessibility          37%

Size Market
Number of Products                 1
Units Sold                      314
Inventory                         62
Age                              2.6
MTBF                          19000
Performance                      4.0
Size                            11.0
Price                    $    33.00
Material Cost            $    13.62
Labor Cost               $     8.57
Contribution Margin             30%
2nd Shift & Over Time            0%
Automation                       3.0
Capacity Next Round             600
Plant Utilization               63%
Promo Budget             $   700.00
Sales Budget                    $   700.00
Customer Awareness                     46%
Customer Accessibility                 42%

Human Resources Summary
Needed Complement                       701
Complement                              700
1st Shift Complement                    640
2nd Shift Complement                     60

Overtime%                             0.20%
Turnover Rate                        10.00%
New Employees                             70
Separated Employees                        0
Recruiting Spend                         $0
Training Hours                             0
Productivity Index                  100.00%

Recruiting Cost                        $70
Separation Cost                         $0
Training Cost                           $0
Total HR Admin Cost                    $70

Labor Contract Next Year
Wages                               $21.00
Benefits                              2,500
Profit Sharing                       2.00%
Annual Raise                         5.00%

Starting Negotiation Position
Wages
Benefits
Profit Sharing
Annual Raise

Ceiling Negotiation Position
Wages
Benefits
Profit Sharing
Annual Raise

Adjusted Labor Demands
Wages
Benefits
Profit Sharing
Annual Raise
Strike Days

TQM Summary
Process Mgt Budgets Last Year
CPI Systems                              $0
Vendor/JIT                               $0
Quality Initiative Training              $0
Channel Support Systems                  $0
Concurrent Engineering                   $0
UNEP Green Programs                      $0

TQM Budgets Last Year
Benchmarking                             $0
Quality Function Deployment Effort       $0
CCE/6 Sigma Training                     $0
GEMI TQEM Sustainability Initiatives     $0
Total Expenditures                       $0

Cumulative Impacts
Material Cost Reduction                0.00%
Labor Cost Reduction                   0.00%
Reduction R&D Cycle Time               0.00%
Reduction Admin Costs                  0.00%
Demand Increase                        0.00%
4
Round                                                    0    1   2   3
Financial Statistics
ROS                                                 4.10%
Asset Turnover                                        1.05
ROA                                                 4.40%
Leverage (Assets/Equity)                                 2
ROE                                                 8.70%
Emergency Loan                                         $0
Sales                                        $101,073,437
EBIT                                          $11,996,365
Profits                                        $4,188,507
Cumulative Profit                              $4,188,507
SG&A / Sales                                        8.90%
Contrib. Margin %                                  28.30%
Market Share                                          $17
Stocks & Bonds
Close                                        $       34.25
 Change                                      $         -
 Shares                                          2,000,000
 MarketCap ($M)                              $          69
 Book Value                                  $       23.97
 EPS                                         $        2.09
 Dividend                                    $        2.00
 Yield                                                5.8%
 P/E                                                   16.4
Bond Market Summary

Financial Summary
Cash flows from operating activities
Net Income (Loss)                                  $4,189
Adjustment for non-cash items:
  Depreciation                                     $7,587
  Extraordinary gains/losses/writeoffs                 $0
Changes in current assets and liabilities:
  Accounts payable                                  $3,583
  Inventory                                        ($8,617)
  Accounts receivable                                ($307)
Net cash from operations                            $6,434

Cash flows from investing activities
Plant improvements (net)                               $0
Cash flows from financing activities
Dividends paid                                     ($4,000)
Sales of common stock                                   $0
Purchase of common stock                                $0
Cash from long term debt issued                         $0
Early retirement of long term debt                      $0
Retirement of current debt                      $0
Cash from current debt borrowing                $0
Cash from emergency loan                        $0
Net cash from financing activities         ($4,000)

Net change in cash position                 $2,434
Balance Sheet Survey
Cash                                        $3,434
Accounts Receivable                         $8,307
Inventory                                   $8,617
Total Current Assets                       $20,358

Plant and equipment                       $113,800
Accumulated Depreciation                  ($37,933)
Total Fixed Assets                         $75,867

Total Assets                               $96,225

Accounts Payable                            $6,583
Current Debt                                    $0
Long Term Debt                             $41,700
Total Liabilities                          $48,283

Common Stock                               $18,360
Retained Earnings                          $29,582
Total Equity                               $47,942

Total Liabilities & Owners' Equity         $96,225
Income Statement Survey
Sales                                     $101,073
Variable Costs (Labor, Material, Carry)    $72,513
Depreciation                                $7,587
SGA (R&D, Promo, Sales, Admin)              $8,978
Other (Fees, Writeoffs, TQM, Bonuses)           $0
EBIT                                       $11,996
Interest (Short term, Long term)            $5,421
Taxes                                       $2,301
Profit Sharing                                 $85
Net Profit                                  $4,189

Traditional Market
Number of Products                               1
Units Sold                                     999
Inventory                                      189
Age                                             3.1
MTBF                                         17500
Performance                                     5.5
Size                              14.5
Price                    $      28.00
Material Cost            $      11.59
Labor Cost               $       7.49
Contribution Margin               29%
2nd Shift & Over Time              0%
Automation Next Round             4.0
Capacity Next Round              1800
Plant Utilization                 66%
Promo Budget             $   1,000.00
Sales Budget             $   1,000.00
Customer Awareness                55%
Customer Accessibility            54%

Low Market
Number of Products                  1
Units Sold                      1763
Inventory                          39
Age                               4.6
MTBF                           14000
Performance                       3.0
Size                             17.0
Price                    $     21.00
Material Cost            $      7.81
Labor Cost               $      7.12
Contribution Margin              27%
2nd Shift & Over Time            30%
Automation                       5.0
Capacity Next Round             1400
Plant Utilization               129%
Promo Budget             $    900.00
Sales Budget             $    900.00
Customer Awareness               52%
Customer Accessibility           40%

High Market
Number of Products                  1
Units Sold                       366
Inventory                          40
Age                               1.7
MTBF                           23000
Performance                       8.0
Size                             12.0
Price                    $     38.00
Material Cost            $     15.98
Labor Cost               $      8.57
Contribution Margin              33%
2nd Shift & Over Time            0%
Automation                       3.0
Capacity Next Round             900
Plant Utilization               45%
Promo Budget             $   800.00
Sales Budget             $   800.00
Customer Awareness              49%
Customer Accessibility          48%

Performance Market
Number of Products                 1
Units Sold                      358
Inventory                         78
Age                              2.5
MTBF                          25000
Performance                      9.4
Size                            15.5
Price                    $    33.00
Material Cost            $    15.87
Labor Cost               $     8.57
Contribution Margin             23%
2nd Shift & Over Time            0%
Automation                       3.0
Capacity Next Round             600
Plant Utilization               73%
Promo Budget             $   700.00
Sales Budget             $   700.00
Customer Awareness              46%
Customer Accessibility          37%

Size Market
Number of Products                 1
Units Sold                      314
Inventory                         62
Age                              2.6
MTBF                          19000
Performance                      4.0
Size                            11.0
Price                    $    33.00
Material Cost            $    13.62
Labor Cost               $     8.57
Contribution Margin             30%
2nd Shift & Over Time            0%
Automation                       3.0
Capacity Next Round             600
Plant Utilization               63%
Promo Budget             $   700.00
Sales Budget                    $   700.00
Customer Awareness                     46%
Customer Accessibility                 42%

Human Resources Summary
Needed Complement                       701
Complement                              700
1st Shift Complement                    640
2nd Shift Complement                     60

Overtime%                             0.20%
Turnover Rate                        10.00%
New Employees                             70
Separated Employees                        0
Recruiting Spend                         $0
Training Hours                             0
Productivity Index                  100.00%

Recruiting Cost                        $70
Separation Cost                         $0
Training Cost                           $0
Total HR Admin Cost                    $70

Labor Contract Next Year
Wages                               $21.00
Benefits                              2,500
Profit Sharing                       2.00%
Annual Raise                         5.00%

Starting Negotiation Position
Wages
Benefits
Profit Sharing
Annual Raise

Ceiling Negotiation Position
Wages
Benefits
Profit Sharing
Annual Raise

Adjusted Labor Demands
Wages
Benefits
Profit Sharing
Annual Raise
Strike Days

TQM Summary
Process Mgt Budgets Last Year
CPI Systems                              $0
Vendor/JIT                               $0
Quality Initiative Training              $0
Channel Support Systems                  $0
Concurrent Engineering                   $0
UNEP Green Programs                      $0

TQM Budgets Last Year
Benchmarking                             $0
Quality Function Deployment Effort       $0
CCE/6 Sigma Training                     $0
GEMI TQEM Sustainability Initiatives     $0
Total Expenditures                       $0

Cumulative Impacts
Material Cost Reduction                0.00%
Labor Cost Reduction                   0.00%
Reduction R&D Cycle Time               0.00%
Reduction Admin Costs                  0.00%
Demand Increase                        0.00%
4
Round                                                    0    1   2   3
Financial Statistics
ROS                                                 4.10%
Asset Turnover                                        1.05
ROA                                                 4.40%
Leverage (Assets/Equity)                                 2
ROE                                                 8.70%
Emergency Loan                                         $0
Sales                                        $101,073,437
EBIT                                          $11,996,365
Profits                                        $4,188,507
Cumulative Profit                              $4,188,507
SG&A / Sales                                        8.90%
Contrib. Margin %                                  28.30%
Market Share                                          $17
Stocks & Bonds
Close                                        $       34.25
 Change                                      $         -
 Shares                                          2,000,000
 MarketCap ($M)                              $          69
 Book Value                                  $       23.97
 EPS                                         $        2.09
 Dividend                                    $        2.00
 Yield                                                5.8%
 P/E                                                   16.4
Bond Market Summary

Financial Summary
Cash flows from operating activities
Net Income (Loss)                                  $4,189
Adjustment for non-cash items:
  Depreciation                                     $7,587
  Extraordinary gains/losses/writeoffs                 $0
Changes in current assets and liabilities:
  Accounts payable                                  $3,583
  Inventory                                        ($8,617)
  Accounts receivable                                ($307)
Net cash from operations                            $6,434

Cash flows from investing activities
Plant improvements (net)                               $0
Cash flows from financing activities
Dividends paid                                     ($4,000)
Sales of common stock                                   $0
Purchase of common stock                                $0
Cash from long term debt issued                         $0
Early retirement of long term debt                      $0
Retirement of current debt                      $0
Cash from current debt borrowing                $0
Cash from emergency loan                        $0
Net cash from financing activities         ($4,000)

Net change in cash position                 $2,434
Balance Sheet Survey
Cash                                        $3,434
Accounts Receivable                         $8,307
Inventory                                   $8,617
Total Current Assets                       $20,358

Plant and equipment                       $113,800
Accumulated Depreciation                  ($37,933)
Total Fixed Assets                         $75,867

Total Assets                               $96,225

Accounts Payable                            $6,583
Current Debt                                    $0
Long Term Debt                             $41,700
Total Liabilities                          $48,283

Common Stock                               $18,360
Retained Earnings                          $29,582
Total Equity                               $47,942

Total Liabilities & Owners' Equity         $96,225
Income Statement Survey
Sales                                     $101,073
Variable Costs (Labor, Material, Carry)    $72,513
Depreciation                                $7,587
SGA (R&D, Promo, Sales, Admin)              $8,978
Other (Fees, Writeoffs, TQM, Bonuses)           $0
EBIT                                       $11,996
Interest (Short term, Long term)            $5,421
Taxes                                       $2,301
Profit Sharing                                 $85
Net Profit                                  $4,189

Traditional Market
Number of Products                               1
Units Sold                                     999
Inventory                                      189
Age                                             3.1
MTBF                                         17500
Performance                                     5.5
Size                              14.5
Price                    $      28.00
Material Cost            $      11.59
Labor Cost               $       7.49
Contribution Margin               29%
2nd Shift & Over Time              0%
Automation Next Round             4.0
Capacity Next Round              1800
Plant Utilization                 66%
Promo Budget             $   1,000.00
Sales Budget             $   1,000.00
Customer Awareness                55%
Customer Accessibility            54%

Low Market
Number of Products                  1
Units Sold                      1763
Inventory                          39
Age                               4.6
MTBF                           14000
Performance                       3.0
Size                             17.0
Price                    $     21.00
Material Cost            $      7.81
Labor Cost               $      7.12
Contribution Margin              27%
2nd Shift & Over Time            30%
Automation                       5.0
Capacity Next Round             1400
Plant Utilization               129%
Promo Budget             $    900.00
Sales Budget             $    900.00
Customer Awareness               52%
Customer Accessibility           40%

High Market
Number of Products                  1
Units Sold                       366
Inventory                          40
Age                               1.7
MTBF                           23000
Performance                       8.0
Size                             12.0
Price                    $     38.00
Material Cost            $     15.98
Labor Cost               $      8.57
Contribution Margin              33%
2nd Shift & Over Time            0%
Automation                       3.0
Capacity Next Round             900
Plant Utilization               45%
Promo Budget             $   800.00
Sales Budget             $   800.00
Customer Awareness              49%
Customer Accessibility          48%

Performance Market
Number of Products                 1
Units Sold                      358
Inventory                         78
Age                              2.5
MTBF                          25000
Performance                      9.4
Size                            15.5
Price                    $    33.00
Material Cost            $    15.87
Labor Cost               $     8.57
Contribution Margin             23%
2nd Shift & Over Time            0%
Automation                       3.0
Capacity Next Round             600
Plant Utilization               73%
Promo Budget             $   700.00
Sales Budget             $   700.00
Customer Awareness              46%
Customer Accessibility          37%

Size Market
Number of Products                 1
Units Sold                      314
Inventory                         62
Age                              2.6
MTBF                          19000
Performance                      4.0
Size                            11.0
Price                    $    33.00
Material Cost            $    13.62
Labor Cost               $     8.57
Contribution Margin             30%
2nd Shift & Over Time            0%
Automation                       3.0
Capacity Next Round             600
Plant Utilization               63%
Promo Budget             $   700.00
Sales Budget                    $   700.00
Customer Awareness                     46%
Customer Accessibility                 42%

Human Resources Summary
Needed Complement                       701
Complement                              700
1st Shift Complement                    640
2nd Shift Complement                     60

Overtime%                             0.20%
Turnover Rate                        10.00%
New Employees                             70
Separated Employees                        0
Recruiting Spend                         $0
Training Hours                             0
Productivity Index                  100.00%

Recruiting Cost                        $70
Separation Cost                         $0
Training Cost                           $0
Total HR Admin Cost                    $70

Labor Contract Next Year
Wages                               $21.00
Benefits                              2,500
Profit Sharing                       2.00%
Annual Raise                         5.00%

Starting Negotiation Position
Wages
Benefits
Profit Sharing
Annual Raise

Ceiling Negotiation Position
Wages
Benefits
Profit Sharing
Annual Raise

Adjusted Labor Demands
Wages
Benefits
Profit Sharing
Annual Raise
Strike Days

TQM Summary
Process Mgt Budgets Last Year
CPI Systems                              $0
Vendor/JIT                               $0
Quality Initiative Training              $0
Channel Support Systems                  $0
Concurrent Engineering                   $0
UNEP Green Programs                      $0

TQM Budgets Last Year
Benchmarking                             $0
Quality Function Deployment Effort       $0
CCE/6 Sigma Training                     $0
GEMI TQEM Sustainability Initiatives     $0
Total Expenditures                       $0

Cumulative Impacts
Material Cost Reduction                0.00%
Labor Cost Reduction                   0.00%
Reduction R&D Cycle Time               0.00%
Reduction Admin Costs                  0.00%
Demand Increase                        0.00%
4
Round                                                    0    1   2   3
Financial Statistics
ROS                                                 4.10%
Asset Turnover                                        1.05
ROA                                                 4.40%
Leverage (Assets/Equity)                                 2
ROE                                                 8.70%
Emergency Loan                                         $0
Sales                                        $101,073,437
EBIT                                          $11,996,365
Profits                                        $4,188,507
Cumulative Profit                              $4,188,507
SG&A / Sales                                        8.90%
Contrib. Margin %                                  28.30%
Market Share                                          $17
Stocks & Bonds
Close                                        $       34.25
 Change                                      $         -
 Shares                                          2,000,000
 MarketCap ($M)                              $          69
 Book Value                                  $       23.97
 EPS                                         $        2.09
 Dividend                                    $        2.00
 Yield                                                5.8%
 P/E                                                   16.4
Bond Market Summary

Financial Summary
Cash flows from operating activities
Net Income (Loss)                                  $4,189
Adjustment for non-cash items:
  Depreciation                                     $7,587
  Extraordinary gains/losses/writeoffs                 $0
Changes in current assets and liabilities:
  Accounts payable                                  $3,583
  Inventory                                        ($8,617)
  Accounts receivable                                ($307)
Net cash from operations                            $6,434

Cash flows from investing activities
Plant improvements (net)                               $0
Cash flows from financing activities
Dividends paid                                     ($4,000)
Sales of common stock                                   $0
Purchase of common stock                                $0
Cash from long term debt issued                         $0
Early retirement of long term debt                      $0
Retirement of current debt                      $0
Cash from current debt borrowing                $0
Cash from emergency loan                        $0
Net cash from financing activities         ($4,000)

Net change in cash position                 $2,434
Balance Sheet Survey
Cash                                        $3,434
Accounts Receivable                         $8,307
Inventory                                   $8,617
Total Current Assets                       $20,358

Plant and equipment                       $113,800
Accumulated Depreciation                  ($37,933)
Total Fixed Assets                         $75,867

Total Assets                               $96,225

Accounts Payable                            $6,583
Current Debt                                    $0
Long Term Debt                             $41,700
Total Liabilities                          $48,283

Common Stock                               $18,360
Retained Earnings                          $29,582
Total Equity                               $47,942

Total Liabilities & Owners' Equity         $96,225
Income Statement Survey
Sales                                     $101,073
Variable Costs (Labor, Material, Carry)    $72,513
Depreciation                                $7,587
SGA (R&D, Promo, Sales, Admin)              $8,978
Other (Fees, Writeoffs, TQM, Bonuses)           $0
EBIT                                       $11,996
Interest (Short term, Long term)            $5,421
Taxes                                       $2,301
Profit Sharing                                 $85
Net Profit                                  $4,189

Traditional Market
Number of Products                               1
Units Sold                                     999
Inventory                                      189
Age                                             3.1
MTBF                                         17500
Performance                                     5.5
Size                              14.5
Price                    $      28.00
Material Cost            $      11.59
Labor Cost               $       7.49
Contribution Margin               29%
2nd Shift & Over Time              0%
Automation Next Round             4.0
Capacity Next Round              1800
Plant Utilization                 66%
Promo Budget             $   1,000.00
Sales Budget             $   1,000.00
Customer Awareness                55%
Customer Accessibility            54%

Low Market
Number of Products                  1
Units Sold                      1763
Inventory                          39
Age                               4.6
MTBF                           14000
Performance                       3.0
Size                             17.0
Price                    $     21.00
Material Cost            $      7.81
Labor Cost               $      7.12
Contribution Margin              27%
2nd Shift & Over Time            30%
Automation                       5.0
Capacity Next Round             1400
Plant Utilization               129%
Promo Budget             $    900.00
Sales Budget             $    900.00
Customer Awareness               52%
Customer Accessibility           40%

High Market
Number of Products                  1
Units Sold                       366
Inventory                          40
Age                               1.7
MTBF                           23000
Performance                       8.0
Size                             12.0
Price                    $     38.00
Material Cost            $     15.98
Labor Cost               $      8.57
Contribution Margin              33%
2nd Shift & Over Time            0%
Automation                       3.0
Capacity Next Round             900
Plant Utilization               45%
Promo Budget             $   800.00
Sales Budget             $   800.00
Customer Awareness              49%
Customer Accessibility          48%

Performance Market
Number of Products                 1
Units Sold                      358
Inventory                         78
Age                              2.5
MTBF                          25000
Performance                      9.4
Size                            15.5
Price                    $    33.00
Material Cost            $    15.87
Labor Cost               $     8.57
Contribution Margin             23%
2nd Shift & Over Time            0%
Automation                       3.0
Capacity Next Round             600
Plant Utilization               73%
Promo Budget             $   700.00
Sales Budget             $   700.00
Customer Awareness              46%
Customer Accessibility          37%

Size Market
Number of Products                 1
Units Sold                      314
Inventory                         62
Age                              2.6
MTBF                          19000
Performance                      4.0
Size                            11.0
Price                    $    33.00
Material Cost            $    13.62
Labor Cost               $     8.57
Contribution Margin             30%
2nd Shift & Over Time            0%
Automation                       3.0
Capacity Next Round             600
Plant Utilization               63%
Promo Budget             $   700.00
Sales Budget                    $   700.00
Customer Awareness                     46%
Customer Accessibility                 42%

Human Resources Summary
Needed Complement                       701
Complement                              700
1st Shift Complement                    640
2nd Shift Complement                     60

Overtime%                             0.20%
Turnover Rate                        10.00%
New Employees                             70
Separated Employees                        0
Recruiting Spend                         $0
Training Hours                             0
Productivity Index                  100.00%

Recruiting Cost                        $70
Separation Cost                         $0
Training Cost                           $0
Total HR Admin Cost                    $70

Labor Contract Next Year
Wages                               $21.00
Benefits                              2,500
Profit Sharing                       2.00%
Annual Raise                         5.00%

Starting Negotiation Position
Wages
Benefits
Profit Sharing
Annual Raise

Ceiling Negotiation Position
Wages
Benefits
Profit Sharing
Annual Raise

Adjusted Labor Demands
Wages
Benefits
Profit Sharing
Annual Raise
Strike Days

TQM Summary
Process Mgt Budgets Last Year
CPI Systems                              $0
Vendor/JIT                               $0
Quality Initiative Training              $0
Channel Support Systems                  $0
Concurrent Engineering                   $0
UNEP Green Programs                      $0

TQM Budgets Last Year
Benchmarking                             $0
Quality Function Deployment Effort       $0
CCE/6 Sigma Training                     $0
GEMI TQEM Sustainability Initiatives     $0
Total Expenditures                       $0

Cumulative Impacts
Material Cost Reduction                0.00%
Labor Cost Reduction                   0.00%
Reduction R&D Cycle Time               0.00%
Reduction Admin Costs                  0.00%
Demand Increase                        0.00%
4

				
DOCUMENT INFO
Shared By:
Categories:
Tags:
Stats:
views:94
posted:4/22/2012
language:Latin
pages:42