Capsim Portfolio Project

jimmh.picholsa9u9

Round3simreport.pdf

Home >Business & Finance homework help >Management homework help >Capsim Portfolio Project

3/24/2019 Report

ww5.capsim.com/capsimplatform/report?simKey=368889&round=3&teamName=Baldwin 1/12

Round 3 - 2022 Report

Sim ID ZP81798_1

3/24/2019 Report

ww5.capsim.com/capsimplatform/report?simKey=368889&round=3&teamName=Baldwin 2/12

High Level Overview High Level Overview

Andrews Baldwin Chester Digby Erie Ferris Average

Sales $62,380 $63,964 $43,765 $43,765 $43,765 $43,765 $50,234

Pro�t $7,387 $11,006 $5,263 $5,263 $5,263 $5,263 $6,574

Contribution Margin 30.6% 39.0% 28.4% 28.4% 28.4% 28.4% 30.5%

Stock Price $28.59 $40.91 $26.22 $26.22 $26.22 $26.22 $29.06

Emergency Loan $0 $0 $0 $0 $0 $0 $0

Market Share 20.7% 21.2% 14.5% 14.5% 14.5% 14.5% 16.7%

Round 3 - 2022 Report

Sim ID ZP81798_1

3/24/2019 Report

ww5.capsim.com/capsimplatform/report?simKey=368889&round=3&teamName=Baldwin 3/12

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

Performance

Si ze

0 2 4 6 8 10 12 14 16 18 20 0

Product List

Name Performance Size Reliability Age Revision Date

Abby -- -- -- -- April 24, 2023

Able 7.2 13.0 19,800 1.9 April 1, 2022

Baker 6.8 12.4 19,500 1.4 December 24, 2022

Cake 6.4 13.6 21,000 6.1 November 25, 2016

Daze 6.4 13.6 21,000 6.1 November 25, 2016

Eat 6.4 13.6 21,000 6.1 November 25, 2016

Fast 6.4 13.6 21,000 6.1 November 25, 2016

3/24/2019 Report

ww5.capsim.com/capsimplatform/report?simKey=368889&round=3&teamName=Baldwin 4/12

Marketing

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%

Demand Information

2022 Total Market Size 6,708

2022 Total Units Sold 5,670

2023 Demand Growth Rate 10%

Market Share

Andrews Baldwin Chester Digby Erie

Ferris

Top Products

Name Price Units Sold Potential Sold Stock Out Sales Budget Customer Accessibility Promo Budget Customer Awareness Customer Satisfaction

Able $35.00 862 1,355 Yes $2,000 58% $1,300 81% 13

Baker $34.00 512 679 Yes $1,550 42% $1,300 82% 15

Cake $34.00 442 425 Yes $1,000 29% $1,000 62% 5

Daze $34.00 442 425 Yes $1,000 29% $1,000 62% 5

Eat $34.00 442 425 Yes $1,000 29% $1,000 62% 5

Fast $34.00 442 425 Yes $1,000 29% $1,000 62% 5

3/24/2019 Report

ww5.capsim.com/capsimplatform/report?simKey=368889&round=3&teamName=Baldwin 6/12

Production

Production Vs. Capacity

1,7821,7821,782

1,8811,8811,881

1,2871,2871,287

1,0001,0001,000

800800800

Production Capacity

Andrews

Baldwin

Chester

Digby

Erie

Ferris

0 100 200 300 400 500 600 700 800 900 1000 1100 1200 1300 1400 1500 1600 1700 1800 1900 2…

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

Abby -- 0 0 -- $0.00 $0.00 $0.00 0% 1 500 0%

Able Low Tech 1,782 1,782 0 $35.00 $13.19 $10.43 30.6% 4 1,100 180%

Baker High Tech 1,881 1,881 0 $34.00 $13.34 $9.04 39% 6 1,250 190%

Cake Low Tech 1,287 1,287 0 $34.00 $12.14 $11.64 28.4% 3 800 163%

Daze Low Tech 1,287 1,287 0 $34.00 $12.14 $11.64 28.4% 3 800 163%

Eat Low Tech 1,287 1,287 0 $34.00 $12.14 $11.64 28.4% 3 800 163%

Fast Low Tech 1,287 1,287 0 $34.00 $12.14 $11.64 28.4% 3 800 163%

3/24/2019 Report

ww5.capsim.com/capsimplatform/report?simKey=368889&round=3&teamName=Baldwin 7/12

Finance Income Statement

Andrews Baldwin Chester Digby Erie Ferris

Sales $62,380 $63,964 $43,765 $43,765 $43,765 $43,765

Variable Costs

Direct Material $24,675 $21,981 $16,338 $16,338 $16,338 $16,338

Direct Labor $18,589 $17,006 $14,978 $14,978 $14,978 $14,978

Inventory Carry $0 $0 $0 $0 $0 $0

Total Variable Costs (Labor, Material, Carry) $43,264 $38,987 $31,316 $31,316 $31,316 $31,316

Contribution Margin $19,117 $24,978 $12,449 $12,449 $12,449 $12,449

Fixed Costs

Depreciation $1,613 $2,500 $960 $960 $960 $960

SG&A

R&D $1,248 $980 $0 $0 $0 $0

Promotions $1,300 $1,300 $1,000 $1,000 $1,000 $1,000

Sales $2,000 $1,550 $1,000 $1,000 $1,000 $1,000

Administration $985 $1,009 $681 $681 $681 $681

Fixed Costs $7,146 $7,339 $3,641 $3,641 $3,641 $3,641

Net Margin $11,970 $17,639 $8,808 $8,808 $8,808 $8,808

Other (Fees/Write-offs/Bonuses/Relocation Fee) $169 $211 $0 $0 $0 $0

EBIT $11,801 $17,428 $8,808 $8,808 $8,808 $8,808

Interest (Short term/Long Term) $204 $149 $546 $546 $546 $546

Taxes $4,059 $6,047 $2,892 $2,892 $2,892 $2,892

Pro�t Sharing $151 $225 $107 $107 $107 $107

Net Pro�t $7,387 $11,006 $5,263 $5,263 $5,263 $5,263

Cash Flow Statement

Andrews Baldwin Chester Digby Erie Ferris

Starting Cash Position $6,428 $5,662 $17,903 $17,903 $17,903 $17,903

Cash From Operations

Net Income(Loss) $7,387 $11,006 $5,263 $5,263 $5,263 $5,263

Adjustment For Non-Cash Items

Depreciation $1,613 $2,500 $960 $960 $960 $960

Extraordinary Gains/Losses/Write-offs $61 $189 $0 $0 $0 $0

Changes In Current Assets And Liabilities

Accounts Payable $182 $489 ($80) ($80) ($80) ($80)

Inventory $0 $0 $0 $0 $0 $0

Accounts Receivable ($641) ($1,107) $198 $198 $198 $198

Net Cash From Operations $8,603 $13,077 $6,341 $6,341 $6,341 $6,341

Cash From Investing

Net Plant Improvements ($7,200) ($11,500) $0 $0 $0 $0

Cash From Financing

Dividends Paid ($1,640) ($900) $0 $0 $0 $0

Sales Of Common Stock $2,000 $0 $0 $0 $0 $0

Purchase Of Common Stock $0 $0 $0 $0 $0 $0

Cash From Long-Term Debt Issued $0 $0 $0 $0 $0 $0

Early Retirement Of Long-Term Debt ($500) ($1,500) $0 $0 $0 $0

Retirement Of Current Debt $0 $0 ($867) ($867) ($867) ($867)

Cash From Current Debt Borrowing $0 $0 $0 $0 $0 $0

Cash From Emergency Loan $0 $0 $0 $0 $0 $0

Net Cash From Financing ($140) ($2,400) ($867) ($867) ($867) ($867)

Effect Of Exchange Rates $0 $0 $0 $0 $0 $0

Net Change In Cash $1,263 ($823) $5,474 $5,474 $5,474 $5,474

Ending Cash Position $7,691 $4,839 $23,377 $23,377 $23,377 $23,377

3/24/2019 Report

ww5.capsim.com/capsimplatform/report?simKey=368889&round=3&teamName=Baldwin 8/12

Balance Sheet

Andrews Baldwin Chester Digby Erie Ferris

Cash $7,691 $4,839 $23,377 $23,377 $23,377 $23,377

Accounts Receivable $5,127 $5,257 $3,597 $3,597 $3,597 $3,597

Inventory $0 $0 $0 $0 $0 $0

Current Assets $12,819 $10,096 $26,974 $26,974 $26,974 $26,974

Plant and Equipment $29,200 $37,500 $14,400 $14,400 $14,400 $14,400

Accumulated Depreciation ($8,947) ($10,207) ($7,680) ($7,680) ($7,680) ($7,680)

Fixed Assets $20,253 $27,293 $6,720 $6,720 $6,720 $6,720

Total Assets $33,072 $37,390 $33,694 $33,694 $33,694 $33,694

Accounts Payable $3,556 $3,204 $2,574 $2,574 $2,574 $2,574

Current Liabilities $3,556 $3,204 $2,574 $2,574 $2,574 $2,574

Current Debt $0 $0 $0 $0 $0 $0

Long-Term Liabilities $1,572 $1,147 $4,333 $4,333 $4,333 $4,333

Total Liabilities $5,127 $4,351 $6,907 $6,907 $6,907 $6,907

Common Stock $5,823 $2,323 $2,323 $2,323 $2,323 $2,323

Retained Earnings $22,121 $30,715 $24,464 $24,464 $24,464 $24,464

Total Equity $27,944 $33,039 $26,787 $26,787 $26,787 $26,787

Total Liabilities & Equity $33,072 $37,390 $33,694 $33,694 $33,694 $33,694

Stock Market Summary

Company Closing Price Change Shares Outstanding Market Cap Book Value EPS Dividend Yield P/E

Andrews $28.59 $7.76 2,186,499 $63m $12.78 $3.38 $0.75 3% 8.46

Baldwin $40.91 $14.12 2,000,000 $82m $16.52 $5.50 $0.45 1% 7.44

Chester $26.22 $4.32 2,000,000 $52m $13.39 $2.63 $0.00 0% 9.97

Digby $26.22 $4.32 2,000,000 $52m $13.39 $2.63 $0.00 0% 9.97

Erie $26.22 $4.32 2,000,000 $52m $13.39 $2.63 $0.00 0% 9.97

Ferris $26.22 $4.32 2,000,000 $52m $13.39 $2.63 $0.00 0% 9.97

Bond Market Summary

Company Series Face Value Yield Closing Price S&P Rating

Andrews 13.0S2025 $1,571,529 11.66% $111.49 AAA

Baldwin 13.0S2025 $1,146,777 11.63% $111.77 AAA

Chester 12.0S2023 13.0S2025

$1,733,333 $2,600,000

11.64% 11.69%

$103.13 $111.22

AAA AAA

Digby 12.0S2023 13.0S2025

$1,733,333 $2,600,000

11.64% 11.69%

$103.13 $111.22

AAA AAA

Erie 12.0S2023 13.0S2025

$1,733,333 $2,600,000

11.64% 11.69%

$103.13 $111.22

AAA AAA

Ferris 12.0S2023 13.0S2025

$1,733,333 $2,600,000

11.64% 11.69%

$103.13 $111.22

AAA AAA

Next Year's Prime Rate: 7%

Stock Price

3/24/2019 Report

ww5.capsim.com/capsimplatform/report?simKey=368889&round=3&teamName=Baldwin 9/12

Andrews Baldwin Chester Digby Erie Ferris

2019 2020 2021 2022 2023 2024 2025 2026 $0

$10

$20

$30

$40

$50

Net Pro�t

Andrews Baldwin Chester Digby Erie Ferris $0

$2500

$5000

$7500

$10000

$12500

3/24/2019 Report

ww5.capsim.com/capsimplatform/report?simKey=368889&round=3&teamName=Baldwin 10/12

Product Financials Baldwin Income Statement

Baker Total

Sales $63,964 $63,964

Variable Cost $38,987 $38,987

Fixed Cost $7,339 $7,339

Net Margin $17,639 $17,639

Other (Fees, Writeoffs) $211

Long Term Interest $149

Taxes & Tariffs $6,047

Pro�t Sharing $225

Net Pro�t $11,006

3/24/2019 Report

ww5.capsim.com/capsimplatform/report?simKey=368889&round=3&teamName=Baldwin 11/12

Workforce Round: 3 Dec. 31, 2022

ZP81798_1

Workforce Summary

Andrews Baldwin Chester Digby Erie Ferris

Number of Employees 303 274 250 250 250 250

First Shift 168 144 154 154 154 154

Second Shift 135 130 96 96 96 96

Overtime % 0% 0% 0% 0% 0% 0%

Turnover Rate 10.0% 10.0% 10.0% 10.0% 10.0% 10.0%

New Employees 49 49 25 25 25 25

Separated Employees 0 0 0 0 0 0

Productivity Index 100.0% 100.0% 100.0% 100.0% 100.0% 100.0%

3/24/2019 Report

ww5.capsim.com/capsimplatform/report?simKey=368889&round=3&teamName=Baldwin 12/12