Final Project OL421

Stocks & Bonds

<="" th="">

F96840_013

Round: 6 December 31 , 2024

Company

Close

Change

Shares

MarketCap ($M)

Book Value

EPS

Dividend

Yield

P/E

Andrews

$1.00

$0.00

2,533,137

$3

($31.28)

($13.84)

$0.00

0.0%

-0.1

Baldwin

$41.39

($3.14)

2,215,401

$92

$20.64

$2.86

$1.73

4.2%

14.5

Chester

$34.53

$0.18

2,307,294

$80

$16.30

$2.45

$2.76

8.0%

14.1

Digby

$55.76

$3.44

2,192,603

$122

$23.74

$5.30

$3.94

7.1%

10.5

Erie

$30.29

($0.21)

2,376,679

$72

$14.69

$2.09

$2.32

7.7%

14.5

Ferris

$56.46

$9.49

2,084,002

$118

$20.29

$6.25

$3.77

6.7%

9.0

Company

Series#

Face

Yield

Close$

S&P

Andrews

13.3S2034

$800,000

13.3%

100.00

DDD

Baldwin

10.0S2029

$2,480,000

10.6%

94.17

CCC

11.0S2030

$5,014,602

11.3%

97.50

CCC

11.0S2031

$1,573,043

11.3%

97.23

CCC

11.0S2032

$4,653,328

11.3%

96.98

CCC

11.5S2033

$2,370,240

11.6%

99.46

CCC

11.1S2034

$9,797,138

11.4%

97.13

CCC

Chester

10.0S2029

$2,361,878

10.6%

94.17

CCC

10.8S2030

$4,941,424

11.2%

96.67

CCC

11.3S2031

$4,485,113

11.5%

98.61

CCC

11.3S2032

$3,672,314

11.5%

98.49

CCC

11.2S2033

$1,521,172

11.4%

97.84

CCC

11.1S2034

$6,879,747

11.4%

97.13

CCC

Digby

10.0S2029

$2,287,212

10.5%

94.88

B

10.9S2030

$4,840,957

11.1%

97.91

B

11.0S2032

$3,314,759

11.2%

97.97

B

11.5S2033

$8,810,113

11.4%

100.55

B

10.9S2034

$8,048,076

11.2%

97.10

B

Erie

10.0S2029

$2,361,878

10.7%

93.83

CCC

10.9S2030

$5,014,581

11.3%

96.68

CCC

11.2S2031

$1,139,179

11.5%

97.70

CCC

11.0S2032

$1,137,334

11.4%

96.49

CCC

11.7S2033

$3,660,798

11.7%

100.00

CCC

10.8S2034

$9,816,837

11.4%

94.85

CCC

Ferris

10.0S2029

$420,545

10.6%

94.53

CCC

11.0S2030

$2,973,227

11.2%

97.92

CCC

10.9S2032

$1,686,491

11.2%

96.97

CCC

11.4S2033

$3,261,788

11.5%

99.46

CCC

10.7S2034

$8,200,163

11.2%

95.39

CCC

FOUNDATION® FAST TRACK

Page 2

Financial Summary

<="" th="">

F96840_013

Round: 6 December 31, 2024

Cash Flow Statement Survey

Andrews

Baldwin

Chester

Digby

Erie

Ferris

Cash flows from operating activities

Net Income (Loss)

($35,056)

$6,329

$5,663

$11,632

$4,968

$13,033

Adjustment for non-cash items:

   Depreciation

$1,906

$4,787

$5,114

$5,808

$4,873

$3,747

   Extraordinary gains/losses/writeoffs

($1)

$0

$0

$0

$0

$0

Changes in current assets and liabilities:

   Accounts payable

($152)

($107)

$1,132

$2,408

$239

$1,006

   Inventory

($24,819)

($2,902)

($6,397)

($6,285)

($5,892)

($4,866)

   Accounts receivable

($60)

$599

($1,017)

($2,428)

$56

($751)

Net cash from operations

($58,181)

$8,705

$4,495

$11,134

$4,245

$12,168

Cash flows from investing activities

Plant improvements (net)

$0

($19,700)

($14,200)

($17,400)

($20,600)

($17,920)

Cash flows from financing activities

Dividends paid

$0

($3,837)

($6,359)

($8,631)

($5,523)

($7,858)

Sales of common stock

$0

$0

$0

$0

$0

$0

Purchase of common stock

$0

$0

$0

$0

$0

$0

Cash from long term debt issued

$800

$9,797

$6,880

$8,048

$9,817

$8,200

Early retirement of long term debt

($500)

$0

$0

$0

$0

$0

Retirement of current debt

($138,265)

($17,083)

($13,593)

($17,096)

($11,623)

($13,849)

Cash from current debt borrowing

$0

$18,363

$12,615

$18,929

$12,823

$20,304

Cash from emergency loan

$196,146

$0

$0

$0

$0

$0

Net cash from financing activities

$58,181

$7,241

($458)

$1,250

$5,494

$6,797

Net change in cash position

$0

($3,755)

($10,163)

($5,016)

($10,862)

$1,045

Balance Sheet Survey

Andrews

Baldwin

Chester

Digby

Erie

Ferris

Cash

$0

$15,911

$10,967

$14,471

$10,586

$24,057

Accounts Receivable

$572

$7,726

$6,775

$10,894

$5,688

$9,477

Inventory

$106,284

$14,852

$10,021

$18,066

$8,490

$12,291

Total Current Assets

$106,856

$38,489

$27,763

$43,432

$24,764

$45,825

Plant and equipment

$28,590

$82,604

$76,708

$87,120

$73,100

$56,200

Accumulated Depreciation

($13,442)

($23,343)

($23,853)

($23,224)

($21,578)

($13,887)

Total Fixed Assets

$15,148

$59,261

$52,855

$63,896

$51,522

$42,313

Total Assets

$122,004

$97,750

$80,618

$107,327

$76,286

$88,138

Accounts Payable

$2,405

$5,175

$3,923

$6,449

$2,831

$6,408

Current Debt

$198,044

$20,963

$15,215

$21,529

$15,423

$22,904

Long Term Debt

$800

$25,888

$23,862

$27,301

$23,131

$16,542

Total Liabilities

$201,249

$52,026

$42,999

$55,279

$41,384

$45,854

Common Stock

$4,723

$5,154

$6,889

$6,825

$8,620

$4,059

Retained Earnings

($83,968)

$40,569

$30,729

$45,223

$26,281

$38,226

Total Equity

($79,245)

$45,724

$37,618

$52,048

$34,902

$42,284

Total Liabilities & Owners' Equity

$122,004

$97,750

$80,618

$107,327

$76,286

$88,138

Income Statement Survey

Andrews

Baldwin

Chester

Digby

Erie

Ferris

Sales

$6,955

$93,997

$82,428

$132,548

$69,204

$115,302

Variable Costs (Labor, Material, Carry)

$17,195

$61,842

$52,083

$90,042

$40,050

$74,573

Depreciation

$1,906

$4,787

$5,114

$5,808

$4,873

$3,747

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

$4,347

$9,066

$6,495

$10,979

$6,617

$8,431

Other (Fees, Writeoffs, TQM, Bonuses)

$3,316

$3,490

$5,744

$2,402

$5,891

$4,160

EBIT

($19,809)

$14,813

$12,992

$23,317

$11,774

$24,392

Interest (Short term, Long term)

$34,123

$4,878

$4,102

$5,057

$3,974

$3,932

Taxes

($18,876)

$3,477

$3,112

$6,391

$2,730

$7,161

Profit Sharing

$0

$129

$116

$237

$101

$266

Net Profit

($35,056)

$6,329

$5,663

$11,632

$4,968

$13,033

FOUNDATION® FAST TRACK

Page 3

Production Analysis

<="" th="">

F96840_013

Round: 6 December 31, 2024

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

162

4,619

10/26/2024

1.8

11200

9.1

13.2

$34.00

$8.99

$13.92

-190%

0%

1.0

1,420

87%

A-Prod

Low

40

158

6/19/2024

2.7

10100

7.0

12.0

$36.00

$7.55

$13.92

16%

0%

1.0

135

73%

Baker

Low

1,626

457

7/21/2024

1.7

18800

8.7

13.1

$29.10

$10.94

$6.62

37%

29%

7.5

1,400

127%

Bold

High

1,114

240

4/9/2024

1.6

22400

10.3

8.6

$41.90

$17.33

$10.46

32%

35%

4.0

1,000

134%

Best

0

0

3/9/2025

0.0

0

0.0

0.0

$0.00

$0.00

$0.00

0%

0%

4.5

450

0%

Cake

Low

2,035

375

1/6/2024

3.2

17000

7.2

11.4

$22.60

$9.31

$4.71

35%

72%

9.0

1,250

171%

Cent

Low

1,024

219

9/17/2024

1.2

20000

9.0

9.5

$35.60

$13.05

$8.68

39%

67%

5.0

950

166%

Daze

Low

1,949

557

7/12/2024

2.4

18000

7.7

12.5

$28.20

$10.14

$7.85

33%

73%

7.0

1,300

172%

Dabble

High

1,190

283

8/3/2024

1.3

22000

11.4

9.2

$42.60

$17.72

$10.55

32%

47%

4.0

1,050

146%

Dust

High

805

0

3/9/2024

0.8

20000

9.2

11.0

$33.40

$13.47

$9.72

29%

100%

5.0

800

161%

Eat

Low

1,340

408

10/2/2024

2.1

16500

7.7

12.7

$26.40

$8.42

$6.84

42%

68%

7.0

1,100

168%

East

Low

1,282

162

10/2/2024

2.0

16500

7.0

12.0

$26.40

$8.48

$6.95

43%

81%

7.0

1,050

180%

Fast

High

1,467

191

7/29/2024

1.4

22000

11.4

8.3

$41.00

$16.84

$9.55

35%

100%

4.9

1,100

198%

Feast

High

1,346

284

7/29/2024

1.3

22000

11.0

8.8

$41.00

$16.09

$9.49

36%

94%

4.9

1,150

192%

FOUNDATION® FAST TRACK

Page 4

Low Tech Market Segment Analysis

<="" th="">

F96840_013

Round: 6 December 31, 2024

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

21%

1,881

1/6/2024

7.2

11.4

$22.60

17000

3.17

$1,025

65%

$1,150

64%

37

Daze

21%

1,831

7/12/2024

7.7

12.5

$28.20

18000

2.38

$1,450

100%

$1,100

55%

36

Baker

17%

1,511

7/21/2024

8.7

13.1

$29.10

18800

1.74

$1,350

93%

$1,250

44%

26

Eat

15%

1,330

10/2/2024

7.7

12.7

$26.40

16500

2.11

$1,000

62%

$1,000

58%

26

East

14%

1,274

10/2/2024

7.0

12.0

$26.40

16500

2.02

$1,000

58%

$1,000

58%

23

Cent

7%

583

9/17/2024

9.0

9.5

$35.60

20000

1.22

$1,025

61%

$1,150

64%

8

Dust

4%

314

3/9/2024

YES

9.2

11.0

$33.40

20000

0.81

$1,450

60%

$1,100

55%

12

Able

2%

162

10/26/2024

9.1

13.2

$34.00

11200

1.84

$0

61%

$100

15%

2

A-Prod

0%

40

6/19/2024

7.0

12.0

$36.00

10100

2.71

$0

43%

$100

15%

1

Dabble

0%

2

8/3/2024

11.4

9.2

$42.60

22000

1.35

$1,450

92%

$1,100

55%

0

FOUNDATION® FAST TRACK

Page 5

High Tech Market Segment Analysis

<="" th="">

F96840_013

Round: 6 December 31, 2024

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

23%

1,467

7/29/2024

11.4

8.3

$41.00

22000

1.43

$1,500

100%

$1,150

74%

47

Feast

21%

1,345

7/29/2024

11.0

8.8

$41.00

22000

1.33

$1,500

90%

$1,150

74%

44

Dabble

18%

1,188

8/3/2024

11.4

9.2

$42.60

22000

1.35

$1,450

92%

$1,100

77%

39

Bold

17%

1,114

4/9/2024

10.3

8.6

$41.90

22400

1.55

$1,350

84%

$1,250

53%

30

Dust

8%

491

3/9/2024

YES

9.2

11.0

$33.40

20000

0.81

$1,450

60%

$1,100

77%

22

Cent

7%

441

9/17/2024

9.0

9.5

$35.60

20000

1.22

$1,025

61%

$1,150

37%

16

Cake

2%

154

1/6/2024

7.2

11.4

$22.60

17000

3.17

$1,025

65%

$1,150

37%

2

Daze

2%

118

7/12/2024

7.7

12.5

$28.20

18000

2.38

$1,450

100%

$1,100

77%

3

Baker

2%

114

7/21/2024

8.7

13.1

$29.10

18800

1.74

$1,350

93%

$1,250

53%

4

Eat

0%

10

10/2/2024

7.7

12.7

$26.40

16500

2.11

$1,000

62%

$1,000

20%

1

East

0%

8

10/2/2024

7.0

12.0

$26.40

16500

2.02

$1,000

58%

$1,000

20%

1

FOUNDATION® FAST TRACK

Page 6

Market Share Report

<="" th="">

F96840_013

Round: 6 December 31, 2024

Actual Market Share in Units

Low

High

Total

Industry Unit Sales

8,929

6,450

15,378

% of Market

58.1%

41.9%

100.0%

Able

1.8%

1.1%

A-Prod

0.5%

0.3%

Total

2.3%

1.3%

Baker

16.9%

1.8%

10.6%

Bold

17.3%

7.3%

Total

16.9%

19.1%

17.8%

Cake

21.1%

2.4%

13.2%

Cent

6.5%

6.8%

6.7%

Total

27.6%

9.2%

19.9%

Daze

20.5%

1.8%

12.7%

Dabble

0.0%

18.4%

7.7%

Dust

3.5%

7.6%

5.2%

Total

24.1%

27.9%

25.6%

Eat

14.9%

0.1%

8.7%

East

14.3%

0.1%

8.3%

Total

29.2%

0.3%

17.1%

Fast

22.7%

9.5%

Feast

20.9%

8.8%

Total

43.6%

18.3%

Potential Market Share in Units

Low

High

Total

Units Demanded

8,929

6,450

15,378

% of Market

58.1%

41.9%

100.0%

Able

1.8%

1.0%

A-Prod

0.4%

0.3%

Total

2.2%

1.3%

Baker

16.7%

1.7%

10.4%

Bold

16.7%

7.0%

Total

16.7%

18.4%

17.4%

Cake

20.8%

2.3%

13.0%

Cent

6.4%

6.6%

6.5%

Total

27.2%

8.9%

19.6%

Daze

20.2%

1.8%

12.5%

Dabble

17.9%

7.5%

Dust

4.7%

10.4%

7.1%

Total

25.0%

30.0%

27.1%

Eat

14.7%

0.1%

8.6%

East

14.1%

0.1%

8.2%

Total

28.8%

0.3%

16.8%

Fast

22.1%

9.3%

Feast

20.2%

8.5%

Total

42.3%

17.8%

FOUNDATION® FAST TRACK

Page 7

Perceptual Map

<="" th="">

F96840_013

Round: 6 December 31, 2024

Perceptual Map for All Segments

Andrews

Name

Pfmn

Size

Revised

Able

9.1

13.2

10/26/2024

A-Prod

7.0

12.0

6/19/2024

Alpha

8.5

10.5

9/14/2024

Aqua

9.0

8.5

12/15/2024

All

5.0

12.2

4/11/2025

Baldwin

Name

Pfmn

Size

Revised

Baker

8.7

13.1

7/21/2024

Bold

10.3

8.6

4/9/2024

Chester

Name

Pfmn

Size

Revised

Cake

7.2

11.4

1/6/2024

Cent

9.0

9.5

9/17/2024

Digby

Name

Pfmn

Size

Revised

Daze

7.7

12.5

7/12/2024

Dabble

11.4

9.2

8/3/2024

Dust

9.2

11.0

3/9/2024

Erie

Name

Pfmn

Size

Revised

Eat

7.7

12.7

10/2/2024

East

7.0

12.0

10/2/2024

Ferris

Name

Pfmn

Size

Revised

Fast

11.4

8.3

7/29/2024

Feast

11.0

8.8

7/29/2024

FOUNDATION® FAST TRACK

Page 8

HR/TQM Report

<="" th="">

F96840_013

Round: 6 December 31, 2024

Andrews

Baldwin

Chester

Digby

Erie

Ferris

Needed Complement

319

370

305

563

303

407

Complement

319

370

305

563

303

407

1st Shift Complement

319

281

180

337

174

207

2nd Shift Complement

0

89

125

226

129

200

Overtime%

0.1%

0.0%

0.0%

0.0%

0.0%

0.0%

Turnover Rate

10.0%

8.5%

8.3%

8.3%

8.5%

8.0%

New Employees

32

31

85

211

39

88

Separated Employees

5

60

0

0

0

0

Recruiting Spend

$0

$2,000

$1,800

$2,700

$2,400

$2,300

Training Hours

0

30

40

34

30

40

Productivity Index

100.0%

108.4%

109.0%

108.2%

107.8%

109.1%

Recruiting Cost

$32

$94

$238

$782

$131

$290

Separation Cost

$25

$301

$0

$0

$0

$0

Training Cost

$0

$222

$244

$383

$182

$326

Total HR Admin Cost

$57

$617

$482

$1,165

$313

$615

Strike Days

Andrews

Baldwin

Chester

Digby

Erie

Ferris

Process Mgt Budgets Last Year

CPI Systems

$500

$0

$900

$0

$900

$0

Vendor/JIT

$350

$0

$900

$0

$900

$750

Quality Initiative Training

$410

$0

$900

$0

$900

$0

Channel Support Systems

$280

$750

$0

$1,000

$0

$750

Concurrent Engineering

$300

$750

$0

$0

$0

$0

UNEP Green Programs

$260

$0

$900

$0

$900

$750

TQM Budgets Last Year

Benchmarking

$220

$0

$0

$1,000

$0

$0

Quality Function Deployment Effort

$300

$750

$0

$0

$0

$0

CCE/6 Sigma Training

$370

$0

$900

$0

$900

$750

GEMI TQEM Sustainability Initiatives

$280

$750

$900

$0

$900

$750

Total Expenditures

$3,270

$3,000

$5,400

$2,000

$5,400

$3,750

Cumulative Impacts

Material Cost Reduction

1.55%

0.53%

11.59%

0.00%

11.59%

9.15%

Labor Cost Reduction

1.60%

0.05%

13.82%

0.00%

13.82%

4.74%

Reduction R&D Cycle Time

10.33%

40.01%

0.00%

0.00%

0.00%

0.00%

Reduction Admin Costs

3.58%

0.00%

25.22%

57.89%

25.22%

22.03%

Demand Increase

3.37%

12.55%

3.69%

5.99%

3.69%

12.27%

FOUNDATION® FAST TRACK

Page 9

Ethics Report

<="" th="">

F96840_013

Round: 6 December 31, 2024

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