Final report

profilenirmak
round1results.docx

Capsim Ops logo

OP99075_1    Round  1 - 2022 Report

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

$26,295

$27,100

$39,138

$34,579

$41,492

$39,120

$34,621

Profit

($3,447)

($1,956)

($5,233)

($2,056)

($1,900)

($1,635)

($2,705)

Contribution Margin

15.58%

20.28%

-1.89%

8.17%

13.45%

7.97%

10.59%

Stock Price

$1.00

$1.06

$1.00

$1.00

$1.14

$1.75

$1.16

Emergency Loan

$0

$0

$0

$0

$0

$0

$0

Market Share

12.7%

13.0%

18.8%

16.6%

20.0%

18.8%

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.3 Size 14.7

9%

High Tech

Customer Buying Criteria

Expectations

Importance

Positioning

Performance 8.1 Size 11.9

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

14.5

18,300

2.2

October 14, 2022

Baker

6.4

13.6

15,000

4.1

April 2, 2022

Cake

6.8

13.2

20,450

2.4

April 23, 2022

Daze

6.7

13.8

18,000

2.4

April 30, 2022

Eat

5.0

14.0

18,000

2.1

November 29, 2022

Fast

6.4

13.6

21,000

4.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.3 Size 14.7

9%

Demand Information

2022 Total Market Size

4,158

2022 Total Units Sold

4,158

2023 Demand Growth Rate

10%

Market Share

Andrews12.9 %Andrews12.9 %Baldwin14.0 %Baldwin14.0 %Chester18.9 %Chester18.9 %Digby14.9 %Digby14.9 %Erie20.3 %Erie20.3 %Ferris19.0 %Ferris19.0 %AndrewsBaldwinChesterDigbyErieFerris

Top Products

Name

Price

Units Sold 

Potential Sold

Stock Out

Sales Budget

Customer Accessibility

Promo Budget

Customer Awareness

Customer Satisfaction

Eat

$35.00

845

734

No

$1,200

37%

$1,150

63%

14

Fast

$35.00

789

684

No

$1,000

35%

$1,000

58%

13

Cake

$31.00

785

897

Yes

$1,250

38%

$1,250

66%

20

Daze

$35.00

618

536

No

$1,000

35%

$1,000

58%

12

Baker

$34.00

584

519

No

$200

27%

$1,400

70%

8

Able

$35.00

537

788

Yes

$1,200

37%

$1,200

65%

16

Section  | Marketing

High Tech

Customer Buying Criteria

Categories

Expectations

Importance

Positioning

Performance 8.1 Size 11.9

33%

Age

0 Years

29%

Price

$25.00 - $45.00

25%

Reliability

17,000 - 23,000 Hours

13%

Demand Information

2022 Total Market Size

1,944

2022 Total Units Sold

1,944

2023 Demand Growth Rate

20%

Market Share

Andrews11.0 %Andrews11.0 %Baldwin11.0 %Baldwin11.0 %Chester24.6 %Chester24.6 %Digby19.0 %Digby19.0 %Erie17.5 %Erie17.5 %Ferris16.9 %Ferris16.9 %AndrewsBaldwinChesterDigbyErieFerris

Top Products

Name

Price

Units Sold 

Potential Sold

Stock Out

Sales Budget

Customer Accessibility

Promo Budget

Customer Awareness

Customer Satisfaction

Cake

$31.00

477

551

Yes

$1,250

39%

$1,250

66%

17

Daze

$35.00

370

318

No

$1,000

35%

$1,000

58%

9

Eat

$35.00

340

295

No

$1,200

38%

$1,150

63%

7

Fast

$35.00

329

283

No

$1,000

35%

$1,000

58%

8

Able

$35.00

214

306

Yes

$1,200

38%

$1,200

65%

7

Baker

$34.00

213

191

No

$200

28%

$1,400

70%

4

Section  | Production

Production vs Capacity

5425425925921,0541,0549889881,0151,0151,0541,0545505501,0001,0001,0001,0001,0001,0001,0001,0001,0001,000ProductionCapacityAndrewsBaldwinChesterDigbyErieFerris0501001502002503003504004505005506006507007508008509009501000105011001…

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

542

751

0

$35.00

$11.50

$14.47

15.6%

4.3

550

145%

Baker

Low Tech

592

797

4

$34.00

$11.64

$12.31

20.3%

3.5

1,000

90%

Cake

Low Tech

1,054

1,263

0

$31.00

$14.97

$15.42

-1.9%

3

1,000

160%

Daze

Low Tech

988

988

209

$35.00

$13.54

$15.14

8.2%

3

1,000

150%

Eat

Low Tech

1,015

1,185

38

$35.00

$11.71

$14.85

13.5%

3.5

1,150

150%

Fast

Low Tech

1,054

1,118

145

$35.00

$14.29

$15.42

8%

3

1,000

160%

Section  | Finance

Income Statement

Categories

Andrews

Baldwin

Chester

Digby

Erie

Ferris

Sales

$26,295

$27,100

$39,138

$34,579

$41,492

$39,120

Variable Costs

Direct Material

$11,339

$11,327

$20,625

$15,219

$18,095

$17,753

Direct Labor

$10,859

$10,247

$19,253

$14,835

$17,511

$17,045

Inventory Carry

$0

$30

$0

$1,698

$304

$1,206

Total Variable Costs (Labor, Material, Carry)

$22,198

$21,604

$39,878

$31,753

$35,910

$36,003

Contribution Margin

$4,096

$5,495

($740)

$2,826

$5,582

$3,117

Period Costs

Depreciation

$851

$1,333

$1,200

$1,200

$1,533

$1,200

SG&A

R&D

$786

$252

$309

$328

$911

$0

Promotions

$1,200

$1,400

$1,250

$1,000

$1,150

$1,000

Sales

$1,200

$200

$1,250

$1,000

$1,200

$1,000

Administration

$1,180

$1,099

$618

$648

$751

$618

Total Period Costs

$5,217

$4,284

$4,627

$4,175

$5,546

$3,818

Net Margin

($1,120)

$1,211

($5,367)

($1,349)

$37

($701)

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

$3,300

$3,538

$1,833

$1,000

$2,119

$1,000

EBIT

($4,420)

($2,326)

($7,200)

($2,349)

($2,083)

($1,701)

Interest (Short term/Long Term)

$883

$683

$850

$814

$840

$814

Taxes

($1,856)

($1,053)

($2,818)

($1,107)

($1,023)

($880)

Profit Sharing

$0

$0

$0

$0

$0

$0

Net Profit

($3,447)

($1,956)

($5,233)

($2,056)

($1,900)

($1,635)

Cash Flow Statement

Categories

Andrews

Baldwin

Chester

Digby

Erie

Ferris

Starting Cash Position

$2,073

$2,073

$2,073

$2,073

$2,073

$2,073

Cash From Operations

Net Income(Loss)

($3,447)

($1,956)

($5,233)

($2,056)

($1,900)

($1,635)

Adjustment For Non-Cash Items

Depreciation

$851

$1,333

$1,200

$1,200

$1,533

$1,200

Extraordinary Gains/Losses/Write-offs

$252

$20

$525

$0

$1

$0

Changes In Current Assets And Liabilities

Accounts Payable

($1,563)

($1,604)

($109)

($395)

($366)

($157)

Inventory

$6,534

$6,419

$6,534

$186

$5,383

$2,026

Accounts Receivable

$428

$362

($628)

($253)

($821)

($626)

Net Cash From Operations

$3,055

$4,573

$2,289

($1,319)

$3,831

$809

Cash From Investing

Net Plant Improvements

$2,405

($2,000)

$0

$0

($5,000)

$0

Cash From Financing

Dividends Paid

($959)

($100)

($2,174)

$0

($202)

$0

Sales Of Common Stock

$800

$0

$1,000

$0

$200

$0

Purchase Of Common Stock

($200)

$0

($200)

$0

($100)

$0

Cash From Long-Term Debt Issued

$1,200

$0

$3,000

$0

$100

$0

Early Retirement Of Long-Term Debt

($3,000)

($1,200)

($7,000)

$0

($100)

$0

Retirement Of Current Debt

$0

$0

$0

$0

$0

$0

Cash From Current Debt Borrowing

$3,200

$0

$6,000

$0

$300

$0

Cash From Emergency Loan

$0

$0

$0

$0

$0

$0

Net Cash From Financing

$1,041

($1,300)

$626

$0

$198

$0

Effect Of Exchange Rates

$0

$0

$0

$0

$0

$0

Net Change In Cash

$6,501

$1,273

$2,915

($1,319)

($971)

$809

Ending Cash Position

$8,574

$3,346

$4,988

$754

$1,102

$2,882

Balance Sheet

Categories

Andrews

Baldwin

Chester

Digby

Erie

Ferris

Cash

$8,574

$3,346

$4,988

$754

$1,102

$2,882

Accounts Receivable

$2,161

$2,227

$3,217

$2,842

$3,410

$3,215

Inventory

$0

$116

$0

$6,349

$1,151

$4,508

Current Assets

$10,735

$5,689

$8,205

$9,945

$5,663

$10,605

Plant and Equipment

$12,760

$20,000

$18,000

$18,000

$23,000

$18,000

Accumulated Depreciation

($4,151)

($7,333)

($7,200)

($7,200)

($7,533)

($7,200)

Fixed Assets

$8,609

$12,667

$10,800

$10,800

$15,467

$10,800

Total Assets

$19,345

$18,355

$19,005

$20,745

$21,130

$21,405

Accounts Payable

$1,287

$1,246

$2,741

$2,455

$2,484

$2,694

Current Debt

$3,200

$0

$6,000

$0

$300

$0

Current Liabilities

$4,487

$1,246

$8,741

$2,455

$2,784

$2,694

Long-Term Liabilities

$4,917

$5,420

$3,125

$6,600

$6,601

$6,600

Total Liabilities

$9,404

$6,665

$11,866

$9,055

$9,385

$9,294

Common Stock

$3,653

$2,904

$3,851

$2,904

$3,082

$2,904

Retained Earnings

$6,288

$8,786

$3,288

$8,786

$8,663

$9,208

Total Equity

$9,941

$11,690

$7,139

$11,690

$11,745

$12,112

Total Liabilities & Equity

$19,345

$18,355

$19,005

$20,745

$21,130

$21,405

Stock Market Summary

Company

Closing Price

Change

Shares Outstanding

Market Cap

Book Value

EPS

Dividend

Yield

P/E

Andrews

$1.00

($3.59)

2,130,643

$2m

$4.67

($1.62)

$0.45

45%

-0.62

Baldwin

$1.06

($3.54)

2,000,000

$2m

$5.84

($0.98)

$0.05

4.7%

-1.08

Chester

$1.00

($3.59)

2,174,191

$2m

$3.28

($2.41)

$1.00

100%

-0.42

Digby

$1.00

($3.59)

2,000,000

$2m

$5.85

($1.03)

$0.00

0%

-0.97

Erie

$1.14

($3.46)

2,021,774

$2m

$5.81

($0.94)

$0.10

8.8%

-1.21

Ferris

$1.75

($2.84)

2,000,000

$3m

$6.06

($0.82)

$0.00

0%

-2.14

Bond Market Summary

Company

Series

Face Value

Yield

Closing Price

S&P Rating

Andrews

12.0S2025 13.0S2027 10.2S2032

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

11.74% 12.15% 10.77%

$102.20 $107.00 $94.72

B B B

Baldwin

12.0S2025 13.0S2027

$2,119,789 $3,300,000

11.38% 11.59%

$105.49 $112.19

A A

Chester

13.0S2027 10.2S2032

$125,126 $3,000,000

12.73% 11.62%

$102.14 $87.77

CC CC

Digby

11.0S2023 12.0S2025 13.0S2027

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

10.96% 11.6% 11.93%

$100.36 $103.45 $108.96

BB BB BB

Erie

11.0S2023 12.0S2025 13.0S2027 10.2S2032

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

10.96% 11.6% 11.93% 10.45%

$100.36 $103.45 $108.96 $97.60

BB BB BB BB

Ferris

11.0S2023 12.0S2025 13.0S2027

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

10.95% 11.57% 11.89%

$100.45 $103.70 $109.36

BB BB BB

Next Year's Prime Rate: 7%

Stock Price

4.594.59111.751.75AndrewsBaldwinChesterDigbyErieFerris20212022202320242025202620272028$0$10

Net Profit

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

Section  | Product Financials

Andrews Income Statement

Category

Able

Other Info

Total

Sales

$26,295

$26,295

Variable Cost

$22,198

$22,198

Fixed Cost

$5,217

$5,217

Net Margin

($1,120)

($1,120)

Other (Fees, Writeoffs)

$3,300

Long Term Interest

$601

Taxes & Tariffs

($1,856)

Profit Sharing

$0

Net Profit

($3,447)

Baldwin Income Statement

Category

Baker

Other Info

Total

Sales

$27,100

$27,100

Variable Cost

$21,604

$21,604

Fixed Cost

$4,284

$4,284

Net Margin

$1,211

$1,211

Other (Fees, Writeoffs)

$3,538

Long Term Interest

$683

Taxes & Tariffs

($1,053)

Profit Sharing

$0

Net Profit

($1,956)

Chester Income Statement

Category

Cake

Other Info

Total

Sales

$39,138

$39,138

Variable Cost

$39,878

$39,878

Fixed Cost

$4,627

$4,627

Net Margin

($5,367)

($5,367)

Other (Fees, Writeoffs)

$1,833

Long Term Interest

$322

Taxes & Tariffs

($2,818)

Profit Sharing

$0

Net Profit

($5,233)

Digby Income Statement

Category

Daze

Other Info

Total

Sales

$34,579

$34,579

Variable Cost

$31,753

$31,753

Fixed Cost

$4,175

$4,175

Net Margin

($1,349)

($1,349)

Other (Fees, Writeoffs)

$1,000

Long Term Interest

$814

Taxes & Tariffs

($1,107)

Profit Sharing

$0

Net Profit

($2,056)

Erie Income Statement

Category

Eat

Other Info

Total

Sales

$41,492

$41,492

Variable Cost

$35,910

$35,910

Fixed Cost

$5,546

$5,546

Net Margin

$37

$37

Other (Fees, Writeoffs)

$2,119

Long Term Interest

$813

Taxes & Tariffs

($1,023)

Profit Sharing

$0

Net Profit

($1,900)

Ferris Income Statement

Category

Fast

Other Info

Total

Sales

$39,120

$39,120

Variable Cost

$36,003

$36,003

Fixed Cost

$3,818

$3,818

Net Margin

($701)

($701)

Other (Fees, Writeoffs)

$1,000

Long Term Interest

$814

Taxes & Tariffs

($880)

Profit Sharing

$0

Net Profit

($1,635)

WorkforceRound: 1 Dec. 31, 2022OP99075_1

Workforce Summary

Categories

Andrews

Baldwin

Chester

Digby

Erie

Ferris

Number of Employees

154

173

308

288

288

308

First Shift

106

173

193

192

192

193

Second Shift

48

0

115

96

96

115

Overtime %

0%

0%

0%

0%

0%

0%

Turnover Rate

10.0%

10.0%

10.0%

10.0%

10.0%

10.0%

New Employees

15

17

31

29

29

31

Separated Employees

154

135

0

20

20

0

Productivity Index

100.0%

100.0%

100.0%

100.0%

100.0%

100.0%

Section  | Custom Modules

Workforce Summary

Categories

Andrews

Baldwin

Chester

Digby

Erie

Ferris

Number of Employees

154

173

308

288

288

308

First Shift

106

173

193

192

192

193

Second Shift

48

0

115

96

96

115

Overtime %

0%

0%

0%

0%

0%

0%

Turnover Rate

10.0%

10.0%

10.0%

10.0%

10.0%

10.0%

New Employees

15

17

31

29

29

31

Separated Employees

154

135

0

20

20

0

Productivity Index

100.0%

100.0%

100.0%

100.0%

100.0%

100.0%

Advanced Operations

Andrews

Baldwin

Chester

Digby

Erie

Ferris

Decisions

Inventory Control

$400

$500

$0

$0

$200

$0

Suppliers

$1,500

$1,000

$1,000

$1,000

$1,500

$1,000

Total Quality Management - Process

$300

$0

$0

$0

$200

$0

Total Quality Management - Product

$700

$2,000

$0

$0

$200

$0

Total Expenditures

$2,900

$3,500

$1,000

$1,000

$2,100

$1,000

Yearly Impacts

Material Cost

-4%

-10%

-3%

-3%

-2.2%

-3%

R & D Cycle Time

2.5%

5%

5%

5%

2.5%

5%

Labor Cost

-3.9%

-8.8%

-3%

-3%

-2.3%

-3%

Demand

1.3%

11.3%

-5%

-5%

-3%

-5%

Inventory Carrying Cost

4.2%

3.5%

7%

7%

5.6%

7%

Production After Adjustment

-2.2%

-5%

-5%

-5%

-2.4%

-5%

Cumulative Impacts

Andrews

Baldwin

Chester

Digby

Erie

Ferris

Material Cost

-4%

-10%

-3%

-3%

-2.2%

-3%

R & D Cycle Time

2.5%

5%

5%

5%

2.5%

5%

Labor Cost

-3.9%

-8.8%

-3%

-3%

-2.3%

-3%

Demand

1.3%

11.3%

-5%

-5%

-3%

-5%

Inventory Carrying Cost

4.2%

3.5%

7%

7%

5.6%

7%

Production After Adjustment

-2.2%

-5%

-5%

-5%

-2.4%

-5%