capsim Board of directors report- template already provided with sample of a 5th week round according to 5th round results and reports just need to follow the already written one and capsim report file that will be attached.
1
19
Baldwin BOD Report- Round 1
Performance Review
R&D.
Traditional:
Low-end:
High-end:
Performance:
Size:
Marketing:
Traditional:
Low-end:
High-end:
Performance:
Size:
Production & operations:
Traditional:
Figure 1
Low-end:
Figure 2
High-end:
Figure 3
Performance:
Figure 4
Size:
Figure 5
Finance
Figure 6
HR & TQM
Plans & strategies
Figure 7
Sales Channel:
Human Resource strategy.
Manufacturing strategy.
Financial strategy.
Business Strategy and Performance Assessment
Actions against business plans
Departures from the business plans
Significant events affecting company and/or market
Goals relative to KPIs performance
Why we achieved or not achieved our goals — what were the
causes of your better than, or weaker than expected performance? (candidness here is
very important)
Baldwin BOD Report- Round 4
Performance Review
R&D.
Traditional:
Low-end:
High-end:
Performance:
Size:
Marketing:
Traditional:
Low-end:
High-end:
Performance:
Size:
Production & operations:
Traditional:
Figure 1
Low-end:
Figure 2
High-end:
Figure 3
Performance:
Figure 4
Size:
Figure 5
Finance
Figure 6
HR & TQM
Plans & strategies
Figure 7
Sales Channel:
Human Resource strategy.
Manufacturing strategy.
Financial strategy.
Business Strategy and Performance Assessment
Actions against business plans
Departures from the business plans
Significant events affecting company and/or market
Goals relative to KPIs performance
Why we achieved or not achieved our goals — what were the
causes of your better than, or weaker than expected performance? (candidness here is
very important)
Customer Survey- Size
Agape Round 1 Round 2 Round 3 Round 4 37 20 25 12 Buddy Round 1 Round 2 Round 3 Round 4 33 51 68 86 Cure Round 1 Round 2 Round 3 Round 4 44 52 52 65 Dune Round 1 Round 2 Round 3 Round 4 22 25 26 36 Egg Round 1 Round 2 Round 3 Round 4 6 2 2 1 Fume Round 1 Round 2 Round 3 Round 4 18 19 16 6
SalesVariable Costs
(Labor,Material,
Carry)
Contribution
Margin
Contribution
Margin%/ Gross
Profit Margin
>30%
DepreciationSGA
(R&D,Promo,
Sales,Admin)
Other
(Fees,Writeoffs,
TQM,Bonuses)
EBITOperating
Profit Margin/
ROS
Interest
(Short term,
Long term)
TaxesProfit
Sharing
Net ProfitNet Profit
Margin/
Net Margin
>10%
Andrews
$117,242$86,997$30,24525.80%$9,560$17,049$1,000$2,6372.25%$10,188($2,643)$0($4,908)-4.2%
Baldwin
$150,775$117,797$32,97821.87%$9,700$26,113$1,635($4,470)-2.96%$10,025($5,073)$0($9,421)-6.2%
Chester
$115,702$78,214$37,48832.40%$8,440$24,227$1,635$3,1872.75%$7,567($1,533)$0($2,847)-2.5%
Digby
$135,979$102,007$33,97224.98%$8,440$21,099$1,175$3,2592.40%$7,003($1,310)$0($2,434)-1.8%
Erie
$70,683$53,237$17,44624.68%$7,587$8,766$0$1,0931.55%$8,627($2,637)$0($4,897)-6.9%
Ferris
$97,262$67,000$30,26231.11%$7,587$14,365$0$8,3108.54%$5,421$1,011$38$1,8401.9%
Name Primary
Segment
Market
Share
Promo
Budget
Cust.
Aware-
ness
Sales
Budget
Cust.
Access-
ibility
Dec.
Cust
Survey
Able Trad21% $1,700100%$3,00088%56
Baker Trad23% $1,400100%$3,00086%68
Cake Trad20% $1,400100%$3,00091%68
Daze Trad22% $1,50095%$3,00082%62
Eat Trad0% $1,00063%$1,00030%1
Fast Trad12% $2,900100%$3,00066%21
Units
Sold
InventoryRevision
Date
Age,
Dec.31
MTBFPfmn
Coord
Size
Coord
PriceMaterial
Cost
Labor
Cost
Contr
.Marg
.
2nd
Shift &
Over-
time
Automat
ion next
Round
Capacity
Next
Round
Plant
Utiliz.
$5.96$10.10
33%24%6.02,000123%
34%14%6.51,800114%
2,4065106-19-2024
2.9185006.214.0$28.20
1.6190007.712.3$25.49$6.16$10.11
2,29409-9-20241.4190007.112.9$24.45
$7.5326%7%5.01,800106%
2,13608-11-20241.5190007.512.5$24.99$4.9740%0%7.02,00099%$9.96
122$10.802,3588-17-20241.5190007.912.1$24.75
$8.7231%22%6.01,800118%
48400311-21-20177.1175005.514.5$28.00$9.02
-614%
0%4.01,80066%
1027$8.721,2623-4-2025
$8.38
Name Primary
Segment
Market
Share
Promo
Budget
Cust.
Aware-
ness
Sales
Budget
Cust.
Access-
ibility
Dec.
Cust
Survey
Acre Low20% $1,700100%$3,50086%34
Bead Low23% $1,400100%$3,00083%48
Cedar Low16% $1,400100%$3,00088%33
Candy Low9% $2,000100%$2,00088%30
Dell Low11% $1,50095%$3,00078%20
Ebb Low6% $90055%$90025%11
Feat Low11% $2,900100%$3,20070%23
Fate Low4% $2,00089%$1,50070%11
Units
Sold
Unit
inventory
Revision
Date
Age,
Dec.31
MTBFPfmn
Coord
Size
Coord
PriceMaterial
Cost
Labor
Cost
Contr.M
arg.
2nd
Shift &
Over-
time
Automati
on next
Round
Capacity
Next
Round
Plant
Utiliz.
$12.350%4.01,00096%
1,5077286-13-20241.7160003.216.8$19.00$7.3327%20%6.01,500116%
$6.36
$5.73
6093565-25-20241.3
30%5.01,400129%
1,4879988-16-20241.6170004.715.3$18.25$6.0718%0%6.01,65088%
2009$5.278515-24-20168.614000
600199%
25%7.01,600124%
1,19303-6-20241.4170003.616.5$18.49$8.20
2,1853026-23-20242.1170003.616.5
170003.616.4$17.99$6.98$6.3323%
100%5.0
9%
$5.7728%48%8.01,800148%2,7584389-21-20243.1175003.216.8$17.95$6.45
100%6.02,140198%3,2759816-19-20244.6
$7.56
$6.29
$6.2933%
21%
$8.5814%
$18.49$5.44
3.017.0$21.00
160004.016.0$22.00
Name Primary
Segment
Market
Share
Promo
Budget
Cust.
Aware-
ness
Sales
Budget
Cust.
Access-
ibility
Dec.
Cust
Survey
Adam High8% $1,700100%$3,00082%9
Aag High7% $1,00046%$1,50082%25
Bid High34% $1,400100%$3,00084%71
Cid High27% $1,400100%$3,00069%56
Duck High14% $1,50097%$2,20059%39
Echo High0% $80046%$80018%0
Fist High10% $2,900100%$3,00062%10
Units
Sold
Unit
inventory
Revision
Date
Age,
Dec.31
MTBFPfmn
Coord
Size
Coord
PriceMaterial
Cost
Labor
Cost
Contr.
Marg.
2nd
Shift &
Over-
time
Automation
next Round
Capacity Next
Round
Plant
Utiliz.
$9.8832%10.39.9$38.49
90045%
393$13.504751-2-20252.524000
1,24037-24-20241.32500012.18.0$38.49$9.34
12.37.7$37.99$9.40
0%3.090072%
36%79%5.0700178%
$9.7230%
35%68%4.0950166%$15.43
$15.23
95%4.5400100%34466-24-20240.52500010.79.3$38.35$11.55$14.8431%
1,5728810-10-20241.2
36563411-27-20253.025500
25000
9.510.5$37.65$6.25$14.000%6.090065%30%
394$15.4764911-13-20241.32500011.48.6$38.00
$12.10
0%5.090096%
911684-19-20195.7230008.012.0$38.00$10.31-889%0%3.0
Name Primary
Segment
Market
Share
Promo
Budget
Cust.
Aware-
ness
Sales
Budget
Cust.
Access-
ibility
Dec.
Cust
Survey
Aft Pfmn18% $1,700100%$3,50075%33
Bold Pfmn33% $1,400100%$3,00081%73
Coat Pfmn22% $1,400100%$3,00067%67
Dot Pfmn18% $1,50092%$2,20058%50
Edge Pfmn2% $70038%$70017%3
Foam Pfmn7% $1,90084%$2,00040%12
Units
Sold
Unit
inventory
Revision
Date
Age,
Dec.31
MTBFPfmn
Coord
Size
Coord
PriceMaterial
Cost
Labor
Cost
Contr.
Marg.
2nd
Shift &
Over-
time
Automation
next Round
Capacity
Next
Round
Plant
Utiliz.
7118211-7-20241.32700012.414.0$31.25
1,309227-21-20241.42700013.313.4$31.99
86907-15-20241.52700012.913.6$31.49
2703029-14-20252.82500010.615.5$31.49
67%4.0650165%
600124%
$10.3117%10%5.0500106%
$10.31-95%0%3.060073%
$9.39
7792215-23-20252.72850010.514.8$30.79$7.63
1210$12.28826-30-20186.5250009.415.5$33.00
$14.80
$14.6724%
$13.9924%
$8.4627%25%5.0
$9.7222%0%3.0
$14.42
30%6.5
$12.29
600130%
60099%
Name Primary
Segment
Market
Share
Promo
Budget
Cust.
Aware-
ness
Sales
Budget
Cust.
Access-
ibility
Dec.
Cust
Survey
Agape Size13% $1,700100%$3,50078%12
Buddy Size30% $1,400100%$3,00083%86
Cure Size31% $1,400100%$3,00067%65
Dune Size18% $1,50092%$2,00054%36
Egg Size1% $70038%$70017%1
Fume Size8% $2,900100%$2,90053%6
Units
Sold
Unit
inventory
Revision
Date
Age,
Dec.31
MTBFPfmn
Coord
Size
Coord
PriceMaterial
Cost
Labor
Cost
Contr.M
arg.
2nd
Shift &
Over-
time
Automation
next Round
Capacity
Next Round
Plant
Utiliz.
4.0650170%
$9.8827%0%4.060096%
5-25-20186.6190004.011.0$33.00$10.31-266%0%3.060063%
3.0600100%
$9.5634%100%5.0600199%
$9.7731%1%
5.560082%
$12.96
$12.14
1,154010-4-2024
4984025-14-20253.3220004.89.2$32.20$6.88
1.3210006.66.7$32.99$9.4633%
3079-28-20252.6170004.98.7$33.99
27%0%
72%
321249
0$12.731,1937-15-20241.4210006.57.1$33.49
$10.16
143$12.9470110-30-20241.4210006.27.8$32.99
492$10.45
SalesVariable Costs
(Labor,Material,
Carry)
Contribution
Margin
Contribution
Margin%/ Gross
Profit Margin
>30%
DepreciationSGA
(R&D,Promo,
Sales,Admin)
Other
(Fees,Writeoffs,
TQM,Bonuses)
EBITOperating
Profit Margin
Interest
(Short term,
Long term)
TaxesProfit
Sharing
Net ProfitNet Profit
Margin/ROS/
Net Margin
>10%
Andrews
$172,555$121,525$51,03029.57%$13,240$35,814$8,280($6,303)-3.65%$18,348($8,628)$0($16,023)-9.3%
Baldwin
$259,908$182,105$77,80329.93%$11,580$29,732$15,029$21,4628.26%$6,672$5,176$192$9,4213.6%
Chester
$230,884$153,791$77,09333.39%$12,493$32,183$15,000$17,4167.54%$6,650$3,768$140$6,8583.0%
Digby
$155,539$116,486$39,05325.11%$8,940$26,085$5,550($1,522)-0.98%$8,390($3,469)$0($6,443)-4.1%
Erie
$23,331$37,638($14,307)-61.32%$7,587$8,433$0($30,327)-129.99%$50,267($28,208)$0($52,386)-224.5%
Ferris
$114,852$84,937$29,91526.05%$11,373$38,751$15,050($35,259)-30.70%$21,529($19,876)$0($36,912)-32.1%