Unit 5 Capsim Core Simulation Assignment

Round 1 - 2019 Sim ID Z78802_11

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

Sales $34,856 $52,514 $44,271 $53,914 $42,584 $47,127 $45,878

Profit $2,311 $2,700 $2,564 $3,569 $1,802 $3,602 $2,758

Contribution Margin

24.1% 21.5% 22.2% 24.0% 19.9% 25.8% 22.9%

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

Stock Price $14.04 $14.79 $14.53 $16.51 $13.05 $16.62 $14.92

Market Share 12.7% 19.1% 16.1% 19.6% 15.5% 17.1% 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.3 Size 14.7

9%

High Tech

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

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 14.2 14000 2.2 17-Aug-2019

Baker 6.4 13.8 19800 2.5 13-Mar-2019

Bold - - - - 15-May-2020

Cake 5.7 14.2 18250 2.3 25-July-2019

Daze 6.1 13.4 20600 2.4 18-Mar-2019

Dabble - - - - 11-May-2020

Eat 6 14.4 17500 2.3 31-July-2019

Fast 7.6 12.7 21500 2.1 25-Oct-2019

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 752 752 No $1,000 35% $1,000 58% 8

Baker $33.40 1,057 1,057 No $1,300 39% $1,300 67% 20

Cake $32.60 990 990 No $925 34% $925 56% 17

Daze $35.00 1,001 1,001 No $1,450 41% $1,450 72% 19

Eat $31.65 977 977 No $850 33% $875 54% 16

Fast $36.40 766 766 No $1,275 36% $1,500 73% 8

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

Demand Information

Market Size 5,544

Units Sold 5,544

Growth Rate 10%

Market Share

Andrews (13.6%) Baldwin (19.1%) Chester (17.9%) Digby (18.1%) Erie (17.6%) Ferris (13.8%)

Name Price Units Sold Potential

Sold Stock Out

Sales Budget

Customer Accessibility

Promo Budget

Customer Awareness

Customer Satisfaction

Able $34.00 273 273 No $1,000 35% $1,000 58% 3

Baker $33.40 515 515 No $1,300 40% $1,300 67% 12

Cake $32.60 368 368 No $925 34% $925 56% 8

Daze $35.00 539 539 No $1,450 42% $1,450 72% 12

Eat $31.65 369 369 No $850 33% $875 54% 8

Fast $36.40 529 529 No $1,275 39% $1,500 73% 24

High Tech Segment

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

Market Size 2,592

Units Sold 2,592

Growth Rate 20%

Market Share

Andrews (10.5%) Baldwin (19.9%) Chester (14.2%) Digby (20.8%) Erie (14.2%) Ferris (20.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 $11.55 $10.60 24.1% 1,287 349 3.0 800 163%

Baker Low Tech $33.40 $14.16 $11.10 21.5% 1,584 99 3.1 800 200%

Bold - - - - - - - 3.0 250 -

Cake Low Tech $32.60 $12.50 $10.74 22.2% 1,392 121 4.7 800 175%

Daze Low Tech $35.00 $14.52 $11.10 24.0% 1,584 131 3.0 850 200%

Dabble - - - - - - - 2.5 350 -

Eat Low Tech $31.65 $12.40 $10.73 19.9% 1,394 136 4.7 800 175%

Fast Low Tech $36.40 $17.15 $10.71 25.8% 1,337 129 3.5 850 169%

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 $34,856 $52,514 $44,271 $53,914 $42,584 $47,127

Variable Costs $26,452 $41,247 $34,459 $40,963 $34,103 $34,986

Fixed Costs $4,135 $5,655 $4,447 $6,026 $4,311 $5,466

Other $0 $167 $147 $135 $147 $21

Interest $641 $1,207 $1,194 $1,186 $1,194 $1,000

Taxes $1,270 $1,484 $1,409 $1,961 $990 $1,979

Profit Sharing $47 $55 $52 $73 $37 $74

Net Profit $2,311 $2,700 $2,564 $3,569 $1,802 $3,602

Cash Flow

Andrews Baldwin Chester Digby Erie Ferris

Cash from Operating ($2,792) $3,018 $2,439 $2,982 $1,271 $3,195

Cash From Investing $0 ($4,820) ($5,440) ($6,500) ($5,440) ($2,600)

Cash from Financing $0 $7,023 $6,612 $6,378 $6,612 $909

Net Change in Cash ($2,792) $5,221 $3,611 $2,860 $2,443 $1,504

Starting Cash Position

$5,598 $5,598 $5,598 $5,598 $5,598 $5,598

Closing Cash Position

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

Balance Sheet

Andrews Baldwin Chester Digby Erie Ferris

Current Assets $14,328 $17,718 $15,891 $16,339 $14,935 $14,426

Fixed Assets $8,640 $13,439 $13,717 $15,080 $13,717 $11,067

Total Assets $22,968 $31,156 $29,608 $31,419 $28,653 $25,493

Current Liabilities $2,607 $7,073 $6,058 $7,098 $5,864 $6,607

Long-Term Liabilities $5,200 $7,680 $7,563 $7,489 $7,563 $5,622

Total Liabilities $7,807 $14,753 $13,621 $14,587 $13,428 $12,229

Total Equity $15,161 $16,403 $15,987 $16,832 $15,225 $13,263

Total Liabilities & Equity

$22,968 $31,156 $29,608 $31,419 $28,653 $25,493

Product Financials

Able Total

Sales $34,856 $34,856

Variable Cost $26,452 $26,452

Able Total

Fixed Cost $4,135 $4,135

Net Margin $4,270 $4,270

Other (Fees, Writeoffs) $0

Interest $641

Taxes $1,270

Profit Sharing $47

Net Profit $2,311