Great Deal! Get Instant $10 FREE in Account on First Order + 10% Cashback on Every Order Order Now

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...

1 answer below »
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
Answered Same Day Jun 23, 2021

Solution

Yash answered on Jun 27 2021
140 Votes
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 pair        $22.550        $23.09        $27.38
         reject rate %        8.60%        8.20%        6.60%
         Productivity        115.00%        108.00%        105.00%
         % Superior materials
         no of models produced        600        650        1550
         TQM spend per pair        $1.04        $1.31        $2.85
         cost of Production LA        $0.00        $0.00        $26.86
         Inventory days        5.48        47        93
         Quality
    LEARNING & DEVELOPMENT    Training spend per employee
         TQM spend per pair        $1.04        $1.31        $2.85
         Green Materials %
         Incentive pay        $4,629.19        $3,277.67        $2,456.62
         Number of employees        1,992        2521.00        3423
    CUSTOMERS & MARKETING     Advertising Spend        $4.69        $5.34        $4.55
         Cele
ity Endorsement payments        $0.00        $0.00        $0.10
         Image rating        70.00    70.00    66.00    72.00    73.00
         Price per pai
         Market Share
         Retailer support Rebate        $1.90        $1.88        $1.67
    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...
SOLUTION.PDF

Answer To This Question Is Available To Download

Related Questions & Answers

More Questions »

Submit New Assignment

Copy and Paste Your Assignment Here