Related to Order No 60959. Please enter data on the spreadsheet using the information from the files sent for Order No 60959. This spreadsheet will be used to support the Management Report for Year 12.
Enter Data Here ALL SPORTS SHOES CO. COMPANY OVERALLBRANDED PRIVATE LABELINTERNET 201020112012201320142015201020112012201320142015201020112012201320142015201020112012201320142015 ActualTargetActualTargetActualTargetActualTargetActualTargetActualActualTargetActualTargetActualTargetActualTargetActualTargetActualActualTargetActualTargetActualTargetActualTargetActualTargetActualActualTargetActualTargetActualTargetActualTargetActualTargetActual OPERATIONS Cost of production per pair reject rate % Productivity % Superior materials no of models produced TQM spend per pair cost of Production LA Inventory days Quality LEARNING & DEVELOPMENTTraining spend per employee TQM spend per pair Green Materials % Incentive pay Number of employees CUSTOMERS & MARKETING Advertising Spend Celebrity Endorsement payments Image rating7070667273 Price per pair Market Share Retailer support Rebate FINANCEEarnings per Share221.9936.05 Revenue$432,646$454,976$729,894 Profit$ 40,000$39,754$120,988 Net profit percentage9%9%17% Return on equity2117.72240.3 Credit ratingB+B+B+B+B+ Current ratio Interest Coverage Cash Balance Borrowings shares on issue DASHBOARD BALANCED SCORECARD DASH BOARD COMPANYGood Quality Shoe Company Base Year 20102011Industry AVGIncrease or Decrease on previous year2012Industry AVGIncrease or Decrease on previous year2013Industry AVGIncrease or Decrease on previous yearIncrease or Decrease on base yearBase Year 20102011Industry AVGIncrease or Decrease on previous year2012Industry AVGIncrease or Decrease on previous year2013Industry AVGIncrease or Decrease on previous yearIncrease or Decrease on base year PRODUCTIVITY/ OPERATIONSFINANCIAL Productivity per employee (pairs per annum)- 0- 0 6,8296,8296,971ERROR:#VALUE!142 Sales$ 432,646.00$ 454,976.00$ 22,330$ 729,894$ 274,918$ - -100% Star rating- 0- 0 5.005.005.00 Operating profit$ 40,000$ 39,754(246)$ 120,988.0081,234$ - 0 -100% Reject Rate11%7%-5%9%2%8%-33%EPS$ 2.00$ 1.99-1%$ 0.17(2)$ - 0 -100% Cost of Production per pair$ 22.94$ 23.551$ 21.51(2)$ 21.83-5%Cash Balance$ - 0$ - 0 $ - 0 $ - 0 Shares on Issue- 0- 0 - 0 - 0 Borrowing$ - 0$ - 0 $ - 0 $ - 0 0LEARNING AND DEVELOPMENT Base Year 20102011Industry AVGIncrease or Decrease on previous year2012Industry AVGIncrease or Decrease on previous year2013Industry AVGIncrease or Decrease on previous yearIncrease or Decrease on base yearBase Year 20102011Industry AVGIncrease or Decrease on previous year2012Industry AVGIncrease or Decrease on previous year2013Industry AVGIncrease or Decrease on previous yearIncrease or Decrease on base year Image rating7066(4)6827466%Training spend per employee$ - 0$ - 0 $ - 0 $ 1,694.00$ 1,694.00 Price per pair$ 48.00$ 49.00$ 1.00$ 45.00-$ 4.00$ 50.004% TQM spend per pair$ - 0$ - 0 $ - 0 $ 0.94$ 0.94 Market Share8%5%-3%7%2%5%-40% Green Materials %0%0% 0% 0% Retailer support Rebate$ 1.45$ 1.41(0)$ 1.640$ 2.3461% Incentive pay6%5%1%11%614%3140% Note areas that are shaded contain formulas DO NOT OVERWRITE THESE You may add other key information to these GRAPHS MARKET SHARE / SHOE PRICEREJECT RATE / PRODUCTIVITY Branded Shoes20102011201220152010201120122015 Price per pair$ 22.94$ 23.55$ 24.88$ 21.33 reject rate %11%0%9%8% Market Share8.3%5.2%5.0%3.1% Productivity- 0- 06,829.006,925.00 SALES REVENUE/PROFIT 2010201120122015 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 pair201020112012201522.9423.5524.8821.33 Market Share20102011201220158.3000000000000004E-25.1999999999999998E-20.053.1E-2 reject rate %20102011201220150.11408.5000000000000006E-27.5999999999999998E-2 Productivity20102011201220150068296925 Sales 2010201120122015432646454976228232278122net profit %20102011201220159.2454339113270431E-28.7376037417358277E-20.165761055714939430.13 22/06/2020 BSG Decisions & Reports https://www.bsg-online.com/users/sim/cor/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) – Current 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 Refurbished 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. Refurbished 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 Refurbished 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) – Current 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/cor/financials 2/7 All Sports Shoes Co. (Industry 50) PRODUCTION AND WORKFORCE Year 12 PRODUCTION STATISTICS Footwear 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 Pair 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 $ per Worker 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 $ per Worker 0 0 0 0 0 0 0 0 Total Cost ($000s) 0 0 0 0 0 0 0 0 Asia-Pacific Annual $ per Worker 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 $ per Worker 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 branded production only. Private-Label pro- duction costs are listed separately in the Private-Label Operations report. Materials Costs Production Labor Best Practices Training Supervisory Costs Enhanced Styling/Features