Capsim Simulation Final Company Performance Summary/ Report

CapsimReport-EljaSensors.pdf

Home >Business & Finance homework help >Management homework help >Capsim Simulation Final Company Performance Summary/ Report

4/13/2021 Courier | Foundation WebApp

https://ww3.capsim.com/cgi-bin/displayReport.cfm?Report=CapCourier#frontpage 1/12

Close Window Page 1 Front Page Page 2 Stocks & Bonds Page 3 Financial Summary Page 4 Production Analysis

Page 5 Low Tech Segment Analysis Page 6 High Tech Segment Analysis

Page 7 Market Share Page 8 Perceptual Map Page 9 HR/TQM Report Page 10 Ethics Report

4/13/2021 Courier | Foundation WebApp

https://ww3.capsim.com/cgi-bin/displayReport.cfm?Report=CapCourier#frontpage 2/12

Top

Round: 8 Dec. 31, 2029

Elja Sensors

F126875_005

Andrews Fatima Eljaouhari

Baldwin

Chester

Digby

Erie

Ferris

Selected Financial Statistics Andrews Baldwin Chester Digby Erie Ferris ROS -9.1% 9.3% 4.4% 9.4% 9.0% 13.9% Asset Turnover 4.63 1.40 1.01 1.36 1.01 1.52 ROA -42.3% 13.0% 4.5% 12.7% 9.1% 21.2% Leverage (Assets/Equity) -0.2 2.0 2.1 2.0 2.0 2.0 ROE -9.6% 25.8% 9.3% 25.2% 18.3% 41.4% Emergency Loan $56,487,103 $0 $0 $0 $0 $0 Sales $53,401,104 $149,470,417 $62,648,351 $168,664,240 $58,670,431 $143,516,894 EBIT $2,886,268 $26,495,773 $7,472,489 $30,415,326 $11,144,119 $35,214,458 Profits ($4,879,258) $13,909,598 $2,776,036 $15,851,289 $5,289,208 $19,943,680 Cumulative Profit ($44,973,676) $67,360,633 $37,795,386 $83,250,528 $38,106,306 $83,755,050 SG&A / Sales 17.7% 8.2% 11.0% 6.8% 11.3% 5.7% Contrib. Margin % 25.3% 32.0% 36.3% 29.8% 47.3% 36.4%

FOUNDATION® FAST TRACK Page 1

4/13/2021 Courier | Foundation WebApp

https://ww3.capsim.com/cgi-bin/displayReport.cfm?Report=CapCourier#frontpage 3/12

Top

Stocks & Bonds F126875_005 Round: 8

December 31 , 2029

Stock Market Summary Company Close Change Shares MarketCap ($M) Book Value PerShare EPS Dividend Yield P/E

Andrews $1.00 $0.00 2,400,000 $2 ($21.26) ($2.03) $3.50 350.0% -0.5 Baldwin $59.25 $14.98 2,215,730 $131 $24.32 $6.28 $6.86 11.6% 9.4 Chester $23.48 ($6.79) 2,290,071 $54 $13.09 $1.21 $4.65 19.8% 19.4 Digby $71.81 $10.49 2,138,350 $154 $29.44 $7.41 $7.27 10.1% 9.7 Erie $26.99 ($2.25) 2,422,289 $65 $11.95 $2.18 $5.78 21.4% 12.3 Ferris $82.73 $12.60 2,071,891 $171 $23.27 $9.63 $10.39 12.6% 8.6

Bond Market Summary Company Series# Face Yield Close$ S&P Andrews 13.3S2036 $4,041,000 13.3% 100.00 DDD Baldwin 11.0S2033 $3,627,509 11.1% 99.38 B 11.0S2034 $1,668,727 11.1% 99.27 B 11.0S2035 $4,178,601 11.1% 99.16 B 11.5S2036 $1,992,111 11.3% 101.41 B 11.2S2037 $9,852,839 11.2% 100.00 B 11.6S2038 $2,572,299 11.4% 102.20 B Chester 10.8S2033 $4,339,933 11.0% 97.85 CCC 11.3S2034 $4,308,367 11.4% 99.27 CCC 11.2S2035 $3,140,503 11.3% 98.75 CCC 11.0S2037 $5,852,042 11.3% 97.47 CCC Digby 10.9S2033 $2,651,539 11.0% 99.07 B 11.1S2034 $360,934 11.1% 99.63 B 10.9S2035 $2,826,569 11.0% 98.74 B 11.4S2036 $8,088,037 11.3% 100.94 B 11.0S2037 $8,694,476 11.1% 98.98 B 11.5S2038 $2,046,742 11.3% 101.65 B Erie 10.0S2032 $89,490 10.3% 96.84 B 10.9S2033 $5,053,944 11.0% 98.77 B 11.2S2034 $1,014,249 11.2% 99.63 B 11.1S2035 $1,268,385 11.2% 99.16 B 11.6S2036 $2,134,335 11.4% 101.40 B 10.8S2037 $5,859,761 11.1% 97.45 B 11.7S2038 $1,601,461 11.4% 102.19 B Ferris 11.1S2033 $479,022 11.1% 100.00 B 10.9S2035 $2,254,358 11.0% 99.16 B 11.4S2036 $3,233,182 11.2% 101.41 B 10.7S2037 $7,087,250 10.9% 97.95 B 11.5S2038 $1,863,484 11.3% 102.21 B

Next Year's Prime Rate 7.00% FOUNDATION® FAST TRACK Page 2

4/13/2021 Courier | Foundation WebApp

https://ww3.capsim.com/cgi-bin/displayReport.cfm?Report=CapCourier#frontpage 4/12

Top

Financial Summary F126875_005 Round: 8December 31, 2029 Cash Flow Statement Survey Andrews Baldwin Chester Digby Erie Ferris Cash flows from operating activities Net Income (Loss) ($4,879) $13,910 $2,776 $15,851 $5,289 $19,944 Adjustment for non-cash items: Depreciation $1,181 $6,020 $4,801 $6,448 $4,560 $4,088 Extraordinary gains/losses/writeoffs $0 ($77) ($46) ($91) ($57) ($5) Changes in current assets and liabilities: Accounts payable ($1,980) $2,151 ($674) $975 ($674) $146 Inventory $2,458 ($2,065) $1,762 ($2,734) $1,453 ($1,104) Accounts receivable ($3,129) ($2,804) $356 ($1,808) ($6) ($1,415)

Net cash from operations ($6,349) $17,134 $8,975 $18,640 $10,565 $21,653 Cash flows from investing activities

Plant improvements (net) $0 $0 $0 $0 $0 $0 Cash flows from financing activities

Dividends paid ($8,400) ($15,209) ($10,642) ($15,538) ($14,000) ($21,531) Sales of common stock $0 $0 $0 $0 $0 $0 Purchase of common stock $0 $0 $0 $0 $0 ($364) Cash from long term debt issued $0 $0 $0 $0 $0 $0 Early retirement of long term debt $0 ($3,279) ($1,776) ($4,036) ($2,216) ($2,512) Retirement of current debt ($42,739) ($16,317) ($13,093) ($23,831) ($9,864) ($21,424)

Cash from current debt borrowing $1,000 $20,692 $11,995 $28,660 $10,200 $23,600

Cash from emergency loan $56,487 $0 $0 $0 $0 $0

Net cash from financing activities $6,349 ($14,114) ($13,516) ($14,745) ($15,881) ($22,231) Net change in cash position $0 $3,021 ($4,540) $3,895 ($5,315) ($578)

Balance Sheet Survey Andrews Baldwin Chester Digby Erie Ferris

Cash $0 $20,678 $6,257 $26,407 $5,010 $18,968 Accounts Receivable $7,315 $12,285 $5,149 $13,863 $4,822 $11,796 Inventory $0 $18,256 $11,335 $23,027 $9,510 $23,612

Total Current Assets $7,315 $51,220 $22,742 $63,297 $19,342 $54,375 Plant and equipment $17,722 $90,304 $72,012 $96,720 $68,400 $61,320 Accumulated Depreciation ($13,497) ($34,703) ($32,613) ($35,623) ($29,800) ($21,614)

Total Fixed Assets $4,225 $55,601 $39,399 $61,097 $38,600 $39,706 Total Assets $11,540 $106,820 $62,141 $124,395 $57,942 $94,082

Accounts Payable $1,026 $8,347 $2,520 $8,102 $1,786 $7,358 Current Debt $57,487 $20,692 $11,995 $28,660 $10,200 $23,600 Total Current Liabilities $58,513 $29,039 $14,515 $36,762 $11,986 $30,958 Long Term Debt $4,041 $23,892 $17,641 $24,668 $17,022 $14,917 Total Liabilities $62,554 $52,931 $32,156 $61,431 $29,007 $45,875 Common Stock $2,723 $6,016 $6,432 $4,907 $9,411 $4,034 Retained Earnings ($53,737) $47,872 $23,552 $58,057 $19,525 $44,172 Total Equity ($51,014) $53,889 $29,985 $62,964 $28,935 $48,206 Total Liabilities & Owners' Equity $11,540 $106,820 $62,141 $124,395 $57,942 $94,082

Income Statement Survey Andrews Baldwin Chester Digby Erie Ferris

Sales $53,401 $149,470 $62,648 $168,664 $58,670 $143,517 Variable Costs (Labor, Material, Carry) $39,907 $101,684 $39,921 $118,324 $30,933 $91,255 Contribution Margin $13,494 $47,786 $22,727 $50,340 $27,737 $52,262 Depreciation $1,181 $6,020 $4,801 $6,448 $4,560 $4,088 SGA (R&D, Promo, Sales, Admin) $9,426 $12,298 $6,874 $11,507 $6,657 $8,171 Other (Fees, Writeoffs, TQM, Bonuses) $0 $2,972 $3,581 $1,969 $5,377 $4,788

$ $ $ $ $ $

4/13/2021 Courier | Foundation WebApp

https://ww3.capsim.com/cgi-bin/displayReport.cfm?Report=CapCourier#frontpage 5/12

EBIT $2,886 $26,496 $7,472 $30,415 $11,144 $35,214

Interest (Short term, Long term) $10,393 $4,660 $3,115 $5,531 $2,841 $3,906 Taxes ($2,627) $7,643 $1,525 $8,709 $2,906 $10,958 Profit Sharing $0 $284 $57 $323 $108 $407 Net Profit ($4,879) $13,910 $2,776 $15,851 $5,289 $19,944 FOUNDATION® FAST TRACK Page 3

4/13/2021 Courier | Foundation WebApp

https://ww3.capsim.com/cgi-bin/displayReport.cfm?Report=CapCourier#frontpage 6/12

Top

Production Analysis F126875_005 Round: 8December 31, 2029

Production Information Andrews Baldwin Chester Digby Erie Ferris

Units Produced 1,837 4,456 2,535 5,170 2,489 3,614

Name Primary

Segment Units Sold

Unit Inven

tory Revision

Date Age

Dec.31 MTBF Pfmn

Coord Size

Coord Price Material

Cost Labor

Cost Contr. Marg.

2nd Shift

& Over-

time

Auto mation

Next Round

Capacity Next

Round Plant Utiliz.

Able Low 1,960 0 2/12/2029 2.1 20000 8.1 11.8 $27.25 $8.54 $11.45 25% 87% 3.0 984 187% A_Duke 0 0 8/19/2030 4.7 20000 8.0 13.0 $40.50 $0.00 $0.00 0% 0% 1.0 1 0% Baker Low 1,565 448 7/6/2029 2.1 18800 9.3 12.4 $27.50 $9.89 $5.26 43% 15% 7.5 1,350 114% Bold High 1,449 341 4/28/2029 1.7 22400 11.6 7.3 $41.35 $16.96 $11.34 29% 43% 4.0 1,050 141% Best High 1,368 68 4/18/2029 1.3 20000 11.3 10.1 $34.00 $13.70 $11.19 26% 81% 4.5 800 179% Cake Low 1,758 403 12/17/2029 1.6 17000 8.0 10.6 $19.00 $8.71 $2.66 38% 38% 9.0 1,200 137% Cent High 900 327 8/16/2029 1.3 20000 10.7 7.9 $32.50 $13.51 $7.25 34% 6% 5.0 850 105% Daze Low 1,541 520 9/11/2029 1.5 18000 8.7 11.5 $27.50 $9.85 $4.54 43% 20% 8.0 1,250 119% Dabble High 1,691 355 7/15/2029 1.4 22000 12.9 7.8 $40.25 $17.83 $11.48 26% 55% 4.0 1,100 154% Dust High 1,819 206 7/8/2029 1.3 20000 10.4 9.8 $32.00 $13.36 $10.43 25% 100% 5.0 1,000 199% Eat Low 1,261 406 10/24/2029 2.1 16500 8.2 12.2 $23.50 $7.40 $4.06 48% 32% 8.0 950 131% East Low 1,235 391 10/24/2029 2.1 16500 7.5 11.5 $23.50 $7.48 $4.20 47% 47% 8.0 850 146% Fast High 1,836 494 7/30/2029 1.4 22000 12.8 6.9 $40.50 $16.33 $9.06 35% 58% 4.9 1,200 157% Feast High 1,707 453 7/30/2029 1.4 22000 12.4 7.4 $40.50 $15.65 $8.76 38% 40% 4.9 1,250 139%

FOUNDATION® FAST TRACK Page 4

4/13/2021 Courier | Foundation WebApp

https://ww3.capsim.com/cgi-bin/displayReport.cfm?Report=CapCourier#frontpage 7/12

Top

Low Tech Market Segment Analysis F126875_005 Round: 8December 31, 2029

Low Tech Statistics Total Industry Unit Demand 10,804 Actual Industry Unit Sales 10,804 Segment % of Total Industry 53.8%

Next Year's Segment Growth Rate 10.0%

Low Tech Customer Buying Criteria Expectations Importance

1. Price $15.00 - 35.00 41%

2. Age Ideal Age = 3.0 29%

3. Reliability MTBF 14000-20000 21%

4. Ideal Position Pfmn 8.8 Size 11.2 9%

Perceptual Map for Low Tech Segment

Top Products in High Tech Segment

Name Market Share

Units Sold

to Seg Revision

Date Stock Out

Pfmn Coord

Size Coord

List Price MTBF

Age Dec.31

Promo Budget

Cust. Aware- ness

Sales Budget

Cust. Access-

ibility

Dec. Cust.

Survey Fast 20% 1,836 7/30/2029 12.8 6.9 $40.50 22000 1.42 $1,500 100% $1,150 76% 50 Feast 18% 1,707 7/30/2029 12.4 7.4 $40.50 22000 1.39 $1,500 100% $1,150 76% 47 Dabble 18% 1,691 7/15/2029 12.9 7.8 $40.25 22000 1.42 $1,450 99% $1,100 76% 45 Bold 16% 1,449 4/28/2029 11.6 7.3 $41.35 22400 1.66 $1,350 91% $1,250 70% 33 Dust 10% 949 7/8/2029 10.4 9.8 $32.00 20000 1.31 $1,700 94% $1,100 76% 24 Best 10% 941 4/18/2029 11.3 10.1 $34.00 20000 1.26 $1,350 70% $1,250 70% 21 Cent 7% 687 8/16/2029 10.7 7.9 $32.50 20000 1.30 $1,025 65% $1,150 33% 19 Daze 0% 19 9/11/2029 8.7 11.5 $27.50 18000 1.54 $1,450 100% $1,100 76% 0 Able 0% 6 2/12/2029 YES 8.1 11.8 $27.25 20000 2.15 $1,400 99% $3,000 14% 0 Cake 0% 1 12/17/2029 8.0 10.6 $19.00 17000 1.56 $1,025 66% $1,150 33% 0 FOUNDATION® FAST TRACK Page 6

4/13/2021 Courier | Foundation WebApp

https://ww3.capsim.com/cgi-bin/displayReport.cfm?Report=CapCourier#frontpage 9/12

Top

Market Share Report F126875_005 Round: 8December 31, 2029

Actual Market Share in Units Low High Total Industry Unit Sales

10,804 9,288 20,091

% of Market 53.8% 46.2% 100.0% Able 18.1% 0.1% 9.8% Total 18.1% 0.1% 9.8% Baker 14.5% 7.8% Bold 15.6% 7.2% Best 4.0% 10.1% 6.8% Total 18.4% 25.7% 21.8% Cake 16.3% 0.0% 8.8% Cent 2.0% 7.4% 4.5% Total 18.2% 7.4% 13.2% Daze 14.1% 0.2% 7.7% Dabble 18.2% 8.4% Dust 8.1% 10.2% 9.1% Total 22.1% 28.6% 25.1% Eat 11.7% 6.3% East 11.4% 6.2% Total 23.1% 12.4% Fast 19.8% 9.1% Feast 18.4% 8.5% Total 38.1% 17.6%

Potential Market Share in Units Low High Total Units Demanded

10,804 9,288 20,091

% of Market

53.8% 46.2% 100.0%

Able 19.9% 0.1% 10.7% Total 22.5% 0.1% 12.1% Baker 13.7% 7.4% Bold 15.6% 7.2% Best 3.7% 10.1% 6.7% Total 17.4% 25.7% 21.3% Cake 15.4% 8.3% Cent 1.9% 7.4% 4.4% Total 17.3% 7.4% 12.7% Daze 13.3% 0.2% 7.3% Dabble 18.2% 8.4% Dust 7.6% 10.2% 8.8% Total 21.0% 28.6% 24.5% Eat 11.0% 5.9% East 10.8% 5.8% Total 21.9% 11.8% Fast 19.8% 9.1% Feast 18.4% 8.5% Total 38.1% 17.6%

FOUNDATION® FAST TRACK Page 7

4/13/2021 Courier | Foundation WebApp

https://ww3.capsim.com/cgi-bin/displayReport.cfm?Report=CapCourier#frontpage 10/12

Top

Perceptual Map F126875_005 Round: 8December 31, 2029

Perceptual Map for All Segments

Andrews Name Pfmn Size Revised

Able 8.1 11.8 2/12/2029 A_Duke 8.0 13.0 8/19/2030 A_Fox 10.0 9.0 1/13/2030 A_Dell 8.0 12.0 7/24/2030 A_fuur 9.4 15.5 9/1/2030

Baldwin Name Pfmn Size Revised

Baker 9.3 12.4 7/6/2029 Bold 11.6 7.3 4/28/2029 Best 11.3 10.1 4/18/2029

Chester Name Pfmn Size Revised

Cake 8.0 10.6 12/17/2029 Cent 10.7 7.9 8/16/2029

Digby Name Pfmn Size Revised

Daze 8.7 11.5 9/11/2029 Dabble 12.9 7.8 7/15/2029 Dust 10.4 9.8 7/8/2029

Erie Name Pfmn Size Revised

Eat 8.2 12.2 10/24/2029 East 7.5 11.5 10/24/2029

Ferris Name Pfmn Size Revised

Fast 12.8 6.9 7/30/2029 Feast 12.4 7.4 7/30/2029

FOUNDATION® FAST TRACK Page 8

4/13/2021 Courier | Foundation WebApp

https://ww3.capsim.com/cgi-bin/displayReport.cfm?Report=CapCourier#frontpage 11/12

Top

HR/TQM Report F126875_005 Round: 8December 31, 2029

HUMAN RESOURCES SUMMARY

Andrews Baldwin Chester Digby Erie Ferris Needed Complement 279 566 162 630 144 443 Complement 279 566 162 630 144 443 1st Shift Complement 150 386 140 387 103 298 2nd Shift Complement 129 180 22 243 40 146 Overtime% 0.2% 0.0% 0.0% 0.0% 0.0% 0.0% Turnover Rate 6.0% 8.0% 8.2% 8.0% 8.4% 7.9% New Employees 17 189 13 91 12 35 Separated Employees 8 0 48 0 82 8 Recruiting Spend $5,000 $2,500 $2,400 $2,800 $2,400 $2,300 Training Hours 80 40 40 38 30 40 Productivity Index 118.5% 109.9% 115.6% 112.6% 111.4% 113.7% Recruiting Cost $101 $661 $45 $346 $41 $116 Separation Cost $40 $0 $241 $0 $412 $41 Training Cost $446 $453 $130 $479 $86 $355 Total HR Admin Cost $588 $1,114 $416 $825 $539 $511 Strike Days

TQM SUMMARY Andrews Baldwin Chester Digby Erie Ferris Process Mgt Budgets Last Year CPI Systems $0 $0 $900 $0 $900 $0 Vendor/JIT $0 $0 $900 $0 $900 $950 Quality Initiative Training $0 $0 $900 $0 $900 $0 Channel Support Systems $0 $750 $0 $1,000 $0 $950 Concurrent Engineering $0 $750 $0 $0 $0 $0 UNEP Green Programs $0 $0 $0 $0 $900 $950 TQM Budgets Last Year Benchmarking $0 $0 $0 $1,000 $0 $0 Quality Function Deployment Effort

$0 $750 $0 $0 $0 $0

CCE/6 Sigma Training $0 $0 $900 $0 $900 $950 GEMI TQEM Sustainability Initiatives

$0 $750 $0 $0 $900 $950

Total Expenditures $0 $3,000 $3,600 $2,000 $5,400 $4,750 Cumulative Impacts Material Cost Reduction 11.80% 1.89% 11.80% 0.00% 11.80% 11.73% Labor Cost Reduction 14.00% 0.28% 14.00% 0.00% 14.00% 9.88% Reduction R&D Cycle Time 40.01% 40.01% 0.00% 0.00% 0.00% 0.00% Reduction Admin Costs 60.02% 0.00% 46.79% 60.02% 46.79% 44.56% Demand Increase 14.40% 14.37% 4.20% 11.16% 8.05% 14.40% FOUNDATION® FAST TRACK Page 9

4/13/2021 Courier | Foundation WebApp

https://ww3.capsim.com/cgi-bin/displayReport.cfm?Report=CapCourier#frontpage 12/12

Top

Ethics Report F126875_005 Round: 8December 31, 2029 ETHICS SUMMARY

Other (Fees, Writeoffs, etc.) The actual dollar impact. Example, $120 means Other increased by $120. Demand Factor The % of normal. 98% means demand fell 2%. Material Cost Impact The % of normal. 104% means matieral costs rose 4%. Admin Cost Impact The % of normal. 103% means admin costs rose 3%. Productivity Impact The % of normal. 104% means productivity increased by 4%. Awareness Impact The % of normal. 105% means normal awareness was multiplied by 1.05. Accessibility Impact The % of normal. 98% means normal accessiblity was multiplied by 0.98.

Normal means the value that would have been produced if the problem had not been presented.

No Impact Andrews Baldwin Chester Digby Erie Ferris Total Other (Fees, Writeoffs, etc.) $0 $0 $0 $0 $0 $0 $0 Demand Factor 100% 100% 100% 100% 100% 100% 100% Material Cost Impact 100% 100% 100% 100% 100% 100% 100% Admin Cost Impact 100% 100% 100% 100% 100% 100% 100% Productivity Impact 100% 100% 100% 100% 100% 100% 100% Awareness Impact 100% 100% 100% 100% 100% 100% 100% Accessibility Impact 100% 100% 100% 100% 100% 100% 100%

FOUNDATION® FAST TRACK Page 10