Final Project: Final Company Performance Summary Andrew

Stocks & Bonds 

<="" th="">

F128156_010

Round: 8 December 31 , 2029

Company 

Close 

Change 

Shares 

MarketCap ($M) 

Book Value Per Share

EPS 

Dividend 

Yield 

P/E 

Andrews

$1.00

$0.00

2,462,943

$2

($131.82)

($30.64)

$50.00

5000.0%

0.0

Baldwin

$67.00

$17.74

2,173,478

$146

$25.74

$7.38

$8.21

12.3%

9.1

Chester

$29.23

($6.47)

2,260,260

$66

$15.67

$1.80

$4.79

16.4%

16.2

Digby

$76.77

$12.17

2,217,285

$170

$31.23

$8.25

$7.12

9.3%

9.3

Erie

$35.98

$0.53

2,467,344

$89

$14.83

$3.41

$6.29

17.5%

10.5

Ferris

$82.03

$9.95

2,080,134

$171

$22.41

$9.34

$11.51

14.0%

8.8

Company 

Series# 

Face 

Yield 

Close$ 

S&P 

Andrews

11.4S2033

$3,188,043

12.1%

94.38

DDD

13.3S2037

$10,000

13.3%

100.00

DDD

13.3S2038

$100,000

13.3%

100.00

DDD

13.3S2039

$1,000

13.3%

100.00

DDD

Baldwin

10.9S2033

$3,013,314

11.0%

98.77

B

11.1S2034

$214,240

11.2%

99.27

B

11.0S2035

$3,339,141

11.1%

98.74

B

11.6S2036

$3,440,452

11.4%

101.40

B

11.1S2037

$10,862,334

11.2%

98.98

B

11.6S2038

$2,985,714

11.4%

101.64

B

Chester

10.8S2033

$4,277,631

11.0%

98.15

B

11.4S2034

$3,707,987

11.4%

100.00

B

11.2S2035

$756,401

11.3%

99.16

B

11.2S2036

$4,488,947

11.3%

99.07

B

11.0S2037

$5,585,510

11.2%

97.97

B

11.5S2038

$1,826,772

11.4%

100.55

B

Digby

10.8S2033

$1,153,626

10.9%

99.07

B

11.0S2035

$1,673,679

11.0%

99.58

B

11.4S2036

$8,759,083

11.2%

101.41

B

10.9S2037

$7,994,485

11.0%

98.97

B

11.4S2038

$7,372,489

11.2%

101.66

B

Erie

10.9S2033

$4,544,291

11.0%

99.38

B

11.3S2034

$465,813

11.2%

100.74

B

11.1S2035

$1,006,169

11.1%

100.00

B

11.5S2036

$3,467,088

11.3%

101.88

B

10.7S2037

$7,575,096

10.9%

97.95

B

11.6S2038

$3,462,728

11.3%

102.76

B

Ferris

11.0S2033

$18,720

11.1%

99.08

B

11.0S2035

$2,709,841

11.1%

98.74

B

11.4S2036

$3,108,582

11.3%

100.47

B

10.7S2037

$7,688,203

11.0%

96.94

B

11.5S2038

$1,207,826

11.4%

101.09

B

FOUNDATION® FAST TRACK

Page 2

Financial Summary 

<="" th="">

F128156_010

Round: 8 December 31, 2029

Cash Flow Statement Survey 

Andrews

Baldwin

Chester

Digby

Erie

Ferris

Cash flows from operating activities 

Net Income (Loss) 

($75,464)

$16,037

$4,068

$18,290

$8,418

$19,433

Adjustment for non-cash items: 

   Depreciation 

$1,555

$6,020

$5,307

$6,861

$5,193

$4,088

   Extraordinary gains/losses/writeoffs 

($1)

($69)

($94)

($111)

($58)

($4)

Changes in current assets and liabilities: 

   Accounts payable 

($201)

$3,055

($325)

$1,931

($412)

$1,716

   Inventory 

($29,127)

($4,375)

$950

($5,718)

$2,301

($11,482)

   Accounts receivable 

$546

($3,126)

$357

($2,144)

($153)

($1,426)

Net cash from operations 

($102,691)

$17,542

$10,263

$19,109

$15,289

$12,325

Cash flows from investing activities 

Plant improvements (net) 

$0

$0

$0

$0

$0

$0

Cash flows from financing activities 

Dividends paid 

($123,147)

($17,843)

($10,836)

($15,781)

($15,507)

($23,944)

Sales of common stock 

$10

$0

$0

$0

$0

$0

Purchase of common stock 

$0

$0

$0

$0

$0

($258)

Cash from long term debt issued 

$1

$0

$0

$0

$0

$0

Early retirement of long term debt 

($10)

($3,530)

($2,693)

($5,129)

($2,498)

($2,591)

Retirement of current debt 

($236,935)

($17,560)

($14,354)

($24,395)

($11,852)

($21,486)

Cash from current debt borrowing 

$200

$22,768

$13,861

$30,510

$11,870

$23,406

Cash from emergency loan 

$462,572

$0

$0

$0

$0

$0

Net cash from financing activities 

$102,691

($16,165)

($14,022)

($14,796)

($17,987)

($24,872)

Net change in cash position 

$0

$1,377

($3,759)

$4,313

($2,698)

($12,547)

Balance Sheet Survey 

Andrews

Baldwin

Chester

Digby

Erie

Ferris

Cash 

$0

$24,753

$11,778

$33,193

$11,571

$14,866

Accounts Receivable 

$516

$13,097

$5,784

$14,953

$5,746

$11,785

Inventory 

$136,032

$17,378

$9,106

$20,250

$7,071

$26,704

Total Current Assets 

$136,548

$55,228

$26,667

$68,396

$24,388

$53,355

Plant and equipment 

$23,330

$90,304

$79,606

$102,920

$77,900

$61,320

Accumulated Depreciation 

($15,492)

($33,923)

($33,445)

($35,708)

($31,225)

($21,699)

Total Fixed Assets 

$7,838

$56,381

$46,161

$67,212

$46,675

$39,621

Total Assets 

$144,386

$111,608

$72,828

$135,608

$71,063

$92,976

Accounts Payable 

$2,979

$9,038

$2,915

$8,891

$2,074

$8,220

Current Debt 

$462,772

$22,768

$13,861

$30,510

$11,870

$23,406

Total Current Liabilities 

$465,751

$31,806

$16,776

$39,401

$13,944

$31,626

Long Term Debt 

$3,299

$23,855

$20,643

$26,953

$20,521

$14,733

Total Liabilities 

$469,050

$55,661

$37,419

$66,354

$34,465

$46,359

Common Stock 

$4,043

$4,688

$6,139

$8,627

$10,497

$4,165

Retained Earnings 

($328,707)

$51,259

$29,269

$60,627

$26,101

$42,452

Total Equity 

($324,664)

$55,947

$35,408

$69,254

$36,598

$46,617

Total Liabilities & Owners' Equity 

$144,386

$111,608

$72,828

$135,608

$71,063

$92,976

Income Statement Survey 

Andrews

Baldwin

Chester

Digby

Erie

Ferris

Sales 

$6,275

$159,348

$70,368

$181,932

$69,911

$143,385

Variable Costs (Labor, Material, Carry) 

$23,441

$107,676

$44,601

$126,515

$36,063

$91,732

Contribution Margin 

($17,166)

$51,672

$25,767

$55,417

$33,848

$51,653

Depreciation 

$1,555

$6,020

$5,307

$6,861

$5,193

$4,088

SGA (R&D, Promo, Sales, Admin) 

$14,585

$12,659

$6,872

$11,898

$6,674

$8,430

Other (Fees, Writeoffs, TQM, Bonuses) 

$2,700

$2,984

$3,547

$1,966

$5,379

$4,789

EBIT 

($36,006)

$30,010

$10,041

$34,691

$16,601

$34,346

Interest (Short term, Long term) 

$80,092

$4,834

$3,655

$5,979

$3,386

$3,840

Taxes 

($40,635)

$8,812

$2,235

$10,049

$4,625

$10,677

Profit Sharing 

$0

$327

$83

$373

$172

$397

Net Profit 

($75,464)

$16,037

$4,068

$18,290

$8,418

$19,433

FOUNDATION® FAST TRACK

Page 3

Production Analysis 

<="" th="">

F128156_010

Round: 8 December 31, 2029

Andrews

Baldwin

Chester

Digby

Erie

Ferris

Units Produced

2,223

4,852

2,933

5,717

2,887

4,010

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

0

8,111

2/5/2030

4.1

9000

6.0

14.0

$25.00

$2.41

$11.94

NA 

72% 

3.0

1,039

171% 

A_Josh

Low

105

147

6/13/2029

2.1

9000

9.0

12.0

$22.00

$6.29

$13.92

-11% 

34% 

1.0

191

132% 

A_Josh

Low

198

0

10/15/2030

4.4

27000

10.0

10.0

$20.00

$13.31

$11.11

-24% 

32% 

3.0

151

131% 

A_Josh

0

0

7/31/2030

3.5

11000

7.0

13.0

$19.00

$0.00

$0.00

0% 

0% 

0.0

0

0% 

A_4

0

0

8/10/2030

2.8

11000

8.0

11.0

$17.00

$0.00

$0.00

0% 

0% 

0.0

0

0% 

Baker

Low

1,865

311

7/6/2029

2.1

18800

9.3

12.4

$27.50

$9.89

$5.48

43% 

33% 

7.5

1,350

132% 

Bold

High

1,448

424

4/28/2029

1.7

22400

11.6

7.3

$41.35

$16.96

$11.50

28% 

57% 

4.0

1,050

156% 

Best

High

1,417

18

4/18/2029

1.3

20000

11.3

10.1

$34.00

$13.70

$11.04

26% 

81% 

4.5

800

179% 

Cake

Low

2,094

219

12/17/2029

1.6

17000

8.0

10.6

$19.00

$8.71

$2.73

39% 

44% 

9.0

1,350

144% 

Cent

High

941

317

8/16/2029

1.3

20000

10.7

7.9

$32.50

$13.51

$7.48

33% 

11% 

5.0

900

110% 

Daze

Low

1,833

370

9/11/2029

1.5

18000

8.7

11.5

$27.50

$9.85

$4.71

44% 

33% 

8.0

1,350

133% 

Dabble

High

1,690

413

7/15/2029

1.4

22000

12.9

7.8

$40.25

$17.83

$11.58

25% 

61% 

4.0

1,150

160% 

Dust

Low

1,985

110

7/8/2029

1.3

20000

10.4

9.8

$32.00

$13.36

$10.42

25% 

100% 

5.0

1,050

199% 

Eat

Low

1,503

338

10/24/2029

2.1

16500

8.2

12.2

$23.50

$7.40

$4.16

49% 

43% 

8.0

1,050

142% 

East

Low

1,472

259

10/24/2029

2.1

16500

7.5

11.5

$23.50

$7.48

$4.13

48% 

40% 

8.0

1,000

139% 

Fast

High

1,835

560

7/30/2029

1.4

22000

12.8

6.9

$40.50

$16.33

$9.21

35% 

75% 

4.9

1,200

173% 

Feast

High

1,706

507

7/30/2029

1.4

22000

12.4

7.4

$40.50

$15.65

$8.95

37% 

56% 

4.9

1,250

154% 

FOUNDATION® FAST TRACK

Page 4

Low Tech Market Segment Analysis 

<="" th="">

F128156_010

Round: 8 December 31, 2029

Perceptual Map for Low 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

Cake

19%

2,093

12/17/2029

8.0

10.6

$19.00

17000

1.56

$1,025

66%

$1,150

65%

35

Baker

17%

1,865

7/6/2029

9.3

12.4

$27.50

18800

2.11

$1,350

95%

$1,250

63%

37

Daze

17%

1,815

9/11/2029

8.7

11.5

$27.50

18000

1.54

$1,450

100%

$1,100

66%

33

Eat

14%

1,503

10/24/2029

8.2

12.2

$23.50

16500

2.14

$1,000

63%

$1,000

63%

30

East

14%

1,472

10/24/2029

7.5

11.5

$23.50

16500

2.10

$1,000

62%

$1,000

63%

29

Dust

10%

1,036

7/8/2029

10.4

9.8

$32.00

20000

1.31

$1,700

94%

$1,100

66%

21

Best

4%

483

4/18/2029

11.3

10.1

$34.00

20000

1.26

$1,350

70%

$1,250

63%

13

Cent

2%

255

8/16/2029

10.7

7.9

$32.50

20000

1.30

$1,025

65%

$1,150

65%

2

A_Josh

2%

177

10/15/2030

YES

10.0

10.0

$20.00

27000

4.41

$700

36%

$500

69%

36

A_Josh

1%

105

6/13/2029

9.0

12.0

$22.00

9000

2.11

$1,000

63%

$1,600

69%

0

FOUNDATION® FAST TRACK

Page 5

High Tech Market Segment Analysis 

<="" th="">

F128156_010

Round: 8 December 31, 2029

Perceptual Map for 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,835

7/30/2029

12.8

6.9

$40.50

22000

1.42

$1,500

100%

$1,150

76%

50

Feast

18%

1,706

7/30/2029

12.4

7.4

$40.50

22000

1.39

$1,500

100%

$1,150

76%

47

Dabble

18%

1,690

7/15/2029

12.9

7.8

$40.25

22000

1.42

$1,450

99%

$1,100

76%

45

Bold

16%

1,448

4/28/2029

11.6

7.3

$41.35

22400

1.66

$1,350

91%

$1,250

70%

33

Dust

10%

948

7/8/2029

10.4

9.8

$32.00

20000

1.31

$1,700

94%

$1,100

76%

24

Best

10%

934

4/18/2029

11.3

10.1

$34.00

20000

1.26

$1,350

70%

$1,250

70%

21

Cent

7%

686

8/16/2029

10.7

7.9

$32.50

20000

1.30

$1,025

65%

$1,150

33%

19

A_Josh

0%

21

10/15/2030

YES

10.0

10.0

$20.00

27000

4.41

$700

36%

$500

14%

4

Daze

0%

19

9/11/2029

8.7

11.5

$27.50

18000

1.54

$1,450

100%

$1,100

76%

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

Market Share Report 

<="" th="">

F128156_010

Round: 8 December 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

A_Josh

1.0%

0.5%

A_Josh

1.6%

0.2%

1.0%

Total

2.6%

0.2%

1.5%

Baker

17.3%

9.3%

Bold

15.6%

7.2%

Best

4.5%

10.1%

7.0%

Total

21.7%

25.6%

23.5%

Cake

19.4%

0.0%

10.4%

Cent

2.4%

7.4%

4.7%

Total

21.7%

7.4%

15.1%

Daze

16.8%

0.2%

9.1%

Dabble

18.2%

8.4%

Dust

9.6%

10.2%

9.9%

Total

26.4%

28.6%

27.4%

Eat

13.9%

7.5%

East

13.6%

7.3%

Total

27.5%

14.8%

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

A_Josh

4.0%

2.2%

A_Josh

14.7%

2.0%

8.8%

Total

18.8%

2.0%

11.0%

Baker

14.4%

7.7%

Bold

15.3%

7.1%

Best

3.9%

9.9%

6.7%

Total

18.3%

25.2%

21.5%

Cake

16.2%

8.7%

Cent

1.9%

7.3%

4.4%

Total

18.1%

7.3%

13.1%

Daze

14.0%

0.2%

7.6%

Dabble

17.9%

8.3%

Dust

8.0%

10.0%

8.9%

Total

22.0%

28.1%

24.8%

Eat

11.6%

6.2%

East

11.3%

6.1%

Total

22.9%

12.3%

Fast

19.4%

9.0%

Feast

18.0%

8.3%

Total

37.4%

17.3%

FOUNDATION® FAST TRACK

Page 7

Perceptual Map 

<="" th="">

F128156_010

Round: 8 December 31, 2029

Perceptual Map for All Segments

Andrews

Name

Pfmn

Size

Revised

Able

6.0

14.0

2/5/2030

A_Josh

9.0

12.0

6/13/2029

A_Josh

10.0

10.0

10/15/2030

A_Josh

7.0

13.0

7/31/2030

A_4

8.0

11.0

8/10/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

HR/TQM Report 

<="" th="">

F128156_010

Round: 8 December 31, 2029

Andrews

Baldwin

Chester

Digby

Erie

Ferris

Needed Complement

360

601

187

686

166

488

Complement

360

601

187

686

166

488

1st Shift Complement

223

381

153

408

117

295

2nd Shift Complement

137

220

34

278

49

193

Overtime%

0.0%

0.0%

0.0%

0.0%

0.0%

0.0%

Turnover Rate

8.7%

8.1%

8.2%

8.0%

8.4%

7.9%

New Employees

31

242

15

162

14

115

Separated Employees

9

0

30

0

64

0

Recruiting Spend

$50

$2,500

$2,400

$2,800

$2,400

$2,300

Training Hours

30

40

40

38

30

40

Productivity Index

109.2%

110.0%

114.5%

111.8%

111.6%

112.5%

Recruiting Cost

$33

$846

$52

$615

$48

$381

Separation Cost

$45

$0

$152

$0

$319

$0

Training Cost

$216

$481

$149

$521

$100

$390

Total HR Admin Cost

$294

$1,327

$353

$1,136

$466

$771

Strike Days

Andrews

Baldwin

Chester

Digby

Erie

Ferris

Process Mgt Budgets Last Year

CPI Systems

$200

$0

$900

$0

$900

$0

Vendor/JIT

$250

$0

$900

$0

$900

$950

Quality Initiative Training

$500

$0

$900

$0

$900

$0

Channel Support Systems

$200

$750

$0

$1,000

$0

$950

Concurrent Engineering

$300

$750

$0

$0

$0

$0

UNEP Green Programs

$250

$0

$0

$0

$900

$950

TQM Budgets Last Year

Benchmarking

$300

$0

$0

$1,000

$0

$0

Quality Function Deployment Effort

$300

$750

$0

$0

$0

$0

CCE/6 Sigma Training

$200

$0

$900

$0

$900

$950

GEMI TQEM Sustainability Initiatives

$200

$750

$0

$0

$900

$950

Total Expenditures

$2,700

$3,000

$3,600

$2,000

$5,400

$4,750

Cumulative Impacts

Material Cost Reduction

10.91%

1.89%

11.80%

0.00%

11.80%

11.73%

Labor Cost Reduction

13.68%

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

13.71%

14.37%

4.20%

11.16%

8.05%

14.40%

FOUNDATION® FAST TRACK

Page 9

Ethics Report 

<="" th="">

F128156_010

Round: 8 December 31, 2029

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