Capsim Portfolio Project

jimmh.picholsa9u9

Round1Simreport.pdf

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

3/24/2019 Report

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

Round 1 - 2020 Report

Sim ID ZP81798_1

3/24/2019 Report

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

High Level Overview High Level Overview

Andrews Baldwin Chester Digby Erie Ferris Average

Sales $51,687 $48,413 $44,318 $44,318 $44,318 $44,318 $46,229

Pro�t $3,582 $4,079 $3,742 $3,742 $3,742 $3,742 $3,772

Contribution Margin 22.1% 25.3% 22.9% 22.9% 22.9% 22.9% 23.2%

Stock Price $16.58 $17.57 $16.90 $16.90 $16.90 $16.90 $16.96

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

Market Share 18.6% 17.5% 16.0% 16.0% 16.0% 16.0% 16.7%

Round 1 - 2020 Report

Sim ID ZP81798_1

3/24/2019 Report

ww5.capsim.com/capsimplatform/report?simKey=368889&round=1&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 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

Performance

Si ze

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

Product List

Name Performance Size Reliability Age Revision Date

Able 6.8 13.3 21,500 2.4 April 7, 2020

Baker 5.4 14.5 20,000 2.2 September 28, 2020

Cake 6.4 13.6 21,000 4.1 November 25, 2016

Daze 6.4 13.6 21,000 4.1 November 25, 2016

Eat 6.4 13.6 21,000 4.1 November 25, 2016

Fast 6.4 13.6 21,000 4.1 November 25, 2016

3/24/2019 Report

ww5.capsim.com/capsimplatform/report?simKey=368889&round=1&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 5.3 Size 14.7 9%

Demand Information

2020 Total Market Size 5,544

2020 Total Units Sold 5,544

2021 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 $34.50 622 678 Yes $1,800 47% $1,250 66% 18

Baker $34.00 401 408 Yes $1,300 40% $1,300 68% 9

Cake $34.00 392 377 No $1,000 35% $1,000 58% 9

Daze $34.00 392 377 No $1,000 35% $1,000 58% 9

Eat $34.00 392 377 No $1,000 35% $1,000 58% 9

Fast $34.00 392 377 No $1,000 35% $1,000 58% 9

3/24/2019 Report

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

Production

Production Vs. Capacity

1,4111,4111,411

1,3371,3371,337

1,2871,2871,287

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

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 1,411 1,498 0 $34.50 $15.64 $10.83 22.1% 3.5 800 178%

Baker Low Tech 1,337 1,424 0 $34.00 $12.38 $10.71 25.3% 4 800 169%

Cake Low Tech 1,287 1,303 71 $34.00 $14.73 $10.60 22.9% 3 800 163%

Daze Low Tech 1,287 1,303 71 $34.00 $14.73 $10.60 22.9% 3 800 163%

Eat Low Tech 1,287 1,303 71 $34.00 $14.73 $10.60 22.9% 3 800 163%

Fast Low Tech 1,287 1,303 71 $34.00 $14.73 $10.60 22.9% 3 800 163%

3/24/2019 Report

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

Finance Income Statement

Andrews Baldwin Chester Digby Erie Ferris

Sales $51,687 $48,413 $44,318 $44,318 $44,318 $44,318

Variable Costs

Direct Material $24,121 $20,959 $20,153 $20,153 $20,153 $20,153

Direct Labor $16,162 $15,199 $13,778 $13,778 $13,778 $13,778

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

Total Variable Costs (Labor, Material, Carry) $40,283 $36,158 $34,152 $34,152 $34,152 $34,152

Contribution Margin $11,404 $12,255 $10,166 $10,166 $10,166 $10,166

Fixed Costs

Depreciation $1,067 $1,173 $960 $960 $960 $960

SG&A

R&D $264 $742 $0 $0 $0 $0

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

Sales $1,800 $1,300 $1,000 $1,000 $1,000 $1,000

Administration $827 $762 $690 $690 $690 $690

Fixed Costs $5,208 $5,278 $3,650 $3,650 $3,650 $3,650

Net Margin $6,196 $6,978 $6,516 $6,516 $6,516 $6,516

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

EBIT $6,167 $6,948 $6,516 $6,516 $6,516 $6,516

Interest (Short term/Long Term) $544 $544 $641 $641 $641 $641

Taxes $1,968 $2,241 $2,056 $2,056 $2,056 $2,056

Pro�t Sharing $73 $83 $76 $76 $76 $76

Net Pro�t $3,582 $4,079 $3,742 $3,742 $3,742 $3,742

Cash Flow Statement

Andrews Baldwin Chester Digby Erie Ferris

Starting Cash Position $5,598 $5,598 $5,598 $5,598 $5,598 $5,598

Cash From Operations

Net Income(Loss) $3,582 $4,079 $3,742 $3,742 $3,742 $3,742

Adjustment For Non-Cash Items

Depreciation $1,067 $1,173 $960 $960 $960 $960

Extraordinary Gains/Losses/Write-offs $16 $16 $0 $0 $0 $0

Changes In Current Assets And Liabilities

Accounts Payable $264 ($75) ($107) ($107) ($107) ($107)

Inventory $2,352 $2,352 $506 $506 $506 $506

Accounts Receivable ($895) ($626) ($289) ($289) ($289) ($289)

Net Cash From Operations $6,386 $6,920 $4,812 $4,812 $4,812 $4,812

Cash From Investing

Net Plant Improvements ($1,600) ($3,200) $0 $0 $0 $0

Cash From Financing

Dividends Paid ($1,000) ($500) $0 $0 $0 $0

Sales Of Common Stock $0 $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 ($900) ($900) $0 $0 $0 $0

Retirement Of Current Debt $0 $0 $0 $0 $0 $0

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 ($1,900) ($1,400) $0 $0 $0 $0

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

Net Change In Cash $2,886 $2,320 $4,812 $4,812 $4,812 $4,812

Ending Cash Position $8,483 $7,918 $10,410 $10,410 $10,410 $10,410

3/24/2019 Report

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

Balance Sheet

Andrews Baldwin Chester Digby Erie Ferris

Cash $8,483 $7,918 $10,410 $10,410 $10,410 $10,410

Accounts Receivable $4,248 $3,979 $3,643 $3,643 $3,643 $3,643

Inventory $0 $0 $1,847 $1,847 $1,847 $1,847

Current Assets $12,732 $11,897 $15,899 $15,899 $15,899 $15,899

Plant and Equipment $16,000 $17,600 $14,400 $14,400 $14,400 $14,400

Accumulated Depreciation ($5,867) ($5,973) ($5,760) ($5,760) ($5,760) ($5,760)

Fixed Assets $10,133 $11,627 $8,640 $8,640 $8,640 $8,640

Total Assets $22,865 $23,523 $24,539 $24,539 $24,539 $24,539

Accounts Payable $3,118 $2,779 $2,747 $2,747 $2,747 $2,747

Current Liabilities $3,118 $2,779 $2,747 $2,747 $2,747 $2,747

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

Long-Term Liabilities $4,316 $4,316 $5,200 $5,200 $5,200 $5,200

Total Liabilities $7,434 $7,095 $7,947 $7,947 $7,947 $7,947

Common Stock $2,323 $2,323 $2,323 $2,323 $2,323 $2,323

Retained Earnings $13,108 $14,106 $14,269 $14,269 $14,269 $14,269

Total Equity $15,431 $16,429 $16,592 $16,592 $16,592 $16,592

Total Liabilities & Equity $22,865 $23,523 $24,539 $24,539 $24,539 $24,539

Stock Market Summary

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

Andrews $16.58 $5.42 2,000,000 $33m $7.72 $1.79 $0.50 3% 9.26

Baldwin $17.57 $6.41 2,000,000 $35m $8.21 $2.04 $0.25 1% 8.61

Chester $16.90 $5.74 2,000,000 $34m $8.30 $1.87 $0.00 0% 9.04

Digby $16.90 $5.74 2,000,000 $34m $8.30 $1.87 $0.00 0% 9.04

Erie $16.90 $5.74 2,000,000 $34m $8.30 $1.87 $0.00 0% 9.04

Ferris $16.90 $5.74 2,000,000 $34m $8.30 $1.87 $0.00 0% 9.04

Bond Market Summary

Company Series Face Value Yield Closing Price S&P Rating

Andrews 12.0S2023 13.0S2025

$1,716,132 $2,600,000

11.26% 11.42%

$106.53 $113.86

AA AA

Baldwin 12.0S2023 13.0S2025

$1,716,132 $2,600,000

11.21% 11.33%

$107.06 $114.70

AA AA

Chester 11.0S2021 12.0S2023 13.0S2025

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

10.84% 11.26% 11.42%

$101.46 $106.53 $113.86

AA AA AA

Digby 11.0S2021 12.0S2023 13.0S2025

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

10.84% 11.26% 11.42%

$101.46 $106.53 $113.86

AA AA AA

Erie 11.0S2021 12.0S2023 13.0S2025

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

10.84% 11.26% 11.42%

$101.46 $106.53 $113.86

AA AA AA

Ferris 11.0S2021 12.0S2023 13.0S2025

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

10.84% 11.26% 11.42%

$101.46 $106.53 $113.86

AA AA AA

Next Year's Prime Rate: 7%

Stock Price

3/24/2019 Report

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

Andrews Baldwin Chester Digby Erie Ferris

2019 2020 2021 2022 2023 2024 2025 2026 $0

$10

$20

Net Pro�t

Andrews Baldwin Chester Digby Erie Ferris $0

$1000

$2000

$3000

$4000

$5000

3/24/2019 Report

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

Product Financials Baldwin Income Statement

Baker Total

Sales $48,413 $48,413

Variable Cost $36,158 $36,158

Fixed Cost $5,278 $5,278

Net Margin $6,978 $6,978

Other (Fees, Writeoffs) $30

Long Term Interest $544

Taxes & Tariffs $2,241

Pro�t Sharing $83

Net Pro�t $4,079

3/24/2019 Report

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

Workforce Round: 1 Dec. 31, 2020

ZP81798_1

Workforce Summary

Andrews Baldwin Chester Digby Erie Ferris

Number of Employees 274 260 250 250 250 250

First Shift 154 154 154 154 154 154

Second Shift 120 106 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 51 36 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=1&teamName=Baldwin 12/12