Final report

profilenirmak
Round2Results.docx

Round 2 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

$24,215

$35,051

$37,259

$46,661

$35,769

$39,613

$36,428

Profit

($2,511)

($660)

($1,240)

($995)

($1)

($1,030)

($1,073)

Contribution Margin

35.58%

27.40%

12.85%

18.36%

26.28%

10.20%

21.78%

Stock Price

$1.00

$2.14

$1.00

$1.80

$3.39

$2.36

$1.95

Emergency Loan

$0

$0

$0

$0

$0

$0

$0

Market Share

11.1%

16.0%

17.0%

21.3%

16.4%

18.1%

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 5.8 Size 14.2

9%

High Tech

Customer Buying Criteria

Expectations

Importance

Positioning

Performance 8.8 Size 11.2

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.2

14.1

17,750

1.9

May 1, 2023

Baker

6.5

13.8

18,000

2.9

April 26, 2023

Cake

6.6

12.8

23,000

2.0

May 17, 2023

Daze

6.7

13.8

20,100

3.4

February 3, 2023

Eat

5.0

14.0

18,000

3.1

November 29, 2022

Fast

6.4

13.6

21,000

5.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 5.8 Size 14.2

9%

Demand Information

2023 Total Market Size

4,574

2023 Total Units Sold

4,080

2024 Demand Growth Rate

10%

Market Share

Andrews10.8 %Andrews10.8 %Baldwin17.7 %Baldwin17.7 %Chester10.6 %Chester10.6 %Digby23.1 %Digby23.1 %Erie19.5 %Erie19.5 %Ferris18.2 %Ferris18.2 %AndrewsBaldwinChesterDigbyErieFerris

Top Products

Name

Price

Units Sold 

Potential Sold

Stock Out

Sales Budget

Customer Accessibility

Promo Budget

Customer Awareness

Customer Satisfaction

Daze

$35.00

944

851

Yes

$900

30%

$900

57%

16

Eat

$35.00

795

957

Yes

$1,400

39%

$1,500

78%

17

Fast

$35.00

742

591

Yes

$1,000

31%

$1,000

61%

9

Baker

$35.00

722

899

Yes

$1,400

32%

$1,400

81%

20

Able

$35.00

443

801

Yes

$1,200

37%

$1,200

71%

14

Cake

$37.75

433

475

Yes

$800

28%

$800

59%

9

Section  | Marketing

High Tech

Customer Buying Criteria

Categories

Expectations

Importance

Positioning

Performance 8.8 Size 11.2

33%

Age

0 Years

29%

Price

$25.00 - $45.00

25%

Reliability

17,000 - 23,000 Hours

13%

Demand Information

2023 Total Market Size

2,333

2023 Total Units Sold

2,087

2024 Demand Growth Rate

20%

Market Share

Andrews11.9 %Andrews11.9 %Baldwin13.4 %Baldwin13.4 %Chester26.5 %Chester26.5 %Digby18.6 %Digby18.6 %Erie10.9 %Erie10.9 %Ferris18.7 %Ferris18.7 %AndrewsBaldwinChesterDigbyErieFerris

Top Products

Name

Price

Units Sold 

Potential Sold

Stock Out

Sales Budget

Customer Accessibility

Promo Budget

Customer Awareness

Customer Satisfaction

Cake

$37.75

554

613

Yes

$800

31%

$800

59%

11

Daze

$35.00

389

345

Yes

$900

31%

$900

57%

5

Fast

$35.00

389

314

Yes

$1,000

31%

$1,000

61%

5

Baker

$35.00

279

348

Yes

$1,400

25%

$1,400

81%

6

Able

$35.00

249

440

Yes

$1,200

38%

$1,200

71%

7

Eat

$35.00

227

272

Yes

$1,400

39%

$1,500

78%

3

Section  | Production

Production vs Capacity

6926929979979879871,1241,1249849849879875505501,0001,0001,0001,0001,0001,0001,1501,1501,0001,000ProductionCapacityAndrewsBaldwinChesterDigbyErieFerris01002003004005006007008009001000110012001300

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

692

692

0

$35.00

$9.97

$12.29

35.6%

4.3

650

177%

Baker

Low Tech

997

1,001

0

$35.00

$10.53

$13.70

27.4%

3.5

1,100

155%

Cake

High Tech

987

987

0

$37.75

$14.15

$16.71

12.9%

3

1,000

160%

Daze

Low Tech

1,124

1,333

0

$35.00

$12.80

$15.09

18.4%

3

1,050

160%

Eat

Low Tech

984

1,022

0

$35.00

$10.11

$14.21

26.3%

3

1,400

133%

Fast

Low Tech

987

1,132

0

$35.00

$12.58

$16.71

10.2%

3

1,000

160%

Section  | Finance

Income Statement

Categories

Andrews

Baldwin

Chester

Digby

Erie

Ferris

Sales

$24,215

$35,051

$37,259

$46,661

$35,769

$39,613

Variable Costs

Direct Material

$7,095

$11,734

$15,980

$17,988

$11,828

$16,875

Direct Labor

$8,504

$13,712

$16,490

$20,106

$14,540

$18,698

Inventory Carry

$0

$0

$0

$0

$0

$0

Total Variable Costs (Labor, Material, Carry)

$15,599

$25,446

$32,470

$38,094

$26,369

$35,573

Contribution Margin

$8,616

$9,605

$4,789

$8,567

$9,400

$4,039

Period Costs

Depreciation

$1,005

$1,467

$1,200

$1,260

$1,987

$1,200

SG&A

R&D

$331

$317

$374

$91

$0

$0

Promotions

$1,200

$1,400

$800

$900

$1,500

$1,000

Sales

$1,200

$1,400

$800

$900

$1,400

$1,000

Administration

$381

$663

$596

$753

$633

$631

Total Period Costs

$4,117

$5,246

$3,770

$3,903

$5,520

$3,831

Net Margin

$4,499

$4,359

$1,019

$4,664

$3,881

$208

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

$7,530

$4,749

$1,220

$5,400

$2,775

$1,000

EBIT

($3,031)

($390)

($201)

($736)

$1,106

($792)

Interest (Short term/Long Term)

$831

$626

$1,708

$794

$1,107

$793

Taxes

($1,352)

($356)

($668)

($536)

$0

($555)

Profit Sharing

$0

$0

$0

$0

$0

$0

Net Profit

($2,511)

($660)

($1,240)

($995)

($1)

($1,030)

Cash Flow Statement

Categories

Andrews

Baldwin

Chester

Digby

Erie

Ferris

Starting Cash Position

$8,574

$3,346

$4,988

$754

$1,102

$2,882

Cash From Operations

Net Income(Loss)

($2,511)

($660)

($1,240)

($995)

($1)

($1,030)

Adjustment For Non-Cash Items

Depreciation

$1,005

$1,467

$1,200

$1,260

$1,987

$1,200

Extraordinary Gains/Losses/Write-offs

$0

$26

($49)

$0

$0

$0

Changes In Current Assets And Liabilities

Accounts Payable

($5)

$836

($72)

$154

($411)

($140)

Inventory

$0

$116

$0

$6,349

$1,151

$4,508

Accounts Receivable

$171

($654)

$154

($993)

$470

($41)

Net Cash From Operations

($1,340)

$1,131

($7)

$5,775

$3,196

$4,497

Cash From Investing

Net Plant Improvements

($2,320)

($2,000)

$0

($900)

($6,800)

$0

Cash From Financing

Dividends Paid

$0

$0

($91)

$0

$0

$0

Sales Of Common Stock

$100

$300

$200

$0

$300

$0

Purchase Of Common Stock

$0

$0

($100)

$0

$0

$0

Cash From Long-Term Debt Issued

$500

$0

$5,000

$0

$1,200

$0

Early Retirement Of Long-Term Debt

$0

($500)

($500)

$0

$0

$0

Retirement Of Current Debt

($3,200)

$0

($6,000)

$0

($300)

$0

Cash From Current Debt Borrowing

$1,800

$0

$7,500

$0

$2,000

$0

Cash From Emergency Loan

$0

$0

$0

$0

$0

$0

Net Cash From Financing

($800)

($200)

$6,009

$0

$3,200

$0

Effect Of Exchange Rates

$0

$0

$0

$0

$0

$0

Net Change In Cash

($4,460)

($1,069)

$6,002

$4,875

($404)

$4,497

Ending Cash Position

$4,114

$2,276

$10,990

$5,629

$698

$7,379

Balance Sheet

Categories

Andrews

Baldwin

Chester

Digby

Erie

Ferris

Cash

$4,114

$2,276

$10,990

$5,629

$698

$7,379

Accounts Receivable

$1,990

$2,881

$3,062

$3,835

$2,940

$3,256

Inventory

$0

$0

$0

$0

$0

$0

Current Assets

$6,105

$5,157

$14,053

$9,465

$3,638

$10,635

Plant and Equipment

$15,080

$22,000

$18,000

$18,900

$29,800

$18,000

Accumulated Depreciation

($5,156)

($8,800)

($8,400)

($8,460)

($9,520)

($8,400)

Fixed Assets

$9,924

$13,200

$9,600

$10,440

$20,280

$9,600

Total Assets

$16,029

$18,357

$23,653

$19,905

$23,918

$20,235

Accounts Payable

$1,282

$2,082

$2,669

$2,609

$2,073

$2,553

Current Debt

$1,800

$0

$7,500

$1,100

$3,001

$1,100

Current Liabilities

$3,082

$2,082

$10,169

$3,709

$5,074

$3,653

Long-Term Liabilities

$5,417

$4,946

$7,576

$5,500

$6,800

$5,500

Total Liabilities

$8,499

$7,028

$17,745

$9,209

$11,874

$9,153

Common Stock

$3,753

$3,204

$3,996

$2,904

$3,382

$2,904

Retained Earnings

$3,777

$8,126

$1,912

$7,791

$8,662

$8,177

Total Equity

$7,530

$11,330

$5,908

$10,695

$12,044

$11,081

Total Liabilities & Equity

$16,029

$18,357

$23,653

$19,905

$23,918

$20,235

Stock Market Summary

Company

Closing Price

Change

Shares Outstanding

Market Cap

Book Value

EPS

Dividend

Yield

P/E

Andrews

$1.00

$0.00

2,230,643

$2m

$3.38

($1.13)

$0.00

0%

-0.89

Baldwin

$2.14

$1.08

2,283,904

$5m

$4.96

($0.29)

$0.00

0%

-7.39

Chester

$1.00

$0.00

2,274,191

$2m

$2.60

($0.55)

$0.04

4%

-1.83

Digby

$1.80

$0.80

2,000,000

$4m

$5.35

($0.50)

$0.00

0%

-3.62

Erie

$3.39

$2.25

2,285,676

$8m

$5.27

$0.00

$0.00

0%

-12,035.09

Ferris

$2.36

$0.61

2,000,000

$5m

$5.54

($0.52)

$0.00

0%

-4.58

Bond Market Summary

Company

Series

Face Value

Yield

Closing Price

S&P Rating

Andrews

12.0S2025 13.0S2027 10.2S2032 11.1S2033

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

11.92% 12.47% 11.04% 11.43%

$100.68 $104.29 $92.43 $97.13

CCC CCC CCC CCC

Baldwin

12.0S2025 13.0S2027

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

11.6% 11.87%

$103.47 $109.51

BBB BBB

Chester

10.2S2032 12.4S2033

$2,575,945 $5,000,000

11.98% 12.89%

$85.17 $96.22

DDD DDD

Digby

12.0S2025 13.0S2027

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

11.78% 12.2%

$101.89 $106.53

BB BB

Erie

12.0S2025 13.0S2027 10.2S2032 10.6S2033

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

11.84% 12.32% 10.79% 10.98%

$101.37 $105.56 $94.51 $96.50

B B B B

Ferris

12.0S2025 13.0S2027

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

11.74% 12.13%

$102.24 $107.18

BB BB

Next Year's Prime Rate: 7%

Stock Price

4.594.5911112.142.143.393.391.751.75AndrewsBaldwinChesterDigbyErieFerris20212022202320242025202620272028$0$10

Net Profit

AndrewsBaldwinChesterDigbyErieFerris$-3000$-2500$-2000$-1500$-1000$-500$0

Section  | Product Financials

Andrews Income Statement

Category

Able

Other Info

Total

Sales

$24,215

$24,215

Variable Cost

$15,599

$15,599

Fixed Cost

$4,117

$4,117

Net Margin

$4,499

$4,499

Other (Fees, Writeoffs)

$7,530

Long Term Interest

$657

Taxes & Tariffs

($1,352)

Profit Sharing

$0

Net Profit

($2,511)

Baldwin Income Statement

Category

Baker

Other Info

Total

Sales

$35,051

$35,051

Variable Cost

$25,446

$25,446

Fixed Cost

$5,246

$5,246

Net Margin

$4,359

$4,359

Other (Fees, Writeoffs)

$4,749

Long Term Interest

$626

Taxes & Tariffs

($356)

Profit Sharing

$0

Net Profit

($660)

Chester Income Statement

Category

Cake

Other Info

Total

Sales

$37,259

$37,259

Variable Cost

$32,470

$32,470

Fixed Cost

$3,770

$3,770

Net Margin

$1,019

$1,019

Other (Fees, Writeoffs)

$1,220

Long Term Interest

$883

Taxes & Tariffs

($668)

Profit Sharing

$0

Net Profit

($1,240)

Digby Income Statement

Category

Daze

Other Info

Total

Sales

$46,661

$46,661

Variable Cost

$38,094

$38,094

Fixed Cost

$3,903

$3,903

Net Margin

$4,664

$4,664

Other (Fees, Writeoffs)

$5,400

Long Term Interest

$693

Taxes & Tariffs

($536)

Profit Sharing

$0

Net Profit

($995)

Erie Income Statement

Category

Eat

Other Info

Total

Sales

$35,769

$35,769

Variable Cost

$26,369

$26,369

Fixed Cost

$5,520

$5,520

Net Margin

$3,881

$3,881

Other (Fees, Writeoffs)

$2,775

Long Term Interest

$830

Taxes & Tariffs

$0

Profit Sharing

$0

Net Profit

($1)

Ferris Income Statement

Category

Fast

Other Info

Total

Sales

$39,613

$39,613

Variable Cost

$35,573

$35,573

Fixed Cost

$3,831

$3,831

Net Margin

$208

$208

Other (Fees, Writeoffs)

$1,000

Long Term Interest

$693

Taxes & Tariffs

($555)

Profit Sharing

$0

Net Profit

($1,030)

WorkforceRound: 2 Dec. 31, 2023OP99075_1

Workforce Summary

Categories

Andrews

Baldwin

Chester

Digby

Erie

Ferris

Number of Employees

157

279

308

308

275

308

First Shift

89

180

193

193

207

193

Second Shift

68

99

115

115

68

115

Overtime %

0%

0%

0%

0%

0%

0%

Turnover Rate

9.3%

11.0%

12.0%

10.6%

11.5%

12.0%

New Employees

18

137

37

53

32

37

Separated Employees

0

0

0

0

13

0

Productivity Index

102.8%

101.0%

100.0%

102.0%

100.5%

100.0%

Section  | Custom Modules

Workforce Summary

Categories

Andrews

Baldwin

Chester

Digby

Erie

Ferris

Number of Employees

157

279

308

308

275

308

First Shift

89

180

193

193

207

193

Second Shift

68

99

115

115

68

115

Overtime %

0%

0%

0%

0%

0%

0%

Turnover Rate

9.3%

11.0%

12.0%

10.6%

11.5%

12.0%

New Employees

18

137

37

53

32

37

Separated Employees

0

0

0

0

13

0

Productivity Index

102.8%

101.0%

100.0%

102.0%

100.5%

100.0%

Human Resources

Andrews

Baldwin

Chester

Digby

Erie

Ferris

Decisions

Manufacturing - Training & Assembly Teams

$1,100

$400

$0

$800

$200

$0

Sales - Compensation

$1,100

$400

$0

$500

$200

$0

Scientists - Recruitment & Retention

$500

$400

$0

$300

$200

$0

Total Expenditures

$2,700

$1,200

$0

$1,600

$600

$0

Yearly Impacts

R & D Cycle Time

1.2%

2%

5%

2.8%

3.5%

5%

Demand

0.8%

0.6%

0%

0.4%

0.3%

0%

Accessibility

4.4%

1.6%

0%

2%

0.8%

0%

Productivity Index

2.8%

1%

0%

2%

0.5%

0%

Turnover Rate

-7.5%

10%

20%

6%

15%

20%

Production After Adjustment

-0.2%

-0.7%

-1%

-0.4%

-0.9%

-1%

Advanced Operations

Andrews

Baldwin

Chester

Digby

Erie

Ferris

Decisions

Inventory Control

$900

$500

$0

$0

$300

$0

Suppliers

$2,000

$1,500

$1,000

$2,000

$1,200

$1,000

Total Quality Management - Process

$1,100

$500

$0

$1,700

$300

$0

Total Quality Management - Product

$800

$1,000

$0

$100

$300

$0

Total Expenditures

$4,800

$3,500

$1,000

$3,800

$2,100

$1,000

Yearly Impacts

Material Cost

-2.8%

-5%

-3%

-0.4%

-3.5%

-3%

R & D Cycle Time

0%

2.5%

5%

0%

4%

5%

Labor Cost

-3.3%

-4.8%

-3%

-0.3%

-3.6%

-3%

Demand

3.3%

3.8%

-5%

-4.3%

-2%

-5%

Inventory Carrying Cost

0.7%

3.5%

7%

7%

4.9%

7%

Production After Adjustment

4.8%

-1.5%

-5%

6.8%

-3.7%

-5%

Cumulative Impacts

Andrews

Baldwin

Chester

Digby

Erie

Ferris

Material Cost

-6.8%

-15%

-6%

-3.4%

-5.7%

-6%

R & D Cycle Time

3.8%

9.5%

15%

7.8%

10%

15%

Labor Cost

-7.2%

-13.5%

-6%

-3.3%

-5.9%

-6%

Demand

5.3%

15.6%

-10%

-8.8%

-4.7%

-10%

Accessibility

4.4%

1.6%

0%

2%

0.8%

0%

Productivity Index

2.8%

1%

0%

2%

0.5%

0%

Turnover Rate

-7.5%

10%

20%

6%

15%

20%

Inventory Carrying Cost

4.9%

7%

14%

14%

10.5%

14%

Production After Adjustment

2.4%

-7.2%

-11%

1.4%

-6.9%

-11%