MT460 Unit 7 assignment

Round 1 - 2019 Sim ID Z79546_8

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

Sales $20,222 $55,827 $48,391 $58,159 $46,595 $50,086 $46,547

Profit ($85) $3,331 $2,862 $4,443 $2,200 $4,072 $2,804

Contribution Margin

32.3% 22.0% 21.4% 24.7% 19.7% 25.8% 24.3%

Emergency Loan $5,925 $0 $0 $0 $0 $0 $0

Stock Price $6.17 $16.01 $15.11 $18.22 $13.82 $17.56 $14.48

Market Share 7.2% 20.0% 17.3% 20.8% 16.7% 17.9% 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 7.1 12.5 19000 2.2 4-Oct-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 $43.00 173 172 No $1,000 27% $1,000 58% 2

Baker $33.40 1,164 1,181 Yes $1,300 39% $1,300 67% 20

Cake $32.60 1,116 1,111 No $925 34% $925 56% 17

Daze $35.00 1,124 1,119 No $1,450 41% $1,450 72% 19

Eat $31.65 1,102 1,098 No $850 33% $875 54% 16

Fast $36.40 865 863 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 (3.1%) Baldwin (21%) Chester (20.1%) Digby (20.3%) Erie (19.9%) Ferris (15.6%)

Name Price Units Sold Potential

Sold Stock Out

Sales Budget

Customer Accessibility

Promo Budget

Customer Awareness

Customer Satisfaction

Able $43.00 297 296 No $1,000 35% $1,000 58% 12

Baker $33.40 508 513 Yes $1,300 40% $1,300 67% 12

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

Daze $35.00 537 536 No $1,450 42% $1,450 72% 12

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

Fast $36.40 511 509 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 (11.5%) Baldwin (19.6%) Chester (14.2%) Digby (20.7%) Erie (14.3%) Ferris (19.7%)

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 High Tech $43.00 $16.08 $9.65 32.3% 941 558 4.0 900 119%

Baker Low Tech $33.40 $14.16 $11.10 22.0% 1,584 0 3.1 800 200%

Bold - - - - - - - 3.0 250 -

Cake Low Tech $32.60 $12.50 $10.98 21.4% 1,541 144 4.7 800 194%

Daze Low Tech $35.00 $14.52 $11.10 24.7% 1,584 10 3.0 850 200%

Dabble - - - - - - - 2.5 350 -

Eat Low Tech $31.65 $12.40 $10.89 19.7% 1,493 108 4.7 800 188%

Fast Low Tech $36.40 $17.15 $10.79 25.8% 1,386 97 3.5 850 175%

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,222 $55,827 $48,391 $58,159 $46,595 $50,086

Variable Costs $13,697 $43,520 $38,017 $43,773 $37,408 $37,153

Fixed Costs $4,734 $5,704 $4,541 $6,089 $4,393 $5,521

Other $70 $167 $147 $135 $147 $21

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

Taxes ($46) $1,830 $1,573 $2,441 $1,209 $2,237

Profit Sharing $0 $68 $58 $91 $45 $83

Net Profit ($85) $3,331 $2,862 $4,443 $2,200 $4,072

Cash Flow

Andrews Baldwin Chester Digby Erie Ferris

Cash from Operating ($9,831) $5,960 $2,076 $6,700 $2,175 $4,380

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

Cash from Financing $9,643 $7,023 $6,612 $6,378 $6,612 $909

Net Change in Cash ($5,588) $8,163 $3,248 $6,578 $3,348 $2,690

Starting Cash Position

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

Closing Cash Position

$0 $13,760 $8,846 $12,176 $8,945 $8,287

Balance Sheet

Andrews Baldwin Chester Digby Erie Ferris

Current Assets $15,879 $18,349 $16,469 $17,213 $15,504 $15,013

Fixed Assets $13,680 $13,439 $13,717 $15,080 $13,717 $11,067

Total Assets $29,559 $31,787 $30,186 $32,293 $29,222 $26,080

Current Liabilities $10,885 $7,073 $6,338 $7,098 $6,036 $6,724

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

Total Liabilities $16,985 $14,753 $13,901 $14,587 $13,599 $12,346

Total Equity $12,573 $17,034 $16,285 $17,706 $15,623 $13,733

Total Liabilities & Equity

$29,559 $31,787 $30,186 $32,293 $29,222 $26,080

Product Financials

Able Total

Sales $20,222 $20,222

Variable Cost $13,697 $13,697

Able Total

Fixed Cost $4,734 $4,734

Net Margin $1,791 $1,791

Other (Fees, Writeoffs) $70

Interest $1,853

Taxes ($46)

Profit Sharing $0

Net Profit ($85)