Final Project OL421

Stocks & Bonds

F96840_013

Round: 1 December 31 , 2019

Company

Close

Change

Shares

MarketCap ($M)

Book Value

EPS

Dividend

Yield

P/E

Andrews

$15.02

$3.85

2,000,000

$30

$7.83

$1.40

$0.00

0.0%

10.7

Baldwin

$14.22

$3.06

2,076,077

$30

$7.76

$1.16

$0.00

0.0%

12.3

Chester

$14.34

$3.17

2,051,004

$29

$7.75

$1.20

$0.00

0.0%

11.9

Digby

$16.32

$5.16

2,036,677

$33

$8.22

$1.70

$0.00

0.0%

9.6

Erie

$12.90

$1.73

2,051,004

$26

$7.38

$0.84

$0.00

0.0%

15.3

Ferris

$16.51

$5.34

2,000,000

$33

$6.60

$1.77

$1.60

9.7%

9.3

Company

Series#

Face

Yield

Close$

S&P

Andrews

11.0S2020

$866,667

10.9%

100.91

BBB

12.0S2022

$1,733,333

11.4%

104.97

BBB

13.0S2024

$2,600,000

11.7%

111.37

BBB

Baldwin

11.0S2020

$866,667

11.0%

100.00

B

12.0S2022

$1,733,333

11.7%

102.44

B

13.0S2024

$2,600,000

12.1%

107.39

B

10.0S2029

$2,480,000

10.6%

94.11

B

Chester

11.0S2020

$866,667

11.0%

100.18

BB

12.0S2022

$1,733,333

11.7%

102.94

BB

13.0S2024

$2,600,000

12.0%

108.17

BB

10.0S2029

$2,361,878

10.5%

95.25

BB

Digby

11.0S2020

$866,667

11.0%

100.09

BB

12.0S2022

$1,733,333

11.7%

102.69

BB

13.0S2024

$2,600,000

12.1%

107.78

BB

10.0S2029

$2,287,212

10.6%

94.68

BB

Erie

11.0S2020

$866,667

11.0%

100.09

BB

12.0S2022

$1,733,333

11.7%

102.69

BB

13.0S2024

$2,600,000

12.1%

107.78

BB

10.0S2029

$2,361,878

10.6%

94.68

BB

Ferris

11.0S2020

$866,667

11.0%

100.00

B

12.0S2022

$1,733,333

11.7%

102.44

B

13.0S2024

$2,600,000

12.1%

107.39

B

10.0S2029

$420,545

10.6%

94.11

B

FOUNDATION® FAST TRACK

Page 2

Financial Summary

F96840_013

Round: 1 December 31, 2019

Cash Flow Statement Survey

Andrews

Baldwin

Chester

Digby

Erie

Ferris

Cash flows from operating activities

Net Income (Loss)

$2,801

$2,403

$2,462

$3,471

$1,723

$3,545

Adjustment for non-cash items:

   Depreciation

$1,088

$1,064

$1,426

$1,020

$1,426

$1,133

   Extraordinary gains/losses/writeoffs

$0

$0

$0

$0

$0

$0

Changes in current assets and liabilities:

   Accounts payable

($363)

$530

($563)

$453

($749)

($42)

   Inventory

($909)

($1,228)

($199)

($787)

($523)

($604)

   Accounts receivable

($77)

($858)

($204)

($969)

($70)

($426)

Net cash from operations

$2,539

$1,911

$2,922

$3,189

$1,807

$3,607

Cash flows from investing activities

Plant improvements (net)

($2,670)

($6,925)

($6,995)

($6,500)

($6,995)

($2,600)

Cash flows from financing activities

Dividends paid

$0

$0

$0

$0

$0

($3,195)

Sales of common stock

$0

$850

$570

$410

$570

$0

Purchase of common stock

$0

$0

$0

$0

$0

$0

Cash from long term debt issued

$0

$2,480

$2,362

$2,287

$2,362

$421

Early retirement of long term debt

$0

$0

$0

$0

$0

$0

Retirement of current debt

$0

$0

$0

$0

$0

$0

Cash from current debt borrowing

$2,000

$3,691

$3,679

$3,679

$3,679

$3,679

Cash from emergency loan

$0

$0

$0

$0

$0

$0

Net cash from financing activities

$2,000

$7,021

$6,610

$6,376

$6,610

$905

Net change in cash position

$1,869

$2,007

$2,538

$3,064

$1,422

$1,911

Balance Sheet Survey

Andrews

Baldwin

Chester

Digby

Erie

Ferris

Cash

$7,471

$7,608

$8,139

$8,666

$7,024

$7,513

Accounts Receivable

$3,431

$4,211

$3,557

$4,322

$3,424

$3,780

Inventory

$3,261

$3,580

$2,551

$3,139

$2,875

$2,956

Total Current Assets

$14,163

$15,400

$14,248

$16,126

$13,322

$14,248

Plant and equipment

$17,070

$21,325

$21,395

$20,900

$21,395

$17,000

Accumulated Depreciation

($5,888)

($5,864)

($6,226)

($5,820)

($6,226)

($5,933)

Total Fixed Assets

$11,182

$15,461

$15,168

$15,080

$15,168

$11,067

Total Assets

$25,345

$30,861

$29,416

$31,206

$28,491

$25,315

Accounts Payable

$2,490

$3,384

$2,290

$3,306

$2,104

$2,812

Current Debt

$2,000

$3,691

$3,679

$3,679

$3,679

$3,679

Long Term Debt

$5,200

$7,680

$7,562

$7,487

$7,562

$5,621

Total Liabilities

$9,690

$14,755

$13,531

$14,472

$13,345

$12,111

Common Stock

$2,323

$3,173

$2,893

$2,733

$2,893

$2,323

Retained Earnings

$13,331

$12,933

$12,992

$14,001

$12,253

$10,881

Total Equity

$15,655

$16,106

$15,885

$16,734

$15,146

$13,204

Total Liabilities & Owners' Equity

$25,345

$30,861

$29,416

$31,206

$28,491

$25,315

Income Statement Survey

Andrews

Baldwin

Chester

Digby

Erie

Ferris

Sales

$41,740

$51,234

$43,281

$52,584

$41,655

$45,984

Variable Costs (Labor, Material, Carry)

$29,779

$40,369

$33,548

$39,817

$33,217

$33,958

Depreciation

$1,088

$1,064

$1,426

$1,020

$1,426

$1,133

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

$5,663

$4,656

$3,102

$4,977

$2,967

$4,307

Other (Fees, Writeoffs, TQM, Bonuses)

$0

$166

$147

$135

$147

$21

EBIT

$5,210

$4,979

$5,058

$6,635

$3,898

$6,565

Interest (Short term, Long term)

$813

$1,207

$1,194

$1,186

$1,194

$1,000

Taxes

$1,539

$1,320

$1,353

$1,907

$946

$1,948

Profit Sharing

$57

$49

$50

$71

$35

$72

Net Profit

$2,801

$2,403

$2,462

$3,471

$1,723

$3,545

FOUNDATION® FAST TRACK

Page 3

Production Analysis

F96840_013

Round: 1 December 31, 2019

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,193

132

6/20/2019

2.3

16000

6.0

14.0

$35.00

$12.36

$10.50

29%

56%

2.5

820

155%

A-Prod

0

0

2/8/2020

0.0

0

0.0

0.0

$0.00

$0.00

$0.00

0%

0%

1.0

75

0%

Baker

Low

1,534

138

3/12/2019

2.5

19800

6.4

13.8

$33.40

$14.16

$11.10

21%

100%

3.2

849

198%

Bold

0

0

5/12/2020

0.0

0

0.0

0.0

$0.00

$0.00

$0.00

0%

0%

3.0

298

0%

Cake

Low

1,328

102

7/23/2019

2.3

18250

5.7

14.2

$32.60

$12.50

$10.67

23%

69%

4.8

849

168%

Daze

Low

1,502

120

3/16/2019

2.4

20600

6.1

13.4

$35.00

$14.52

$11.02

24%

94%

3.0

850

192%

Dabble

0

0

5/8/2020

0.0

0

0.0

0.0

$0.00

$0.00

$0.00

0%

0%

2.5

350

0%

Eat

Low

1,316

115

7/28/2019

2.3

17500

6.0

14.4

$31.65

$12.40

$10.65

20%

69%

4.8

849

168%

Fast

Low

1,263

111

10/21/2019

2.1

21500

7.6

12.7

$36.40

$17.15

$10.60

26%

63%

3.5

850

161%

FOUNDATION® FAST TRACK

Page 4

Low Tech Market Segment Analysis

F96840_013

Round: 1 December 31, 2019

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

Baker

19%

1,036

3/12/2019

6.4

13.8

$33.40

19800

2.45

$1,300

67%

$1,300

39%

20

Daze

18%

981

3/16/2019

6.1

13.4

$35.00

20600

2.45

$1,450

72%

$1,450

41%

19

Cake

18%

971

7/23/2019

5.7

14.2

$32.60

18250

2.27

$925

56%

$925

34%

17

Eat

17%

959

7/28/2019

6.0

14.4

$31.65

17500

2.26

$875

54%

$850

33%

16

Able

15%

842

6/20/2019

6.0

14.0

$35.00

16000

2.31

$1,750

78%

$1,750

46%

13

Fast

14%

755

10/21/2019

7.6

12.7

$36.40

21500

2.14

$1,500

73%

$1,275

36%

8

FOUNDATION® FAST TRACK

Page 5

High Tech Market Segment Analysis

F96840_013

Round: 1 December 31, 2019

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

Daze

20%

521

3/16/2019

6.1

13.4

$35.00

20600

2.45

$1,450

72%

$1,450

42%

12

Fast

20%

508

10/21/2019

7.6

12.7

$36.40

21500

2.14

$1,500

73%

$1,275

39%

24

Baker

19%

498

3/12/2019

6.4

13.8

$33.40

19800

2.45

$1,300

67%

$1,300

40%

12

Eat

14%

357

7/28/2019

6.0

14.4

$31.65

17500

2.26

$875

54%

$850

33%

8

Cake

14%

356

7/23/2019

5.7

14.2

$32.60

18250

2.27

$925

56%

$925

34%

8

Able

14%

351

6/20/2019

6.0

14.0

$35.00

16000

2.31

$1,750

78%

$1,750

46%

7

FOUNDATION® FAST TRACK

Page 6

Market Share Report

F96840_013

Round: 1 December 31, 2019

Actual Market Share in Units

Low

High

Total

Industry Unit Sales

5,544

2,592

8,136

% of Market

68.1%

31.9%

100.0%

Able

15.2%

13.5%

14.7%

Total

15.2%

13.5%

14.7%

Baker

18.7%

19.2%

18.9%

Total

18.7%

19.2%

18.9%

Cake

17.5%

13.8%

16.3%

Total

17.5%

13.8%

16.3%

Daze

17.7%

20.1%

18.5%

Total

17.7%

20.1%

18.5%

Eat

17.3%

13.8%

16.2%

Total

17.3%

13.8%

16.2%

Fast

13.6%

19.6%

15.5%

Total

13.6%

19.6%

15.5%

Potential Market Share in Units

Low

High

Total

Units Demanded

5,544

2,592

8,136

% of Market

68.1%

31.9%

100.0%

Able

15.5%

13.8%

14.9%

Total

15.5%

13.8%

14.9%

Baker

18.6%

19.2%

18.8%

Total

18.6%

19.2%

18.8%

Cake

17.5%

13.7%

16.3%

Total

17.5%

13.7%

16.3%

Daze

17.6%

20.1%

18.4%

Total

17.6%

20.1%

18.4%

Eat

17.2%

13.7%

16.1%

Total

17.2%

13.7%

16.1%

Fast

13.6%

19.6%

15.5%

Total

13.6%

19.6%

15.5%

FOUNDATION® FAST TRACK

Page 7

Perceptual Map

F96840_013

Round: 1 December 31, 2019

Perceptual Map for All Segments

Andrews

Name

Pfmn

Size

Revised

Able

6.0

14.0

6/20/2019

Baldwin

Name

Pfmn

Size

Revised

Baker

6.4

13.8

3/12/2019

Chester

Name

Pfmn

Size

Revised

Cake

5.7

14.2

7/23/2019

Digby

Name

Pfmn

Size

Revised

Daze

6.1

13.4

3/16/2019

Erie

Name

Pfmn

Size

Revised

Eat

6.0

14.4

7/28/2019

Ferris

Name

Pfmn

Size

Revised

Fast

7.6

12.7

10/21/2019

FOUNDATION® FAST TRACK

Page 8

HR/TQM Report

F96840_013

Round: 1 December 31, 2019

Andrews

Baldwin

Chester

Digby

Erie

Ferris

Needed Complement

240

308

260

298

260

250

Complement

240

308

260

298

260

250

1st Shift Complement

154

154

154

154

154

154

2nd Shift Complement

86

154

106

144

106

96

Overtime%

0.2%

0.0%

0.0%

0.0%

0.0%

0.0%

Turnover Rate

10.0%

10.0%

10.0%

10.0%

10.0%

10.0%

New Employees

24

91

38

80

38

27

Separated Employees

8

0

0

0

0

0

Recruiting Spend

$0

$0

$0

$0

$0

$0

Training Hours

0

0

0

0

0

0

Productivity Index

100.0%

100.0%

100.0%

100.0%

100.0%

100.0%

Recruiting Cost

$24

$91

$38

$80

$38

$27

Separation Cost

$40

$0

$0

$0

$0

$0

Training Cost

$0

$0

$0

$0

$0

$0

Total HR Admin Cost

$64

$91

$38

$80

$38

$27

Strike Days

Andrews

Baldwin

Chester

Digby

Erie

Ferris

Process Mgt Budgets Last Year

CPI Systems

$0

$0

$0

$0

$0

$0

Vendor/JIT

$0

$0

$0

$0

$0

$0

Quality Initiative Training

$0

$0

$0

$0

$0

$0

Channel Support Systems

$0

$0

$0

$0

$0

$0

Concurrent Engineering

$0

$0

$0

$0

$0

$0

UNEP Green Programs

$0

$0

$0

$0

$0

$0

TQM Budgets Last Year

Benchmarking

$0

$0

$0

$0

$0

$0

Quality Function Deployment Effort

$0

$0

$0

$0

$0

$0

CCE/6 Sigma Training

$0

$0

$0

$0

$0

$0

GEMI TQEM Sustainability Initiatives

$0

$0

$0

$0

$0

$0

Total Expenditures

$0

$0

$0

$0

$0

$0

Cumulative Impacts

Material Cost Reduction

0.00%

0.00%

0.00%

0.00%

0.00%

0.00%

Labor Cost Reduction

0.00%

0.00%

0.00%

0.00%

0.00%

0.00%

Reduction R&D Cycle Time

0.00%

0.00%

0.00%

0.00%

0.00%

0.00%

Reduction Admin Costs

0.00%

0.00%

0.00%

0.00%

0.00%

0.00%

Demand Increase

0.00%

0.00%

0.00%

0.00%

0.00%

0.00%

FOUNDATION® FAST TRACK

Page 9

Ethics Report

F96840_013

Round: 1 December 31, 2019

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%