Final Project OL421

Stocks & Bonds

F96840_013

Round: 4 December 31 , 2022

Company

Close

Change

Shares

MarketCap ($M)

Book Value

EPS

Dividend

Yield

P/E

Andrews

$1.00

$0.00

2,233,137

$2

($6.44)

($9.01)

$0.00

0.0%

-0.1

Baldwin

$40.32

$4.08

2,215,401

$89

$16.24

$3.68

$2.63

6.5%

10.9

Chester

$25.72

$7.43

2,307,294

$59

$14.17

$2.86

$0.00

0.0%

9.0

Digby

$42.83

$5.02

2,134,224

$91

$15.56

$4.15

$3.39

7.9%

10.3

Erie

$21.85

$1.32

2,206,190

$48

$10.48

$1.57

$1.90

8.7%

13.9

Ferris

$27.60

$7.30

2,052,583

$57

$10.73

$3.07

$2.56

9.3%

9.0

Company

Series#

Face

Yield

Close$

S&P

Andrews

13.0S2024

$2,600,000

13.1%

99.50

DDD

Baldwin

13.0S2024

$2,600,000

12.7%

102.55

CCC

10.0S2029

$2,480,000

10.7%

93.04

CCC

11.0S2030

$5,014,602

11.3%

97.47

CCC

11.0S2031

$1,573,043

11.3%

97.28

CCC

11.0S2032

$4,653,328

11.3%

97.12

CCC

Chester

13.0S2024

$2,600,000

12.6%

103.07

B

10.0S2029

$2,361,878

10.6%

94.38

B

10.8S2030

$4,941,424

11.0%

97.96

B

11.3S2031

$4,485,113

11.2%

100.55

B

11.3S2032

$3,672,314

11.2%

100.58

B

Digby

13.0S2024

$2,600,000

12.7%

102.55

CCC

10.0S2029

$2,287,212

10.7%

93.04

CCC

10.9S2030

$4,840,957

11.2%

96.97

CCC

11.0S2032

$3,314,759

11.3%

97.12

CCC

Erie

13.0S2024

$2,600,000

12.7%

102.21

CCC

10.0S2029

$2,361,878

10.8%

92.17

CCC

10.9S2030

$5,014,581

11.4%

95.98

CCC

11.2S2031

$1,139,179

11.5%

97.31

CCC

11.0S2032

$1,137,334

11.5%

96.00

CCC

Ferris

13.0S2024

$2,600,000

12.7%

102.73

B

10.0S2029

$420,545

10.7%

93.49

B

11.0S2030

$2,973,227

11.2%

97.97

B

10.9S2032

$1,686,491

11.2%

97.10

B

FOUNDATION® FAST TRACK

Page 2

Financial Summary

F96840_013

Round: 4 December 31, 2022

Cash Flow Statement Survey

Andrews

Baldwin

Chester

Digby

Erie

Ferris

Cash flows from operating activities

Net Income (Loss)

($20,121)

$8,161

$6,606

$8,855

$3,470

$6,304

Adjustment for non-cash items:

   Depreciation

$1,466

$3,560

$3,513

$3,108

$2,745

$1,827

   Extraordinary gains/losses/writeoffs

($1)

$0

$0

$0

$0

$0

Changes in current assets and liabilities:

   Accounts payable

($53)

($488)

$289

($231)

$484

$1,842

   Inventory

($20,621)

($6,328)

($185)

($5,174)

($1,383)

($6,290)

   Accounts receivable

$25

$241

($1,339)

($51)

($905)

($1,943)

Net cash from operations

($39,305)

$5,146

$8,884

$6,507

$4,411

$1,741

Cash flows from investing activities

Plant improvements (net)

($4,920)

($11,900)

($7,500)

($9,035)

($3,222)

($3,500)

Cash flows from financing activities

Dividends paid

$0

($5,822)

$0

($7,239)

($4,192)

($5,254)

Sales of common stock

$100

$0

$662

$0

$0

$0

Purchase of common stock

$0

$0

$0

$0

$0

$0

Cash from long term debt issued

$0

$4,653

$3,672

$3,315

$1,137

$1,686

Early retirement of long term debt

($100)

$0

$0

$0

$0

$0

Retirement of current debt

($31,334)

($11,705)

($6,579)

($12,973)

($6,693)

($8,158)

Cash from current debt borrowing

$1,000

$16,238

$8,593

$16,880

$10,214

$9,696

Cash from emergency loan

$74,559

$0

$0

$0

$0

$0

Net cash from financing activities

$44,225

$3,365

$6,348

($17)

$466

($2,029)

Net change in cash position

$0

($3,389)

$7,733

($2,545)

$1,655

($3,789)

Balance Sheet Survey

Andrews

Baldwin

Chester

Digby

Erie

Ferris

Cash

$0

$13,805

$15,779

$12,919

$11,516

$8,557

Accounts Receivable

$768

$7,692

$6,112

$7,439

$5,366

$6,177

Inventory

$54,467

$15,206

$4,166

$15,605

$5,240

$10,866

Total Current Assets

$55,235

$36,703

$26,057

$35,963

$22,121

$25,600

Plant and equipment

$21,990

$53,404

$52,692

$46,620

$41,180

$27,400

Accumulated Depreciation

($9,630)

($14,362)

($14,572)

($13,635)

($13,204)

($7,588)

Total Fixed Assets

$12,360

$39,042

$38,120

$32,985

$27,976

$19,812

Total Assets

$67,595

$75,745

$64,177

$68,948

$50,097

$45,412

Accounts Payable

$2,175

$5,480

$3,092

$4,312

$2,778

$4,410

Current Debt

$77,191

$17,972

$10,326

$18,392

$11,948

$11,293

Long Term Debt

$2,600

$16,321

$18,061

$13,043

$12,253

$7,680

Total Liabilities

$81,966

$39,773

$31,479

$35,747

$26,978

$23,383

Common Stock

$4,423

$5,154

$6,889

$4,325

$4,894

$3,191

Retained Earnings

($18,795)

$30,817

$25,809

$28,876

$18,224

$18,837

Total Equity

($14,371)

$35,972

$32,698

$33,201

$23,118

$22,029

Total Liabilities & Owners' Equity

$67,595

$75,745

$64,177

$68,948

$50,097

$45,412

Income Statement Survey

Andrews

Baldwin

Chester

Digby

Erie

Ferris

Sales

$9,350

$93,584

$74,360

$90,509

$65,284

$75,154

Variable Costs (Labor, Material, Carry)

$12,382

$62,174

$45,460

$59,657

$43,330

$48,665

Depreciation

$1,466

$3,560

$3,513

$3,108

$2,745

$1,827

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

$11,975

$8,258

$6,348

$8,452

$5,783

$8,968

Other (Fees, Writeoffs, TQM, Bonuses)

$985

$3,233

$5,617

$2,166

$5,457

$3,834

EBIT

($17,459)

$16,359

$13,423

$17,126

$7,968

$11,861

Interest (Short term, Long term)

$13,496

$3,548

$3,052

$3,225

$2,520

$1,964

Taxes

($10,834)

$4,484

$3,630

$4,866

$1,907

$3,464

Profit Sharing

$0

$167

$135

$181

$71

$129

Net Profit

($20,121)

$8,161

$6,606

$8,855

$3,470

$6,304

FOUNDATION® FAST TRACK

Page 3

Production Analysis

F96840_013

Round: 4 December 31, 2022

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

267

2,489

7/30/2020

3.9

11000

6.0

13.2

$35.00

$8.03

$12.84

-32%

67%

1.0

820

151%

A-Prod

0

0

2/8/2020

2.9

9000

5.5

14.0

$37.00

$0.00

$0.00

0%

0%

1.0

75

0%

Alpha

0

0

2/8/2021

1.9

13100

7.0

13.0

$35.00

$0.00

$0.00

0%

0%

1.0

0

0%

Aqua

0

0

2/23/2022

0.9

10350

6.8

11.3

$34.00

$0.00

$0.00

0%

0%

0.0

0

0%

Baker

Low

1,826

415

4/16/2022

2.4

19800

7.0

13.6

$33.40

$11.22

$9.68

34%

60%

5.0

1,400

158%

Bold

High

770

228

5/30/2022

1.3

22400

8.8

10.1

$42.35

$17.18

$10.48

32%

64%

4.0

800

162%

Cake

Low

1,790

212

7/17/2021

3.4

17000

5.8

13.4

$25.20

$8.91

$5.59

38%

71%

7.5

1,200

170%

Cent

Low

786

41

8/16/2022

1.0

20000

7.3

11.3

$37.20

$13.10

$9.38

40%

100%

4.5

416

199%

Daze

Low

1,635

425

6/15/2022

2.3

19000

7.2

13.0

$34.00

$11.73

$9.89

34%

50%

4.8

1,300

149%

Dabble

High

776

222

6/29/2022

1.2

22000

9.7

10.6

$45.00

$17.40

$11.19

35%

43%

3.8

700

142%

Eat

Low

1,349

252

5/28/2022

2.0

16500

6.9

13.5

$27.60

$9.63

$7.25

36%

47%

5.6

950

147%

East

Low

951

43

1/8/2022

1.8

16500

6.2

12.8

$29.50

$9.70

$10.10

31%

100%

5.6

500

199%

Fast

High

877

280

7/10/2022

1.5

22000

10.0

9.7

$44.00

$18.06

$10.38

33%

82%

4.5

600

180%

Feast

High

831

109

7/10/2022

1.0

22000

9.6

10.2

$44.00

$17.21

$10.05

37%

58%

4.5

600

157%

FOUNDATION® FAST TRACK

Page 4

Low Tech Market Segment Analysis

F96840_013

Round: 4 December 31, 2022

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

23%

1,696

7/17/2021

5.8

13.4

$25.20

17000

3.36

$1,025

63%

$1,150

51%

28

Baker

22%

1,597

4/16/2022

7.0

13.6

$33.40

19800

2.42

$1,350

88%

$1,350

48%

29

Daze

19%

1,398

6/15/2022

7.2

13.0

$34.00

19000

2.30

$1,450

95%

$1,450

45%

24

Eat

16%

1,177

5/28/2022

6.9

13.5

$27.60

16500

1.98

$1,000

57%

$1,000

47%

21

East

10%

745

1/8/2022

6.2

12.8

$29.50

16500

1.80

$1,000

50%

$1,000

47%

15

Cent

6%

455

8/16/2022

7.3

11.3

$37.20

20000

1.01

$1,025

54%

$1,150

51%

8

Able

4%

267

7/30/2020

6.0

13.2

$35.00

11000

3.86

$1,750

100%

$1,750

32%

4

Bold

1%

40

5/30/2022

8.8

10.1

$42.35

22400

1.28

$1,350

68%

$1,350

48%

1

Feast

0%

6

7/10/2022

9.6

10.2

$44.00

22000

1.04

$1,500

67%

$1,500

13%

0

FOUNDATION® FAST TRACK

Page 5

High Tech Market Segment Analysis

F96840_013

Round: 4 December 31, 2022

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%

877

7/10/2022

10.0

9.7

$44.00

22000

1.46

$1,500

98%

$1,500

67%

38

Feast

18%

826

7/10/2022

9.6

10.2

$44.00

22000

1.04

$1,500

67%

$1,500

67%

34

Dabble

17%

776

6/29/2022

9.7

10.6

$45.00

22000

1.21

$1,450

75%

$1,450

73%

32

Bold

16%

730

5/30/2022

8.8

10.1

$42.35

22400

1.28

$1,350

68%

$1,350

64%

28

Cent

7%

332

8/16/2022

7.3

11.3

$37.20

20000

1.01

$1,025

54%

$1,150

45%

14

Daze

5%

238

6/15/2022

7.2

13.0

$34.00

19000

2.30

$1,450

95%

$1,450

73%

11

Baker

5%

229

4/16/2022

7.0

13.6

$33.40

19800

2.42

$1,350

88%

$1,350

64%

7

East

5%

206

1/8/2022

6.2

12.8

$29.50

16500

1.80

$1,000

50%

$1,000

39%

5

Eat

4%

172

5/28/2022

6.9

13.5

$27.60

16500

1.98

$1,000

57%

$1,000

39%

6

Cake

2%

94

7/17/2021

5.8

13.4

$25.20

17000

3.36

$1,025

63%

$1,150

45%

1

FOUNDATION® FAST TRACK

Page 6

Market Share Report

F96840_013

Round: 4 December 31, 2022

Actual Market Share in Units

Low

High

Total

Industry Unit Sales

7,379

4,479

11,858

% of Market

62.2%

37.8%

100.0%

Able

3.6%

2.3%

Total

3.6%

2.3%

Baker

21.6%

5.1%

15.4%

Bold

0.5%

16.3%

6.5%

Total

22.2%

21.4%

21.9%

Cake

23.0%

2.1%

15.1%

Cent

6.2%

7.4%

6.6%

Total

29.1%

9.5%

21.7%

Daze

18.9%

5.3%

13.8%

Dabble

17.3%

6.5%

Total

18.9%

22.6%

20.3%

Eat

15.9%

3.8%

11.4%

East

10.1%

4.6%

8.0%

Total

26.0%

8.4%

19.4%

Fast

19.6%

7.4%

Feast

0.1%

18.4%

7.0%

Total

0.1%

38.0%

14.4%

Potential Market Share in Units

Low

High

Total

Units Demanded

7,379

4,479

11,858

% of Market

62.2%

37.8%

100.0%

Able

3.6%

2.3%

Total

3.6%

2.3%

Baker

21.6%

5.1%

15.4%

Bold

0.5%

16.3%

6.5%

Total

22.2%

21.4%

21.9%

Cake

23.0%

2.1%

15.1%

Cent

6.2%

7.4%

6.6%

Total

29.1%

9.5%

21.7%

Daze

18.9%

5.3%

13.8%

Dabble

17.3%

6.5%

Total

18.9%

22.6%

20.3%

Eat

16.0%

3.8%

11.4%

East

10.1%

4.6%

8.0%

Total

26.0%

8.4%

19.4%

Fast

19.6%

7.4%

Feast

0.1%

18.4%

7.0%

Total

0.1%

38.0%

14.4%

FOUNDATION® FAST TRACK

Page 7

Perceptual Map

F96840_013

Round: 4 December 31, 2022

Perceptual Map for All Segments

Andrews

Name

Pfmn

Size

Revised

Able

6.0

13.2

7/30/2020

A-Prod

5.5

14.0

2/8/2020

Alpha

7.0

13.0

2/8/2021

Aqua

6.8

11.3

2/23/2022

Baldwin

Name

Pfmn

Size

Revised

Baker

7.0

13.6

4/16/2022

Bold

8.8

10.1

5/30/2022

Chester

Name

Pfmn

Size

Revised

Cake

5.8

13.4

7/17/2021

Cent

7.3

11.3

8/16/2022

Digby

Name

Pfmn

Size

Revised

Daze

7.2

13.0

6/15/2022

Dabble

9.7

10.6

6/29/2022

Erie

Name

Pfmn

Size

Revised

Eat

6.9

13.5

5/28/2022

East

6.2

12.8

1/8/2022

Ferris

Name

Pfmn

Size

Revised

Fast

10.0

9.7

7/10/2022

Feast

9.6

10.2

7/10/2022

FOUNDATION® FAST TRACK

Page 8

HR/TQM Report

F96840_013

Round: 4 December 31, 2022

Andrews

Baldwin

Chester

Digby

Erie

Ferris

Needed Complement

255

461

281

451

322

317

Complement

153

461

281

451

322

317

1st Shift Complement

153

286

154

306

191

187

2nd Shift Complement

0

175

127

145

131

130

Overtime%

66.9%

0.0%

0.0%

0.0%

0.0%

0.0%

Turnover Rate

16.7%

8.5%

8.3%

8.4%

8.8%

8.3%

New Employees

26

39

23

38

84

145

Separated Employees

102

70

4

48

0

0

Recruiting Spend

$0

$2,000

$1,800

$2,700

$2,200

$3,000

Training Hours

0

30

40

34

25

40

Productivity Index

100.0%

104.4%

105.5%

105.2%

103.6%

106.6%

Recruiting Cost

$26

$118

$66

$140

$268

$580

Separation Cost

$510

$349

$22

$240

$0

$0

Training Cost

$0

$277

$224

$307

$161

$253

Total HR Admin Cost

$536

$744

$312

$687

$429

$833

Strike Days

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

$750

Quality Initiative Training

$0

$0

$900

$0

$900

$0

Channel Support Systems

$300

$750

$0

$1,000

$0

$750

Concurrent Engineering

$0

$750

$0

$0

$0

$0

UNEP Green Programs

$260

$750

$900

$0

$900

$750

TQM Budgets Last Year

Benchmarking

$0

$0

$0

$1,000

$0

$0

Quality Function Deployment Effort

$420

$750

$0

$0

$0

$0

CCE/6 Sigma Training

$0

$0

$900

$0

$900

$750

GEMI TQEM Sustainability Initiatives

$0

$0

$900

$0

$900

$750

Total Expenditures

$980

$3,000

$5,400

$2,000

$5,400

$3,750

Cumulative Impacts

Material Cost Reduction

0.00%

0.03%

5.71%

0.00%

5.71%

2.72%

Labor Cost Reduction

0.00%

0.00%

7.04%

0.00%

7.04%

0.98%

Reduction R&D Cycle Time

0.46%

27.25%

0.00%

0.00%

0.00%

0.00%

Reduction Admin Costs

0.00%

0.00%

5.50%

25.93%

5.50%

4.66%

Demand Increase

0.30%

6.11%

0.73%

1.30%

0.73%

4.09%

FOUNDATION® FAST TRACK

Page 9

Ethics Report

F96840_013

Round: 4 December 31, 2022

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