For Kim Woods management 600 business planning seminar

profileBill2017
ROUND1_8DATA.xlsx
Home>Business & Finance homework help>Management homework help>For Kim Woods management 600 business planning seminar

Round 1 Decisions

CAP SIM Business Simulation Round 1 Data & Analysis
Product Decisions Production Information
ProductName Baker Bead Bid Bold Buddy NA NA NA Name Primary Segment Units Sold Unit Inven tory Revision Date Age Dec.31 MTBF Pfmn Coord Size Coord Price Material Cost Labor Cost Contr. Marg. 2nd Shift & Auto mation Next Round Capacity Next Round Plant Utiliz.
Over-
Performance 5.8 3 8.9 10.2 4.9 0 0 0 time
Baker Trad 2,367 56 5/1/20 2.4 17500 5.8 14 $27.99 $11.06 $8.60 29% 25% 6 1,800 124%
Size 14 17 11 14.8 9.8 0 0 0 Baker Low 2,010 467 1/22/20 5.6 12500 3 17 $20.99 $6.60 $8.10 27% 76% 8 1,400 174%
Bid High 584 36 10/5/20 1.5 23000 8.9 11 $39.99 $15.81 $8.97 38% 0% 3 900 64%
MTBFrdSpec 17500 12500 23000 25000 19000 0 0 0 Bold Pfmn 501 114 7/29/20 2 25000 10.2 14.8 $33.99 $15.55 $8.97 26% 0% 3 600 89%
Buddy Size 438 144 11/12/20 1.9 19000 4.9 9.8 $33.99 $13.66 $8.97 32% 0% 3 600 87%
Price 27.99 20.99 39.99 33.99 33.99 0 0 0
PromoBudget 2000 2000 2000 1000 1000 0 0 0
SalesBudget 1000 1000 1000 700 700 0 0 0
UnitSalesForecast 2446 2502 625 620 587 0 0 0
ProductionOrdered 2257 2463 585 542 525 0 0 0
CapacityChange 0 0 0 0 0 0 0 0
AutomationNextRound 6 8 3 3 3 0 0 0
Finance Decisions
FinanceFunction StIssue StRetire Dividend ShortDebt BondRetire BondIssue AR AP
FinanceDecisions 7000 0 0 0 0 10000 30 30

Round 2 Decisions

CAP SIM Business Simulation Round 1 Data & Analysis
Product Decisions Production Information
ProductName Baker Bead Bid Bold Buddy NA NA NA Name Primary Segment Units Sold Unit Inven tory Revision Date Age Dec.31 MTBF Pfmn Coord Size Coord Price Material Cost Labor Cost Contr. Marg. 2nd Shift & Auto mation Next Round Capacity Next Round Plant Utiliz.
Over-
Performance 6.4 3 10.1 11.2 5.4 0 0 0 time
Baker Trad 2,561 0 7/26/21 1.9 16999 6.4 13.6 $27.99 $10.51 $6.68 38% 40% 8 1,800 139%
Size 13.6 17 10 14 8.3 0 0 0 Bead Low 2,063 211 1/22/20 6.6 12500 3 17 $20.99 $5.93 $3.91 46% 30% 8 1,400 129%
Bid High 686 0 11/27/21 1.3 22300 10.1 10 $39.49 $15.56 $9.40 38% 0% 4 900 72%
MTBFrdSpec 16999 12500 22300 23750 19000 0 0 0 Bold Pfmn 596 0 9/30/21 1.6 23750 11.2 14 $33.99 $15.02 $9.40 28% 0% 3 600 80%
Buddy Size 515 0 11/21/21 1.5 19000 5.4 8.3 $33.99 $13.73 $9.40 34% 0% 3 600 62%
Price 27.99 20.99 39.49 33.99 33.99 0 0 0
PromoBudget 2000 2000 2000 1100 1100 0 0 0
SalesBudget 1014 930 845 718 718 0 0 0
UnitSalesForecast 2585 2291 693 601 519 0 0 0
ProductionOrdered 2529 1824 657 487 375 0 0 0
CapacityChange 0 0 0 0 0 0 0 0
AutomationNextRound 8 8 4 3 3 0 0 0
Marketing Decisions
MKTGPrimarySeg Trad Low High Perf Size 0 0 0
MKTGPrintMedia 550 550 300 200 200 0 0 0
MKTGDirectMail 550 550 400 200 200 0 0 0
MKTGWebMedia 300 300 500 100 100 0 0 0
MKTGEmail 300 300 500 300 300 0 0 0
MKTGTradeShows 300 300 300 300 300 0 0 0
ProductName Baker Bead Bid Bold Buddy NA NA NA
MKTGSalesPriorities 0.24 0.22 0.2 0.17 0.17 0 0 0
MKTGSalesBudget Resources Trad Low High Perf Size
MKTGOutsideSales 11 3 2 2 2 2 0 0
MKTGInsideSales 29 5 6 6 6 6 0 0
MKTGDistributors 14 3 3 3 3 2 0 0
MKTGReports 0 0 0 0 0 0 0 0
Finance Decisions
FinanceFunction StIssue StRetire Dividend ShortDebt BondRetire BondIssue AR AP
FinanceDecisions 0 0 0 0 0 3500 30 30
HR Decisions
Complement RecrSpend TrainHrs
742 2500 40
0 0 0

Round 3 Decisions

Product Decisions Production Information
ProductName Baker Bead Bid Bold Buddy NA NA NA Name Primary Segment Units Sold Unit Inven tory Revision Date Age Dec.31 MTBF Pfmn Coord Size Coord Price Material Cost Labor Cost Contr. Marg. 2nd Shift & Auto mation Next Round Capacity Next Round Plant Utiliz.
Over-
Performance 6.8 3 11.1 12.2 6.2 0 0 0 time
Baker Trad 3,484 81 8/24/22 1.6 16999 6.8 12.9 $27.99 $9.68 $4.28 50% 100% 8 1,801 198%
Size 12.9 17 8.8 13.2 7.2 0 0 0 Bead Low 2,069 914 1/22/20 7.6 12500 3 17 $21.99 $5.07 $4.28 54% 100% 8 1,401 198%
Bid High 1,091 0 8/31/22 1.3 22300 11.1 8.8 $38.49 $14.71 $8.79 40% 22% 8 900 121%
MTBFrdSpec 16999 12500 22300 22500 16500 0 0 0 Bold Pfmn 631 266 7/18/22 1.5 22500 12.2 13.2 $33.49 $13.74 $10.72 23% 51% 5 600 150%
Buddy Size 850 0 8/13/22 1.4 16500 6.2 7.2 $33.49 $12.21 $10.56 31% 43% 5 600 142%
Price 27.99 21.99 38.49 33.49 33.49 0 0 0
PromoBudget 2000 2000 2000 1125 1125 0 0 0
SalesBudget 1122 1029 1029 795 795 0 0 0
UnitSalesForecast 3488 2810 1002 824 780 0 0 0
ProductionOrdered 3600 2800 1102 906 858 0 0 0
CapacityChange 1 1 0 0 0 0 0 0
AutomationNextRound 8 8 8 5 5 0 0 0
Marketing Decisions
MKTGPrimarySeg Trad Low High Perf Size 0 0 0
MKTGPrintMedia 650 650 100 200 200 0 0 0
MKTGDirectMail 650 650 500 200 200 0 0 0
MKTGWebMedia 200 200 500 100 100 0 0 0
MKTGEmail 200 200 600 325 325 0 0 0
MKTGTradeShows 300 300 300 300 300 0 0 0
ProductName Baker Bead Bid Bold Buddy NA NA NA
MKTGSalesPriorities 0.24 0.22 0.22 0.17 0.17 0 0 0
MKTGSalesBudget Resources Trad Low High Perf Size
MKTGOutsideSales 13 3 3 3 2 2 0 0
MKTGInsideSales 31 6 5 8 6 6 0 0
MKTGDistributors 15 3 4 3 3 2 0 0
MKTGReports 0 0 0 0 0 0 0 0
Finance Decisions
FinanceFunction StIssue StRetire Dividend ShortDebt BondRetire BondIssue AR AP
FinanceDecisions 0 0 0 0 0 0 30 30
HR Decisions
Complement RecrSpend TrainHrs
943 5000 80
100 0 0
TQM Decisions
TQMfunction CPI VendorJIT QIT Channels CCE BenchMark QFDE CCE6sigma UNEPGreen GEMISustain
TQMbudgets 1500 1500 1500 1500 1500 1500 1500 1500 1500 1500

Round 4 Decisions

Product Decisions Production Information
ProductName Baker Bead Bid Bold Buddy NA NA NA Name Primary Segment Units Sold Unit Inven tory Revision Date Age Dec.31 MTBF Pfmn Coord Size Coord Price Material Cost Labor Cost Contr. Marg. 2nd Shift & Auto mation Next Round Capacity Next Round Plant Utiliz.
Over-
Performance 7.9 3.8 12 13 6.8 0 0 0 time
Baker Trad 3,431 214 10/19/23 1.4 15999 7.9 12 $27.99 $8.83 $3.89 55% 100% 8 1,804 198%
Size 12 16.3 7.6 12.7 6.8 0 0 0 Bead Low 2,207 941 8/24/23 4.5 12000 3.8 16.3 $21.99 $4.69 $3.71 58% 61% 8 1,404 159%
Bid High 1,420 291 10/22/23 1.2 22300 12 7.6 $37.99 $13.61 $3.86 54% 92% 8 902 190%
MTBFrdSpec 15999 12000 22300 22500 16500 0 0 0 Bold Pfmn 726 271 5/12/23 1.6 22500 13 12.7 $32.99 $12.51 $6.84 34% 23% 7 602 122%
Buddy Size 1,188 0 4/13/23 1.6 16500 6.8 6.8 $32.99 $10.89 $7.77 43% 100% 7 602 198%
Price 27.99 21.99 37.99 32.99 32.99 0 0 0
PromoBudget 2000 2000 2000 2000 2000 0 0 0
SalesBudget 1452 1331 1331 1029 1029 0 0 0
UnitSalesForecast 4727 2965 1571 937 1263 0 0 0
ProductionOrdered 3600 2256 1728 738 1200 0 0 0
CapacityChange 3 3 2 2 2 0 0 0
AutomationNextRound 8 8 8 7 7 0 0 0
Marketing Decisions
MKTGPrimarySeg Trad Low High Perf Size 0 0 0
MKTGPrintMedia 650 650 100 300 400 0 0 0
MKTGDirectMail 650 650 500 300 200 0 0 0
MKTGWebMedia 200 200 500 500 500 0 0 0
MKTGEmail 200 200 600 600 600 0 0 0
MKTGTradeShows 300 300 300 300 300 0 0 0
ProductName Baker Bead Bid Bold Buddy NA NA NA
MKTGSalesPriorities 0.24 0.22 0.22 0.17 0.17 0 0 0
MKTGSalesBudget Resources Trad Low High Perf Size
MKTGOutsideSales 20 3 3 7 2 5 0 0
MKTGInsideSales 37 6 5 8 12 6 0 0
MKTGDistributors 17 4 4 4 3 2 0 0
MKTGReports 0 0 0 0 0 0 0 0
Finance Decisions
FinanceFunction StIssue StRetire Dividend ShortDebt BondRetire BondIssue AR AP
FinanceDecisions 0 0 1 0 0 55000 30 30
HR Decisions
Complement RecrSpend TrainHrs
697 5000 80
100 0 0
TQM Decisions
TQMfunction CPI VendorJIT QIT Channels CCE BenchMark QFDE CCE6sigma UNEPGreen GEMISustain
TQMbudgets 1500 1500 1500 1500 1500 1500 1500 1500 1500 1500

Round 5 Decisions

Product Decisions Production Information
ProductName Baker Bead Bid Bold Buddy NA NA NA Name Primary Segment Units Sold Unit Inven tory Revision Date Age Dec.31 MTBF Pfmn Coord Size Coord Price Material Cost Labor Cost Contr. Marg. 2nd Shift & Auto mation Next Round Capacity Next Round Plant Utiliz.
Over-
Performance 8.6 3.8 12.8 13.6 7.4 0 0 0 time
Baker Trad 3,787 0 8/5/24 1.4 15999 8.6 11.3 $27.49 $8.61 $3.85 55% 100% 8 2,804 198%
Size 11.3 16.3 7.3 11.9 6.2 0 0 0 Bead Low 2,450 0 8/24/23 5.5 12000 3.8 16.3 $21.99 $4.23 $3.22 63% 9% 8 1,405 107%
Bid High 1,586 0 7/18/24 1.3 22300 12.8 7.3 $37.49 $13.06 $3.57 55% 45% 8 942 144%
MTBFrdSpec 15999 12000 22300 22500 16500 0 0 0 Bold Pfmn 864 0 7/1/24 1.5 22500 13.6 11.9 $32.49 $12.11 $4.14 46% 0% 8 603 99%
Buddy Size 1,192 0 6/11/24 1.6 16500 7.4 6.2 $32.49 $10.47 $5.13 52% 100% 8 1,602 198%
Price 27.49 21.99 37.49 32.49 32.49 0 0 0
PromoBudget 1850 1850 2000 2400 2500 0 0 0
SalesBudget 1837 1921 1837 1420 1503 0 0 0
UnitSalesForecast 3934 2465 1599 870 1546 0 0 0
ProductionOrdered 3608 1524 1308 599 1204 0 0 0
CapacityChange 1000 1 40 1 1000 0 0 0
AutomationNextRound 8 8 8 8 8 0 0 0
Marketing Decisions
MKTGPrimarySeg Trad Low High Perf Size 0 0 0
MKTGPrintMedia 675 700 100 500 550 0 0 0
MKTGDirectMail 675 700 500 500 550 0 0 0
MKTGWebMedia 100 125 500 500 500 0 0 0
MKTGEmail 100 125 600 600 600 0 0 0
MKTGTradeShows 300 200 300 300 300 0 0 0
ProductName Baker Bead Bid Bold Buddy NA NA NA
MKTGSalesPriorities 0.22 0.23 0.22 0.17 0.18 0 0 0
MKTGSalesBudget Resources Trad Low High Perf Size
MKTGOutsideSales 28 3 3 8 2 12 0 0
MKTGInsideSales 39 6 5 8 14 6 0 0
MKTGDistributors 29 10 10 4 3 2 0 0
MKTGReports 0 0 0 0 0 0 0 0
Finance Decisions
FinanceFunction StIssue StRetire Dividend ShortDebt BondRetire BondIssue AR AP
FinanceDecisions 0 17000 0 0 0 0 30 30
HR Decisions
Complement RecrSpend TrainHrs
508 5000 80
0 0 0
TQM Decisions
TQMfunction CPI VendorJIT QIT Channels CCE BenchMark QFDE CCE6sigma UNEPGreen GEMISustain
TQMbudgets 1000 1000 1000 1000 1000 1000 1000 1000 1000 1000

Round 6 Decisions

Product Decisions Production Information
ProductName Baker Bead Bid Bold Buddy NA NA NA Name Primary Segment Units Sold Unit Inven tory Revision Date Age Dec.31 MTBF Pfmn Coord Size Coord Price Material Cost Labor Cost Contr. Marg. 2nd Shift & Auto mation Next Round Capacity Next Round Plant Utiliz.
Over-
Performance 9.2 4.5 13.5 14.4 8 0 0 0 time
Baker Trad 5,012 260 7/31/25 1.4 15999 9.2 10.6 $26.99 $8.41 $3.83 55% 90% 8 3,004 188%
Size 10.6 15.6 6.6 11.2 5.4 0 0 0 Bead Low 2,782 0 8/10/25 3.4 12000 4.5 15.6 $21.99 $4.28 $3.87 63% 100% 8 2,505 198%
Bid High 1,865 0 8/10/25 1.4 22300 13.5 6.6 $36.99 $12.70 $3.87 55% 100% 8 2,142 198%
MTBFrdSpec 15999 12000 22300 27000 16500 0 0 0 Bold Pfmn 1,059 135 9/28/25 1.4 27000 14.4 11.2 $31.99 $13.05 $3.87 50% 100% 8 903 198%
Buddy Size 2,134 170 8/11/25 1.5 16500 8 5.4 $31.99 $10.19 $3.58 57% 45% 8 1,802 144%
Price 26.99 21.99 36.99 31.99 31.99 0 0 0
PromoBudget 2200 2200 2000 2400 2500 0 0 0
SalesBudget 2288 2392 2080 1768 2080 0 0 0
UnitSalesForecast 5324 2810 1884 1206 2327 0 0 0
ProductionOrdered 5324 2810 1884 1206 2327 0 0 0
CapacityChange 200 1100 1200 300 200 0 0 0
AutomationNextRound 8 8 8 8 8 0 0 0
Marketing Decisions
MKTGPrimarySeg Trad Low High Perf Size 0 0 0
MKTGPrintMedia 700 700 100 500 550 0 0 0
MKTGDirectMail 700 700 500 500 550 0 0 0
MKTGWebMedia 250 250 500 500 500 0 0 0
MKTGEmail 250 250 600 600 600 0 0 0
MKTGTradeShows 300 300 300 300 300 0 0 0
ProductName Baker Bead Bid Bold Buddy NA NA NA
MKTGSalesPriorities 0.22 0.23 0.2 0.17 0.2 0 0 0
MKTGSalesBudget Resources Trad Low High Perf Size
MKTGOutsideSales 32 3 3 12 2 12 0 0
MKTGInsideSales 52 6 5 8 18 15 0 0
MKTGDistributors 38 15 15 4 3 1 0 0
MKTGReports 0 0 0 0 0 0 0 0
Finance Decisions
FinanceFunction StIssue StRetire Dividend ShortDebt BondRetire BondIssue AR AP
FinanceDecisions 0 0 1 0 25000 0 30 30
HR Decisions
Complement RecrSpend TrainHrs
746 5000 80
0 0 0
TQM Decisions
TQMfunction CPI VendorJIT QIT Channels CCE BenchMark QFDE CCE6sigma UNEPGreen GEMISustain
TQMbudgets 0 0 0 0 0 0 0 0 0 0

Round 7 Decisions

Product Decisions Production Information
ProductName Baker Bead Bid Bold Buddy NA NA NA Name Primary Segment Units Sold Unit Inven tory Revision Date Age Dec.31 MTBF Pfmn Coord Size Coord Price Material Cost Labor Cost Contr. Marg. 2nd Shift & Auto mation Next Round Capacity Next Round Plant Utiliz.
Over-
Performance 10 4.5 14.7 15.8 8.9 0 0 0 time
Baker Trad 5,139 1,069 8/7/26 1.4 15999 10 10 $26.49 $8.25 $4.00 53% 100% 8 4,004 198%
Size 10 15.6 5 10.7 3.7 0 0 0 Bead Low 4,961 0 8/10/25 4.4 12000 4.5 15.6 $21.49 $3.91 $4.00 63% 100% 8 3,505 198%
Bid High 2,231 753 12/23/26 1.2 22300 14.7 5 $36.49 $12.77 $3.68 55% 41% 8 2,142 139%
MTBFrdSpec 15999 12000 22300 27000 16500 0 0 0 Bold Pfmn 1,572 0 10/14/26 1.3 27000 15.8 10.7 $31.49 $12.98 $3.82 48% 61% 8 1,153 159%
Buddy Size 2,040 1,000 12/13/26 1.3 16500 8.9 3.7 $31.49 $10.33 $3.82 54% 61% 8 2,052 159%
Price 26.49 21.49 36.49 31.49 31.49 0 0 0
PromoBudget 2200 2200 2200 2400 2500 0 0 0 Name Units Sold Forecast Target
SalesBudget 3394 3548 3085 2622 3085 0 0 0
Baker 5,139 6008 85.5%
UnitSalesForecast 6008 5010 3013 1586 3069 0 0 0 Bead 4,961 5010 99.0%
Bid 2,231 3013 74.0%
ProductionOrdered 6008 5010 3013 1451 2899 0 0 0 Bold 1,572 1451 108.3%
Buddy 2,040 2899 70.4%
CapacityChange 1000 1000 0 250 250 0 0 0
Baker Bead Bid Bold Buddy Brave
AutomationNextRound 8 8 8 8 8 0 0 0 2026 Capacity Change 1000 1000 0 250 250 0 0 0
2027 Capacity Change 0 2000 0 1000 0 100 0 0
Marketing Decisions Next year 2028 Capacity 4004 5505 2142 2153 2052 100
MKTGPrimarySeg Trad Low High Perf Size 0 0 0
MKTGPrintMedia 700 700 250 500 550 0 0 0
MKTGDirectMail 700 700 550 500 550 0 0 0
MKTGWebMedia 250 250 500 500 500 0 0 0
MKTGEmail 250 250 600 600 600 0 0 0
MKTGTradeShows 300 300 300 300 300 0 0 0 WEEK 7
ProductName Baker Bead Bid Bold Buddy NA NA NA Name Market Share Units Sold to Seg Revision Stock Out Pfmn Coord Size Coord List Name Age Dec.31 Promo Cust. Aware- Sales Budget Cust. Access- Dec. Cust. Survey
Date Price Budget ness ibility
MKTGSalesPriorities 0.22 0.23 0.2 0.17 0.2 0 0 0 Baker 38% 5,139 8/7/26 10 10 $26.49 Baker 1.4 $2,200 90% $3,394 88% 48
MKTGSalesBudget Resources Trad Low High Perf Size Cake 32% 4,426 10/14/26 9.2 10.8 $25.34 Cake 1.64 $2,900 93% $1,910 100% 55
Able 30% 4,113 1/18/26 YES 8.5 11.5 $25.99 Able 2.45 $2,000 75% $2,190 90% 31
MKTGOutsideSales 51 3 12 12 12 12 0 0 Week 8
MKTGInsideSales 105 20 10 20 30 25 0 0 Name Market Share Units Sold to Seg Revision Stock Out Pfmn Coord Size Coord List Name Age Dec.31 Promo Cust. Aware- Sales Budget Cust. Access- Dec. Cust. Survey
MKTGDistributors 38 15 15 4 3 1 0 0 Date Price Budget ness ibility
MKTGReports 0 0 0 0 0 0 0 0 Baker 47% 6,960 10/16/27 YES 11 9 $25.99 Baker 1.3 $2,500 93% $3,927 100% 45
Finance Decisions Cake 41% 6,104 10/14/26 YES 9.2 10.8 $25.98 Cake 2.64 $2,900 95% $1,830 100% 32
FinanceFunction StIssue StRetire Dividend ShortDebt BondRetire BondIssue AR AP Able 12% 1,834 1/16/28 YES 8.5 11.5 $25.99 Able 3.45 $2,000 77% $2,190 95% 4
FinanceDecisions 0 17000 1.1 0 0 0 30 30
HR Decisions
Complement RecrSpend TrainHrs
1000 5000 80
100 0 0
TQM Decisions
TQMfunction CPI VendorJIT QIT Channels CCE BenchMark QFDE CCE6sigma UNEPGreen GEMISustain
TQMbudgets 0 0 0 0 0 0 0 0 0 0

Units Sold

Trad Low High Pfmn Size 5139 4961 2231 1572 2040

Round 8 Decisions

Product Decisions Production Information
ProductName Baker Bead Bid Bold Buddy Brave NA NA Name Primary Segment Units Sold Unit Inven tory Revision Date Age Dec.31 MTBF Pfmn Coord Size Coord Price Material Cost Labor Cost Contr. Marg. 2nd Shift & Auto mation Next Round Capacity Next Round Plant Utiliz.
Over-
Performance 11 5.2 16 17.5 9.9 10.2 0 0 time
Baker Trad 6,960 0 10/16/27 1.3 15999 11 9 $25.99 $8.25 $3.86 54% 49% 9 4,004 147%
Size 9 14.6 4 9.8 2.3 9.9 0 0 Bead Low 6,520 0 9/16/27 2.9 12000 5.2 14.6 $20.99 $4.06 $4.09 62% 88% 9 5,505 186%
Bid High 3,211 0 11/19/27 1.1 22300 16 4 $35.99 $12.66 $3.56 56% 16% 9 2,142 115%
MTBFrdSpec 15999 12000 22300 27000 16500 18000 0 0 Bold Pfmn 2,283 0 1/4/28 2.3 27000 15.8 10.7 $30.99 $12.33 $4.14 46% 100% 9 2,153 198%
Buddy Size 1,466 0 12/1/27 1.2 16500 9.9 2.3 $30.99 $10.32 $3.34 56% 0% 9 2,052 23%
Price 25.99 20.99 35.99 30.99 30.99 0 0 0 Brave 0 0 1/31/28 0 0 0 0 $0.00 $0.00 $0.00 0% 0% 1 100 0%
PromoBudget 2500 2700 2500 2600 2500 1500 0 0 Sold Forecast Target
Baker 6,960 7,020 99.1%
SalesBudget 3927 4106 3570 3035 3570 0 0 0 Bead 6,520 6,585 99.0%
Bid 3,211 3,236 99.2%
UnitSalesForecast 7020 6585 3236 2306 1471 0 0 0 Bold 2,283 2,306 99.0%
Buddy 1,466 1,471 99.7%
ProductionOrdered 5949 6585 2483 2306 471 0 0 0 Brave 0 0 100.0%
CapacityChange 0 2000 0 1000 0 100 0 0
AutomationNextRound 9 9 9 9 9 1 0 0
Marketing Decisions
MKTGPrimarySeg Trad Low High Perf Size Trad 0 0
MKTGPrintMedia 700 700 550 600 550 300 0 0
MKTGDirectMail 700 700 550 600 550 300 0 0
MKTGWebMedia 400 500 500 500 500 300 0 0
MKTGEmail 400 500 600 600 600 300 0 0
MKTGTradeShows 300 300 300 300 300 300 0 0
ProductName Baker Bead Bid Bold Buddy Brave NA NA
MKTGSalesPriorities 0.22 0.23 0.2 0.17 0.2 0 0 0
MKTGSalesBudget Resources Trad Low High Perf Size
MKTGOutsideSales 52 4 12 12 12 12 0 0
MKTGInsideSales 129 30 9 30 30 30 0 0
MKTGDistributors 49 15 15 3 9 7 0 0
MKTGReports 0 0 0 0 0 0 0 0
Finance Decisions
FinanceFunction StIssue StRetire Dividend ShortDebt BondRetire BondIssue AR AP
FinanceDecisions 0 43787 3 0 0 184000 30 30
HR Decisions
Complement RecrSpend TrainHrs
954 5000 80
0 0 0
TQM Decisions
TQMfunction CPI VendorJIT QIT Channels CCE BenchMark QFDE CCE6sigma UNEPGreen GEMISustain
TQMbudgets 0 0 0 0 0 0 0 0 0 0

Units Sold

Trad Low High Pfmn Size 6960 6520 3211 2283 1466 0

Sheet3

CHARTS & GRAPHS

Product Week 1 Price Week 2 Price Week 3 Price Week 4 Price Week 5 Price Week 6 Price Week 7 Price Week 8 Price Product Week1 Forec ast Units Sold Week 2 Forec ast Units Sold Week 3 Forec ast Units Sold Week 4 Forec ast Units Sold Week 5 Forecast Units Sold Week 6 Forec ast Units Sold Week 7 Forec ast Units Sold Week 8 Forec ast Units Sold
Baker $27.99 $27.99 $27.99 $27.99 $27.49 $26.99 $26.49 $25.99 Baker 2447 2,367 2585 2,561 3488 3,484 4727 3,431 3,394 3,787 5,324 5,012 6,008 5,139 7,020 6,960
Bead $20.99 $20.99 $21.99 $21.99 $21.99 $21.99 $21.49 $20.99 Bead 2502 2,010 2291 2,063 2810 2,069 2965 2,207 2,465 2,450 2,810 2,782 5,010 4,961 6,585 6,520
Bid $39.99 $39.49 $38.49 $37.99 $37.49 $36.99 $36.49 $35.99 Bid 625 584 693 686 1002 1,091 1571 1,420 1,599 1,586 1,884 1,865 3,013 2,231 3,236 3,211
Bold $33.99 $33.99 $33.49 $32.99 $32.49 $31.99 $31.49 $30.99 Bold 620 501 601 596 824 631 937 726 870 864 1,206 1,059 1,586 1,572 2,306 2,283
Buddy $33.99 $33.99 $33.49 $32.99 $32.49 $31.99 $31.49 $30.99 Buddy 587 438 519 515 780 850 1263 1,188 1,546 1,192 2,327 2,134 3,069 2,040 1,471 1,466
Brave $0.00 Brave 0 0 0
2446 2502 625 620 587
UnitSalesForecast 2585 2291 693 601 519 0 0 0
UnitSalesForecast 3488 2810 1002 824 780
UnitSalesForecast 4727 2965 1571 937 1263
UnitSalesForecast 3934 2465 1599 870 1546
UnitSalesForecast 5324 2810 1884 1206 2327
UnitSalesForecast 6008 5010 3013 1586 3069
UnitSalesForecast 7020 6585 3236 2306 1471 0

Product

Pricing History

Week 1 Price Week 2 Price Week 3 Price Week 4 Price Week 5 Price Week 6 Price Week 7 Price Week 8 Price

Week 1 Price Week 2 Price Week 3 Price Week 4 Price Week 5 Price Week 6 Price Week 7 Price Week 8 Price Baker

Week 1 Price Week 2 Price Week 3 Price Week 4 Price Week 5 Price Week 6 Price Week 7 Price Week 8 Price 27.99 27.99 27.99 27.99 27.49 26.99 26.49 25.99 Bead

Week 1 Price Week 2 Price Week 3 Price Week 4 Price Week 5 Price Week 6 Price Week 7 Price Week 8 Price 20.99 20.99 21.99 21.99 21.99 21.99 21.49 20.99 Bid

Week 1 Price Week 2 Price Week 3 Price Week 4 Price Week 5 Price Week 6 Price Week 7 Price Week 8 Price 39.99 39.49 38.49 37.99 37.49 36.99 36.49 35.99 Bold

Week 1 Price Week 2 Price Week 3 Price Week 4 Price Week 5 Price Week 6 Price Week 7 Price Week 8 Price 33.99 33.99 33.49 32.99 32.49 31.99 31.49 30.99 Buddy

Week 1 Price Week 2 Price Week 3 Price Week 4 Price Week 5 Price Week 6 Price Week 7 Price Week 8 Price 33.99 33.99 33.49 32.99 32.49 31.99 31.49 30.99

Weekly Forecast v Sold

Baker

Week1 Forec ast Units Sold Week 2 Forec ast Units Sold Week 3 Forec ast Units Sold Week 4 Forec ast Units Sold Week 5 Forecast Units Sold Week 6 Forec ast Units Sold Week 7 Forec ast Units Sold Week 8 Forec ast Units Sold 2447 2367 2585 2561 3488 3484 4727 3431 3394 3787 5324 5012 6008 5139 7020 6960 Bead

Week1 Forec ast Units Sold Week 2 Forec ast Units Sold Week 3 Forec ast Units Sold Week 4 Forec ast Units Sold Week 5 Forecast Units Sold Week 6 Forec ast Units Sold Week 7 Forec ast Units Sold Week 8 Forec ast Units Sold 2502 2010 2291 2063 2810 2069 2965 2207 2465 2450 2810 2782 5010 4961 6585 6520 Bid

Week1 Forec ast Units Sold Week 2 Forec ast Units Sold Week 3 Forec ast Units Sold Week 4 Forec ast Units Sold Week 5 Forecast Units Sold Week 6 Forec ast Units Sold Week 7 Forec ast Units Sold Week 8 Forec ast Units Sold 625 584 693 686 1002 1091 1571 1420 1599 1586 1884 1865 3013 2231 3236 3211 Bold

Week1 Forec ast Units Sold Week 2 Forec ast Units Sold Week 3 Forec ast Units Sold Week 4 Forec ast Units Sold Week 5 Forecast Units Sold Week 6 Forec ast Units Sold Week 7 Forec ast Units Sold Week 8 Forec ast Units Sold 620 501 601 596 824 631 937 726 870 864 1206 1059 1586 1572 2306 2283 Buddy

Week1 Forec ast Units Sold Week 2 Forec ast Units Sold Week 3 Forec ast Units Sold Week 4 Forec ast Units Sold Week 5 Forecast Units Sold Week 6 Forec ast Units Sold Week 7 Forec ast Units Sold Week 8 Forec ast Units Sold 587 438 519 515 780 850 1263 1188 1546 1192 2327 2134 3069 2040 1471 1466 Brave

Week1 Forec ast Units Sold Week 2 Forec ast Units Sold Week 3 Forec ast Units Sold Week 4 Forec ast Units Sold Week 5 Forecast Units Sold Week 6 Forec ast Units Sold Week 7 Forec ast Units Sold Week 8 Forec ast Units Sold 0 0 0

Week1 Forec ast Units Sold Week 2 Forec ast Units Sold Week 3 Forec ast Units Sold Week 4 Forec ast Units Sold Week 5 Forecast Units Sold Week 6 Forec ast Units Sold Week 7 Forec ast Units Sold Week 8 Forec ast Units Sold

Week1 Forec ast Units Sold Week 2 Forec ast Units Sold Week 3 Forec ast Units Sold Week 4 Forec ast Units Sold Week 5 Forecast Units Sold Week 6 Forec ast Units Sold Week 7 Forec ast Units Sold Week 8 Forec ast Units Sold

Sheet10

Name
Baker
Bead
Bid
Bold
Buddy
Brave