Final report

profilenirmak
Round3Results.docx

Round 3 Results

Contents

· Section 1  Research and Development

· Section 2  Marketing Low Tech

· Section 3  Marketing High Tech

· Section 4  Production

· Section 5  Finance

· Section 6  Product Financials

· Section 7  Custom Modules

High Level Overview

High Level Overview

Categories

Andrews

Baldwin

Chester

Digby

Erie

Ferris

Average

Sales

$22,298

$38,665

$24,620

$53,888

$34,225

$32,216

$34,319

Profit

($1,805)

$37

($3,089)

$1,723

$1,254

($1,779)

($610)

Contribution Margin

38.75%

31.90%

16.44%

30.27%

30.98%

8.33%

26.11%

Stock Price

$1.00

$4.45

$1.00

$7.80

$7.46

$1.00

$3.79

Emergency Loan

$0

$0

$0

$0

$0

$0

$0

Market Share

10.8%

18.8%

12.0%

26.2%

16.6%

15.6%

16.7%

Section  | Research and Development

Low Tech

Customer Buying Criteria

Expectations

Importance

Price

$15.00 - $35.00

41%

Age

3 Years

29%

Reliability

14,000 - 20,000 Hours

21%

Positioning

Performance 6.3 Size 13.7

9%

High Tech

Customer Buying Criteria

Expectations

Importance

Positioning

Performance 9.5 Size 10.5

33%

Age

0 Years

29%

Price

$25.00 - $45.00

25%

Reliability

17,000 - 23,000 Hours

13%

Perceptual Map

PerformanceSizeAbleAbleBakerBakerCakeCakeDazeDazeEatEatFastFast0246810121416182002468101214161820

Product List

Name

Performance

Size

Reliability

Age

Revision Date

Able

5.7

13.9

17,900

1.8

April 22, 2024

Baker

6.8

13.4

19,000

2.3

May 5, 2024

Cake

7.3

12.1

19,900

1.6

October 7, 2024

Daze

6.3

13.7

14,500

2.4

June 27, 2024

Eat

5.0

14.0

18,000

4.1

November 29, 2022

Fast

6.4

13.6

21,000

6.1

November 25, 2018

Section  | Marketing

Low Tech

Customer Buying Criteria

Categories

Expectations

Importance

Price

$15.00 - $35.00

41%

Age

3 Years

29%

Reliability

14,000 - 20,000 Hours

21%

Positioning

Performance 6.3 Size 13.7

9%

Demand Information

2024 Total Market Size

5,031

2024 Total Units Sold

3,816

2025 Demand Growth Rate

10%

Market Share

Andrews9.9 %Andrews9.9 %Baldwin18.4 %Baldwin18.4 %Chester7.6 %Chester7.6 %Digby29.1 %Digby29.1 %Erie21.2 %Erie21.2 %Ferris13.8 %Ferris13.8 %AndrewsBaldwinChesterDigbyErieFerris

Top Products

Name

Price

Units Sold 

Potential Sold

Stock Out

Sales Budget

Customer Accessibility

Promo Budget

Customer Awareness

Customer Satisfaction

Daze

$35.00

1,112

803

Yes

$1,200

32%

$1,200

66%

10

Eat

$37.00

807

761

Yes

$1,500

37%

$1,600

91%

10

Baker

$35.00

702

1,561

Yes

$2,000

45%

$2,000

99%

28

Fast

$35.00

526

468

Yes

$1,000

28%

$1,000

62%

7

Able

$35.00

379

795

Yes

$1,100

37%

$1,100

72%

14

Cake

$37.75

289

643

Yes

$700

21%

$1,050

63%

8

Section  | Marketing

High Tech

Customer Buying Criteria

Categories

Expectations

Importance

Positioning

Performance 9.5 Size 10.5

33%

Age

0 Years

29%

Price

$25.00 - $45.00

25%

Reliability

17,000 - 23,000 Hours

13%

Demand Information

2024 Total Market Size

2,799

2024 Total Units Sold

1,963

2025 Demand Growth Rate

20%

Market Share

Andrews13.1 %Andrews13.1 %Baldwin20.5 %Baldwin20.5 %Chester18.5 %Chester18.5 %Digby21.8 %Digby21.8 %Erie6.0 %Erie6.0 %Ferris20.1 %Ferris20.1 %AndrewsBaldwinChesterDigbyErieFerris

Top Products

Name

Price

Units Sold 

Potential Sold

Stock Out

Sales Budget

Customer Accessibility

Promo Budget

Customer Awareness

Customer Satisfaction

Daze

$35.00

428

290

Yes

$1,200

32%

$1,200

66%

2

Baker

$35.00

403

833

Yes

$2,000

40%

$2,000

99%

11

Fast

$35.00

394

320

Yes

$1,000

29%

$1,000

62%

4

Cake

$37.75

363

747

Yes

$700

25%

$1,050

63%

11

Able

$35.00

258

502

Yes

$1,100

31%

$1,100

72%

4

Eat

$37.00

118

106

Yes

$1,500

31%

$1,600

91%

0

Section  | Production

Production vs Capacity

6376371,1051,1056526521,5401,5409259259209206506501,1001,1005505501,0501,0501,4001,4001,0001,000ProductionCapacityAndrewsBaldwinChesterDigbyErieFerris010020030040050060070080090010001100120013001400150016001700

Plant Information

Name

Primary Segment

Units Produced

Units Sold

Inventory

Price

Material Cost

Labor Cost

Contribution Margin

Auto. Next Round

Capacity Next Round

Plant Utilization

Able

Low Tech

637

637

0

$35.00

$9.53

$11.78

38.8%

4.5

700

138%

Baker

Low Tech

1,105

1,105

0

$35.00

$9.71

$13.28

31.9%

3.5

1,100

155%

Cake

High Tech

652

652

0

$37.75

$12.05

$17.24

16.4%

2.7

550

200%

Daze

Low Tech

1,540

1,540

0

$35.00

$9.14

$14.56

30.3%

3.1

1,100

200%

Eat

Low Tech

925

925

0

$37.00

$8.69

$15.07

31%

3

1,400

109%

Fast

Low Tech

920

920

0

$35.00

$11.04

$18.17

8.3%

3

1,000

160%

Section  | Finance

Income Statement

Categories

Andrews

Baldwin

Chester

Digby

Erie

Ferris

Sales

$22,298

$38,665

$24,620

$53,888

$34,225

$32,216

Variable Costs

Direct Material

$6,151

$11,659

$9,326

$15,158

$9,684

$12,809

Direct Labor

$7,506

$14,673

$11,246

$22,416

$13,937

$16,725

Inventory Carry

$0

$0

$0

$0

$0

$0

Total Variable Costs (Labor, Material, Carry)

$13,657

$26,332

$20,571

$37,574

$23,621

$29,534

Contribution Margin

$8,640

$12,334

$4,048

$16,314

$10,603

$2,682

Period Costs

Depreciation

$1,120

$1,467

$704

$1,349

$1,987

$1,200

SG&A

R&D

$306

$342

$765

$486

$0

$0

Promotions

$1,100

$2,000

$1,050

$1,200

$1,600

$1,000

Sales

$1,100

$2,000

$700

$1,200

$1,500

$1,000

Administration

$426

$640

$879

$941

$568

$526

Total Period Costs

$4,052

$6,449

$4,098

$5,177

$5,655

$3,726

Net Margin

$4,588

$5,884

($49)

$11,137

$4,948

($1,044)

Other (Fees/Write-offs/Bonuses/Relocation Fee)

$6,212

$5,200

$3,826

$7,575

$2,115

$1,000

EBIT

($1,623)

$684

($3,875)

$3,562

$2,833

($2,044)

Interest (Short term/Long Term)

$1,154

$626

$877

$857

$864

$693

Taxes

($972)

$20

($1,663)

$947

$689

($958)

Profit Sharing

$0

$1

$0

$35

$26

$0

Net Profit

($1,805)

$37

($3,089)

$1,723

$1,254

($1,779)

Cash Flow Statement

Categories

Andrews

Baldwin

Chester

Digby

Erie

Ferris

Starting Cash Position

$4,114

$2,276

$10,990

$5,629

$698

$7,379

Cash From Operations

Net Income(Loss)

($1,805)

$37

($3,089)

$1,723

$1,254

($1,779)

Adjustment For Non-Cash Items

Depreciation

$1,120

$1,467

$704

$1,349

$1,987

$1,200

Extraordinary Gains/Losses/Write-offs

$0

$0

($1,327)

$0

$0

$0

Changes In Current Assets And Liabilities

Accounts Payable

($160)

$82

($978)

$479

($131)

($126)

Inventory

$0

$0

$0

$0

$0

$0

Accounts Receivable

$158

($297)

$1,039

($594)

$127

$608

Net Cash From Operations

($687)

$1,289

($3,651)

$2,958

$3,237

($97)

Cash From Investing

Net Plant Improvements

($1,720)

$0

$4,605

($1,340)

$0

$0

Cash From Financing

Dividends Paid

($1,002)

$0

($481)

$0

$0

$0

Sales Of Common Stock

$200

$0

$400

$0

$0

$0

Purchase Of Common Stock

($100)

$0

$0

$0

$0

$0

Cash From Long-Term Debt Issued

$2,000

$0

$0

$1,500

$300

$0

Early Retirement Of Long-Term Debt

$0

$0

($2,200)

$0

$0

$0

Retirement Of Current Debt

($1,800)

$0

($7,500)

($1,100)

($3,001)

($1,100)

Cash From Current Debt Borrowing

$2,600

$0

$2,200

$0

$0

$0

Cash From Emergency Loan

$0

$0

$0

$0

$0

$0

Net Cash From Financing

$1,898

$0

($7,581)

$400

($2,701)

($1,100)

Effect Of Exchange Rates

$0

$0

$0

$0

$0

$0

Net Change In Cash

($509)

$1,289

($6,627)

$2,018

$535

($1,197)

Ending Cash Position

$3,605

$3,565

$4,363

$7,647

$1,234

$6,182

Balance Sheet

Categories

Andrews

Baldwin

Chester

Digby

Erie

Ferris

Cash

$3,605

$3,565

$4,363

$7,647

$1,234

$6,182

Accounts Receivable

$1,833

$3,178

$2,024

$4,429

$2,813

$2,648

Inventory

$0

$0

$0

$0

$0

$0

Current Assets

$5,438

$6,743

$6,386

$12,076

$4,047

$8,830

Plant and Equipment

$16,800

$22,000

$10,560

$20,240

$29,800

$18,000

Accumulated Depreciation

($6,276)

($10,267)

($5,324)

($9,809)

($11,507)

($9,600)

Fixed Assets

$10,524

$11,733

$5,236

$10,431

$18,293

$8,400

Total Assets

$15,962

$18,476

$11,622

$22,507

$22,340

$17,230

Accounts Payable

$1,123

$2,164

$1,691

$3,088

$1,941

$2,427

Current Debt

$2,600

$0

$2,200

$0

$0

$0

Current Liabilities

$3,723

$2,164

$3,891

$3,088

$1,941

$2,427

Long-Term Liabilities

$7,417

$4,946

$4,994

$7,000

$7,100

$5,500

Total Liabilities

$11,139

$7,110

$8,885

$10,088

$9,041

$7,927

Common Stock

$3,902

$3,204

$4,396

$2,904

$3,382

$2,904

Retained Earnings

$921

$8,162

($1,658)

$9,515

$9,917

$6,398

Total Equity

$4,823

$11,366

$2,738

$12,419

$13,298

$9,302

Total Liabilities & Equity

$15,962

$18,476

$11,622

$22,507

$22,340

$17,230

Stock Market Summary

Company

Closing Price

Change

Shares Outstanding

Market Cap

Book Value

EPS

Dividend

Yield

P/E

Andrews

$1.00

$0.00

2,330,643

$2m

$2.07

($0.77)

$0.43

43%

-1.29

Baldwin

$4.45

$2.31

2,283,904

$10m

$4.98

$0.02

$0.00

0%

276.82

Chester

$1.00

$0.00

2,674,191

$3m

$1.02

($1.16)

$0.18

18%

-0.87

Digby

$7.80

$6.00

2,000,000

$16m

$6.21

$0.86

$0.00

0%

9.05

Erie

$7.46

$4.07

2,285,676

$17m

$5.82

$0.55

$0.00

0%

13.60

Ferris

$1.00

($1.36)

2,000,000

$2m

$4.65

($0.89)

$0.00

0%

-1.12

Bond Market Summary

Company

Series

Face Value

Yield

Closing Price

S&P Rating

Andrews

12.0S2025 13.0S2027 10.2S2032 11.1S2033 11.6S2034

$416,552 $3,300,000 $1,200,000 $500,000 $2,000,000

12.1% 12.97% 11.72% 12.23% 12.48%

$99.20 $100.24 $87.00 $90.73 $92.92

DDD DDD DDD DDD DDD

Baldwin

12.0S2025 13.0S2027

$1,645,812 $3,300,000

11.79% 12.1%

$101.82 $107.46

BBB BBB

Chester

12.4S2033

$4,993,784

12.86%

$96.42

DDD

Digby

12.0S2025 13.0S2027 10.9S2034

$2,200,000 $3,300,000 $1,500,000

11.86% 12.3% 10.77%

$101.17 $105.65 $101.19

BB BB BB

Erie

12.0S2025 13.0S2027 10.2S2032 10.6S2033 11.2S2034

$2,200,000 $3,300,000 $100,000 $1,200,000 $300,000

11.81% 12.16% 10.2% 10.36% 10.56%

$101.63 $106.94 $100.00 $102.29 $106.09

BBB BBB BBB BBB BBB

Ferris

12.0S2025 13.0S2027

$2,200,000 $3,300,000

11.87% 12.33%

$101.08 $105.39

BB BB

Next Year's Prime Rate: 7%

Stock Price

4.594.591111112.142.144.454.457.87.83.393.391.751.75AndrewsBaldwinChesterDigbyErieFerris20212022202320242025202620272028$0$10

Net Profit

AndrewsBaldwinChesterDigbyErieFerris$-4000$-3000$-2000$-1000$0$1000$2000

Section  | Product Financials

Andrews Income Statement

Category

Able

Other Info

Total

Sales

$22,298

$22,298

Variable Cost

$13,657

$13,657

Fixed Cost

$4,052

$4,052

Net Margin

$4,588

$4,588

Other (Fees, Writeoffs)

$6,212

Long Term Interest

$889

Taxes & Tariffs

($972)

Profit Sharing

$0

Net Profit

($1,805)

Baldwin Income Statement

Category

Baker

Other Info

Total

Sales

$38,665

$38,665

Variable Cost

$26,332

$26,332

Fixed Cost

$6,449

$6,449

Net Margin

$5,884

$5,884

Other (Fees, Writeoffs)

$5,200

Long Term Interest

$626

Taxes & Tariffs

$20

Profit Sharing

$1

Net Profit

$37

Chester Income Statement

Category

Cake

Other Info

Total

Sales

$24,620

$24,620

Variable Cost

$20,571

$20,571

Fixed Cost

$4,098

$4,098

Net Margin

($49)

($49)

Other (Fees, Writeoffs)

$3,826

Long Term Interest

$619

Taxes & Tariffs

($1,663)

Profit Sharing

$0

Net Profit

($3,089)

Digby Income Statement

Category

Daze

Other Info

Total

Sales

$53,888

$53,888

Variable Cost

$37,574

$37,574

Fixed Cost

$5,177

$5,177

Net Margin

$11,137

$11,137

Other (Fees, Writeoffs)

$7,575

Long Term Interest

$857

Taxes & Tariffs

$947

Profit Sharing

$35

Net Profit

$1,723

Erie Income Statement

Category

Eat

Other Info

Total

Sales

$34,225

$34,225

Variable Cost

$23,621

$23,621

Fixed Cost

$5,655

$5,655

Net Margin

$4,948

$4,948

Other (Fees, Writeoffs)

$2,115

Long Term Interest

$864

Taxes & Tariffs

$689

Profit Sharing

$26

Net Profit

$1,254

Ferris Income Statement

Category

Fast

Other Info

Total

Sales

$32,216

$32,216

Variable Cost

$29,534

$29,534

Fixed Cost

$3,726

$3,726

Net Margin

($1,044)

($1,044)

Other (Fees, Writeoffs)

$1,000

Long Term Interest

$693

Taxes & Tariffs

($958)

Profit Sharing

$0

Net Profit

($1,779)

WorkforceRound: 3 Dec. 31, 2024OP99075_1

Workforce Summary

Categories

Andrews

Baldwin

Chester

Digby

Erie

Ferris

Number of Employees

141

303

212

396

292

308

First Shift

102

196

106

198

268

193

Second Shift

39

107

106

198

24

115

Overtime %

0%

0%

0%

0%

0%

0%

Turnover Rate

8.0%

12.0%

14.0%

11.3%

13.0%

14.0%

New Employees

11

60

30

133

55

43

Separated Employees

16

0

96

0

0

0

Productivity Index

105.3%

102.0%

100.0%

103.5%

101.0%

100.0%

Section  | Custom Modules

Workforce Summary

Categories

Andrews

Baldwin

Chester

Digby

Erie

Ferris

Number of Employees

141

303

212

396

292

308

First Shift

102

196

106

198

268

193

Second Shift

39

107

106

198

24

115

Overtime %

0%

0%

0%

0%

0%

0%

Turnover Rate

8.0%

12.0%

14.0%

11.3%

13.0%

14.0%

New Employees

11

60

30

133

55

43

Separated Employees

16

0

96

0

0

0

Productivity Index

105.3%

102.0%

100.0%

103.5%

101.0%

100.0%

Human Resources

Andrews

Baldwin

Chester

Digby

Erie

Ferris

Decisions

Manufacturing - Training & Assembly Teams

$1,000

$400

$0

$600

$200

$0

Sales - Compensation

$1,400

$400

$0

$500

$200

$0

Scientists - Recruitment & Retention

$1,700

$400

$0

$300

$200

$0

Total Expenditures

$4,100

$1,200

$0

$1,400

$600

$0

Yearly Impacts

R & D Cycle Time

-7.8%

2%

5%

2.8%

3.5%

5%

Demand

2.6%

0.6%

0%

0.4%

0.3%

0%

Accessibility

5.6%

1.6%

0%

2%

0.8%

0%

Productivity Index

2.5%

1%

0%

1.5%

0.5%

0%

Turnover Rate

-13%

10%

20%

7%

15%

20%

Production After Adjustment

-0.3%

-0.7%

-1%

-0.6%

-0.9%

-1%

Advanced Operations

Andrews

Baldwin

Chester

Digby

Erie

Ferris

Decisions

Inventory Control

$0

$500

$1,300

$1,700

$100

$0

Suppliers

$2,000

$1,500

$1,200

$1,700

$1,000

$1,000

Total Quality Management - Process

$0

$1,000

$600

$1,500

$300

$0

Total Quality Management - Product

$0

$1,000

$2,000

$1,200

$100

$0

Total Expenditures

$2,000

$4,000

$5,100

$6,100

$1,500

$1,000

Yearly Impacts

Material Cost

0%

-5%

-9.4%

-5.1%

-3.3%

-3%

R & D Cycle Time

0%

2.5%

4%

1.5%

5%

5%

Labor Cost

0%

-4.8%

-9.4%

-6.5%

-3.4%

-3%

Demand

-5%

3.8%

13.3%

8.3%

-4%

-5%

Inventory Carrying Cost

7%

3.5%

-2.1%

-4.9%

6.3%

7%

Production After Adjustment

0%

1.6%

-2.5%

4.9%

-4.7%

-5%

Cumulative Impacts

Andrews

Baldwin

Chester

Digby

Erie

Ferris

Material Cost

-6.8%

-20%

-15.4%

-8.5%

-9%

-9%

R & D Cycle Time

-4%

14%

24%

12%

18.5%

25%

Labor Cost

-7.2%

-18.3%

-15.4%

-9.7%

-9.3%

-9%

Demand

2.8%

20%

3.3%

-0.1%

-8.4%

-15%

Accessibility

10%

3.2%

0%

4%

1.6%

0%

Productivity Index

5.3%

2%

0%

3.5%

1%

0%

Turnover Rate

-20.5%

20%

40%

13%

30%

40%

Inventory Carrying Cost

11.9%

10.5%

11.9%

9.1%

16.8%

21%

Production After Adjustment

2.1%

-6.2%

-14.5%

5.8%

-12.5%

-17%