MT460 Unit 7 assignment

Round 3 - 2021 Sim ID Z79546_8

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

Sales $16,611 $95,883 $56,651 $89,714 $52,721 $49,490 $60,178

Profit ($7,537) $10,006 $1,607 $10,500 $3,143 $3,779 $3,583

Contribution Margin

11.8% 29.8% 24.6% 32.9% 28.7% 35.5% 27.2%

Emergency Loan $42,700 $0 $0 $0 $0 $0 $0

Stock Price $1.00 $34.87 $16.88 $40.58 $19.07 $19.68 $22.01

Market Share 4.6% 26.6% 15.7% 24.8% 14.6% 13.7% 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 6.3 Size 13.7

9%

High Tech

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

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.9 13.1 20000 1.8 18-Mar-2021

Baker 6.5 14.1 19800 3.1 8-Mar-2020

Bold 8.1 10.9 22400 1 6-Sep-2021

Cake 5.8 13.4 17000 2.4 20-June-2021

Cent 6.8 12.3 20000 0.7 7-May-2021

Daze 6.6 13.6 19000 3.1 8-Jan-2021

Dabble 9 11.3 22000 0.9 17-Oct-2021

Eat 6.4 13.7 16500 2.4 20-June-2021

East 6.2 12.8 17000 0.8 16-Mar-2021

Fast 9.3 10.4 22000 1.5 11-Oct-2021

Feast 8.9 10.9 22000 0.6 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 $43.00 122 120 No $1,200 13% $1,200 66% 2

Baker $33.40 1,757 1,726 No $1,350 47% $1,350 84% 28

Bold $42.35 113 116 No $1,350 47% $1,350 54% 1

Cake $26.20 1,577 1,559 No $1,025 42% $1,025 60% 25

Cent $39.20 113 165 Yes $1,025 42% $1,025 47% 5

Daze $34.00 1,568 1,540 No $1,450 46% $1,450 90% 26

Eat $28.60 1,223 1,202 No $875 37% $875 53% 20

East $34.00 208 253 Yes $875 37% $875 42% 6

Fast $44.00 26 26 No $1,275 19% $1,500 93% 0

Feast $44.00 1 1 No $1,275 19% $1,000 46% 0

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 6.3 Size 13.7 9%

Demand Information

Market Size 6,708

Units Sold 6,708

Growth Rate 10%

Market Share

Andrews (1.8%) Baldwin (27.9%) Chester (25.2%) Digby (23.4%) Erie (21.3%) Ferris (0.4%)

Name Price Units Sold Potential

Sold Stock Out

Sales Budget

Customer Accessibility

Promo Budget

Customer Awareness

Customer Satisfaction

Able $43.00 264 247 No $1,200 31% $1,200 66% 7

Baker $33.40 246 230 No $1,350 61% $1,350 84% 6

Bold $42.35 572 570 No $1,350 61% $1,350 54% 26

Cake $26.20 197 186 No $1,025 40% $1,025 60% 7

Cent $39.20 147 216 Yes $1,025 40% $1,025 47% 13

Daze $34.00 260 243 No $1,450 66% $1,450 90% 7

Dabble $45.00 613 582 No $1,450 66% $1,450 60% 30

Eat $28.60 149 139 No $875 34% $875 53% 6

East $34.00 188 230 Yes $875 34% $875 42% 10

Fast $44.00 676 635 No $1,275 54% $1,500 93% 33

Feast $44.00 421 455 No $1,275 54% $1,000 46% 29

High Tech Segment

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

Demand Information

Market Size 3,732

Units Sold 3,732

Growth Rate 20%

Market Share

Andrews (7.1%) Baldwin (21.9%) Chester (9.2%) Digby (23.4%) Erie (9%) Ferris (29.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 High Tech $43.00 $13.91 $10.17 11.8% 1,139 1,742 4.1 900 128%

Baker Low Tech $33.40 $11.41 $11.81 28.1% 2,178 176 4.5 1,250 183%

Bold High Tech $42.35 $17.03 $11.27 33.9% 743 58 4.0 450 188%

Cake Low Tech $26.20 $10.59 $9.55 21.4% 1,989 215 5.8 1,150 200%

Cent High Tech $39.20 $13.60 $9.86 39.2% 260 0 4.5 350 200%

Daze Low Tech $34.00 $11.74 $10.76 31.0% 2,088 260 4.2 1,250 175%

Dabble High Tech $45.00 $17.37 $11.06 37.3% 746 142 3.2 500 150%

Eat Low Tech $28.60 $10.69 $9.43 27.1% 1,692 362 5.5 1,050 189%

East Low Tech $34.00 $11.62 $10.60 33.3% 396 0 4.0 400 200%

Fast High Tech $44.00 $18.58 $9.22 35.9% 842 269 4.0 1,000 85%

Feast High Tech $44.00 $17.67 $10.65 34.7% 422 0 4.0 600 143%

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 $16,611 $95,883 $56,651 $89,714 $52,721 $49,490

Variable Costs $14,647 $67,268 $42,691 $60,164 $37,603 $31,932

Fixed Costs $4,463 $10,392 $8,673 $10,569 $7,639 $9,325

Other $536 $154 $253 $4 $194 $139

Interest $8,560 $2,360 $2,512 $2,494 $2,352 $2,161

Taxes ($4,058) $5,498 $883 $5,769 $1,727 $2,076

Profit Sharing $0 $204 $33 $214 $64 $77

Net Profit ($7,537) $10,006 $1,607 $10,500 $3,143 $3,779

Cash Flow

Andrews Baldwin Chester Digby Erie Ferris

Cash from Operating ($23,116) $6,416 $436 $2,577 ($529) $2,238

Cash From Investing ($210) ($9,820) ($12,380) ($3,540) ($10,380) ($7,500)

Cash from Financing $23,326 $868 $6,611 ($2,541) $5,819 $4,182

Net Change in Cash $0 ($2,536) ($5,333) ($3,505) ($5,090) ($1,080)

Starting Cash Position

$0 $18,301 $15,696 $19,377 $14,931 $11,194

Closing Cash Position

$0 $15,766 $10,363 $15,873 $9,841 $10,114

Balance Sheet

Andrews Baldwin Chester Digby Erie Ferris

Current Assets $44,228 $29,429 $19,385 $33,160 $21,486 $21,431

Fixed Assets $15,045 $29,020 $31,032 $26,413 $28,043 $24,280

Total Assets $59,273 $58,449 $50,417 $59,573 $49,529 $45,711

Current Liabilities $46,504 $14,285 $11,559 $17,582 $11,029 $12,767

Long-Term Liabilities $9,233 $13,708 $15,079 $11,022 $13,753 $9,873

Total Liabilities $55,737 $27,993 $26,638 $28,605 $24,783 $22,640

Total Equity $3,536 $30,456 $23,780 $30,969 $24,746 $23,070

Total Liabilities & Equity

$59,273 $58,449 $50,417 $59,573 $49,529 $45,711

Product Financials

Able Total

Sales $16,611 $16,611

Variable Cost $14,647 $14,647

Able Total

Fixed Cost $4,463 $4,463

Net Margin ($2,499) ($2,499)

Other (Fees, Writeoffs) $536

Interest $8,560

Taxes ($4,058)

Profit Sharing $0

Net Profit ($7,537)