Unit 5 Capsim Core Simulation Assignment

Round 2 - 2020 Sim ID Z78802_11

High Level Overview Team Name Andrews Baldwin Chester Digby Erie Ferris Average

Sales $20,123 $69,479 $47,156 $82,580 $42,375 $50,572 $52,047

Profit ($1,287) $6,138 $3,585 $8,717 $3,196 $3,663 $4,002

Contribution Margin

19.6% 27.3% 27.6% 29.6% 29.0% 28.3% 26.9%

Emergency Loan $11,507 $0 $0 $0 $0 $0 $0

Stock Price $1.56 $22.19 $17.28 $28.71 $15.39 $19.22 $17.39

Market Share 6.4% 22.2% 15.1% 26.4% 13.6% 16.2% 16.7%

Research and Development Use the Customer Buying Criteria, Product List and Perceptual Map to help you design products for your customers and analyze where your products are positioned relative to your competition.

Customer Buying Criteria

Low Tech

Customer Buying Criteria 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 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

Performance

S iz

e

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

2

4

6

8

10

12

14

16

18

20

Product List

Name Pfmn. Size Reliability Age Revision Date

Able 6.5 14.8 14000 1.9 18-May-2020

Baker 6.5 14.1 19800 2.1 8-Mar-2020

Bold 7.1 11.7 22400 0.6 15-May-2020

Cake 5.7 14.2 17000 3.3 19-Jan-2020

Cent - - - - 7-May-2021

Daze 6.6 13.6 19500 2.1 22-Apr-2020

Dabble 8 12.4 22000 0.6 11-May-2020

Eat 6 14.4 16500 3.3 15-Jan-2020

East - - - - 16-Mar-2021

Fast 8.5 11.6 22000 1.7 14-Oct-2020

Feast - - - - 23-May-2021

Marketing Look at each segment to assess how your products fit in the market. View how many units each product sold and their projected sales, and compare your product's price, promo & sales budget to the competition. The Customer Satisfaction Score tells you what your customers think of each product.

Name Price Units Sold Potential

Sold Stock Out

Sales Budget

Customer Accessibility

Promo Budget

Customer Awareness

Customer Satisfaction

Able $34.00 489 479 No $1,000 31% $1,000 61% 7

Baker $33.40 1,234 1,328 Yes $1,350 43% $1,350 77% 22

Bold $42.35 30 43 Yes $550 43% $550 33% 1

Cake $28.95 1,387 1,354 No $925 29% $925 56% 20

Daze $35.00 1,229 1,202 No $1,450 48% $1,450 83% 19

Eat $29.30 1,236 1,207 No $875 28% $875 54% 18

Fast $38.50 493 484 No $1,275 28% $1,500 85% 1

Low Tech Segment

Buying Criteria 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

Market Size 6,098

Units Sold 6,098

Growth Rate 10%

Market Share

Andrews (8%) Baldwin (20.7%) Chester (22.7%) Digby (20.2%) Erie (20.3%) Ferris (8.1%)

Name Price Units Sold Potential

Sold Stock Out

Sales Budget

Customer Accessibility

Promo Budget

Customer Awareness

Customer Satisfaction

Able $34.00 102 92 No $1,000 25% $1,000 61% 2

Baker $33.40 449 479 Yes $1,350 47% $1,350 77% 11

Bold $42.35 283 419 Yes $550 47% $550 33% 20

Cake $28.95 242 221 No $925 30% $925 56% 5

Daze $35.00 556 502 No $1,450 53% $1,450 83% 12

Dabble $45.00 446 455 Yes $750 53% $750 39% 21

Eat $29.30 210 192 No $875 28% $875 54% 4

Fast $38.50 821 751 No $1,275 38% $1,500 85% 30

High Tech Segment

Buying Criteria 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

Market Size 3,110

Units Sold 3,110

Growth Rate 20%

Market Share

Andrews (3.3%) Baldwin (23.6%) Chester (7.8%) Digby (32.2%) Erie (6.7%) Ferris (26.4%)

Production All information related to your Production department decisions is below. View your product costs compared to the competition, and assess the capacity, automation, and utilization levels of each product.

Name Primary Segment

Price Material

Cost Labor Cost

Contribution Margin

Units Produced

Inventory Automation Next Round

Capacity Next Round

Plant Utilization

Able Low Tech $34.00 $10.29 $11.11 19.6% 1,287 1,045 3.0 800 163%

Baker Low Tech $33.40 $12.64 $11.48 25.7% 1,584 0 3.4 1,050 200%

Bold High Tech $42.35 $16.60 $10.90 34.1% 313 0 3.5 350 200%

Cake Low Tech $28.95 $10.83 $9.11 27.6% 1,591 83 4.9 900 200%

Cent - - - - - - - 4.0 200 -

Daze Low Tech $35.00 $13.15 $11.62 27.2% 1,683 29 3.7 1,100 200%

Dabble High Tech $45.00 $16.61 $11.33 37.0% 446 0 3.2 500 143%

Eat Low Tech $29.30 $10.80 $8.85 29.0% 1,394 83 4.7 922 175%

East - - - - - - - 4.0 300 -

Fast High Tech $38.50 $17.96 $10.35 28.3% 1,337 152 3.5 950 159%

Feast - - - - - - - 3.0 350 -

Finance View high-level financial overviews - income statement, cash flow statement and balance sheet - for each company in your industry. Below, you can see how each of your products contributed to your profitability.

Income Statement

Andrews Baldwin Chester Digby Erie Ferris

Sales $20,123 $69,479 $47,156 $82,580 $42,375 $50,572

Variable Costs $16,182 $50,503 $34,161 $58,167 $30,078 $36,252

Fixed Costs $3,665 $7,286 $5,303 $8,531 $5,256 $6,693

Other $0 $229 $242 $235 $253 $196

Interest $2,256 $1,826 $1,821 $1,963 $1,770 $1,680

Taxes ($693) $3,373 $1,970 $4,790 $1,756 $2,013

Profit Sharing $0 $125 $73 $178 $65 $75

Net Profit ($1,287) $6,138 $3,585 $8,717 $3,196 $3,663

Cash Flow

Andrews Baldwin Chester Digby Erie Ferris

Cash from Operating ($14,312) $9,687 $6,046 $12,298 $6,003 $4,014

Cash From Investing $0 ($7,860) ($7,600) ($10,400) ($9,630) ($8,300)

Cash from Financing $11,507 $6,518 $6,875 $8,065 $6,385 $7,269

Net Change in Cash ($2,806) $8,345 $5,321 $9,963 $2,759 $2,982

Starting Cash Position

$2,806 $10,819 $9,208 $8,458 $8,041 $7,102

Closing Cash Position

$0 $19,163 $14,530 $18,421 $10,799 $10,084

Balance Sheet

Andrews Baldwin Chester Digby Erie Ferris

Current Assets $25,223 $24,874 $20,141 $25,935 $15,999 $18,389

Fixed Assets $7,680 $19,493 $19,781 $23,393 $21,823 $18,100

Total Assets $32,903 $44,367 $39,922 $49,328 $37,821 $36,489

Current Liabilities $14,697 $10,436 $8,809 $12,455 $7,635 $10,893

Long-Term Liabilities $4,333 $10,521 $10,593 $10,632 $10,650 $7,786

Total Liabilities $19,030 $20,957 $19,402 $23,087 $18,285 $18,679

Total Equity $13,873 $23,410 $20,521 $26,241 $19,537 $17,810

Total Liabilities & Equity

$32,903 $44,367 $39,922 $49,328 $37,821 $36,489

Product Financials

Able Total

Sales $20,123 $20,123

Variable Cost $16,182 $16,182

Able Total

Fixed Cost $3,665 $3,665

Net Margin $276 $276

Other (Fees, Writeoffs) $0

Interest $2,256

Taxes ($693)

Profit Sharing $0

Net Profit ($1,287)