Business Finance - Accounting Assignment 11: Complete Round 6 of CAPSIM
dream86
Round6CAPSIMreport.xlsxHigh Level Overview
| High Level Overview | ||||||||||||||||||
| Andrews | Baldwin | Chester | Digby | Erie | Ferris | Garrett | Harper | Irving | Average | |||||||||
| ROS | -11.10% | 9.50% | 5.10% | 18.20% | -37.50% | -2.20% | 5.50% | 8.30% | 8.00% | 0.42% | ||||||||
| Asset Turnover | 0.93 | 1.88 | 1.83 | 1.73 | 0.26 | 1.01 | 0.39 | 1.09 | 1.52 | 1.18 | ||||||||
| ROA | -10.30% | 17.90% | 9.40% | 31.40% | -9.60% | -2.20% | 2.20% | 9.10% | 12.20% | 6.68% | ||||||||
| Leverage | 4.84 | 1.35 | 1.91 | 1.09 | 2.77 | 1.68 | 2.16 | 1.32 | 1.71 | 2.09 | ||||||||
| ROE | -49.90% | 24.10% | 17.90% | 34.20% | -26.50% | -3.70% | 4.70% | 12.00% | 20.90% | 3.74% | ||||||||
| Sales | $99,700 | $262,264 | $280,353 | $436,760 | $45,828 | $114,429 | $77,797 | $138,463 | $242,049 | $188,627 | ||||||||
| EBIT | ($7,410) | $41,203 | $28,415 | $124,667 | ($9,657) | ($225) | $19,804 | $20,589 | $37,846 | $28,359 | ||||||||
| Profit | ($11,097) | $24,905 | $14,327 | $79,406 | ($17,182) | ($2,509) | $4,275 | $11,539 | $19,438 | $13,678 | ||||||||
| Cumulative Profit | ($29,226) | $68,289 | $37,910 | $176,994 | $22,578 | $14,864 | $47,569 | $43,865 | $48,930 | $47,975 | ||||||||
| SG&A to Sales Ratio | 15.19% | 8.32% | 9.28% | 4.79% | 34.34% | 12.65% | 6.56% | 12.69% | 10.61% | 12.71% | ||||||||
| Contribution Margin | 19.91% | 29.88% | 25.71% | 44.17% | 39.29% | 24.84% | 54.38% | 34.17% | 39.79% | 34.68% | ||||||||
| Emergency Loan | $0 | $0 | $0 | $0 | $76,684 | $3,087 | $0 | $0 | $0 | $8,863 | ||||||||
| Traditional | Low End | High End | Performance | Size | ||||||||||||||
| Customer Buying Criteria | Expectations | Importance | Customer Buying Criteria | Expectations | Importance | Customer Buying Criteria | Expectations | Importance | Customer Buying Criteria | Expectations | Importance | Customer Buying Criteria | Expectations | Importance | ||||
| Age | 2 Years | 47% | Price | $12.00 - $22.00 | 53% | Positioning | Performance 14.3 Size 5.7 | 43% | Reliability | 22,000 - 27,000 | 43% | Positioning | Performance 8.2 Size 4.6 | 43% | ||||
| Price | $17.00 - $27.00 | 23% | Age | 7 Years | 24% | Age | 0 Years | 29% | Positioning | Performance 15.4 Size 11.8 | 29% | Age | 1 Years | 29% | ||||
| Positioning | Performance 9.2 Size 10.8 | 21% | Positioning | Performance 4.7 Size 15.3 | 16% | Reliability | 20,000 - 25,000 | 19% | Price | $22.00 - $32.00 | 19% | Reliability | 16,000 - 21,000 | 19% | ||||
| Reliability | 14,000 - 19,000 | 9% | Reliability | 12,000 - 17,000 | 7% | Price | $27.00 - $37.00 | 9% | Age | 1 Years | 9% | Price | $22.00 - $32.00 | 9% | ||||
| Product List | ||||||||||||||||||
| Name | Performance | Size | Reliability | Age | Revision Date | |||||||||||||
| Able | 6.5 | 13.4 | 18,900 | 5.1 | 24-Jan-2033 | |||||||||||||
| Acre | 3.4 | 16.3 | 12,200 | 4.6 | 7-Jan-2033 | |||||||||||||
| Adam | 11.2 | 8.4 | 22,500 | 4.2 | 15-Aug-2033 | |||||||||||||
| Aft | 12.3 | 13.9 | 23,400 | 2.7 | 27-Apr-2032 | |||||||||||||
| Agape | 5.9 | 8.0 | 17,100 | 2.5 | 27-May-2032 | |||||||||||||
| Baker | 8.0 | 12.0 | 17,500 | 2.7 | 21-July-2032 | |||||||||||||
| Bead | 3.5 | 16.1 | 14,000 | 5.5 | 18-July-2032 | |||||||||||||
| Bid | 12.5 | 8.4 | 23,000 | 1.6 | 14-June-2032 | |||||||||||||
| Bold | 13.4 | 12.3 | 27,000 | 1.6 | 11-July-2032 | |||||||||||||
| Buddy | 7.0 | 6.6 | 19,000 | 1.7 | 22-June-2032 | |||||||||||||
| Cake | 8.8 | 11.2 | 17,500 | 1.4 | 5-Nov-2032 | |||||||||||||
| Cedar | 5.3 | 14.8 | 12,000 | 2.7 | 7-Aug-2031 | |||||||||||||
| Cid | 13.2 | 6.8 | 25,000 | 1.2 | 17-Dec-2032 | |||||||||||||
| Coat | 13.5 | 11.8 | 27,000 | 2.4 | 17-Jan-2033 | |||||||||||||
| Cure | 7.8 | 7.6 | 25,000 | 2.5 | 8-Jan-2034 | |||||||||||||
| Daze | 9.2 | 10.8 | 19,000 | 2.0 | 13-June-2032 | |||||||||||||
| Dell | 4.7 | 15.3 | 17,000 | 3.3 | 20-May-2032 | |||||||||||||
| Dot | 15.4 | 11.8 | 27,000 | 1.8 | 9-Apr-2032 | |||||||||||||
| Duck | 14.3 | 5.7 | 25,000 | 1.6 | 10-May-2032 | |||||||||||||
| Dune | 8.2 | 4.6 | 21,000 | 1.8 | 19-Apr-2032 | |||||||||||||
| Eat | 7.5 | 14.2 | 18,350 | 4.1 | 4-Oct-2030 | |||||||||||||
| Ebb | 5.0 | 15.1 | 14,500 | 6.8 | 14-Dec-2029 | |||||||||||||
| Echo | 6.8 | 13.6 | 18,000 | 4.7 | 14-Feb-2030 | |||||||||||||
| Edge | 7.0 | 13.5 | 16,550 | 4.7 | 24-July-2030 | |||||||||||||
| Egg | 6.0 | 13.6 | 18,000 | 4.8 | 17-Apr-2030 | |||||||||||||
| Fast | 10.5 | 9.4 | 23,200 | 3.0 | 14-Aug-2032 | |||||||||||||
| Feat | 3.0 | 17.0 | 14,000 | 10.6 | 26-May-2022 | |||||||||||||
| Fist | 10.3 | 10.4 | 23,000 | 4.1 | 21-July-2032 | |||||||||||||
| Foam | 11.2 | 14.4 | 25,000 | 4.7 | 11-Mar-2032 | |||||||||||||
| Fume | 5.1 | 9.5 | 19,000 | 4.8 | 17-Jan-2032 | |||||||||||||
| Gerbil | 3.0 | 17.0 | 14,000 | 10.6 | 26-May-2022 | |||||||||||||
| Hamper | 7.6 | 6.5 | 19,000 | 1.4 | 10-Dec-2032 | |||||||||||||
| Heft | 9.0 | 12.0 | 18,850 | 1.5 | 14-Dec-2032 | |||||||||||||
| Hilt | 13.1 | 13.5 | 26,000 | 1.2 | 5-Dec-2032 | |||||||||||||
| Hoary | 12.8 | 7.9 | 24,000 | 1.2 | 3-Dec-2032 | |||||||||||||
| Hue | 4.9 | 15.1 | 15,000 | 1.4 | 1-Dec-2032 | |||||||||||||
| Ignite | 8.8 | 11.1 | 19,000 | 1.6 | 21-Apr-2032 | |||||||||||||
| Indigo | 11.2 | 8.6 | 25,000 | 1.8 | 12-Apr-2032 | |||||||||||||
| Invert | 14.9 | 11.4 | 27,000 | 1.8 | 7-May-2032 | |||||||||||||
| Iota | 7.3 | 5.8 | 21,000 | 1.9 | 13-Apr-2032 | |||||||||||||
| Irate | 5.6 | 15.8 | 14,000 | 1.7 | 27-Mar-2032 |
Traditional
| Traditional | |||||||||||||
| Customer Buying Criteria | |||||||||||||
| Expectations | Importance | ||||||||||||
| Age | 2 Years | 47% | |||||||||||
| Price | $17.00 - $27.00 | 23% | |||||||||||
| Positioning | Performance 9.2 Size 10.8 | 21% | |||||||||||
| Reliability | 14,000 - 19,000 | 9% | |||||||||||
| Demand Information | |||||||||||||
| 2032 Total Market Size | 18,789 | ||||||||||||
| 2032 Total Units Sold | 15,769 | ||||||||||||
| Segment % of Total Industry | 25.5% | ||||||||||||
| 2033 Demand Growth Rate | 9.2% | ||||||||||||
| Top Products | |||||||||||||
| Name | Price | Units Sold | Potential Sold | Stock Out | Age | Performance | Size | Reliability | Sales Budget | Customer Accessibility | Promo Budget | Customer Awareness | Customer Satisfaction |
| Daze | $24.50 | 4,963 | 5,562 | Yes | 2.0 | 9.2 | 10.8 | 19,000 | $1,250 | 100.0% | $1,400 | 100.0% | 85 |
| Baker | $28.00 | 2,600 | 1,369 | Yes | 2.7 | 8.0 | 12.0 | 17,500 | $3,100 | 94.0% | $1,800 | 100.0% | 26 |
| Cake | $24.00 | 2,579 | 4,460 | Yes | 1.4 | 8.8 | 11.2 | 17,500 | $2,500 | 88.0% | $1,500 | 100.0% | 56 |
| Ignite | $24.50 | 1,872 | 5,103 | Yes | 1.6 | 8.8 | 11.1 | 19,000 | $3,000 | 83.0% | $2,000 | 100.0% | 74 |
| Heft | $27.50 | 1,627 | 1,755 | Yes | 1.5 | 9.0 | 12.0 | 18,850 | $1,350 | 34.0% | $1,450 | 96.4% | 24 |
| Fast | $25.75 | 1,074 | 477 | Yes | 3.0 | 10.5 | 9.4 | 23,200 | $1,200 | 14.0% | $1,400 | 94.5% | 14 |
| Able | $26.50 | 1,054 | 63 | Yes | 5.1 | 6.5 | 13.4 | 18,900 | $350 | 25.0% | $250 | 20.4% | 0 |
Low End
| Low End | |||||||||||||
| Customer Buying Criteria | |||||||||||||
| Expectations | Importance | ||||||||||||
| Price | $12.00 - $22.00 | 53% | |||||||||||
| Age | 7 Years | 24% | |||||||||||
| Positioning | Performance 4.7 Size 15.3 | 16% | |||||||||||
| Reliability | 12,000 - 17,000 | 7% | |||||||||||
| Demand Information | |||||||||||||
| 2032 Total Market Size | 26,106 | ||||||||||||
| 2032 Total Units Sold | 26,106 | ||||||||||||
| Segment % of Total Industry | 36.2% | ||||||||||||
| 2033 Demand Growth Rate | 11.7% | ||||||||||||
| Top Products | |||||||||||||
| Name | Price | Units Sold | Potential Sold | Stock Out | Age | Performance | Size | Reliability | Sales Budget | Customer Accessibility | Promo Budget | Customer Awareness | Customer Satisfaction |
| Dell | $18.00 | 6,849 | 8,321 | Yes | 3.3 | 4.7 | 15.3 | 17,000 | $1,250 | 100.0% | $1,400 | 100.0% | 39 |
| Gerbil | $18.50 | 4,205 | 1,909 | No | 10.6 | 3.0 | 17.0 | 14,000 | $3,000 | 84.0% | $1,500 | 100.0% | 4 |
| Cedar | $16.00 | 3,732 | 5,248 | Yes | 2.7 | 5.3 | 14.8 | 12,000 | $2,500 | 94.0% | $1,000 | 84.4% | 29 |
| Bead | $19.50 | 3,101 | 1,974 | Yes | 5.5 | 3.5 | 16.1 | 14,000 | $1,600 | 42.0% | $900 | 55.0% | 13 |
| Irate | $19.50 | 2,745 | 2,713 | Yes | 1.7 | 5.6 | 15.8 | 14,000 | $3,000 | 83.0% | $1,500 | 90.8% | 14 |
| Ebb | $21.50 | 2,132 | 3,687 | Yes | 6.8 | 5.0 | 15.1 | 14,500 | $1,500 | 60.0% | $1,250 | 85.0% | 20 |
| Hue | $22.50 | 1,768 | 856 | Yes | 1.4 | 4.9 | 15.1 | 15,000 | $1,600 | 46.0% | $1,250 | 78.2% | 5 |
| Feat | $21.00 | 1,257 | 581 | No | 10.6 | 3.0 | 17.0 | 14,000 | $1,300 | 35.0% | $1,200 | 70.8% | 1 |
| Acre | $23.25 | 211 | 639 | Yes | 4.6 | 3.4 | 16.3 | 12,200 | $1,300 | 19.0% | $1,250 | 83.6% | 3 |
| Able | $26.50 | 74 | 67 | Yes | 5.1 | 6.5 | 13.4 | 18,900 | $350 | 19.0% | $250 | 20.4% | 0 |
| Cake | $24.00 | 33 | 110 | Yes | 1.4 | 8.8 | 11.2 | 17,500 | $2,500 | 94.0% | $1,500 | 100.0% | 0 |
High End
| High End | |||||||||||||
| Customer Buying Criteria | |||||||||||||
| Expectations | Importance | ||||||||||||
| Positioning | Performance 14.3 Size 5.7 | 43% | |||||||||||
| Age | 0 Years | 29% | |||||||||||
| Reliability | 20,000 - 25,000 | 19% | |||||||||||
| Price | $27.00 - $37.00 | 9% | |||||||||||
| Demand Information | |||||||||||||
| 2032 Total Market Size | 9,429 | ||||||||||||
| 2032 Total Units Sold | 9,384 | ||||||||||||
| Segment % of Total Industry | 13.6% | ||||||||||||
| 2033 Demand Growth Rate | 16.2% | ||||||||||||
| Top Products | |||||||||||||
| Name | Price | Units Sold | Potential Sold | Stock Out | Age | Performance | Size | Reliability | Sales Budget | Customer Accessibility | Promo Budget | Customer Awareness | Customer Satisfaction |
| Duck | $36.50 | 2,978 | 4,398 | Yes | 1.6 | 14.3 | 5.7 | 25,000 | $1,300 | 100.0% | $1,400 | 100.0% | 73 |
| Cid | $35.00 | 1,866 | 1,821 | Yes | 1.2 | 13.2 | 6.8 | 25,000 | $2,500 | 87.0% | $1,500 | 100.0% | 52 |
| Indigo | $37.00 | 1,535 | 1,464 | Yes | 1.8 | 11.2 | 8.6 | 25,000 | $3,000 | 100.0% | $1,500 | 100.0% | 19 |
| Bid | $37.00 | 1,396 | 940 | Yes | 1.6 | 12.5 | 8.4 | 23,000 | $2,200 | 76.0% | $1,350 | 87.3% | 13 |
| Adam | $38.75 | 766 | 135 | Yes | 4.2 | 11.2 | 8.4 | 22,500 | $1,250 | 18.0% | $1,400 | 90.1% | 2 |
| Hoary | $37.50 | 526 | 533 | Yes | 1.2 | 12.8 | 7.9 | 24,000 | $1,300 | 37.0% | $1,150 | 65.5% | 13 |
| Fast | $25.75 | 220 | 132 | Yes | 3.0 | 10.5 | 9.4 | 23,200 | $1,200 | 17.0% | $1,400 | 94.5% | 2 |
| Fist | $35.50 | 96 | 6 | No | 4.1 | 10.3 | 10.4 | 23,000 | $1,550 | 17.0% | $1,500 | 80.8% | 0 |
Performance
| Performance | |||||||||||||
| Customer Buying Criteria | |||||||||||||
| Expectations | Importance | ||||||||||||
| Reliability | 22,000 - 27,000 | 43% | |||||||||||
| Positioning | Performance 15.4 Size 11.8 | 29% | |||||||||||
| Price | $22.00 - $32.00 | 19% | |||||||||||
| Age | 1 Years | 9% | |||||||||||
| Demand Information | |||||||||||||
| 2032 Total Market Size | 8,493 | ||||||||||||
| 2032 Total Units Sold | 6,508 | ||||||||||||
| Segment % of Total Industry | 12.6% | ||||||||||||
| 2033 Demand Growth Rate | 19.8% | ||||||||||||
| Top Products | |||||||||||||
| Name | Price | Units Sold | Potential Sold | Stock Out | Age | Performance | Size | Reliability | Sales Budget | Customer Accessibility | Promo Budget | Customer Awareness | Customer Satisfaction |
| Coat | $35.00 | 1,399 | 713 | Yes | 2.4 | 13.5 | 11.8 | 27,000 | $2,500 | 46.0% | $2,000 | 100.0% | 14 |
| Invert | $34.00 | 1,238 | 1,966 | Yes | 1.8 | 14.9 | 11.4 | 27,000 | $3,000 | 92.0% | $1,500 | 100.0% | 46 |
| Dot | $32.50 | 1,191 | 3,271 | Yes | 1.8 | 15.4 | 11.8 | 27,000 | $3,400 | 100.0% | $1,850 | 100.0% | 77 |
| Bold | $32.00 | 1,107 | 1,734 | Yes | 1.6 | 13.4 | 12.3 | 27,000 | $2,050 | 70.0% | $1,400 | 91.5% | 41 |
| Hilt | $32.50 | 612 | 407 | Yes | 1.2 | 13.1 | 13.5 | 26,000 | $900 | 20.0% | $900 | 48.8% | 11 |
| Aft | $30.00 | 502 | 274 | Yes | 2.7 | 12.3 | 13.9 | 23,400 | $700 | 14.0% | $1,150 | 69.2% | 4 |
| Foam | $33.00 | 458 | 127 | Yes | 4.7 | 11.2 | 14.4 | 25,000 | $1,200 | 11.0% | $1,200 | 63.5% | 2 |
Size
| Size | |||||||||||||
| Customer Buying Criteria | |||||||||||||
| Expectations | Importance | ||||||||||||
| Positioning | Performance 8.2 Size 4.6 | 43% | |||||||||||
| Age | 1 Years | 29% | |||||||||||
| Reliability | 16,000 - 21,000 | 19% | |||||||||||
| Price | $22.00 - $32.00 | 9% | |||||||||||
| Demand Information | |||||||||||||
| 2032 Total Market Size | 8,156 | ||||||||||||
| 2032 Total Units Sold | 7,560 | ||||||||||||
| Segment % of Total Industry | 12.0% | ||||||||||||
| 2033 Demand Growth Rate | 18.3% | ||||||||||||
| Top Products | |||||||||||||
| Name | Price | Units Sold | Potential Sold | Stock Out | Age | Performance | Size | Reliability | Sales Budget | Customer Accessibility | Promo Budget | Customer Awareness | Customer Satisfaction |
| Dune | $32.00 | 1,390 | 4,396 | Yes | 1.8 | 8.2 | 4.6 | 21,000 | $2,850 | 100.0% | $1,400 | 100.0% | 100 |
| Buddy | $32.00 | 1,310 | 860 | Yes | 1.7 | 7.0 | 6.6 | 19,000 | $1,800 | 62.0% | $1,200 | 75.3% | 18 |
| Iota | $34.00 | 1,288 | 1,777 | Yes | 1.9 | 7.3 | 5.8 | 21,000 | $3,000 | 100.0% | $1,500 | 100.0% | 32 |
| Cure | $36.00 | 1,213 | 180 | Yes | 2.5 | 7.8 | 7.6 | 25,000 | $2,500 | 27.0% | $2,000 | 100.0% | 3 |
| Agape | $29.75 | 678 | 370 | Yes | 2.5 | 5.9 | 8.0 | 17,100 | $1,700 | 38.0% | $1,200 | 76.8% | 7 |
| Fast | $25.75 | 664 | 179 | Yes | 3.0 | 10.5 | 9.4 | 23,200 | $1,200 | 24.0% | $1,400 | 94.5% | 0 |
| Fume | $33.00 | 578 | 29 | No | 4.8 | 5.1 | 9.5 | 19,000 | $700 | 24.0% | $900 | 54.0% | 0 |
| Hamper | $32.50 | 440 | 364 | Yes | 1.4 | 7.6 | 6.5 | 19,000 | $900 | 21.0% | $1,000 | 58.8% | 11 |
Production
| Plant Information | ||||||||||||||||
| Name | Primary Segment | Units Sold | Inventory | Revision Date | Age Dec.31 | MTBF | Pfmn Coord | Size | Price | Material Cost | Labor Cost | Contribution Margin | 2nd Shift & Over-time | Auto. Next Round | Capacity Next Round | Plant Utilization |
| Able | Low End | 1,127 | 0 | 24-Jan-2033 | 5.10 | 18,900 | 6.50 | 13.40 | $26.50 | $8.43 | $9.54 | 30.00% | 0.00% | 5 | 1,750 | 80% |
| Acre | Low End | 211 | 0 | 7-Jan-2033 | 4.60 | 12,200 | 3.40 | 16.30 | $23.25 | $4.28 | $10.34 | 35.60% | 0.00% | 4 | 1,950 | 13% |
| Adam | High End | 766 | 0 | 15-Aug-2033 | 4.20 | 22,500 | 11.20 | 8.40 | $38.75 | $12.99 | $15.11 | 25.40% | 0.00% | 2 | 1,050 | 97% |
| Aft | Performance | 502 | 0 | 27-Apr-2032 | 2.70 | 23,400 | 12.30 | 13.90 | $30.00 | $12.19 | $14.31 | 8.50% | 0.00% | 2 | 1,000 | 63% |
| Agape | Size | 678 | 0 | 27-May-2032 | 2.50 | 17,100 | 5.90 | 8.00 | $29.75 | $10.12 | $18.08 | 1.60% | 40.00% | 1 | 700 | 140% |
| Baker | Traditional | 2,600 | 0 | 21-July-2032 | 2.70 | 17,500 | 8.00 | 12.00 | $28.00 | $8.73 | $10.31 | 31.50% | 50.00% | 4 | 1,850 | 150% |
| Bead | Low End | 3,101 | 0 | 18-July-2032 | 5.50 | 14,000 | 3.50 | 16.10 | $19.50 | $4.76 | $7.50 | 36.90% | 61.00% | 6 | 2,000 | 161% |
| Bid | High End | 1,396 | 0 | 14-June-2032 | 1.60 | 23,000 | 12.50 | 8.40 | $37.00 | $13.13 | $12.01 | 30.90% | 61.10% | 3 | 1,050 | 161% |
| Bold | Performance | 1,107 | 0 | 11-July-2032 | 1.60 | 27,000 | 13.40 | 12.30 | $32.00 | $13.59 | $12.06 | 18.80% | 64.30% | 3 | 850 | 164% |
| Buddy | Size | 1,310 | 0 | 22-June-2032 | 1.70 | 19,000 | 7.00 | 6.60 | $32.00 | $11.14 | $12.52 | 25.10% | 94.30% | 3 | 1,050 | 194% |
| Cake | Traditional | 2,612 | 0 | 5-Nov-2032 | 1.40 | 17,500 | 8.80 | 11.20 | $24.00 | $9.32 | $8.61 | 25.50% | 21.70% | 5 | 2,300 | 122% |
| Cedar | Low End | 3,732 | 0 | 7-Aug-2031 | 2.70 | 12,000 | 5.30 | 14.80 | $16.00 | $5.26 | $7.79 | 16.00% | 60.00% | 6 | 2,500 | 160% |
| Cid | High End | 1,866 | 0 | 17-Dec-2032 | 1.20 | 25,000 | 13.20 | 6.80 | $35.00 | $14.55 | $10.58 | 28.20% | 42.80% | 4 | 1,400 | 143% |
| Coat | Performance | 1,399 | 0 | 17-Jan-2033 | 2.40 | 27,000 | 13.50 | 11.80 | $35.00 | $13.79 | $10.43 | 28.60% | 36.40% | 4 | 1,100 | 136% |
| Cure | Size | 1,213 | 0 | 8-Jan-2034 | 2.50 | 25,000 | 7.80 | 7.60 | $36.00 | $12.64 | $11.01 | 32.40% | 30.00% | 4 | 1,000 | 130% |
| Daze | Traditional | 4,963 | 0 | 13-June-2032 | 2.00 | 19,000 | 9.20 | 10.80 | $24.50 | $9.51 | $4.77 | 42.40% | 99.90% | 7 | 2,500 | 200% |
| Dell | Low End | 6,849 | 0 | 20-May-2032 | 3.30 | 17,000 | 4.70 | 15.30 | $18.00 | $5.99 | $2.98 | 51.40% | 99.90% | 9 | 3,450 | 200% |
| Dot | Performance | 1,191 | 0 | 9-Apr-2032 | 1.80 | 27,000 | 15.40 | 11.80 | $32.50 | $13.87 | $7.74 | 33.30% | 99.90% | 5 | 600 | 200% |
| Duck | High End | 2,978 | 0 | 10-May-2032 | 1.60 | 25,000 | 14.30 | 5.70 | $36.50 | $14.51 | $5.96 | 44.30% | 99.90% | 6 | 1,500 | 200% |
| Dune | Size | 1,390 | 0 | 19-Apr-2032 | 1.80 | 21,000 | 8.20 | 4.60 | $32.00 | $12.22 | $7.74 | 37.80% | 99.90% | 5 | 700 | 200% |
| Eat | 0 | 1,599 | 4-Oct-2030 | 4.10 | 18,350 | 7.50 | 14.20 | $32.00 | $8.40 | $4.79 | 0.00% | 0.00% | 7 | 2,450 | 67% | |
| Ebb | Low End | 2,132 | 0 | 14-Dec-2029 | 6.80 | 14,500 | 5.00 | 15.10 | $21.50 | $5.96 | $6.77 | 39.30% | 37.50% | 6 | 1,600 | 138% |
| Echo | 0 | 1,598 | 14-Feb-2030 | 4.70 | 18,000 | 6.80 | 13.60 | $38.50 | $8.19 | $9.10 | 0.00% | 0.00% | 3 | 900 | 62% | |
| Edge | 0 | 1,221 | 24-July-2030 | 4.70 | 16,550 | 7.00 | 13.50 | $33.50 | $7.87 | $8.86 | 0.00% | 0.00% | 4 | 700 | 71% | |
| Egg | 0 | 1,560 | 17-Apr-2030 | 4.80 | 18,000 | 6.00 | 13.60 | $33.50 | $7.91 | $8.74 | 0.00% | 0.00% | 4 | 750 | 77% | |
| Fast | Traditional | 1,959 | 0 | 14-Aug-2032 | 3.00 | 23,200 | 10.50 | 9.40 | $25.75 | $12.45 | $7.03 | 21.90% | 0.00% | 6 | 3,050 | 72% |
| Feat | Low End | 1,257 | 586 | 26-May-2022 | 10.60 | 14,000 | 3.00 | 17.00 | $21.00 | $4.36 | $9.74 | 27.40% | 47.90% | 5 | 1,400 | 148% |
| Fist | 96 | 760 | 21-July-2032 | 4.10 | 23,000 | 10.30 | 10.40 | $35.50 | $11.97 | $11.24 | -26.70% | 0.00% | 3 | 900 | 46% | |
| Foam | Performance | 458 | 0 | 11-Mar-2032 | 4.70 | 25,000 | 11.20 | 14.40 | $33.00 | $11.92 | $11.24 | 28.70% | 0.00% | 3 | 600 | 73% |
| Fume | 578 | 32 | 17-Jan-2032 | 4.80 | 19,000 | 5.10 | 9.50 | $33.00 | $9.73 | $11.24 | 35.10% | 0.00% | 3 | 1,100 | 72% | |
| Gerbil | Low End | 4,205 | 2,063 | 26-May-2022 | 10.60 | 14,000 | 3.00 | 17.00 | $18.50 | $4.39 | $3.28 | 54.40% | 8.50% | 9 | 6,000 | 109% |
| Hamper | Size | 440 | 0 | 10-Dec-2032 | 1.40 | 19,000 | 7.60 | 6.50 | $32.50 | $11.71 | $10.57 | 31.20% | 0.00% | 3 | 600 | 77% |
| Heft | Traditional | 1,627 | 0 | 14-Dec-2032 | 1.50 | 18,850 | 9.00 | 12.00 | $27.50 | $9.83 | $8.59 | 33.30% | 0.00% | 5 | 1,800 | 94% |
| Hilt | Performance | 612 | 0 | 5-Dec-2032 | 1.20 | 26,000 | 13.10 | 13.50 | $32.50 | $13.41 | $10.88 | 25.10% | 6.70% | 3 | 600 | 107% |
| Hoary | High End | 526 | 0 | 3-Dec-2032 | 1.20 | 24,000 | 12.80 | 7.90 | $37.50 | $14.20 | $10.57 | 33.70% | 0.00% | 3 | 550 | 100% |
| Hue | Low End | 1,768 | 0 | 1-Dec-2032 | 1.40 | 15,000 | 4.90 | 15.10 | $22.50 | $6.08 | $7.92 | 41.00% | 0.00% | 5 | 1,600 | 76% |
| Ignite | Traditional | 1,872 | 0 | 21-Apr-2032 | 1.60 | 19,000 | 8.80 | 11.10 | $24.50 | $9.51 | $6.80 | 33.20% | 11.20% | 7 | 1,700 | 111% |
| Indigo | High End | 1,535 | 0 | 12-Apr-2032 | 1.80 | 25,000 | 11.20 | 8.60 | $37.00 | $12.85 | $7.43 | 44.90% | 72.20% | 6 | 1,250 | 172% |
| Invert | Performance | 1,238 | 0 | 7-May-2032 | 1.80 | 27,000 | 14.90 | 11.40 | $34.00 | $14.08 | $7.60 | 36.20% | 56.20% | 6 | 1,000 | 156% |
| Iota | Size | 1,288 | 0 | 13-Apr-2032 | 1.90 | 21,000 | 7.30 | 5.80 | $34.00 | $11.83 | $7.32 | 43.50% | 36.80% | 6 | 1,100 | 137% |
| Irate | Low End | 2,745 | 0 | 27-Mar-2032 | 1.70 | 14,000 | 5.60 | 15.80 | $19.50 | $5.51 | $5.19 | 39.90% | 0.00% | 7 | 1,800 | 42% |
Finance
| Income Statement | |||||||||
| Andrews | Baldwin | Chester | Digby | Erie | Ferris | Garrett | Harper | Irving | |
| Sales | $99,700 | $262,264 | $280,353 | $436,760 | $45,828 | $114,429 | $77,797 | $138,463 | $242,049 |
| Total Variable Costs (Labor, Material, Carry) | $79,850 | $183,898 | $208,265 | $243,860 | $27,824 | $86,002 | $35,491 | $91,152 | $145,745 |
| Depreciation | $10,362 | $10,253 | $13,987 | $19,947 | $11,921 | $11,705 | $16,000 | $7,753 | $14,429 |
| SG&A | $15,143 | $21,811 | $26,026 | $20,931 | $15,739 | $14,471 | $5,102 | $17,569 | $25,672 |
| Other (Fees/Write-offs/Bonuses/Relocation Fee) | $1,755 | $5,099 | $3,660 | $27,356 | $0 | $2,475 | $1,400 | $1,400 | $18,356 |
| EBIT | ($7,410) | $41,203 | $28,415 | $124,667 | ($9,657) | ($225) | $19,804 | $20,589 | $37,846 |
| Interest (Short term/Long Term) | $9,663 | $2,106 | $5,923 | $11 | $16,777 | $3,634 | $13,093 | $2,474 | $7,330 |
| Taxes | ($5,975) | $13,684 | $7,872 | $43,630 | ($9,252) | ($1,351) | $2,349 | $6,340 | $10,680 |
| Profit Sharing | $0 | $508 | $292 | $1,621 | $0 | $0 | $87 | $235 | $397 |
| Net Profit | ($11,097) | $24,905 | $14,327 | $79,406 | ($17,182) | ($2,509) | $4,275 | $11,539 | $19,438 |
| Balance Sheet | |||||||||
| Andrews | Baldwin | Chester | Digby | Erie | Ferris | Garrett | Harper | Irving | |
| Cash | $29,966 | $54,838 | $29,016 | $39,107 | $0 | $0 | $9,439 | $85,589 | $18,543 |
| Accounts Receivable | $8,741 | $21,556 | $23,043 | $35,898 | $3,767 | $9,405 | $6,394 | $7,587 | $19,894 |
| Inventory | $0 | $0 | $0 | $0 | $98,929 | $26,671 | $16,446 | $0 | $0 |
| Total Current Assets | $38,707 | $76,394 | $52,058 | $75,005 | $102,696 | $36,076 | $32,279 | $93,176 | $38,438 |
| Plant and Equipment | $155,431 | $153,800 | $209,800 | $299,200 | $178,820 | $175,580 | $240,000 | $116,300 | $216,440 |
| Accumulated Depreciation | ($86,516) | ($90,787) | ($108,980) | ($121,693) | ($101,924) | ($98,288) | ($74,800) | ($82,353) | ($96,151) |
| Total Fixed Assets | $68,915 | $63,013 | $100,820 | $177,507 | $76,896 | $77,292 | $165,200 | $33,947 | $120,289 |
| Total Assets | $107,622 | $139,408 | $152,878 | $252,511 | $179,592 | $113,368 | $197,479 | $127,122 | $158,726 |
| Accounts Payable | $13,345 | $15,115 | $25,677 | $20,043 | $6,329 | $15,110 | $4,107 | $6,828 | $9,993 |
| Current Debt | $32,450 | $20,850 | $10,759 | $0 | $97,534 | $30,937 | $20,850 | $20,850 | $30,850 |
| Long-Term Debt | $39,600 | $0 | $36,300 | $95 | $11,000 | $0 | $81,200 | $3,200 | $25,000 |
| Total Liabilities | $85,395 | $35,965 | $72,735 | $20,138 | $114,863 | $46,047 | $106,157 | $30,878 | $65,843 |
| Common Stock | $26,060 | $16,482 | $18,360 | $76,048 | $22,254 | $31,832 | $18,360 | $35,456 | $18,560 |
| Retained Earnings | ($3,833) | $86,961 | $61,783 | $156,325 | $42,475 | $35,489 | $72,963 | $60,789 | $74,323 |
| Total Equity | $22,227 | $103,443 | $80,143 | $232,373 | $64,729 | $67,321 | $91,323 | $96,244 | $92,883 |
| Total Liabilities & Owner's Equity | $107,622 | $139,408 | $152,878 | $252,511 | $179,592 | $113,368 | $197,479 | $127,122 | $158,726 |
| Cash Flow Statement | |||||||||
| Andrews | Baldwin | Chester | Digby | Erie | Ferris | Garrett | Harper | Irving | |
| Cash From Operations | |||||||||
| Net Income(Loss) | ($11,097) | $24,905 | $14,327 | $79,406 | ($17,182) | ($2,509) | $4,275 | $11,539 | $19,438 |
| Adjustment For Non-Cash Items | |||||||||
| Depreciation | $10,362 | $10,253 | $13,987 | $19,947 | $11,921 | $11,705 | $16,000 | $7,753 | $14,429 |
| Extraordinary Gains/Losses/Write-offs | $0 | $0 | $9 | $645 | $0 | $0 | $0 | $0 | ($1,644) |
| Changes In Current Assets And Liabilities | |||||||||
| Accounts Payable | $939 | $4,945 | $11,164 | $3,732 | ($120) | ($92) | ($358) | $500 | $920 |
| Inventory | $0 | $0 | $0 | $0 | ($49,176) | ($9,116) | ($16,446) | $8,079 | $24,160 |
| Accounts Receivable | ($6,007) | ($6,613) | ($3,260) | ($8,563) | $4,286 | ($834) | $3,084 | ($861) | ($874) |
| Net Cash From Operations | ($5,803) | $33,491 | $36,227 | $95,166 | ($50,270) | ($845) | $6,554 | $27,010 | $56,429 |
| Cash From Investing | |||||||||
| Net Plant Improvements | ($15,220) | ($12,800) | $0 | $0 | $0 | ($9,880) | $0 | $0 | ($53,720) |
| Cash From Financing | |||||||||
| Dividends Paid | $0 | $0 | ($1,520) | ($34,474) | $0 | ($1,242) | $0 | $0 | $0 |
| Sales Of Common Stock | $1,700 | $0 | $0 | $0 | $0 | $7,500 | $0 | $0 | $0 |
| Purchase Of Common Stock | $0 | ($6,600) | $0 | ($19,500) | $0 | $0 | $0 | $0 | $0 |
| Cash From Long-Term Debt Issued | $33,400 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 |
| Early Retirement Of Long-Term Debt | $0 | $0 | ($10,100) | ($27,900) | $0 | $0 | $0 | $0 | $0 |
| Retirement Of Current Debt | $0 | $0 | $0 | $0 | ($26,414) | ($5,620) | $0 | $0 | ($20,000) |
| Cash From Current Debt Borrowing | $11,600 | $0 | $0 | $0 | $0 | $7,000 | $0 | $0 | $10,000 |
| Cash From Emergency Loan | $0 | $0 | $0 | $0 | $76,684 | $3,087 | $0 | $0 | $0 |
| Net Cash From Financing | $46,700 | ($6,600) | ($11,620) | ($81,874) | $50,270 | $10,725 | $0 | $0 | ($10,000) |
| Net Change In Cash | $25,677 | $14,091 | $24,607 | $13,292 | $0 | $0 | $6,554 | $27,010 | ($7,291) |
| Stock Market Summary | |||||||||
| Company | Closing Price | Change | Shares Outstanding | Market Cap | Book Value | EPS | Dividend | Yield | P/E |
| Andrews | $1.00 | ($7.46) | $2,456,413 | $2 | $9.05 | ($4.52) | $0 | 0% | -0.22 |
| Baldwin | $108.50 | $40.93 | $1,863,826 | $202 | $55.50 | $13.36 | $0 | 0% | 8.12 |
| Chester | $68.11 | $25.25 | $2,000,000 | $136 | $40.07 | $7.16 | $1 | 1% | 9.51 |
| Digby | $210.63 | $74.68 | $2,725,208 | $574 | $85.27 | $29.14 | $13 | 6% | 7.23 |
| Erie | $1.00 | ($40.11) | $2,046,692 | $2 | $31.63 | ($8.40) | $0 | 0% | -0.12 |
| Ferris | $13.17 | ($5.13) | $2,483,360 | $33 | $27.11 | ($1.01) | $1 | 4% | -13.04 |
| Garrett | $66.44 | ($13.30) | $2,000,000 | $133 | $45.66 | $2.14 | $0 | 0% | 31.08 |
| Harper | $59.10 | $3.07 | $2,556,332 | $151 | $37.65 | $4.51 | $0 | 0% | 13.09 |
| Irving | $88.75 | $37.69 | $2,200,000 | $195 | $42.22 | $8.84 | $0 | 0% | 10.04 |
| Bond Market Summary | |||||||||
| Company | Series | Face Value | Yield | Closing Price | S&P Rating | ||||
| Andrews | 11.3S2037 | $6,200,000 | 13.45% | $84.03 | DDD | ||||
| Andrews | 14.3S2042 | $33,400,000 | 15.73% | $90.88 | DDD | ||||
| Chester | 11.6S2038 | $8,100,000 | 12.79% | $90.67 | B | ||||
| Chester | 12.3S2039 | $15,100,000 | 13.27% | $92.71 | B | ||||
| Chester | 13.6S2041 | $13,100,000 | 13.87% | $98.02 | B | ||||
| Digby | 11.3S2037 | $94,806 | 11.34% | $99.63 | AAA | ||||
| Erie | 11.3S2037 | $10,000,000 | 13.13% | $86.09 | C | ||||
| Erie | 11.8S2040 | $1,000,000 | 14.10% | $83.67 | C | ||||
| Garrett | 11.3S2037 | $3,500,000 | 12.77% | $88.52 | CCC | ||||
| Garrett | 12.4S2038 | $5,800,000 | 13.59% | $91.22 | CCC | ||||
| Garrett | 12.2S2040 | $24,900,000 | 13.76% | $88.67 | CCC | ||||
| Garrett | 13.3S2041 | $47,000,000 | 14.26% | $93.25 | CCC | ||||
| Harper | 11.5S2039 | $3,200,000 | 11.66% | $98.62 | AAA | ||||
| Irving | 11.3S2037 | $5,000,000 | 12.15% | $93.02 | BBB | ||||
| Irving | 14.7S2041 | $20,000,000 | 13.72% | $107.10 | BBB | ||||
| Next Year's Prime Rate: | 10.0 |
Market Share
| Market Share | Actual Market Share | Potential Market Share | ||||||||||||
| Name | Traditional | Low End | High End | Performance | Size | Total | Name | Traditional | Low End | High End | Performance | Size | Total | |
| Industry Units Sales | 15,769 | 26,106 | 9,384 | 6,508 | 7,560 | 65,327 | Industry Units Sales | 18,789 | 26,106 | 9,429 | 8,493 | 8,156 | 70,973 | |
| % of Market | 24.1% | 40.0% | 14.4% | 10.0% | 11.6% | 100.0% | % of Market | 26.5% | 36.8% | 13.3% | 12.0% | 11.5% | 100.0% | |
| Able | 6.7% | 0.3% | 0.0% | 0.0% | 0.0% | 1.7% | Able | 0.3% | 0.3% | 0.0% | 0.0% | 0.0% | 0.2% | |
| Acre | 0.0% | 0.8% | 0.0% | 0.0% | 0.0% | 0.3% | Acre | 0.0% | 2.4% | 0.0% | 0.0% | 0.0% | 0.9% | |
| Adam | 0.0% | 0.0% | 8.2% | 0.0% | 0.0% | 1.2% | Adam | 0.0% | 0.0% | 1.4% | 0.0% | 0.0% | 0.2% | |
| Aft | 0.0% | 0.0% | 0.0% | 7.7% | 0.0% | 0.8% | Aft | 0.0% | 0.0% | 0.0% | 3.2% | 0.0% | 0.4% | |
| Agape | 0.0% | 0.0% | 0.0% | 0.0% | 9.0% | 1.0% | Agape | 0.0% | 0.0% | 0.0% | 0.0% | 4.5% | 0.5% | |
| Total | 6.7% | 1.1% | 8.2% | 7.7% | 9.0% | 5.0% | Total | 0.3% | 2.7% | 1.4% | 3.2% | 4.5% | 2.2% | |
| Baker | 16.5% | 0.0% | 0.0% | 0.0% | 0.0% | 4.0% | Baker | 7.3% | 0.0% | 0.0% | 0.0% | 0.0% | 1.9% | |
| Bead | 0.0% | 11.9% | 0.0% | 0.0% | 0.0% | 4.7% | Bead | 0.0% | 7.6% | 0.0% | 0.0% | 0.0% | 2.8% | |
| Bid | 0.0% | 0.0% | 14.9% | 0.0% | 0.0% | 2.1% | Bid | 0.0% | 0.0% | 10.0% | 0.0% | 0.0% | 1.3% | |
| Bold | 0.0% | 0.0% | 0.0% | 17.0% | 0.0% | 1.7% | Bold | 0.0% | 0.0% | 0.0% | 20.4% | 0.0% | 2.4% | |
| Buddy | 0.0% | 0.0% | 0.0% | 0.0% | 17.3% | 2.0% | Buddy | 0.0% | 0.0% | 0.0% | 0.0% | 10.5% | 1.2% | |
| Total | 16.5% | 11.9% | 14.9% | 17.0% | 17.3% | 14.6% | Total | 7.3% | 7.6% | 10.0% | 20.4% | 10.5% | 9.7% | |
| Cake | 16.4% | 0.1% | 0.0% | 0.0% | 0.0% | 4.0% | Cake | 23.7% | 0.4% | 0.0% | 0.0% | 0.0% | 6.4% | |
| Cedar | 0.0% | 14.3% | 0.0% | 0.0% | 0.0% | 5.7% | Cedar | 0.0% | 20.1% | 0.0% | 0.0% | 0.0% | 7.4% | |
| Cid | 0.0% | 0.0% | 19.9% | 0.0% | 0.0% | 2.9% | Cid | 0.0% | 0.0% | 19.3% | 0.0% | 0.0% | 2.6% | |
| Coat | 0.0% | 0.0% | 0.0% | 21.5% | 0.0% | 2.1% | Coat | 0.0% | 0.0% | 0.0% | 8.4% | 0.0% | 1.0% | |
| Cure | 0.0% | 0.0% | 0.0% | 0.0% | 16.0% | 1.9% | Cure | 0.0% | 0.0% | 0.0% | 0.0% | 2.2% | 0.3% | |
| Total | 16.4% | 14.4% | 19.9% | 21.5% | 16.0% | 16.6% | Total | 23.7% | 20.5% | 19.3% | 8.4% | 2.2% | 17.7% | |
| Daze | 31.5% | 0.0% | 0.0% | 0.0% | 0.0% | 7.6% | Daze | 29.6% | 0.0% | 0.0% | 0.0% | 0.0% | 7.8% | |
| Dell | 0.0% | 26.2% | 0.0% | 0.0% | 0.0% | 10.5% | Dell | 0.0% | 31.9% | 0.0% | 0.0% | 0.0% | 11.7% | |
| Dot | 0.0% | 0.0% | 0.0% | 18.3% | 0.0% | 1.8% | Dot | 0.0% | 0.0% | 0.0% | 38.5% | 0.0% | 4.6% | |
| Duck | 0.0% | 0.0% | 31.7% | 0.0% | 0.0% | 4.6% | Duck | 0.0% | 0.0% | 46.6% | 0.0% | 0.0% | 6.2% | |
| Dune | 0.0% | 0.0% | 0.0% | 0.0% | 18.4% | 2.1% | Dune | 0.0% | 0.0% | 0.0% | 0.0% | 53.9% | 6.2% | |
| Total | 31.5% | 26.2% | 31.7% | 18.3% | 18.4% | 26.6% | Total | 29.6% | 31.9% | 46.6% | 38.5% | 53.9% | 36.6% | |
| Eat | 0.0% | 0.0% | 0.0% | 0.0% | 0.0% | 0.0% | Eat | 0.0% | 0.0% | 0.0% | 0.0% | 0.0% | 0.0% | |
| Ebb | 0.0% | 8.2% | 0.0% | 0.0% | 0.0% | 3.3% | Ebb | 0.0% | 14.1% | 0.0% | 0.0% | 0.0% | 5.2% | |
| Echo | 0.0% | 0.0% | 0.0% | 0.0% | 0.0% | 0.0% | Echo | 0.0% | 0.0% | 0.0% | 0.0% | 0.0% | 0.0% | |
| Edge | 0.0% | 0.0% | 0.0% | 0.0% | 0.0% | 0.0% | Edge | 0.0% | 0.0% | 0.0% | 0.0% | 0.0% | 0.0% | |
| Egg | 0.0% | 0.0% | 0.0% | 0.0% | 0.0% | 0.0% | Egg | 0.0% | 0.0% | 0.0% | 0.0% | 0.0% | 0.0% | |
| Total | 0.0% | 8.2% | 0.0% | 0.0% | 0.0% | 3.3% | Total | 0.0% | 14.1% | 0.0% | 0.0% | 0.0% | 5.2% | |
| Fast | 6.8% | 0.0% | 2.3% | 0.0% | 8.8% | 3.0% | Fast | 2.5% | 0.0% | 1.4% | 0.0% | 2.2% | 1.1% | |
| Feat | 0.0% | 4.8% | 0.0% | 0.0% | 0.0% | 1.9% | Feat | 0.0% | 2.2% | 0.0% | 0.0% | 0.0% | 0.8% | |
| Fist | 0.0% | 0.0% | 1.0% | 0.0% | 0.0% | 0.1% | Fist | 0.0% | 0.0% | 0.1% | 0.0% | 0.0% | 0.0% | |
| Foam | 0.0% | 0.0% | 0.0% | 7.0% | 0.0% | 0.7% | Foam | 0.0% | 0.0% | 0.0% | 1.5% | 0.0% | 0.2% | |
| Fume | 0.0% | 0.0% | 0.0% | 0.0% | 7.6% | 0.9% | Fume | 0.0% | 0.0% | 0.0% | 0.0% | 0.4% | 0.0% | |
| Total | 6.8% | 4.8% | 3.4% | 7.0% | 16.4% | 6.7% | Total | 2.5% | 2.2% | 1.5% | 1.5% | 2.5% | 2.2% | |
| Gerbil | 0.0% | 16.1% | 0.0% | 0.0% | 0.0% | 6.4% | Gerbil | 0.0% | 7.3% | 0.0% | 0.0% | 0.0% | 2.7% | |
| Total | 0.0% | 16.1% | 0.0% | 0.0% | 0.0% | 6.4% | Total | 0.0% | 7.3% | 0.0% | 0.0% | 0.0% | 2.7% | |
| Hamper | 0.0% | 0.0% | 0.0% | 0.0% | 5.8% | 0.7% | Hamper | 0.0% | 0.0% | 0.0% | 0.0% | 4.5% | 0.5% | |
| Heft | 10.3% | 0.0% | 0.0% | 0.0% | 0.0% | 2.5% | Heft | 9.3% | 0.0% | 0.0% | 0.0% | 0.0% | 2.5% | |
| Hilt | 0.0% | 0.0% | 0.0% | 9.4% | 0.0% | 0.9% | Hilt | 0.0% | 0.0% | 0.0% | 4.8% | 0.0% | 0.6% | |
| Hoary | 0.0% | 0.0% | 5.6% | 0.0% | 0.0% | 0.8% | Hoary | 0.0% | 0.0% | 5.7% | 0.0% | 0.0% | 0.8% | |
| Hue | 0.0% | 6.8% | 0.0% | 0.0% | 0.0% | 2.7% | Hue | 0.0% | 3.3% | 0.0% | 0.0% | 0.0% | 1.2% | |
| Total | 10.3% | 6.8% | 5.6% | 9.4% | 5.8% | 7.6% | Total | 9.3% | 3.3% | 5.7% | 4.8% | 4.5% | 5.5% | |
| Ignite | 11.9% | 0.0% | 0.0% | 0.0% | 0.0% | 2.9% | Ignite | 27.2% | 0.0% | 0.0% | 0.0% | 0.0% | 7.2% | |
| Indigo | 0.0% | 0.0% | 16.4% | 0.0% | 0.0% | 2.3% | Indigo | 0.0% | 0.0% | 15.5% | 0.0% | 0.0% | 2.1% | |
| Invert | 0.0% | 0.0% | 0.0% | 19.0% | 0.0% | 1.9% | Invert | 0.0% | 0.0% | 0.0% | 23.2% | 0.0% | 2.8% | |
| Iota | 0.0% | 0.0% | 0.0% | 0.0% | 17.0% | 2.0% | Iota | 0.0% | 0.0% | 0.0% | 0.0% | 21.8% | 2.5% | |
| Irate | 0.0% | 10.5% | 0.0% | 0.0% | 0.0% | 4.2% | Irate | 0.0% | 10.4% | 0.0% | 0.0% | 0.0% | 3.8% | |
| Total | 11.9% | 10.5% | 16.4% | 19.0% | 17.0% | 13.3% | Total | 27.2% | 10.4% | 15.5% | 23.2% | 21.8% | 18.3% |
Custom Modules
| Custom Modules | |||||||||
| Andrews | Baldwin | Chester | Digby | Erie | Ferris | Garrett | Harper | Irving | |
| Number of Employees | 729 | 1,420 | 1,568 | 1,258 | 597 | 732 | 341 | 685 | 781 |
| First Shift | 676 | 873 | 1,132 | 629 | 537 | 645 | 314 | 678 | 588 |
| Second Shift | 53 | 547 | 436 | 629 | 60 | 87 | 27 | 7 | 193 |
| Overtime % | 0% | 0% | 0% | 0% | 0% | 0% | 0% | 0% | 0% |
| Turnover Rate | 15.0% | 14.5% | 15.0% | 5.0% | 11.7% | 13.7% | 15.0% | 15.0% | 5.0% |
| New Employees | 174 | 594 | 432 | 63 | 70 | 100 | 51 | 144 | 39 |
| Separated Employees | 0 | 0 | 0 | 4 | 0 | 14 | 5 | 0 | 3 |
| Productivity Index | 100.0% | 107.5% | 105.0% | 117.5% | 109.5% | 105.5% | 107.5% | 105.5% | 116.8% |
| Total Quality Management | |||||||||
| Andrews | Baldwin | Chester | Digby | Erie | Ferris | Garrett | Harper | Irving | |
| Decisions | |||||||||
| Benchmarking | $0 | $0 | $500 | $2,000 | $0 | $100 | $300 | $100 | $1,000 |
| CCE (Concurrent Engineering)/6 Sigma Training | $0 | $1,000 | $0 | $2,000 | $0 | $100 | $0 | $100 | $1,500 |
| CPI (Continuous Process Improvement) Systems | $0 | $500 | $500 | $2,000 | $0 | $100 | $500 | $100 | $1,500 |
| Channel Support Systems | $0 | $0 | $0 | $2,000 | $0 | $100 | $0 | $0 | $2,000 |
| Concurrent Engineering | $0 | $0 | $0 | $2,000 | $0 | $100 | $0 | $100 | $2,000 |
| GEMI TQEM Sustainability | $0 | $0 | $0 | $2,000 | $0 | $200 | $0 | $100 | $1,000 |
| QIT (Quality Initiative Training) | $0 | $0 | $500 | $2,000 | $0 | $200 | $0 | $100 | $1,000 |
| Quality Function Deployment Effort | $0 | $500 | $0 | $2,000 | $0 | $100 | $0 | $100 | $2,000 |
| UNEP Green Program | $0 | $0 | $0 | $2,000 | $0 | $100 | $0 | $0 | $500 |
| Vendor/JIT (Just in Time) Inventory | $0 | $500 | $500 | $2,000 | $0 | $100 | $300 | $100 | $1,500 |
| Total Expenditures | $0 | $2,500 | $2,000 | $20,000 | $0 | $1,200 | $1,100 | $800 | $14,000 |
| Yearly Impacts | |||||||||
| Material Cost | 0% | -1% | -0% | -4% | 0% | 0% | -0% | 0% | -3% |
| R & D Cycle Time | 0% | -1% | 0% | -16% | 0% | 0% | 0% | 0% | -16% |
| Labor Cost | 0% | -1% | -1% | -5% | 0% | -0% | 0% | 0% | -4% |
| Demand | 0% | 0% | 0% | 6% | 0% | 0% | 0% | 0% | 4% |
| Administrative Cost | 0% | -2% | -3% | -23% | 0% | -0% | -1% | -0% | -17% |
| Human Resources | |||||||||
| Andrews | Baldwin | Chester | Digby | Erie | Ferris | Garrett | Harper | Irving | |
| Decisions | |||||||||
| Manufacturing - Training & Assembly Teams | $0 | $1,000 | $500 | $2,000 | $0 | $300 | $300 | $200 | $2,000 |
| Sales - Compensation | $0 | $500 | $500 | $2,000 | $0 | $300 | $0 | $200 | $2,000 |
| Scientists - Recruitment & Retention | $0 | $1,000 | $500 | $2,000 | $0 | $300 | $0 | $200 | $2,000 |
| Total Expenditures | $0 | $2,500 | $1,500 | $6,000 | $0 | $900 | $300 | $600 | $6,000 |
| Yearly Impacts | |||||||||
| R & D Cycle Time | 0% | -3% | 1% | -8% | 5% | 3% | 5% | 4% | -10% |
| Demand | 0% | 2% | 1% | 1% | 0% | 0% | 0% | 0% | 2% |
| Accessibility | 0% | 2% | 2% | 8% | 0% | 1% | 0% | 1% | 8% |
| Productivity Index | 0% | 3% | 1% | 5% | 0% | 1% | 1% | 1% | 5% |
| Turnover Rate | 0% | 5% | 8% | -5% | 20% | 13% | 18% | 14% | -19% |
| Production After Adjustment | 0% | -0% | -1% | 1% | -1% | -1% | -1% | -1% | 1% |
| Cumulative Impacts | |||||||||
| Andrews | Baldwin | Chester | Digby | Erie | Ferris | Garrett | Harper | Irving | |
| Material Cost | 0.0% | -3.5% | -3.2% | -8.3% | -0.1% | -1.1% | -0.6% | 0.0% | -6.0% |
| R & D Cycle Time | 20.0% | -27.7% | -5.3% | -64.3% | 0.6% | -0.4% | 13.8% | 12.2% | -59.3% |
| Labor Cost | 0.0% | -1.4% | -4.1% | -10.0% | -0.7% | -1.3% | -0.1% | 0.0% | -8.0% |
| Demand | 0.0% | 7.1% | 5.5% | 21.1% | 4.5% | 5.2% | 2.3% | 2.6% | 19.1% |
| Administrative Cost | 0.0% | -23.2% | -28.1% | -46.5% | -0.4% | -5.5% | -3.0% | -0.1% | -29.6% |
| Accessibility | 0.0% | 8.0% | 8.0% | 28.0% | 12.8% | 10.4% | 6.8% | 7.6% | 25.6% |
| Productivity Index | 0.0% | 7.5% | 5.0% | 17.5% | 9.5% | 5.5% | 7.5% | 5.5% | 16.8% |
| Turnover Rate | 50.0% | 45.0% | 50.0% | -50.0% | 17.0% | 37.0% | 50.0% | 50.0% | -50.0% |
| Production After Adjustment | -4.0% | -2.8% | -3.5% | 0.2% | -2.2% | -3.4% | -2.8% | -3.4% | 0.0% |
