Capstone Key Metrics Assignment and Test
LadyLion
CapsimDeliverable2_PracticeSet1KeyMetricsWorksheet2.xlsxSheet1
| CAPSIM DELIVERABLE 2 | This template applies to the Capstone Individual Footrace ONLY. Other formats may require a different template. | |||||||||
| PRACTICE SET 1 | How to use this worksheet | |||||||||
| Key Metrics Worksheet | 1. Enter your Company name and competitive strategy (if you have one) in the highlighted cells to the left. | |||||||||
| INDIVIDUAL Practice Round Results | 2. Complete the spreadsheet for the COMPANY DASHBOARD and the SEGMENT | PRODUCT DASHBOARD by filling in the shaded cells with the correct values. | |||||||||
| 3. All information to complete the template can be found in the Capstone Courier on the pages indicated in column B | ||||||||||
| YOUR COMPANY NAME HERE | 4. Include the UNITS ($, %, units, rating, etc) in the columns for round 0 and the last round you play. You can leave off the units in the other columns | |||||||||
| COMPETITIVE STRATEGY | 5. Round 0 has been completed for you as an example | |||||||||
| 6. (Optional) You may also choose to do a competitive analysis, comparing the same metrics from your closest competitors to your own performance. | ||||||||||
| COMPANY DASHBOARD | ||||||||||
| COMPANY METRIC | Courier page | Round 0 | Round 1 | Round 2 | Round 3 | Include all the rounds you completed. Add more rounds here if you need to. | ||||
| Sales revenue (100%) | p 1 & 3 | $ 101,073,437 | ||||||||
| Contribution Margin | p 1 | 28.3% | ||||||||
| SG&A/Sales | p 1 | 8.9% | ||||||||
| ROS | p 1 | 4.1% | ||||||||
| Net Profit | p 1 & 3 | $ 4,188,507 | ||||||||
| Cash Balance | p 3 | $ 3,434 | ||||||||
| Emergency Loan | p 1 & 3 | $ - 0 | ||||||||
| Market Share | p 1 & 10 | 16.67% | ||||||||
| Stock Price | p 2 | $ 34.25 | ||||||||
| SEGMENT | PRODUCT DASHBOARD | ||||||||||
| PRODUCT METRIC || SEGMENT Traditional Note the first two lines are industry level metrics. The rest are metrics for your product only. | Courier page | Round 0 | Round 1 | Round 2 | Round 3 | |||||
| Able | Able | name of new product 1 | Able | name of new product 1 | name of new product 2 | Able | name of new product 1 | name of new product 2 | ||
| Segment total industry unit demand | p 5-9 | 7387 | ||||||||
| Segment percent of total total industry | p 5-10 | 32.4% | ||||||||
| Units sold in this segment | p 4 -9 | 961 | if applicable | if applicable | if applicable | |||||
| Unit inventory | p 4 | 189 | ||||||||
| Actual Market Share in this primary segment | p 10 | 13.0% | ||||||||
| Potential Market Share in this primary segment | p 10 | 13.0% | ||||||||
| Product Revision date | p 4 -9 | 11/21/18 | ||||||||
| Contribution margin | p 4 | 29.0% | ||||||||
| Customer survey score in this segment | p 5-9 | 18 | ||||||||
| Total units sold in other segments Mary Beth Rousseau: Mary Beth Rousseau: Does not add to total units sold because of the way Capsim rounds small numbers. | p 5-9 | 26 | ||||||||
| PRODUCT METRIC || SEGMENT Low End Note the first two lines are industry level metrics. The rest are metrics for your product only. | Courier page | Round 0 | Round 1 | Round 2 | Round 3 | |||||
| Acre | Acre | name of new product 1 | Acre | name of new product 1 | name of new product 2 | Acre | name of new product 1 | name of new product 2 | ||
| Segment total industry unit demand | p 5-10 | 8960 | ||||||||
| Segment percent of total total industry | p 5-10 | 39.3% | ||||||||
| Units sold in this segment | p 4 -9 | 1493 | if applicable | if applicable | if applicable | |||||
| Unit inventory | p 4 | 39 | ||||||||
| Actual Market Share in this primary segment | p 10 | 17.0% | ||||||||
| Potential Market Share in this primary segment | p 10 | 17.0% | ||||||||
| Product Revision date | p 4 -9 | 5/25/17 | ||||||||
| Contribution margin | p 4 | 27.0% | ||||||||
| Customer survey score in this segment | p 5-9 | 12 | ||||||||
| Total units sold in other segments | p 5-9 | 270 | ||||||||
| PRODUCT METRIC || SEGMENT High End Note the first two lines are industry level metrics. The rest are metrics for your product only. | Courier page | Round 0 | Round 1 | Round 2 | Round 3 | |||||
| Adam | Adam | name of new product 1 | Adam | name of new product 1 | name of new product 2 | Adam | name of new product 1 | name of new product 2 | ||
| Segment total industry unit demand | p 5-9 | 2554 | ||||||||
| Segment percent of total total industry | p 5-10 | 11.2% | ||||||||
| Units sold in this segment | p 4 -9 | 366 | if applicable | if applicable | if applicable | |||||
| Unit inventory | p 4 | 40 | ||||||||
| Actual Market Share in this primary segment | p 10 | 14.30% | ||||||||
| Potential Market Share in this primary segment | p 10 | 14.30% | ||||||||
| Product Revision date | p 4 -9 | 4/18/20 | ||||||||
| Contribution margin | p 4 | 33.0% | ||||||||
| Customer survey score in this segment | p 5-9 | 21 | ||||||||
| Total units sold in other segments | p 5-9 | 0 | ||||||||
| PRODUCT METRIC || SEGMENT Performance Note the first two lines are industry level metrics. The rest are metrics for your product only. | Courier page | Round 0 | Round 1 | Round 2 | Round 3 | |||||
| Aft | Aft | name of new product 1 | Aft | name of new product 1 | name of new product 2 | Aft | name of new product 1 | name of new product 2 | ||
| Segment total industry unit demand | p 5-9 | 1915 | ||||||||
| Segment percent of total total industry | p 5-10 | 8.4% | ||||||||
| Units sold in this segment | p 4 -9 | 317 | if applicable | if applicable | if applicable | |||||
| Unit inventory | p 4 | 78 | ||||||||
| Actual Market Share in this primary segment | p 10 | 17.0% | ||||||||
| Potential Market Share in this primary segment | p 10 | 17.0% | ||||||||
| Product Revision date | p 4 -9 | 6/30/19 | ||||||||
| Contribution margin | p 4 | 23.0% | ||||||||
| Customer survey score in this segment | p 5-9 | 20 | ||||||||
| Total units sold in other segments | p 5-9 | 41 | ||||||||
| PRODUCT METRIC || SEGMENT Size Note the first two lines are industry level metrics. The rest are metrics for your product only. | Courier page | Round 0 | Round 1 | Round 2 | Round 3 | |||||
| Agape | Agape | name of new product 1 | Agape | name of new product 1 | name of new product 2 | Agape | name of new product 1 | name of new product 2 | ||
| Segment total industry unit demand | p 5-9 | 1984 | ||||||||
| Segment percent of total total industry | p 5-10 | 8.7% | ||||||||
| Units sold in this segment | p 4 -9 | 307 | if applicable | if applicable | if applicable | |||||
| Unit inventory | p 4 | 62 | ||||||||
| Actual Market Share in this primary segment | p 10 | 15.00% | ||||||||
| Potential Market Share in this primary segment | p 10 | 15.00% | ||||||||
| Product Revision date | p 4 -9 | 5/25/19 | ||||||||
| Contribution margin | p 4 | 30.0% | ||||||||
| Customer survey score in this segment | p 5-9 | 27 | ||||||||
| Total units sold in other segments Mary Beth Rousseau: Mary Beth Rousseau: Does not add to total units sold because of the way Capsim rounds small numbers. | p 5-9 | 0 |
DELIVERABLE 2 Practice Set 1 Key Metrics Worksheet
