Enter Data Here
ALL SPORTS SHOES CO.
COMPANY OVERALL BRANDED PRIVATE LABEL INTERNET
2010 2011 2012 2013 2014 2015 2010 2011 2012 2013 2014 2015 2010 2011 2012 2013 2014 2015 2010 2011 2012 2013 2014 2015
Actual Target Actual Target Actual Target Actual Target Actual Target Actual Actual Target Actual Target Actual Target Actual Target Actual Target Actual Actual Target Actual Target Actual Target Actual Target Actual Target Actual Actual Target Actual Target Actual Target Actual Target Actual Target Actual
OPERATIONS Cost of production per pai
reject rate %
Productivity
% Superior materials
no of models produced
TQM spend per pai
cost of Production LA
Inventory days
Quality
LEARNING & DEVELOPMENT Training spend per employee
TQM spend per pai
Green Materials %
Incentive pay
Number of employees
CUSTOMERS & MARKETING Advertising Spend
Cele
ity Endorsement payments
Image rating 70 70 66 72 73
Price per pai
Market Share
Retailer support Rebate
FINANCE Earnings per Share 2 2 1.99 3 6.05
Revenue $432,646 $454,976 $729,894
Profit $ 40,000 $39,754 $120,988
Net profit percentage 9% 9% 17%
Return on equity 21 17.7 22 40.3
Credit rating B+ B+ B+ B+ B+
Cu
ent ratio
Interest Coverage
Cash Balance
Bo
owings
shares on issue
DASHBOARD
BALANCED SCORECARD DASH BOARD
COMPANY Good Quality Shoe Company
Base Year 2010 2011 Industry AVG Increase or Decrease on previous year 2012 Industry AVG Increase or Decrease on previous year 2013 Industry AVG Increase or Decrease on previous year Increase or Decrease on base year Base Year 2010 2011 Industry AVG Increase or Decrease on previous year 2012 Industry AVG Increase or Decrease on previous year 2013 Industry AVG Increase or Decrease on previous year Increase or Decrease on base yea
PRODUCTIVITY/ OPERATIONS FINANCIAL
Productivity per employee (pairs per annum) - 0 - 0 6,829 6,829 6,971 ERROR:#VALUE! 142 Sales $ 432,646.00 $ 454,976.00 $ 22,330 $ 729,894 $ 274,918 $ - -100%
Star rating - 0 - 0 5.00 5.00 5.00 Operating profit $ 40,000 $ 39,754 (246) $ 120,988.00 81,234 $ - 0 -100%
Reject Rate 11% 7% -5% 9% 2% 8% -33% EPS $ 2.00 $ 1.99 -1% $ 0.17 (2) $ - 0 -100%
Cost of Production per pair $ XXXXXXXXXX $ XXXXXXXXXX 1 $ XXXXXXXXXX (2) $ XXXXXXXXXX -5% Cash Balance $ - 0 $ - 0 $ - 0 $ - 0
Shares on Issue - 0 - 0 - 0 - 0
Bo
owing $ - 0 $ - 0 $ - 0 $ - 0
0 LEARNING AND DEVELOPMENT
Base Year 2010 2011 Industry AVG Increase or Decrease on previous year 2012 Industry AVG Increase or Decrease on previous year 2013 Industry AVG Increase or Decrease on previous year Increase or Decrease on base year Base Year 2010 2011 Industry AVG Increase or Decrease on previous year 2012 Industry AVG Increase or Decrease on previous year 2013 Industry AVG Increase or Decrease on previous year Increase or Decrease on base yea
Image rating 70 66 (4) 68 2 74 6 6% Training spend per employee $ - 0 $ - 0 $ - 0 $ 1,694.00 $ 1,694.00
Price per pair $ XXXXXXXXXX $ XXXXXXXXXX $ 1.00 $ XXXXXXXXXX -$ 4.00 $ XXXXXXXXXX 4% TQM spend per pair $ - 0 $ - 0 $ - 0 $ 0.94 $ 0.94
Market Share 8% 5% -3% 7% 2% 5% -40% Green Materials % 0% 0% 0% 0%
Retailer support Rebate $ 1.45 $ 1.41 (0) $ 1.64 0 $ 2.34 61% Incentive pay 6% 5% 1% 11% 6 14% 3 140%
Note areas that are shaded contain formulas DO NOT OVERWRITE THESE
You may add other key information to these
GRAPHS
MARKET SHARE / SHOE PRICE REJECT RATE / PRODUCTIVITY
Branded Shoes 2010 2011 2012 2015 2010 2011 2012 2015
Price per pair $ XXXXXXXXXX $ XXXXXXXXXX $ XXXXXXXXXX $ XXXXXXXXXX reject rate % 11% 0% 9% 8%
Market Share 8.3% 5.2% 5.0% 3.1% Productivity - 0 - 0 6,829.00 6,925.00
SALES REVENUE/PROFIT
2010 2011 2012 2015
Sales $ 432,646 $ 454,976 $ 228,232 $ 278,122
net profit % 9.2% 8.7% 16.6% 13.0%
NOTE YOU CAN ADD MORE GRAPHS HERE AND CHANGE THE FORMATTING
Price per pair 2010 2011 2012 2015 22.94 23.55 24.88 21.33 Market Share 2010 2011 2012 2015 8.3000000000000004E-2 5.1999999999999998E-2 0.05 3.1E-2
reject rate % 2010 2011 2012 2015 0.114 0 8.5000000000000006E-2 7.5999999999999998E-2 Productivity 2010 2011 2012 2015 0 0 6829 6925
Sales 2010 2011 2012 2015 432646 454976 228232 278122 net profit % 2010 2011 2012 2015 9.2454339113270431E-2 8.7376037417358277E-2 XXXXXXXXXX 0.13
22/06/2020 BSG Decisions & Reports
https:
www.bsg-online.com/users/sim/co
financials 1/7
All Sports Shoes Co.
(Industry 50)
FACILITIES Â AND Â EQUIPMENT Year 12
FACILITY Â SPACE
Facility Space Available in Year 11 (000s of pairs)
Completion of New/Additional Space (construction initiated in Y11)
Facility Space Available (to house construction equipment in Y12)
North America
5,000 pairs
0
5,000 pairs
Europe-Africa
0 pairs
0
0 pairs
Asia-Pacific
6,000 pairs
0
6,000 pairs
Latin America
0 pairs
5,000
5,000 pairs
Total
(all facilities)
11,000 pairs
5,000
16,000 pairs
Beginning Gross Investment in Facility Space ($000s)
+ Investment in Additional Facility Space (initiated in Y11)
+ Capital Cost for Improved Working Conditions (CSRC)
Gross Investment in Facility Space ($000s)
– Accumulated Depreciation (through Year 11)
– Cu
ent Year 12 Depreciation (2.5% of gross investment)
Net Investment in Facility Space ($000s)
$ 96,000
0
0
96,000
21,900
2,400
$ 71,700
$ 0
0
0
0
0
0
$ 0
$ 114,000
0
0
114,000
15,200
2,850
$ 95,950
$ 0
80,000
0
80,000
0
2,000
$ 78,000
$ 210,000
80,000
0
290,000
37,100
7,250
$ 245,650
Construction Work-In-Progress (new space to be available in Y13)
Capital Cost of Construction Work-In-Progress ($000s)
0 pairs
$ 0
0 pairs
$ 0
0 pairs
$ 0
0 pairs
$ 0
0 pairs
$ 0
FOOTWEAR Â PRODUCTION Â EQUIPMENT
Purchase of Additional Equipment
(at the beginning of Year 12)
New
Refu
ished
Production Equipment In-Place in Y11 (000s of pairs without OT)
Equipment Sold (at the beginning of Year 12)
Production Equipment Available in Y12 (000s of pairs w/o OT)
Percentage of New vs. Refu
ished Equipment in Y12
North America
4,000 pairs
0
0
0
4,000 pairs
100.0% 0.0%
Europe-Africa
0 pairs
0
0
0
0 pairs
0.0% 0.0%
Asia-Pacific
6,000 pairs
0
0
0
6,000 pairs
33.0% 67.0%
Latin America
0 pairs
3,000
0
0
3,000 pairs
100.0% 0.0%
Total
(all facilities)
10,000 pairs
3,000
0
0
13,000 pairs
69.0% 31.0%
Beginning Gross Investment in Equipment (000s)
+ Capital Cost of New Equipment (purchased in Year 12)
+ Capital Cost of Refu
ished Equipment (purchased in Y12)
+ Capital Cost of Production Improvement Options
+ Capital Cost of Energy Efficiency Initiatives
– Capital Cost of Equipment Sold
Gross Investment in Produciton Equipment
– Accumulated Depreciation (through Year 11)
– Cu
ent Year 12 Depreciation (10% of gross investment)
Net Investment in Produciton Equipment ($000s)
$ 80,000
0
0
0
0
0
80,000
56,000
8,000
$ 16,000
$ 0
0
0
0
0
0
0
0
0
$ 0
$ 97,600
0
0
15,000
0
0
112,600
32,800
11,260
$ 68,540
$ 0
60,000
0
0
0
0
60,000
0
6,000
$ 54,000
$ 177,600
60,000
0
15,000
0
0
252,600
88,800
25,260
$ 138,540
Production
Improvement
Options
New Option Ordered in Year 12
Capital Cost of Option Ordered ($000s)
Options in Place (ordered in prior year)
$ 0
none
none
$ 0
none
none
$ 0
none
A
$ 0
none
none
Â
Â
Â
Company Operating Reports Copyright © GLO-BUS Software, Inc. Printed 22-Jun-20 at 9:07 pm — Page 1
22/06/2020 BSG Decisions & Reports
https:
www.bsg-online.com/users/sim/co
financials 2/7
All Sports Shoes Co.
(Industry 50)
PRODUCTION Â AND Â WORKFORCE Year 12
PRODUCTION Â STATISTICS
Footwea
Production
(000s of pairs)
Regular-Time Pairs
Overtime Pairs
Rejected Pairs
Net Footwear Production
S/Q Rating of Pairs Produced
Number of Models Produced
North America
Branded
4,000
0
–336
3,664
5.8★
400
P-Label
0
0
–0
0
4.7★
100
Europe-Africa
Branded
0
0
–0
0
0.0★
0
P-Label
0
0
–0
0
0.0★
0
Asia-Pacific
Branded
6,000
0
–312
5,688
6.1★
450
P-Label
0
0
–0
0
4.6★
100
Latin America
Branded
3,000
600
–252
3,348
6.6★
400
P-Label
0
0
–0
0
3.0★
100
Total
(all facilities)
Branded
13,000
600
–900
12,700
Â
Â
P-Label
0
0
–0
0
Â
Â
Cost of Rejected Pairs $ Thousands
$ Per Pai
Reject Rate (% of regular + overtime pairs)
Branded
8.4%
9,490
2.59
P-Label
5.6%
0
0.00
Branded
0.0%
0
0.00
P-Label
0.0%
0
0.00
Branded
5.2%
7,508
1.32
P-Label
3.3%
0
0.00
Branded
7.0%
6,294
1.88
P-Label
4.2%
0
0.00
Branded
6.6%
23,292
1.81
P-Label
0.0%
0
0.00
Production Capability (000s of pairs without OT)
Total Production (including rejected pairs)
Utilization of Production Capability (max = 120%)
4,000 pairs
4,000 pairs
100%
0 pairs
0 pairs
0%
6,000 pairs
6,000 pairs
100%
3,000 pairs
3,600 pairs
120%
13,000 pairs
13,600 pairs
105%
WORKFORCE Â STATISTICS
Workforce
Compensation
(in Year 12)
Base Wages
Incentive Pay
Fringe Benefits
Total Regular Comp.
Overtime Pay
Total Compensation
Best Practices Training Expenditures (in Y12)
Supervisory Compensation (salary + benefits)
North America
Annual
$ pe
Worke
34,683
3,376
3,007
41,066
0
41,066
800
60,600
Total
Cost
($000s)
28,232
2,748
2,448
33,428
0
33,428
651
2,485
Europe-Africa
Annual
$ pe
Worke
0
0
0
0
0
0
0
0
Total
Cost
($000s)
0
0
0
0
0
0
0
0
Asia-Pacific
Annual
$ pe
Worke
12,241
2,526
1,536
16,303
0
16,303
600
25,250
Total
Cost
($000s)
20,675
4,266
2,594
27,535
0
27,535
1,013
1,061
Latin America
Annual
$ pe
Worke
12,120
1,750
1,500
15,370
3,986
19,356
600
25,250
Total
Cost
($000s)
9,660
1,395
1,196
12,251
3,177
15,428
478
1,010
Total
(all facilities)
Total
Cost
($000s)
58,567
8,409
6,238
73,214
3,177
76,391
2,142
4,556
Incentive Pay as % of Regular Compensation
Cumulative Best Practices (total $ per worker)
8.2%
2,200
0.0%
0
15.5%
1,600
11.4%
600
Â
Â
Workforce Productivity (pairs per worker per year)
Number of Workers Employed
Number of Supervisors Employed
Year 11
5,045
793
32
Year 12
4,912
814
41
Year 11
0
0
0
Year 12
0
0
0
Year 11
3,607
1,663
33
Year 12
3,552
1,689
42
Year 11
0
0
0
Year 12
3,764
797
40
Year 11
Â
2,456
65
Year 12
Â
3,300
123
BRANDED Â PRODUCTION Â COSTS
This section lists
costs for
anded
production only.
Private-Label pro-
duction costs are
listed separately in
the Private-Label
Operations report.
Materials Costs
Production Labo
Best Practices Training
Supervisory Costs
Enhanced Styling/Features