Answer To: SAME EXPERT please as Order No 61715 as he knows already on how to do this. Required to write and...
Harshit answered on Jul 18 2021
Table of Contents
EXECUTIVE SUMMARY……………………………………………………………………………………………………….3
OVERALL STRATEGY……………………………………………………………………………………………………..3
COMPANY’S PRIMARY TACTICS………………………………………………………………………………......3
KEY OUTCOMES……………………………………………………………………………………………………………5
STOCK PRICE…………………………………………………………………………………………………………………6
FORWARD STRATEGIES…………………………………………………………………………………………………6
MAIN REPORT……………………………………………………………………………………………………………………..7
FINANCIAL PERFORMANCE…………………………………………………………………………………………..7
SUMMARY OF KEY PERFORMANCE INDICATORS…………………………………………………….7
FINANCIAL RESULTS……………………………………………………………………………………………….8
FINANCIAL DATA ANALYSIS…………………………………………………………………………………….8
LIQUIDITY AND OTHER RATIOS……………………………………………………………………………….9
CASH POSITION…………………………………………………………………………………………………….11
OPERATIONS……………………………………………………………………………………………………………….11
STOCK LEVEL…………………………………………………………………………………………………………11
PLANT CAPACITY AND PRODUCTION LEVEL…………………………………………………………..12
PLANT UPGRADE…………………………………………………………………………………………………..14
CUSTOMER MARKETING……………………………………………………………………………………………..15
SALES PER SEGMENT…………………………………………………………………………………………….15
BRANDED SALES PER REGION IN DOLLARS……….…………………………………………………..15
INTERNET SALES PER REGION IN DOLLARS……………………………………………………………16
PRICING………………………………………………………………………………………………………………..16
ADVERTISING SPEND…………………………………………………………………………………………….17
RESOURCES/LEARNING……………………………………………………………………………………………….18
OVERALL SUMMARY…………………………………………………………………………………………….18
EMPLOYEES PRODUCTIVITY VS INDUSTRY AVERAGE…………………………………………….19
CONCLUSION AND SWOT ANALYSIS………………………………………………………………………………….19
STRATEGIES FOR NEXT DECISION ROUNDS………………………………..……………………………………..20
1. EXECUTIVE SUMMARY
1. OVERALL STRATEGY:
All Sports Shoes Company is proud to announce its successfulachievement all its targets in Year 15. The company has consistently focused on each region separately and customized marketing tactics depending on each marketing demand. The management has employed a more value for the money strategy also in Year 15 and dedicated all its resources to produce premium quality shoes that satisfy every taste.
The company has embarked a strategy of doubling its investment in advertising and increasing the bids of the celebrities’ contracts in Year 14 that paid off this year. This tactic led to an outstanding increase its image, revenue and distribution.
The company has improved yearly multiplying its styling and quality rating from 4 stars \ in Year 10 to 7.8 in Year 15.
All Sports Shoes Co. has utilized its profit yearly to in improve its equipment to minimize its reject rate and enhanced its styling and quality.
PREMIUM SHOES FOR EVERY TASTE is the company promise to all customers.
1. COMPANY’S PRIME TACTICS Year 15:
All Sports Shoes Co. had a vision since the beginning to deliver an affordable end product that is made out of the finest materials in the market with varieties of models that satisfy all tastes, ages, genders and sports. In order to achieve the same, the management had continuously tried to reduce its production cost to be able to deliver its promise and in Year 15, the company is proud to announce that this goal has been achieved.
The company’s reputation and awareness was on the company’s focused list where it dedicated all its resources to reach all consumers and become the market leader in the industry. In Year 15, the company has been the leader in its product’s demand, where its shoes has been listed the most in Europe Africa and Latin America retail outlets.
By monitoring the market changes and its rivals’ competition, the following Scorecard has been put up in place to monitor and measure its performance towards achieving its strategic targets:
The company has improved its profitability in Year 15 by 12% compared to Year 14 and became a 1 BILLION SALES COMPANY: understanding the need of expending globally, lots of efforts has been dedicated to improve the company’s sales online in Year 14 and 15 where 2’438’000 shoes has been sold in Year 15, recording its highest sales in North America.
Focusing on customer satisfaction, the management continued its investment in retail support, where $ 63 Million has been budgeted to support customers in all the regions. The management has improved all deliveries from the previous year by allocating additional $ 3 Million to make sure everyone receives their orders on time, including the internet sales.
This year, the company continued its high investments in marketing activities, where the company allocated additional $ 50 Million to support its advertising and marketing campaigns after its successful impact in increasing revenue and company’s awareness. The company’s distribution goal in Year 14 was set to reach 5’000 stores in the four regions by Year 15 but the results were extraordinary and beyond expectation: the company is present this year in 10’627 stores across its distribution territory.
The company has invested this year as well in improving the workplace conditions and it is committed every year to create an enjoyable workplace and optimize employees’ productivity. In Year 15, productivity in Asia Pacific has increased 44.3% versus Year 14 and in Latin America 35.9% respectively. The North America plant’s production was suspended in Year 15 due to equipment upgrades; however, the company has offered generous remunerations for its employees to compensate this event and looking forward to resuming its operations in Year 16.
1. KEY OUTCOMES:
Below is a quick overview of the company’s key achievements and opportunities for Year 15:
+111.73% Net Revenue growth compared to Year 14
+11.4% Improvement of the styling/quality rating
+77.5% growth of the Earning Per Share’s expectation of the shareholders versus Year 14
+ 10.5% improvement of image rating
+122% wider distribution of retail outlets compared to Year 14
+64.4% growth of the Return on Equity versus investors’ expectation
1. STOCK PRICE:
This year, the company’s prospect became rosier; its stock price has doubled since Year 14 “$163.25 per share” and has increased enormously its value in the market scoring third place among the highest stock value companies in the industry.
1. FORWARD STRATEGIES:
The management will continue prioritising its market leader strategy, focusing on reaching the biggest number of consumers in each region. It will also monitor closely its performance versus its rivals in each market, and optimize its advertising and marketing activities to improve constantly the image of All Sports Shoes. The styling and quality will continue to improve to achieve the company’s goal and deliver affordable premium quality products.
2. MAIN REPORT
1. FINANCIAL PERFORMANCE
1. SUMMARY OF KEY PERFOMANCE INDICATORS:
The company has decided in Year 15 to lower slightly its prices and improved its styling and quality to offer a better value for money for the consumers. This led to an increase in Net sales especially in Asia Pacific where the region recorded +29.6% compared to the previous year.
The management has allocated high budgets for investments and operations spend in Year 14 and 15 which finally paid off this year, recording +88.4% ROE growth versus last year.
The company is expected to record higher results in Year 16.
1. FINANCIAL RESULTS:
The EPS’ (Earning per Share) target has exceeded the investors’ expectation, achieving +77.5 % compared to the last year performance. The company didn’t have any new borrowings in Year 15 and relied on its profits to finance its operational activities.
1. FINANCIAL DATA ANALYSIS:
· The net revenue of the company has increased in the year 15 when compared to year 14 but the increase has not been at the same rate. The net revenue of the company increased by 16.5% in year 14 when compared to year 13 but the same was at 11.7% when compared to year 14 and 15. But the growth has been better than other year. This happened as the rating in the styling of the company has improved.
· Due to the aggressive marketing strategies, the demand for the shoes of the company has increased and the company became the leader in the demand of shoes in the market. The company has been constantly focusing on the decrease in the cost of production of the company which was achieved in the year 15. Due to the decrease in the cost of production, the profit of the company improved and was restored at the 14% net profit rate which was 9% in the year 14.
· The company rating in the year 14 was A- which improved in that particular year but the same again fell to B+ which was the previous rating of the company. Although the rating of the company has fallen but the company image is now at 84% which was 76% in the previous year. The stock price of the company is the proof the same as the same has increased by more than 100% and is at $163.25 which is the highest when compared with year 10 to year 14. This shows that the company is a trustworthy and financially strong company and has a positive stability in the eyes of the investors.
· The ROE of the company has increased by almost twice of what it was in the year 14. In the year 14 the Return on Equity was at 21.8% which increased to 41.1% in the year 15 as the net profit of the company has increased a lot due to reduction in the cost of production of the company. The company has been focusing on the marketing strategies which have increased the sales and with new goals of cost reduction; the company was able to increase its net profit.
· The total assets of the company in the year 15 were at 747,148 which were comprised of 351,242 with the current assets and the remaining was investment in the equipment and facilities. The current assets of the company have been constantly increasing and the same trend of increase was followed in this year as well.
1. LIQUIDITY & OTHER RATIOS:
Liquidity Ratio: This ratio includes the current ratio the formula for which is
Current ratio / Current Liabilities
Current ratio means the ability of the company to pay off its short term liability of 1 year using the current assets. This ratio measures the company’s ability to pay off its short term liabilities using the liquid assets.
ALL SPORTS SHOES CO. $ '000
YEAR 12
YEAR 13
YEAR 14
YEAR 15
Current Assets
2,44,615
2,90,341
2,95,452
3,51,242
Current Liabilities
1,04,663
61,819
88,792
73,282
Current Ratio
2.34
4.70
3.33
4.79
The current assets of the company decreased at a higher rate in the year 14 but the same improved in the year 15 again. The current ratio of the company has improved and is the best in the past 4 years. The current ratio of the company has improved which reflects that the liquidity position of the company has improved and therefore the company is performing well. The current ratio of the company has fallen in the year 14 but the same was improved in the year 15 as the cost was less and the profit.
Interest coverage ratio: This ratio reflects the profit of the company as earned by the company is how many times of the fixed interest expense as incurred by the company. This shows that how much the company earns of the interest expensed.
Earnings before interest and taxes / Interest expense
= 232473/ 25753
= 9.03
The interest coverage ratio of the company was improving till year 14 but the same decreased in the year 15. The interest coverage ratio was at 10.19 in the year 14 but the same was at 9.03 in the year 15.
Debt to assets Ratio: This ratio reflects the number of times the debt is of the assets of the company. The company is in a good position if this ratio is least. This shows that the company has more assets and fewer debts which will make the company less risky.
Long Term Debts/Total Assets
= 253000 / 747148
=0.3386
The debt to assets ratio of the company was at 0.4373 in the year 14 which has decreased to 0.3386 which is a good sign. This shows that the company’s assets have increased as the long term debts of the company was same in the year 14 and year 15.
Default risk ratio: This ratio reflects the effect of the repayments of the loans in the operating cash flows of the company. The company generates cash with its business operations during the year and the same is measured in terms of the principal payments of the long term loans of the company.
Cash flow from operations/Principal payments
= 174879/46471
= 3.76
The ratio is 3.76 for the year 15 which is not a good sign for the company which was at 5.16 in the year 14. At the ratio has decreased, this reflects that the default risk of the company has increased.
1. CASH POSITION:
In Year 15, All Sports Shoes Co. was able to maintain $ 61 Million cash on hand, being the second highest company compared to other rivals. The company has invested in improving its equipments and purchasing new ones for Latin America and repurchased 100 additional shares. The management didn’t pay any dividends this year but allocated its surplus to support its planned marketing activities.
1. OPERATIONS
0. STOCK LEVEL:
The management decided to suspend the production of its plant in North America for Year 15 only to renovate and upgrade the plant. This helped the company to reduce its excess of stock by 33% compared to Year 14, minimizing its days on inventory from 157 days to 88 days. The inventory clearance was reduced this year and generated $ 34 Million additional sales.
0. PLANT CAPACITY AND PRODUCTION LEVEL:
The average use of the plants’ capacity was 120% in Year 15 that matches the company’s strategy to maximize its capacity to reduce as much as possible its cost per pair. The temporary closure of North America has improved its stock cover and reduced the production cost per pair.
0. PLANT UPGRADE:
The company continued to invest in improving its plants’ equipment: in Latin-America, option C was purchased to improve the Style/Quality rating in Year 16 and become 9.2*. in Option B was installed in Asia Pacific to reduce production run setup costs by 50% in Year 16.
1. CUSTOMER MARKETING
1. SALES PER SEGMENT:
Asia-Pacific region scored the highest growth in Year 15, achieving +47.9% in its wholesales and +37.9% in its internet sales per pair. Internet segment continued its phenomenal growth, recording $ 229 Million in Year 15.
1. BRANDED UNIT SALES PER REGION:
the total sales of units has improved 19.2% compared to the previous year, with an outstanding growth of Asia Pacific region in particular.
1. INTERNET UNIT SALES PER REGION:
Asia Pacific region has also ranked first in the internet sales this year with a growth of 37.9% versus last year. The total online sales has increased by 17.9% compared to Year 14.
1. PRICING:
This year, All Sports Shoes Co. has reduced slightly the prices of it improved styling shoes, made from 90% superior materials, to guarantee an affordable premium quality shoes in the market. The company has improved 10.37% its TQM per pair, its enhanced feature styling by 17.6% and reduced its production run set up by 16.2%.
The total production cost has been reduced by 1.5% after all these improvements and enhancements.
1. ADVERTISING SPEND:
The advertising spend per pair has been significantly increased in Year 14 in all plants and reduced to an average of $ 6.25 per pair in Year 15. The management decided this year to spend more on retail support which led to over achieving the company’s set targets.
D) RESOURCES/LEARNING
1. OVERAL SUMMARY:
The productivity per employee continued to grow in Asia Pacific and Latin America plants. The management is determined to offer a friendly and efficient workplace and is striving to optimize the productivity in each factory.
1. EMPLOYEE’S PRODUCTIVITY vs INDUSTRY AVERAGE:
Even though the productivity has been improved in Year 14 and 15 the company’s performance is still within the average compared to the industry in general. The company has invested this year as well in improving the ventilation systems, lighting and safety so the employees are all safe and comfortable in the workplace.
3. CONCLUSION AND SWOT ANALYSIS
STRENGTHS
The company focused on the decrease in the level of cost of production of shoes which it was able to achieve which has become the strength of the company. Due to the aggressive marketing strategies used in the year 14 contributed with an increase in the revenue of the company and therefore the company targeted to decreased its cost of production which the company was able to achieve and therefore the company will be able to reduce it further and therefore the profit margin of the company has improved a lot from the previous year. Using the economies of the scale, the company will be able to decrease the cost of production further in the future years.
WEAKNESSES
The company has allocated huge amount of investment in the advertisement and the same has a huge impact on the income earning capacity of the company. The company should focus on the internet and digital marketing and find out ways to reduce the marketing cost. The credit rating of the company has also decreased which may impact adversely to the company financial performance in the eyes of the stakeholders.
OPPORTUNITIES
The company has no private label of its own and the company can focus on launching its own private label which will give the company a boost if the label improves. The company has been working under the brand name of other companies which the company can have and focus on building a private label of its own which will create a brand for itself. The image of the company has also improved and the stock price of the company has also improved therefore the company will be able to build a brand for itself.
THREATS
The shoe industry involves huge players within the industry and therefore the company has to focus competitors which are the biggest threat of the company. The competition in this industry is very huge and therefore the company should focus on improving the market share in the company.
4. STRATEGIES FOR NEXT DECISION ROUNDS
The All Sports Company targeted to improve its sales in the year 14 which the company was able to achieve and in the year 15 the company’s focus was to decrease the cost of production which was continuously increasing, the company was also able to reduce its cost of production. The company now is on the correct trend of image building and the financials of the company has also improved. The company in its future years can focus a building of a private brand and not just work under the brand of other companies. The current aggressive marketing strategies could help the company to increase the brand name of the company and the image of the company has also improved to 84% in the year 15 which could be helpful for the company for building its own label. The company’s performance in the stock market has also improved. The motto of the company is to make shoes for all and the same can be achieved by the company in a better if the company launched its own label. Therefore the strategy for the company in the future years should be on to build a label of its own so that the organization mission and vision of making shoes for all the class of society could be achieved in a better way.
RETAIL OUTLETS 10'627
EBIT MARGIN 22.8%
GROSS REVENUE $M 1'020
IMAGE RATING 84
S/Q RATING 7.8*
RETURN ON EQUITY 41.1
STOCK LEVEL
NA
YEAR 13 YEAR 14 YEAR 15 981 1307 480 EA
YEAR 13 YEAR 14 YEAR 15 1660 1305 1097 AP
YEAR 13 YEAR 14 YEAR 15 1319 1648 1259 LA
YEAR 13 YEAR 14 YEAR 15 737 513 364
TOTAL PAIRS '000
TOTAL PRODUCTION
NA 4000
YEAR 13 YEAR 14 YEAR 15 4200 4800 0 EA YEAR 13 YEAR 14 YEAR 15 0 0 0 AP 6000
YEAR 13 YEAR 14 YEAR 15 6900 7200 7200 LA 3600
YEAR 13 YEAR 14 YEAR 15 4750 4800 6000
TOTAL PRODUCTION '000
SALES UNIT PER REGION
NA YEAR 13 YEAR 14 YEAR 15 2396 2682 3128 EA YEAR 13 YEAR 14 YEAR 15 2141 2283 2778 AP YEAR 13 YEAR 14 YEAR 15 1551 1864 2756 LA YEAR 13 YEAR 14 YEAR 15 1886 2200 2103 TOTAL YEAR 13 YEAR 14 YEAR 15 7974 9029 10765
BRANDED SALES '000 / REGION
TOTAL SALES '000 / REGION
INTERNET SALES
NA YEAR 13 YEAR 14 YEAR 15 449 609 699 EA YEAR 13 YEAR 14 YEAR 15 403 557 601 AP YEAR 13 YEAR 14 YEAR 15 330 414 571 LA YEAR 13 YEAR 14 YEAR 15 377 487 567 TOTAL YEAR 13 YEAR 14 YEAR 15 1559 2067 2438
SALES UNIT '000 / REGION
TOTAL SALES '000 / REGION
TOTAL ADVERSTISING AVERAGE
YEAR 10 YEAR 11 YEAR 12 YEAR 13 YEAR 14 YEAR 15 4.77216312056738 5.444413302156061 4.5425328038751971 4.9436353233519386 8.2702999491955449 6.249505894678828
TOTAL AVERAGE ADV SPEND / PAIR
YEAR 14 YEAR 15
ACTUALACTUAL
Net Revenue912,699 16.5%1,019,754 11.7%
Cost of goods500,515 22.1%471,243 -5.8%
Expenses282,467 38.8%316,038 11.9%
Net Profit81,894 -23.4%232,473 183.9%
Net Profit %9%-37.2%14.2%62.6%
ROI69.7%-14.5%89.6%28.6%
ROE21.8 -15.5%41.1 88.5%
YOY %
ALL SPORTS
SHOES CO.
$ '000
YOY %
Company Performance
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 23 23.09 27.38 28.6 29.3 23 23.09 27.38 28.64 29.26 25.04 24.09
reject rate % 8.6% 8.20% 6.6% 7.0% 5.5% 8.6% 8.20% 6.6% 7% 5.5% 8.5% 2.7%
Net Production 8,371 9,919 12,700 14,765 15,869 7,571 9,919 12,700 14,230 15,869 800 535
% Superior materials 32% 34% 50% 62% 70% 32% 34% 50% 62% 70%
no of models produced 200 250 450 500 500 200 250 450 500 500 100 100
TQM spend per pair 1.04 1.31 2.85 2.71 3.28 1.04 1.31 2.85 2.71 3.28 1.04 2.57
Quality 4 4.2 5.8 6.3 7 4 4.2
tc={AE7C235B-6064-4CDD-BA78-FFB11D6FB33A}: [Threaded comment]
Your version of Excel allows you to read this threaded comment; however, any edits to it will get removed if the file is opened in a newer version of Excel. Learn more: https://go.microsoft.com/fwlink/?linkid=870924
Comment:
lowest amongst 4 regions 5.8 6.3 7.0 3 5
LEARNING & DEVELOPMENT Training spend $848 $1,632 2,142 3,001 3,431 $848 $1,632 2,142 3,001 3,431
TQM spend per pair 1.04 1.31 2.85 2.71 3.28 1.04 1.31 2.85 2.71 3.28
Incentive pay 5,518 8,263 8,409 15,261 13,976 5,518 8,263 8,409 15,261 13,976
Number of employees 1,943 2,456 3,300 3,546 3,431 1,943 2,456 3,300 3,546 3,431
CUSTOMERS & MARKETING Advertising Spend 52,000 62,840 64,000 63,250 108,750 29,323 38,215 37,030 38,868 74,045 22,677 24625 26,970 24,382 34,705
Celebrity Endorsement payments 0 0 1,000 1001 1000 0 0 842 837 814 0 0 158 164 186
Image rating 70 70 66 72 73 72 76 70 70 66 72 73 72 76 70 72 70 70 66 72 73 72 76
Price per pair 50.38 50.78 59.59 63.41 66.55 34.5 34
tc={93F615B1-CC2A-4E81-94E0-B29E3163DB91}: [Threaded comment]
Your version of Excel allows you to read this threaded comment; however, any edits to it will get removed if the file is opened in a newer version of Excel. Learn more: https://go.microsoft.com/fwlink/?linkid=870924
Comment:
Exclusive of RX adjustments 69.38
tc={6F012644-4C36-440D-B2F5-6320BDBF9810}: [Threaded comment]
Your version of Excel allows you to read this threaded comment; however, any edits to it will get removed if the file is opened in a newer version of Excel. Learn more: https://go.microsoft.com/fwlink/?linkid=870924
Comment:
Excluding RX Adj 72.09 84.08 88.77 93.8
Market Share 8.3% 8.7% 9.4% 8.60% 9.00% 8.30% 7% 8.60% 7.60% 8.60%
Retailer support Rebate 11,850 13,450 13,584 18,227 28,514 11,850 13,450 13,584 18227 28514
Sales $ 432,646 454,278 450,826 495,909 694,141 728,848 769,401 807,871 937,952 314731 363365 546275 602171 744068 27600 18,190 90315 87,461 147,866 149,040 193,884
Sales units (000s) 8,150 8,558 8,238 9,062 9,665 10,148 10,068 10,571 11,096 6247 7155 8134 7974 9029 800 535 1103 1,083 1,531 1,559 2,067
FINANCE Earnings per Share 2 2 1.99 3 6.05 3.5 5.35 4 4.36
Net Revenues
tc={681E0A37-1F3C-470B-997E-E89C13220375}: [Threaded comment]
Your version of Excel allows you to read this threaded comment; however, any edits to it will get removed if the file is opened in a newer version of Excel. Learn more: https://go.microsoft.com/fwlink/?linkid=870924
Comment:
Income Statement
tc={AE7C235B-6064-4CDD-BA78-FFB11D6FB33A}: [Threaded comment]
Your version of Excel allows you to read this threaded comment; however, any edits to it will get removed if the file is opened in a newer version of Excel. Learn more: https://go.microsoft.com/fwlink/?linkid=870924
Comment:
lowest amongst 4 regions
tc={93F615B1-CC2A-4E81-94E0-B29E3163DB91}: [Threaded comment]
Your version of Excel allows you to read this threaded comment; however, any edits to it will get removed if the file is opened in a newer version of Excel. Learn more: https://go.microsoft.com/fwlink/?linkid=870924
Comment:
Exclusive of RX adjustments 432,646 454,278 454,976 500,474 729,894 766,389 783,757 822,945 912,699
Profit 40,000 42,000 39,754 43,729 120,988 127,037 106,962 112,310 81,894
Net profit percentage 9.2% 8.7% 9% 16.6% 17% 13.6% 14% 9.0%
Return on equity 20 21 17.7 22 40.3 23 25.8 24 21.8
Credit rating B B+ B+ B+ B+ B+ B+ A- A-
Current ratio 2.77 1.92 2.34 4.7 3.33
Interest Coverage 6.62 7.52 10.1 9.75 10.19
Cash Balance 6,074 0 24,184 8,414 - 0
Borrowings 132,488 261,856 268,063 202,319 378,292
New Shares on Issue 0 0 0 0 0
BALANCED SCOREBOARD
METRIC YEAR 13 % vs TARGET YEAR 14 % vs TARGET YEAR 15 % vs TARGET
TARGET ACHIEVEMENT TARGET ACHIEVEMENT TARGET ACHIEVEMENT
FINANCIAL
MAINTAIN PROFITABILITY $ 766,388,700 $ 783,757,000 2.3% $ 822,944,850 $ 912,699,000 10.9% $ 1,000,000,000 $ 1,019,754,000 2.0%
INCREASE EARNING PER SHARE 3.5 5.35 52.9% 4 4.36 9.0% 4.5 7.74 72.0%
CUSTOMER
INCREASE RETAIL SUPPORT $ 18,000,000 $ 18,227,000 ACHIEVED $ 27,800,000 $ 28,514,000 ACHIEVED $ 60,000,000 $ 63,169,000 ACHIEVED
ON TIME DELIVERY $ 7,900,000 $ 8,559,000 ACHIEVED $ 13,000,000 $ 13,544,000 ACHIEVED $ 16,000,000 $ 16,148,000 ACHIEVED
INTERNAL PROCESS
PREMIUM QUALITY SHOES WITH LOW PRODUCTION COST $ 29.00 $ 28.64 ACHIEVED $ 28.75 $ 29.26 NOT ACHIEVED $ 29.00 $ 28.95 ACHIEVED
OPTIMIZE RETAIL DISTRIBUTION 4,000 4,423 11% 4,500 4,786 6% 5,000 10,627 113%
DOUBLE MARKETING ACTIVITIES - $ 111,285,000 - $ 200,000,000 $ 212,384,000 ACHIEVED $ 210,000,000 $ 212,055,000 ACHIEVED
IMPROVE S/Q STYLING 6* 6.3* ACHIEVED 7* 7* ACHIEVED 7.5* 7.6* ACHIEVED
LEARNING AND GROWTH
AMELIORATE PRODUCTIVITY PER EMPLOYEE $ 4,200,000 $ 4,108,000 NOT ACHIEVED $ 4,200,000 $ 4,309,000 ACHIEVED $ 4,000,000
Maia: Maia:
Comparing only AP & LA $ 4,058,500 ACHIEVED
INVEST IN TRAINING $ 3,000,000 $ 3,001,000 ACHIEVED $ 3,400,000 $ 3,431,000 ACHIEVED $ 2,650,000
Maia: Maia:
Comparing only AP & LA $ 2,724,000 ACHIEVED
CSR INITIATIVES - YR 13 ETHICS TRAINING -YR14 IMPROVED WORKING CONDITIONS - $ 400,000 ACHIEVED - $ 600,000 ACHIEVED $ 1,500,000 $ 1,500,000 ACHIEVED
Sheet1
EBIT MARGIN 22.80% (+95.59% vs YR 14) NET REVENUE 1'019'754 (+ 11.73% vs YR 14 ) NET PROFIT MARGIN 14.2 % (+57.78% vs YR 14) b g Industry
IMAGE RATING 84 (+10.5% vs YR14) RETAIL OUTLETS 10'627 (+122% vs YR14) S/Q RATING 7.8* (+11.4% vs YR14) 7204 11241 6401
MARKETING SUPPORT $212'055'000 AVERAGE PRODUCTIVITY $4'058'500 EARNING / SHARE $7.74 (+72% vs Investor expectation)
212055
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 2014 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 2014 Industry AVG Increase or Decrease on previous year Increase or Decrease on base year
PRODUCTIVITY/ OPERATIONS FINANCIAL
Productivity per employee (pairs per annum) 4 4 (0) 4 (0) 4 0 5 0 7% Sales $ 432,646.00 $ 454,976.00 $ 22,330 $ 729,894 $ 274,918 $ 783,757 $ 53,863 $ 912,699 $ 128,942 111%
Star rating 4.00 4.20 0.20 5.80 1.60 6.30 0.50 7.00 0.70 75% Operating profit $ 40,000 $ 39,754 (246) $ 120,988.00 81,234 $ 106,962.00 (14,026) $ 81,894.00 (25,068) 105%
Reject Rate 9% 8% -0% 7% -2% 7% 0% 6% -2% -36% EPS $ 2.00 $ 1.99 -1% $ 6.05 4 $ 5.35 (1) $ 4.36 (1) 118%
Cost of Production per pair $ 22.55 $ 23.09 1 $ 27.38 4 $ 28.64 1 $ 29.26 1 30% Cash Balance $ 6,074.00 $ - 0 $ 24,184.00 24,184 $ 8,414.00 (15,770) $ - 0 -100%
Shares on Issue - 0 - 0 - 0 - 0 - 0
Borrowing $ 132,488.00 $ 261,856.00 129,368 $ 268,063.00 6,207 $ 202,319.00 (65,744) $ 378,292.00 175,973 186%
CUSTOMERS AND MARKETING 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 2014 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 2014 Industry AVG Increase or Decrease on previous year Increase or Decrease on base year
Image rating 70 66 (4) 73 7 72 (1) 76 4 9% Training spend per employee $ 848.00 $ 1,632.00 $ 784.00 $ 2,142.00 $ 510.00 $ 3,001.00 $ 859.00 $ 3,431.00 $ 430.00 305%
Price per pair (Wholesale) $ 50.38 $ 50.78 $ 0.40 $ 59.59 $ 8.81 $ 63.41 $ 3.82 $ 66.55 $ 3.14 32% TQM spend per pair $ 1.04 $ 1.31 $ 0.27 $ 2.85 $ 1.54 $ 2.71 -$ 0.14 $ 3.28 $ 0.57 215%
Market Share (Wholesale) 8% 9% 0% 9% 1% 9% -1% 9% 0% 8% Green Materials %
Retailer support Rebate $ 11,850.00 $ 13,450.00 1,600 $ 13,584.00 134 $ 18,227.00 4,643 $ 28,514.00 10,287 141% Incentive pay 5,518.00 8,263.00 2,745.00 8,409.00 146 15,261.00 6,852 13,976.00 (1,285) 153%
Sales (in '000 Dollars) $ 432,646.00 $ 450,826.00 18,180 $ 677,916.00 227,090 $ 769,401.00 91,485 $ 937,952.00 168,551 117%
`
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 / SHOES PRODUCED
Branded Shoes YEAR 10 YEAR 11 YEAR 12 YEAR 13 YEAR 14 YEAR 10 YEAR 11 YEAR 12 YEAR 13 YEAR 14
Price per pair $ 50.38 $ 50.78 $ 59.59 $ 63.41 $ 66.55 reject rate % 9% 8% 7% 7% 6%
Market Share 8.3% 8.7% 9.4% 8.6% 9.0% Net Production 8,371.00 9,919.00 12,700.00 14,765.00 15,869.00
SALES REVENUE/PROFIT
YEAR 10 YEAR 11 YEAR 12 YEAR 13 YEAR 14
Sales $ 432,646 $ 454,976 $ 729,894 $ 783,757 $ 912,699
net profit % 9.2% 8.7% 16.6% 13.6% 9%
BRANDED PRODUCTION NA
YEAR 12 YEAR 13 YEAR 14
pair/worker/year PRODUCTIVITY $ 4,076 $ 4,108 $ 4,309
$/pair produced PRODUCTION COST 27.38 28.64 29.26
YEAR 12 YEAR 13 YEAR 14
INTERNET PRICE 84 89 93.75
WHOLESALE PRICE 59.5 63.65 66.55
S/Q RATING 5.8 6.3 7
WHOLESALE MARKET SHARE
Price per pair YEAR 10 YEAR 11 YEAR 12 YEAR 13 YEAR 14 50.38 50.78 59.59 63.41 66.55 Market Share YEAR 10 YEAR 11 YEAR 12 YEAR 13 YEAR 14 8.3000000000000004E-2 8.6999999999999994E-2 9.4E-2 8.5999999999999993E-2 0.09
WHOLESALE PRICE/PAIR
MARKET SHARE
REJECT RATE AND PRODUCTION
reject rate % YEAR 10 YEAR 11 YEAR 12 YEAR 13 YEAR 14 8.5999999999999993E-2 8.2000000000000003E-2 6.6000000000000003E-2 7.0000000000000007E-2 5.5E-2 Net Production YEAR 10 YEAR 11 YEAR 12 YEAR 13 YEAR 14 8371 9919 12700 14765 15869
REJECT RATE
TOTAL PRODUCTION
SALES REVENUE & PROFIT
Sales YEAR 10 YEAR 11 YEAR 12 YEAR 13 YEAR 14 432646 454976 729894 783757 912699 net profit % YEAR 10 YEAR 11 YEAR 12 YEAR 13 YEAR 14 9.2454339113270431E-2 8.7376037417358277E-2 0.16576105571493943 0.13647342224694645 8.9727281392879804E-2
SALES REVENUE '000
NET PROFIT %
BRANDED PRODUCTION
PRODUCTIVITY YEAR 12 YEAR 13 YEAR 14 4076 4108.333333333333 4309.333333333333 PRODUCTION COST YEAR 12 YEAR 13 YEAR 14 27.38 28.64 29.26 PAIR/WORKER/YEAR $ '000
$/PAIR PRODUCED
PRICE AND S/Q RATING
INTERNET PRICE YEAR 12 YEAR 13 YEAR 14 84 89 93.75 WHOLESALE PRICE YEAR 12 YEAR 13 YEAR 14 59.5 63.65 66.55 S/Q RATING YEAR 12 YEAR 13 YEAR 14 5.8 6.3 7
PRICE $
S/Q RATING
North America
All Sports Shoes Co. North America
YEAR 10 YEAR 11 YEAR 12 YEAR 13 YEAR 14 YEAR 15
BRANDED P/L INTERNET BRANDED P/L INTERNET BRANDED P/L INTERNET BRANDED P/L INTERNET BRANDED P/L INTERNET BRANDED P/L INTERNET
OPERATIONS reject rate % 7.00% 6.90% 7.40% 7.30% 8.40% 5.60% 8.90% 4% 4% 2%
cost of Rejected pairs ($000) 6302 752 6964 0 9490 0 11669 6483 0
% Superior materials 31.00% 20.00% 39.00% 38.00% 62.00% 70.00%
Materials costs per pair $ 8.52 7.48 9.3 9.75 0 10.66 10.46
no of models produced 200 100 200 400 100 500 100 500 100
TQM spend per pair 1.08 1.08 1.3 0 2.73 2.63 2.61
Production costs per pair 23.98 26.93 25.46 0 30.87 34.24 33.57 0
COG sold per pair 24.98 26.42 32.2 35.24 34.57 38.09
Total Production (incl rej) 4463 4000 4000 4200 4800 0
Capacity utilization 112% 100% 100% 105% 120% 0
Completion of new/ add space (000s of pairs) 1000 0 0 0 0
Purchase of new equipment 0 0 0 0 0 0
Production improvement options 0 0 0 10000
Maia: Maia:
Option A 0 0
S/Q rating 4* 3* 4.2 0 5.8 4.7 6.3 5 7.1 5.3 7.8 5.3
End of Year Inventory (000s) 71 369 1156 981 1307 480
Inventory clearance ($000) 11989 36911 37661 0
operating profit margin 18.3% 22.5% 14.2% 18.9% 20.7% 27.8% 17.9% 27.2% 19.1% 25.6% 12.8% 26.0%
LEARNING & DEVELOPMENT Training expenditure 480 634 651 820 781 0
Employee's productivity 5000 5045 4912 4879 5123 0
Number of employees 800 793 814 820 781 0
Incentive pay % 11.20% 8.60% 8.20% 14.90% 13.10% 0.00%
Number of supervisors 20 32 41 41 39 0
CUSTOMERS & MARKETING Advertising Spend 8498 1502 10469 1531 10134 1866 10527 1973 20372 4628 15531 3469
Celebrity Endorsement payments 237 44 251 47 242 55 1658 371
Price per pair 48 32 67 48 35 69 60 42 84 61.55 36 86 66.55 34 94 66.25 93.75
Market Share 8.30% 8.30% 8.80% 6.80% 8.60% 7.80% 8.50% 7.30% 9.00% 8.50% 10.20% 8.80%
Retailer support 4000 5000 6180 6425 8738 18050
Sales $ 95856 6400 28064 108960 0 22908 149209 0 40627 184385 44227 216148 57246 207230 65531
Sales units (000s) 1997 200 353 2270 0 332 2287 0 421 2396 449 2682 609 3128 699
Search engine advertising 5000 5500 5500 5000 5250 5250
Total marketing expenses 16492 7652 20010 8181 21125 9360 20917 9370 35521 12283 43841 11440
RETAIL OUTLETS 1000 1000 1236 1285 1398 2888
Maia: Maia:
2nd highest in industry
Europe Africa
ALL SPORTS SHOES CO. Europe Africa
YEAR 10 YEAR 11 YEAR 12 YEAR 13 YEAR 14 YEAR 15
BRANDED P/L INTERNET BRANDED P/L INTERNET BRANDED P/L INTERNET BRANDED P/L INTERNET BRANDED P/L INTERNET BRANDED P/L INTERNET
OPERATIONS reject rate % 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00%
cost of Rejected pairs ($000) 0 0 0 0 0 0 0 0 0 0
% Superior materials 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00%
Materials costs per pair $ 0 0 0 0
no of models produced 200 100 246 0 500 0 500 500 500
TQM spend per pair 0 0 0 0 0 0.00% 0 0 0
Production costs per pair 0 0 0 0 0 0 0 0 0 0.00% 0 0
COG sold per pair 30.98 20.97 34.81 34.28 33.55 35.27
Total Production (incl rej) 0 0 0 0 0 0
Capacity utilization 0% 0% 0% 0
Completion of new/ add space (000s of pairs) 0 0 0 0
Purchase of new equipment 0 0 0 0
Production improvement options 0 0 0 0
S/Q rating 4 3 4.5 0 4.5 6.2 4.6 6.2 6.3 7.1 7.7
End of Year Inventory (000s) 60 657 641 1660 1305 1097
Inventory clearance ($000) 0 0 21473 23345 54922 12872
operating profit margin 13.3% 17.9% 14.1% 16.8% 19.5% 27.1% 16.5% 25.9% 21.0% 27.5% 17.9% 29.4%
LEARNING & DEVELOPMENT Training expenditure 0 0 0
Employee's productivity 0 0 0
Number of employees 0 0 0
Incentive pay % 0.00% 0.00% 0.00%
Number of supervisors 0 0 0
CUSTOMERS & MARKETING Advertising Spend 7650 1350 9919 1581 9639 1861 10099 1901 19294 4706 18086 3914
Celebrity Endorsement payments 234 45 225 42 206 50 1473 319
Price per pair 48 37 72 48 38 69 60 41 84 62.25 36 87 66.55 36 94 66.25 94
Market Share 8.30% 8.30% 8.50% 7.20% 9.70% 9.20% 8.70% 7.40% 8.70% 8.90% 10.00% 8.50%
Retailer support 4000 4250 3630 5733 7086 14868
Sales $ 90100 7400 25350 100700 26513 156702 42510 157648 40099 205469 52358 196483 56494
Sales units (000s) 1700 200 300 1900 0 303 2259 436 2141 403 2283 557 2778 601
Search engine advertising 4500 5500 5500 4250 4500 4500
Total marketing expenses 15050 7000 17969 8413 18021 0 9529 19376 8543 31837 11606 42067 11083
RETAIL OUTLETS 1000 1000 854 1349 1181 2478
Maia: Maia:
highest in industry
Asia Pacific
ALL SPORTS SHOES CO. Asia Pacific
YEAR 10 YEAR 11 YEAR 12 YEAR 13 YEAR 14 YEAR 15
BRANDED P/L INTERNET BRANDED P/L INTERNET BRANDED P/L INTERNET BRANDED P/L INTERNET BRANDED P/L INTERNET BRANDED P/L INTERNET
reject rate % 10.10% 10.00% 8.60% 8.00% 5.20% 3.30% 5.40% 3% 5.2% 2.7% 4.9% 2.4%
cost of Rejected pairs ($000) 8175 916 11560 0 7508 0 9007 9420 9586
% Superior materials 54.00% 20.00% 48.00% 60.00% 68.00% 70.00% 90.00%
Materials costs per pair $ 10.28 10.53 10.13 10.55 10.65 11.63
no of models produced 200 100 250 100 450 100 500 100 500 100 500 100
TQM spend per pair 1 1.31 2.95 2.75 3.27 3.79
Production costs per pair 21.15 21.68 25.44 25.54 26.5 28.6
COG sold per pair 26.44 26.54 27.51 29.05
Total Production (incl rej) 4693 6800 6000 6900 7200 7200
Capacity utilization 117% 113% 100% 115% 120% 120%
Completion of new/ add space (000s of pairs) 2000 0 0 0 0 0
Purchase of new equipment (000s of pairs) 0 2000 0 0 0 0
Production improvement options 1500
Maia: Maia:
Option A 0 0 9600
Maia: Maia:
Option B
Maia: Maia:
Option A S/Q rating 4 3 4.5 0 5.2 4.6 6.3 5 7 5.2 7.6
End of Year Inventory (Pairs) 45 481 831 1319 1648 1259
Inventory clearance ($000) 0 0 13271 20607 29371 12296
operating profit margin 21.9% 17.5% 21.9% 17.8% 29.2% 28.8% 29.9% 24.9% 26.6% 28.9% 25.3% 33.6%
LEARNING & DEVELOPMENT Training expenditure 457 998 1013 1369 1604 1536
Employee's productivity 3500 3607 3552 3506 3741 3907
Number of employees 1143 1663 1689 1711 1604 1536
Incentive pay % 10.40% 19.50% 15.50% 15.20% 15.30% 15.40%
Number of supervisors 29 33 42 43 46 44
CUSTOMERS & MARKETING Advertising Spend 6800 1200 8658 1342 8415 1585 8658 1842 17184 3816 16154 3914
Celebrity Endorsement payments 0 0 171 32 163 35 168 37 1461 303
Price per pair 48 32 67 49 30 70 58 40 83 65.05 37 91 66.55 37 93 66.25 93
Market Share 8.30% 8.30% 8.80% 7.20% 9.00% 8.10% 7.80% 7.40% 8.40% 7.80% 11.50% 9.30%
Retailer support 1925 2100 1977 2499 7107 13087
Sales $ 61200 6400 17888 73353 19140 109285 29796 122059 30030 152737 38502 194821 53103
Sales units (000s) 1275 225 1497 232 1657 312 1551 330 1864 414 2756 571
Search engine advertising 4000 4250 4500 3750 4000 4250
Total marketing expenses 11275 6350 13752 6938 13877 8267 16904 7977 29645 10203 40624 10249
RETAIL OUTLETS 700 700 659 769 971 2276
Maia: Maia:
2nd highest in industry
Latin America
ALL SPORTS SHOES CO. Latin America
YEAR 10 YEAR 11 YEAR 12 YEAR 13 YEAR 14 YEAR 15
BRANDED P/L INTERNET BRANDED P/L INTERNET BRANDED P/L INTERNET BRANDED P/L INTERNET BRANDED P/L INTERNET BRANDED P/L INTERNET
reject rate % 7.00% 4.20% 7.70% 3% 7% 3% 3.7% 1.3%
cost of Rejected pairs ($000) 6294 8452 353 9557 6182
% Superior materials 56.00% 64.00% 24.09% 70.00% 90.00%
Materials costs per pair $ 10.07 10.7 10.91 11.69
no of models produced 0 100 0 0 400 100 500 100 500 100 500 0
TQM spend per pair 2.8 2.71 3.35 3.43
Production costs per pair 26.86 28.33 29.03
COG sold per pair 27.86 29.33 30.03 29.84
Total Production (incl rej) 3600 4750 4800 6000
Capacity utilization 0% 0% 120% 119% 113% 120%
Completion of new/ add space (000s of pairs) 0 0 5000 0
Purchase of new equipment (000s of pairs) 0 0 3000 1000 250 750
Production improvement options 0 0 0 10625
Maia: Maia:
Option A 24000
Maia: Maia:
Option C
S/Q rating 3 6.6 6.5 5 7.2 5 8.1
End of Year Inventory (000s) 45 395 407 737 513 364
Inventory clearance ($000) 0 0 18231 16026 19359 11064
operating profit margin 9.1% 9.8% 6.1% 10.5% 41.8% 42.0% 37.9% 12.6% 36.8% 9.4% 15.2% 28.4% 41.3%
LEARNING & DEVELOPMENT Training expenditure 478 812 1046 1188
Employee's productivity 3764 3940 4064 4210 0.0359251969
Number of employees 797 1015 1046 1188
Incentive pay % 11.40% 28.40% 24.70% 21.40%
Number of supervisors 40 51 42 48
11313
CUSTOMERS & MARKETING Advertising Spend 6375 1125 9169 1331 8415 1658 9584 1916 17195 3805 15752 4248
Celebrity Endorsement payments 200 37 198 40 198 44 1115 301
Price per pair 53 37 72 54 35 75 60 42 84 65.75 34 92 66.55 35 94 66.35 94
Market Share 8.30% 8.30% 8.60% 0.00% 6.60% 10.20% 0.00% 9.30% 9.10% 8.20% 9.70% 9.00% 8.40% 9%
Retailer support 1925 2100 1797 3570 7107 17164
Sales $ 67575 7400 19013 80352 18900 131079 34933 138079 18190 34684 169714 45778 149015 53298
Sales units (000s) 1275 200 225 1488 216 1931 362 1886 535 377 2200 487 2103 567
Search engine advertising 4000 3500 4500 3750 4000 4250
Total marketing expenses 10850 6275 14245 6119 14701 8145 20142 8056 30550 10199 41602 11149
RETAIL OUTLETS 700 700 599 1020 1236 2985
Maia: Maia:
highest in industry
Maia: Maia:
Option A
OPERATION ANALYSIS
STOCK LEVEL
NA EA AP LA TOTAL OVER STOCK
YEAR 10 71 60 45 45 221 2.7%
YEAR 11 369 657 481 395 1902 23.1%
YEAR 12 1156 641 831 407 3035 31.4%
YEAR 13 981 1660 1319 737
YEAR 14 1307 1305 1648 513
YEAR 15 480 1097 1259 364
INVENTORY CLEARANCE 61549
8.9%
PRODUCTION LEVEL
NA EA AP LA
YEAR 10 4,463 - 0 4,693 - 0
YEAR 11 4,000 - 0 6,800 - 0
YEAR 12 4,000 - 0 6,000 3,600
YEAR 13 4200 - 0 6900 4750
YEAR 14 4800 - 0 7200 4800
YEAR 15 0 0 7200 6000
PRODUCTIVITY $ '000 NA AP LA
ALL SS IA ALL SS IA ALL SS IA
YEAR 11 5,045 AVERAGE 3,607 AVERAGE - 0 -
YEAR 12 4,912 AVERAGE 3,552 AVERAGE 3,764 LOW
YEAR 13 4,879 LOW 3,506 LOW 3,940 LOW
YEAR 14 5,123 AVERAGE 3,741 AVERAGE 4,064 AVERAGE
YEAR 15 - - 3,907 AVERAGE 4,210 AVERAGE
YOY 15 vs 14 4.4% 3.6%
*ALL SS: ALL SPORTS SHOES Co.
** IA: INDUSTRY AVERAGE
CAPACITY
NA EA AP LA
YEAR 10 112% 0% 117% -
YEAR 11 100% 0% 113% -
YEAR 12 100% 0% 100% 120%
YEAR 13 105% 0% 115% 119%
YEAR 14 120% 0% 120% 113%
YEAR 15 0% 0% 120% 120%
STOCK LEVEL
NA
YEAR 13 YEAR 14 YEAR 15 981 1307 480 EA
YEAR 13 YEAR 14 YEAR 15 1660 1305 1097 AP
YEAR 13 YEAR 14 YEAR 15 1319 1648 1259 LA
YEAR 13 YEAR 14 YEAR 15 737 513 364
TOTAL PAIRS '000
TOTAL PRODUCTION
NA 4000
YEAR 13 YEAR 14 YEAR 15 4200 4800 0 EA YEAR 13 YEAR 14 YEAR 15 0 0 0 AP 6000
YEAR 13 YEAR 14 YEAR 15 6900 7200 7200 LA 3600
YEAR 13 YEAR 14 YEAR 15 4750 4800 6000
TOTAL PRODUCTION '000
PLANTS CAPACITY
NA YEAR 13 YEAR 14 YEAR 15 1.05 1.2 0 AP YEAR 13 YEAR 14 YEAR 15 1.1499999999999999 1.2 1.2 LA YEAR 13 YEAR 14 YEAR 15 1.19 1.1299999999999999 1.2
CAPACITY %
END OF YEAR STOCK
NA YEAR 12 YEAR 13 YEAR 14 YEAR 15 1156 981 1307 480 EA YEAR 12 YEAR 13 YEAR 14 YEAR 15 641 1660 1305 1097 AP YEAR 12 YEAR 13 YEAR 14 YEAR 15 831 1319 1648 1259 LA YEAR 12 YEAR 13 YEAR 14 YEAR 15 407 737 513 364
MARKETING ANALYSIS
ALL SPORTS SHOES CO. YEAR 10 YEAR 11 YEAR 12 YEAR 13 YEAR 14 TREND YEAR 15 TREND
ACTUAL TARGET ACTUAL TARGET ACTUAL TARGET ACTUAL TARGET ACTUAL YR 14 vs YR13 TARGET ACTUAL YR 15 vs YR 14
WHOLESALE 314,731 330,468 363,365 546,275 602,171 744,068 24% 747,549 0.5%
PRIVATE LABELS 27,600 28,980 - - 0 18,190 - 0 -100% - ERROR:#VALUE!
INTERNET 90,315 94,831 87,461 147,866 149,040 193,884 30% 228,426 17.8%
ALL SPORTS SHOES CO. $ '000 YEAR 12 SALES YEAR 13 SALES YEAR 14 SALES YEAR 15 SALES YR 14 vs YR13
WHOLESALE 546,275 602,171 744,068 747,549 0.5%
PRIVATE LABELS - 0 18,190 - 0 - -
INTERNET 147,866 149,040 193,884 228,426 17.8%
SALES PER REGION
BRANDED/$000 NA EA AP LA TOTAL
YEAR 10 95856 90100 61200 67575 314731
YEAR 11 108960 100700 73353 80352 363365
YEAR 12 149209 156702 109285 131079 546275
YEAR 13 184385 157648 122059 138079 602171
YEAR 14 216148 205469 152737 169714 744068
YEAR 15 207230 196483 194821 149015 747549
SAELS UNIT
BRANDED / pairs NA EA AP LA TOTAL
YEAR 10 1997 1700 1275 1275 6247
YEAR 11 2270 1900 1497 1488 7155
YEAR 12 2287 2259 1657 1931 8134
YEAR 13 2396 2141 1551 1886 7974
YEAR 14 2682 2283 1864 2200 9029
YEAR 15 3128 2778 2756 2103 10765
NA EA AP LA TOTAL
YEAR 10 28064 25350 17888 19013 90315
YEAR 11 22908 26513 19140 18900 87461
YEAR 12 40627 42510 29796 34933 147866
YEAR 13 44227 40099 30030 34684 149040
YEAR 14 57246 52358 38502 45778 193884
YEAR 15 65531 56494 53103 53298 228426
INTERNET/PAIRS
NA EA AP LA TOTAL
YEAR 10 353 300 225 225 1103
YEAR 11 332 303 232 216 1083
YEAR 12 421 436 312 362 1531
YEAR 13 449 403 330 377 1559
YEAR 14 609 557 414 487 2067
YEAR 15 699 601 571 567 2438
PRICES
ALL SPORTS SHOES Co. PRICES vs INDUSTRY AVERAGE NA EA AP LA
ALL SS IA ALL SS IA ALL SS IA ALL SS IA
WHOLESALE PRICES $
YEAR 10 48 48 53 53 48 48 53 53
YEAR 11 48 53.87 53 56.79 49 53.96 54 56.91
YEAR 12 60 59 60 58.29 58 56.33 60 58.33
YEAR 13 61.55 59.63 62.25 60.39 65.05 59.75 65.75 60.77 63.65
YEAR 14 66.55 59.96 66.55 60.88 66.55 59.92 66.55 61.33 66.55
YEAR 15 66.25 61.02 66.25 60.06 66.25 60.35 66.35 60.9 66.275
INTERNET PRICES $
YEAR 10 67 67 72 72 67 67 72 72
YEAR 11 69 76.25 75 78.83 70 76.33 75 78.92
YEAR 12 84 83.54 85 82.37 83 79.62 84 82.37
YEAR 13 86 83.87 87 84.71 91 84.21 92 85.21 89
YEAR 14 94 84.87 94 85.83 93 84.33 94 86.79 93.75
YEAR 15 93.75 84.89 94 83.71 93 84.83 94 85.87 93.6875
YEAR 13 YEAR 14 YEAR 15
WHOLESALE 63.65 66.55 66.275
INTERNET 89 93.75 93.6875
ADVERSTISING SPEND $/PAIR NA EA AP LA TOTAL ADVERSTISING AVERAGE YEAR 10 YEAR 11 YEAR 12 YEAR 13 YEAR 14 YEAR 15
YEAR 10 4.26 4.50 5.33 5.00 4.77 TOTAL ADVERSTISING AVERAGE 4.77 5.44 4.54 4.94 8.27 6.25
YEAR 11 4.61 5.22 5.78 6.16 5.44
YEAR 12 4.43 4.27 5.08 4.39 4.54
YEAR 13 4.39 4.72 5.58 5.08 4.94
YEAR 14 7.60 8.45 9.22 7.82 8.27
YEAR 15 4.96 6.51 6.03 7.49 6.25
AVERAGE PER REGION 5.04 5.61 6.17 5.99 5.70
-0.3464436896 -0.2295550952 -0.3456867477 -0.0415551989 -0.2443435023
UNIT SOLD YEAR 15 YEAR 14 YEAR 13 YEAR 12 YEAR 11 YEAR 10
WHOLESALE 10765 9029 7974 8134 7155 6247
INTERNET 2438 2067 1559 1531 1083 1103
TOTAL 13203 11096 9533 9665 8238 7350
% WHOLESALE 81.5% 81.4% 83.6% 84.2% 86.9% 85.0%
% INTERNET 18.5% 18.6% 16.4% 15.8% 13.1% 15.0%
WHOLESALE PER REGION
NA YEAR 13 YEAR 14 YEAR 15 184385 216148 207230 EA YEAR 13 YEAR 14 YEAR 15 157648 205469 196483 AP YEAR 13 YEAR 14 YEAR 15 122059 152737 194821 LA YEAR 13 YEAR 14 YEAR 15 138079 169714 149015 TOTAL YEAR 13 YEAR 14 YEAR 15 602171 744068 747549
GROSS REVENUE $ '000
GROSS REVENUE $ '000
INTERNET SALES
NA YEAR 13 YEAR 14 YEAR 15 44227 57246 65531 EA YEAR 13 YEAR 14 YEAR 15 40099 52358 56494 AP YEAR 13 YEAR 14 YEAR 15 30030 38502 53103 LA YEAR 13 YEAR 14 YEAR 15 34684 45778 53298 TOTAL YEAR 13 YEAR 14 YEAR 15 149040 193884 228426
GROSS REVENUE $ '000
GROSS REVENUE $ '000
SALES UNIT PER REGION
NA YEAR 13 YEAR 14 YEAR 15 2396 2682 3128 EA YEAR 13 YEAR 14 YEAR 15 2141 2283 2778 AP YEAR 13 YEAR 14 YEAR 15 1551 1864 2756 LA YEAR 13 YEAR 14 YEAR 15 1886 2200 2103 TOTAL YEAR 13 YEAR 14 YEAR 15 7974 9029 10765
BRANDED SALES '000 / REGION
TOTAL SALES '000 / REGION
INTERNET SALES
NA YEAR 13 YEAR 14 YEAR 15 449 609 699 EA YEAR 13 YEAR 14 YEAR 15 403 557 601 AP YEAR 13 YEAR 14 YEAR 15 330 414 571 LA YEAR 13 YEAR 14 YEAR 15 377 487 567 TOTAL YEAR 13 YEAR 14 YEAR 15 1559 2067 2438
SALES UNIT '000 / REGION
TOTAL SALES '000 / REGION
PRICES TREND
WHOLESALE YEAR 13 YEAR 14 YEAR 15 63.650000000000006 66.55 66.275000000000006 INTERNET YEAR 13 YEAR 14 YEAR 15 89 93.75 93.6875
WHOLESALE PRICE/ UNIT/ DOLLAR
INTERNET PRICE / UNIT/ DOLLAR
TOTAL ADVERSTISING AVERAGE
YEAR 10 YEAR 11 YEAR 12 YEAR 13 YEAR 14 YEAR 15 4.7721631205673756 5.444413302156061 4.5425328038752006 4.943635323351935 8.2702999491955467 6.2495058946788244
TOTAL AVERAGE ADV SPEND / PAIR
WHOLESALE INTERNET 10765 2438
RESOURCE-LEARNING
ALL SPORTS SHOES CO. $ '000 Training spend per employee Employee's productivity Number of employees Incentive pay % Number of supervisors
YEAR 10
NA 480 5,000 800 11.20% 20
EA - 0 - 0 - 0 - 0 - 0
AP 457 3,500 1,143 10.40% 29
LA - 0 - 0 - 0 - 0 - 0
YEAR 11
NA 634 5,045 793 8.60% 32
EA - 0 - 0 - 0 - 0 - 0
AP 998 3,607 1,663 19.50% 33
LA - 0 - 0 - 0 - 0 - 0
YEAR 12
NA 651 4,912 814 8.20% 41
EA - 0 - 0 - 0 - 0 - 0
AP 1,013 3,552 1,689 15.50% 42
LA 478 3,764 797 11.40% 40
YEAR 13
NA 820 4,879 820 14.90% 41
EA - 0 - 0 - 0 - 0 - 0
AP 1,369 3,506 1,711 15.20% 43
LA 812 3,940 1,015 28.40% 51
YEAR 14
NA 781 5,123 781 13.10% 39
EA - 0 - 0 - 0 - 0 - 0
AP 1,604 3,741 1,604 15.30% 46
LA 1,046 4,064 1,046 24.70% 42
YEAR 15
NA - 0 - 0 - 0 - 0 - 0
EA - 0 - 0 - 0 - 0 - 0
AP 1,536 3,907 1,536 15.40% 44
LA 1,188 4,210 1,188 21.40% 48
FINANCE ANALYSIS
ALL SPORTS SHOES CO. YEAR 10 YEAR 11 YEAR 12 YEAR 13 YEAR 14 YEAR 15
ACTUAL TARGET ACTUAL TARGET ACTUAL TARGET ACTUAL TARGET ACTUAL TARGET ACTUAL
Revenue 432,646 454,278 454,976 500,474 729,894 783,757
Cost of goods 228,053 233,184 351,041 410,050 500,515 500,515
Expenses 137,276 156,293 187,023 203,442 282,467 282,467
Net Profit 40,000 42,000 39,754 43,729 120,988 106,962 81,894 - 0
Net Profit % 9.2% 9.7% 8.7% 9.6% 17% 14% 9% 0%
ROI 44.8%
Maia: Maia:
Net investment in YR 11 is $(000) 88'800 87.3%
Maia: Maia:
Net investment in year 12 is $(000) 138'540 81.5%
Maia: Maia:
Net investment is $ '000 131280
69.7%
Maia: Maia:
Nei investment is $'000 117520 0.0%
Maia: Maia:
Nei investment is $'000 117520
ROE 20.0 21.0 17.7 22.0 40.3 23.0 25.8 24.0 21.8 24.0 21.8
ALL SPORTS SHOES CO. YEAR 10 YEAR 11 YEAR 12 YEAR 13 YEAR 14
ACTUAL TARGET ACTUAL % vs TARGET TARGET ACTUAL % vs TARGET TARGET ACTUAL % vs TARGET TARGET ACTUAL % vs TARGET
Earnings per Share 2 2 1.99 -0.5% 3 6.05 101.7% 3.5 5.35 52.9% 4 4.36 9.0%
Credit rating B B+ B+ ACHIEVED B+ B+ ACHIEVED B+ ACHIEVED A- ACHIEVED
Interest Coverage 6.62 7.52 10.1 9.75 10.19
Borrowings 132488 261856 268063 202319 378292
Stock price - 40 16.72 -58.2% 50 133.85 167.7% 65 99.25 52.7% 80 75.65 -5.4%
ALL SPORTS SHOES CO. YEAR 10 YEAR 11 YEAR 12 YEAR 13 YEAR 14
Current Assets 97,778 144,911 244,615 290,341 295,452
Current Liabilities 35,288 75,556 104,663 61,819 88,792
Current Ratio 2.771 1.918 2.337 4.697 3.327
ALL SPORTS SHOES CO. $ '000 YEAR 12 YEAR 13 YOY % YEAR 14 YOY % YEAR 15 YOY %
ACTUAL ACTUAL ACTUAL ACTUAL
Net Revenue 729,894 783,757 7.4% 912,699 16.5% 1,019,754 11.7%
Cost of goods 351,041 410,050 16.8% 500,515 22.1% 471,243 -5.8%
Expenses 187,023 203,442 8.8% 282,467 38.8% 316,038 11.9%
Net Profit 120,988 106,962 -11.6% 81,894 -23.4% 232,473 183.9%
Net Profit % 17% 14% -20.2% 9% -37.2% 14.2% 62.6%
ROI 87.3%
Maia: Maia:
Net investment in year 12 is $(000) 138'540 81.5%
Maia: Maia:
Net investment is $ '000 131280
-6.7% 69.7%
Maia: Maia:
Nei investment is $'000 117520
Maia: Maia:
Nei investment is $'000 117520 -14.5% 89.6%
Maia: Maia:
Net investment is '000 122,509
Maia: Maia:
Net investment in YR 11 is $(000) 88'800
Maia: Maia:
Net investment in year 12 is $(000) 138'540
Maia: Maia:
Net investment is $ '000 131280
Maia: Maia:
Net investment in year 12 is $(000) 138'540
Maia: Maia:
Net investment is $ '000 131280
28.6%
ROE 40.3 25.8 -36.0% 21.8 -15.5% 41.1 88.5%
ALL SPORTS SHOES CO. $ '000 YEAR 12 YEAR 13 YEAR 14
TARGET ACTUAL % vs TARGET TARGET ACTUAL % vs TARGET TARGET ACTUAL % vs TARGET
Earnings per Share 3 6.05 101.7% 3.5 5.35 52.9% 4 4.36 9.0%
Credit rating B+ B+ ACHIEVED B+ ACHIEVED A- ACHIEVED
Interest Coverage 10.1 9.75 10.19
Borrowings 268,063 202,319 378,292
Stock price 50 133.85 167.7% 65 99.25 52.7% 80 75.65 -5.4%
ALL SPORTS SHOES CO. $ '000 YEAR 13 YEAR 14 YEAR 15
TARGET ACTUAL % vs TARGET TARGET ACTUAL % vs TARGET TARGET ACTUAL % vs TARGET
Earnings per Share 3.5 5.35 52.9% 4 4.36 9.0% 4.5 7.74 72.0%
Credit rating B+ B+ ACHIEVED A- A- ACHIEVED A- B+ NOT ACHIEVED
Interest Coverage - 9.75 - 10 10.19 ACHIEVED 9 9.03 ACHIEVED
Borrowings - 202,319 - 380,000 378,292 ACHIEVED 330,000 or less 326,282 ACHIEVED
Stock price 65 99.25 52.7% 80 75.65 -5.4% 100 163.25 63.3%
ALL SPORTS SHOES CO. $ '000 YEAR 12 YEAR 13 YEAR 14 YEAR 15
Current Assets 244,615 290,341 295,452
Current Liabilities 104,663 61,819 88,792
Current Ratio 2.34 4.70 3.33
TARGETACTUAL
% vs
TARGET
TARGETACTUAL
% vs
TARGET
Earnings per Share44.369.0%4.57.7472.0%
Credit ratingA-A-ACHIEVEDA-B+NOT ACHIEVED
Interest Coverage1010.19ACHIEVED99.03ACHIEVED
Borrowings380,000 378,292 ACHIEVED330,000 or less326,282 ACHIEVED
Stock price8075.65-5.4%100163.2563.3%
YEAR 15
ALL SPORTS
SHOES CO.
$ '000
YEAR 14
Company Performance
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 23 23.09 27.38 28.6 29.3 23 23.09 27.38 28.64 29.26 25.04 24.09
reject rate % 8.6% 8.20% 6.6% 7.0% 5.5% 8.6% 8.20% 6.6% 7% 5.5% 8.5% 2.7%
Net Production 8,371 9,919 12,700 14,765 15,869 7,571 9,919 12,700 14,230 15,869 800 535
% Superior materials 32% 34% 50% 62% 70% 32% 34% 50% 62% 70%
no of models produced 200 250 450 500 500 200 250 450 500 500 100 100
TQM spend per pair 1.04 1.31 2.85 2.71 3.28 1.04 1.31 2.85 2.71 3.28 1.04 2.57
Quality 4 4.2 5.8 6.3 7 4 4.2
tc={AE7C235B-6064-4CDD-BA78-FFB11D6FB33A}: [Threaded comment]
Your version of Excel allows you to read this threaded comment; however, any edits to it will get removed if the file is opened in a newer version of Excel. Learn more: https://go.microsoft.com/fwlink/?linkid=870924
Comment:
lowest amongst 4 regions 5.8 6.3 7.0 3 5
LEARNING & DEVELOPMENT Training spend $848 $1,632 2,142 3,001 3,431 $848 $1,632 2,142 3,001 3,431
TQM spend per pair 1.04 1.31 2.85 2.71 3.28 1.04 1.31 2.85 2.71 3.28
Incentive pay 5,518 8,263 8,409 15,261 13,976 5,518 8,263 8,409 15,261 13,976
Number of employees 1,943 2,456 3,300 3,546 3,431 1,943 2,456 3,300 3,546 3,431
CUSTOMERS & MARKETING Advertising Spend 52,000 62,840 64,000 63,250 108,750 29,323 38,215 37,030 38,868 74,045 22,677 24625 26,970 24,382 34,705
Celebrity Endorsement payments 0 0 1,000 1001 1000 0 0 842 837 814 0 0 158 164 186
Image rating 70 70 66 72 73 72 76 70 70 66 72 73 72 76 70 72 70 70 66 72 73 72 76
Price per pair 50.38 50.78 59.59 63.41 66.55 34.5 34
tc={93F615B1-CC2A-4E81-94E0-B29E3163DB91}: [Threaded comment]
Your version of Excel allows you to read this threaded comment; however, any edits to it will get removed if the file is opened in a newer version of Excel. Learn more: https://go.microsoft.com/fwlink/?linkid=870924
Comment:
Exclusive of RX adjustments 69.38
tc={6F012644-4C36-440D-B2F5-6320BDBF9810}: [Threaded comment]
Your version of Excel allows you to read this threaded comment; however, any edits to it will get removed if the file is opened in a newer version of Excel. Learn more: https://go.microsoft.com/fwlink/?linkid=870924
Comment:
Excluding RX Adj 72.09 84.08 88.77 93.8
Market Share 8.3% 8.7% 9.4% 8.60% 9.00% 8.30% 7% 8.60% 7.60% 8.60%
Retailer support Rebate 11,850 13,450 13,584 18,227 28,514 11,850 13,450 13,584 18227 28514
Sales $ 432,646 454,278 450,826 495,909 694,141 728,848 769,401 807,871 937,952 314731 363365 546275 602171 744068 27600 18,190 90315 87,461 147,866 149,040 193,884
Sales units (000s) 8,150 8,558 8,238 9,062 9,665 10,148 10,068 10,571 11,096 6247 7155 8134 7974 9029 800 535 1103 1,083 1,531 1,559 2,067
FINANCE Earnings per Share 2 2 1.99 3 6.05 3.5 5.35 4 4.36
Net Revenues
tc={681E0A37-1F3C-470B-997E-E89C13220375}: [Threaded comment]
Your version of Excel allows you to read this threaded comment; however, any edits to it will get removed if the file is opened in a newer version of Excel. Learn more: https://go.microsoft.com/fwlink/?linkid=870924
Comment:
Income Statement
tc={AE7C235B-6064-4CDD-BA78-FFB11D6FB33A}: [Threaded comment]
Your version of Excel allows you to read this threaded comment; however, any edits to it will get removed if the file is opened in a newer version of Excel. Learn more: https://go.microsoft.com/fwlink/?linkid=870924
Comment:
lowest amongst 4 regions
tc={93F615B1-CC2A-4E81-94E0-B29E3163DB91}: [Threaded comment]
Your version of Excel allows you to read this threaded comment; however, any edits to it will get removed if the file is opened in a newer version of Excel. Learn more: https://go.microsoft.com/fwlink/?linkid=870924
Comment:
Exclusive of RX adjustments 432,646 454,278 454,976 500,474 729,894 766,389 783,757 822,945 912,699
Profit 40,000 42,000 39,754 43,729 120,988 127,037 106,962 112,310 81,894
Net profit percentage 9.2% 8.7% 9% 16.6% 17% 13.6% 14% 9.0%
Return on equity 20 21 17.7 22 40.3 23 25.8 24 21.8
Credit rating B B+ B+ B+ B+ B+ B+ A- A-
Current ratio 2.77 1.92 2.34 4.7 3.33
Interest Coverage 6.62 7.52 10.1 9.75 10.19
Cash Balance 6,074 0 24,184 8,414 - 0
Borrowings 132,488 261,856 268,063 202,319 378,292
New Shares on Issue 0 0 0 0 0
BALANCED SCOREBOARD
METRIC YEAR 13 % vs TARGET YEAR 14 % vs TARGET YEAR 15 % vs TARGET
TARGET ACHIEVEMENT TARGET ACHIEVEMENT TARGET ACHIEVEMENT
FINANCIAL
MAINTAIN PROFITABILITY $ 766,388,700 $ 783,757,000 2.3% $ 822,944,850 $ 912,699,000 10.9% $ 1,000,000,000 $ 1,019,754,000 2.0%
INCREASE EARNING PER SHARE 3.5 5.35 52.9% 4 4.36 9.0% 4.5 7.74 72.0%
CUSTOMER
INCREASE RETAIL SUPPORT $ 18,000,000 $ 18,227,000 ACHIEVED $ 27,800,000 $ 28,514,000 ACHIEVED $ 60,000,000 $ 63,169,000 ACHIEVED
ON TIME DELIVERY $ 7,900,000 $ 8,559,000 ACHIEVED $ 13,000,000 $ 13,544,000 ACHIEVED $ 16,000,000 $ 16,148,000 ACHIEVED
INTERNAL PROCESS
PREMIUM QUALITY SHOES WITH LOW PRODUCTION COST $ 29.00 $ 28.64 ACHIEVED $ 28.75 $ 29.26 NOT ACHIEVED $ 29.00 $ 28.95 ACHIEVED
OPTIMIZE RETAIL DISTRIBUTION 4,000 4,423 11% 4,500 4,786 6% 5,000 10,627 113%
DOUBLE MARKETING ACTIVITIES - $ 111,285,000 - $ 200,000,000 $ 212,384,000 ACHIEVED $ 210,000,000 $ 212,055,000 ACHIEVED
IMPROVE S/Q STYLING 6* 6.3* ACHIEVED 7* 7* ACHIEVED 7.5* 7.6* ACHIEVED
LEARNING AND GROWTH
AMELIORATE PRODUCTIVITY PER EMPLOYEE $ 4,200,000 $ 4,108,000 NOT ACHIEVED $ 4,200,000 $ 4,309,000 ACHIEVED $ 4,000,000
Maia: Maia:
Comparing only AP & LA $ 4,058,500 ACHIEVED
INVEST IN TRAINING $ 3,000,000 $ 3,001,000 ACHIEVED $ 3,400,000 $ 3,431,000 ACHIEVED $ 2,650,000
Maia: Maia:
Comparing only AP & LA $ 2,724,000 ACHIEVED
CSR INITIATIVES - YR 13 ETHICS TRAINING -YR14 IMPROVED WORKING CONDITIONS - $ 400,000 ACHIEVED - $ 600,000 ACHIEVED $ 1,500,000 $ 1,500,000 ACHIEVED
Sheet1
EBIT MARGIN 22.80% (+95.59% vs YR 14) NET REVENUE 1'019'754 (+ 11.73% vs YR 14 ) NET PROFIT MARGIN 14.2 % (+57.78% vs YR 14) b g Industry
IMAGE RATING 84 (+10.5% vs YR14) RETAIL OUTLETS 10'627 (+122% vs YR14) S/Q RATING 7.8* (+11.4% vs YR14) 7204 11241 6401
MARKETING SUPPORT $212'055'000 AVERAGE PRODUCTIVITY $4'058'500 EARNING / SHARE $7.74 (+72% vs Investor expectation)
212055
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 2014 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 2014 Industry AVG Increase or Decrease on previous year Increase or Decrease on base year
PRODUCTIVITY/ OPERATIONS FINANCIAL
Productivity per employee (pairs per annum) 4 4 (0) 4 (0) 4 0 5 0 7% Sales $ 432,646.00 $ 454,976.00 $ 22,330 $ 729,894 $ 274,918 $ 783,757 $ 53,863 $ 912,699 $ 128,942 111%
Star rating 4.00 4.20 0.20 5.80 1.60 6.30 0.50 7.00 0.70 75% Operating profit $ 40,000 $ 39,754 (246) $ 120,988.00 81,234 $ 106,962.00 (14,026) $ 81,894.00 (25,068) 105%
Reject Rate 9% 8% -0% 7% -2% 7% 0% 6% -2% -36% EPS $ 2.00 $ 1.99 -1% $ 6.05 4 $ 5.35 (1) $ 4.36 (1) 118%
Cost of Production per pair $ 22.55 $ 23.09 1 $ 27.38 4 $ 28.64 1 $ 29.26 1 30% Cash Balance $ 6,074.00 $ - 0 $ 24,184.00 24,184 $ 8,414.00 (15,770) $ - 0 -100%
Shares on Issue - 0 - 0 - 0 - 0 - 0
Borrowing $ 132,488.00 $ 261,856.00 129,368 $ 268,063.00 6,207 $ 202,319.00 (65,744) $ 378,292.00 175,973 186%
CUSTOMERS AND MARKETING 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 2014 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 2014 Industry AVG Increase or Decrease on previous year Increase or Decrease on base year
Image rating 70 66 (4) 73 7 72 (1) 76 4 9% Training spend per employee $ 848.00 $ 1,632.00 $ 784.00 $ 2,142.00 $ 510.00 $ 3,001.00 $ 859.00 $ 3,431.00 $ 430.00 305%
Price per pair (Wholesale) $ 50.38 $ 50.78 $ 0.40 $ 59.59 $ 8.81 $ 63.41 $ 3.82 $ 66.55 $ 3.14 32% TQM spend per pair $ 1.04 $ 1.31 $ 0.27 $ 2.85 $ 1.54 $ 2.71 -$ 0.14 $ 3.28 $ 0.57 215%
Market Share (Wholesale) 8% 9% 0% 9% 1% 9% -1% 9% 0% 8% Green Materials %
Retailer support Rebate $ 11,850.00 $ 13,450.00 1,600 $ 13,584.00 134 $ 18,227.00 4,643 $ 28,514.00 10,287 141% Incentive pay 5,518.00 8,263.00 2,745.00 8,409.00 146 15,261.00 6,852 13,976.00 (1,285) 153%
Sales (in '000 Dollars) $ 432,646.00 $ 450,826.00 18,180 $ 677,916.00 227,090 $ 769,401.00 91,485 $ 937,952.00 168,551 117%
`
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 / SHOES PRODUCED
Branded Shoes YEAR 10 YEAR 11 YEAR 12 YEAR 13 YEAR 14 YEAR 10 YEAR 11 YEAR 12 YEAR 13 YEAR 14
Price per pair $ 50.38 $ 50.78 $ 59.59 $ 63.41 $ 66.55 reject rate % 9% 8% 7% 7% 6%
Market Share 8.3% 8.7% 9.4% 8.6% 9.0% Net Production 8,371.00 9,919.00 12,700.00 14,765.00 15,869.00
SALES REVENUE/PROFIT
YEAR 10 YEAR 11 YEAR 12 YEAR 13 YEAR 14
Sales $ 432,646 $ 454,976 $ 729,894 $ 783,757 $ 912,699
net profit % 9.2% 8.7% 16.6% 13.6% 9%
BRANDED PRODUCTION NA
YEAR 12 YEAR 13 YEAR 14
pair/worker/year PRODUCTIVITY $ 4,076 $ 4,108 $ 4,309
$/pair produced PRODUCTION COST 27.38 28.64 29.26
YEAR 12 YEAR 13 YEAR 14
INTERNET PRICE 84 89 93.75
WHOLESALE PRICE 59.5 63.65 66.55
S/Q RATING 5.8 6.3 7
WHOLESALE MARKET SHARE
Price per pair YEAR 10 YEAR 11 YEAR 12 YEAR 13 YEAR 14 50.38 50.78 59.59 63.41 66.55 Market Share YEAR 10 YEAR 11 YEAR 12 YEAR 13 YEAR 14 8.3000000000000004E-2 8.6999999999999994E-2 9.4E-2 8.5999999999999993E-2 0.09
WHOLESALE PRICE/PAIR
MARKET SHARE
REJECT RATE AND PRODUCTION
reject rate % YEAR 10 YEAR 11 YEAR 12 YEAR 13 YEAR 14 8.5999999999999993E-2 8.2000000000000003E-2 6.6000000000000003E-2 7.0000000000000007E-2 5.5E-2 Net Production YEAR 10 YEAR 11 YEAR 12 YEAR 13 YEAR 14 8371 9919 12700 14765 15869
REJECT RATE
TOTAL PRODUCTION
SALES REVENUE & PROFIT
Sales YEAR 10 YEAR 11 YEAR 12 YEAR 13 YEAR 14 432646 454976 729894 783757 912699 net profit % YEAR 10 YEAR 11 YEAR 12 YEAR 13 YEAR 14 9.2454339113270431E-2 8.7376037417358277E-2 0.16576105571493943 0.13647342224694645 8.9727281392879804E-2
SALES REVENUE '000
NET PROFIT %
BRANDED PRODUCTION
PRODUCTIVITY YEAR 12 YEAR 13 YEAR 14 4076 4108.333333333333 4309.333333333333 PRODUCTION COST YEAR 12 YEAR 13 YEAR 14 27.38 28.64 29.26 PAIR/WORKER/YEAR $ '000
$/PAIR PRODUCED
PRICE AND S/Q RATING
INTERNET PRICE YEAR 12 YEAR 13 YEAR 14 84 89 93.75 WHOLESALE PRICE YEAR 12 YEAR 13 YEAR 14 59.5 63.65 66.55 S/Q RATING YEAR 12 YEAR 13 YEAR 14 5.8 6.3 7
PRICE $
S/Q RATING
North America
All Sports Shoes Co. North America
YEAR 10 YEAR 11 YEAR 12 YEAR 13 YEAR 14 YEAR 15
BRANDED P/L INTERNET BRANDED P/L INTERNET BRANDED P/L INTERNET BRANDED P/L INTERNET BRANDED P/L INTERNET BRANDED P/L INTERNET
OPERATIONS reject rate % 7.00% 6.90% 7.40% 7.30% 8.40% 5.60% 8.90% 4% 4% 2%
cost of Rejected pairs ($000) 6302 752 6964 0 9490 0 11669 6483 0
% Superior materials 31.00% 20.00% 39.00% 38.00% 62.00% 70.00%
Materials costs per pair $ 8.52 7.48 9.3 9.75 0 10.66 10.46
no of models produced 200 100 200 400 100 500 100 500 100
TQM spend per pair 1.08 1.08 1.3 0 2.73 2.63 2.61
Production costs per pair 23.98 26.93 25.46 0 30.87 34.24 33.57 0
COG sold per pair 24.98 26.42 32.2 35.24 34.57 38.09
Total Production (incl rej) 4463 4000 4000 4200 4800 0
Capacity utilization 112% 100% 100% 105% 120% 0
Completion of new/ add space (000s of pairs) 1000 0 0 0 0
Purchase of new equipment 0 0 0 0 0 0
Production improvement options 0 0 0 10000
Maia: Maia:
Option A 0 0
S/Q rating 4* 3* 4.2 0 5.8 4.7 6.3 5 7.1 5.3 7.8 5.3
End of Year Inventory (000s) 71 369 1156 981 1307 480
Inventory clearance ($000) 11989 36911 37661 0
operating profit margin 18.3% 22.5% 14.2% 18.9% 20.7% 27.8% 17.9% 27.2% 19.1% 25.6% 12.8% 26.0%
LEARNING & DEVELOPMENT Training expenditure 480 634 651 820 781 0
Employee's productivity 5000 5045 4912 4879 5123 0
Number of employees 800 793 814 820 781 0
Incentive pay % 11.20% 8.60% 8.20% 14.90% 13.10% 0.00%
Number of supervisors 20 32 41 41 39 0
CUSTOMERS & MARKETING Advertising Spend 8498 1502 10469 1531 10134 1866 10527 1973 20372 4628 15531 3469
Celebrity Endorsement payments 237 44 251 47 242 55 1658 371
Price per pair 48 32 67 48 35 69 60 42 84 61.55 36 86 66.55 34 94 66.25 93.75
Market Share 8.30% 8.30% 8.80% 6.80% 8.60% 7.80% 8.50% 7.30% 9.00% 8.50% 10.20% 8.80%
Retailer support 4000 5000 6180 6425 8738 18050
Sales $ 95856 6400 28064 108960 0 22908 149209 0 40627 184385 44227 216148 57246 207230 65531
Sales units (000s) 1997 200 353 2270 0 332 2287 0 421 2396 449 2682 609 3128 699
Search engine advertising 5000 5500 5500 5000 5250 5250
Total marketing expenses 16492 7652 20010 8181 21125 9360 20917 9370 35521 12283 43841 11440
RETAIL OUTLETS 1000 1000 1236 1285 1398 2888
Maia: Maia:
2nd highest in industry
Europe Africa
ALL SPORTS SHOES CO. Europe Africa
YEAR 10 YEAR 11 YEAR 12 YEAR 13 YEAR 14 YEAR 15
BRANDED P/L INTERNET BRANDED P/L INTERNET BRANDED P/L INTERNET BRANDED P/L INTERNET BRANDED P/L INTERNET BRANDED P/L INTERNET
OPERATIONS reject rate % 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00%
cost of Rejected pairs ($000) 0 0 0 0 0 0 0 0 0 0
% Superior materials 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00%
Materials costs per pair $ 0 0 0 0
no of models produced 200 100 246 0 500 0 500 500 500
TQM spend per pair 0 0 0 0 0 0.00% 0 0 0
Production costs per pair 0 0 0 0 0 0 0 0 0 0.00% 0 0
COG sold per pair 30.98 20.97 34.81 34.28 33.55 35.27
Total Production (incl rej) 0 0 0 0 0 0
Capacity utilization 0% 0% 0% 0
Completion of new/ add space (000s of pairs) 0 0 0 0
Purchase of new equipment 0 0 0 0
Production improvement options 0 0 0 0
S/Q rating 4 3 4.5 0 4.5 6.2 4.6 6.2 6.3 7.1 7.7
End of Year Inventory (000s) 60 657 641 1660 1305 1097
Inventory clearance ($000) 0 0 21473 23345 54922 12872
operating profit margin 13.3% 17.9% 14.1% 16.8% 19.5% 27.1% 16.5% 25.9% 21.0% 27.5% 17.9% 29.4%
LEARNING & DEVELOPMENT Training expenditure 0 0 0
Employee's productivity 0 0 0
Number of employees 0 0 0
Incentive pay % 0.00% 0.00% 0.00%
Number of supervisors 0 0 0
CUSTOMERS & MARKETING Advertising Spend 7650 1350 9919 1581 9639 1861 10099 1901 19294 4706 18086 3914
Celebrity Endorsement payments 234 45 225 42 206 50 1473 319
Price per pair 48 37 72 48 38 69 60 41 84 62.25 36 87 66.55 36 94 66.25 94
Market Share 8.30% 8.30% 8.50% 7.20% 9.70% 9.20% 8.70% 7.40% 8.70% 8.90% 10.00% 8.50%
Retailer support 4000 4250 3630 5733 7086 14868
Sales $ 90100 7400 25350 100700 26513 156702 42510 157648 40099 205469 52358 196483 56494
Sales units (000s) 1700 200 300 1900 0 303 2259 436 2141 403 2283 557 2778 601
Search engine advertising 4500 5500 5500 4250 4500 4500
Total marketing expenses 15050 7000 17969 8413 18021 0 9529 19376 8543 31837 11606 42067 11083
RETAIL OUTLETS 1000 1000 854 1349 1181 2478
Maia: Maia:
highest in industry
Asia Pacific
ALL SPORTS SHOES CO. Asia Pacific
YEAR 10 YEAR 11 YEAR 12 YEAR 13 YEAR 14 YEAR 15
BRANDED P/L INTERNET BRANDED P/L INTERNET BRANDED P/L INTERNET BRANDED P/L INTERNET BRANDED P/L INTERNET BRANDED P/L INTERNET
reject rate % 10.10% 10.00% 8.60% 8.00% 5.20% 3.30% 5.40% 3% 5.2% 2.7% 4.9% 2.4%
cost of Rejected pairs ($000) 8175 916 11560 0 7508 0 9007 9420 9586
% Superior materials 54.00% 20.00% 48.00% 60.00% 68.00% 70.00% 90.00%
Materials costs per pair $ 10.28 10.53 10.13 10.55 10.65 11.63
no of models produced 200 100 250 100 450 100 500 100 500 100 500 100
TQM spend per pair 1 1.31 2.95 2.75 3.27 3.79
Production costs per pair 21.15 21.68 25.44 25.54 26.5 28.6
COG sold per pair 26.44 26.54 27.51 29.05
Total Production (incl rej) 4693 6800 6000 6900 7200 7200
Capacity utilization 117% 113% 100% 115% 120% 120%
Completion of new/ add space (000s of pairs) 2000 0 0 0 0 0
Purchase of new equipment (000s of pairs) 0 2000 0 0 0 0
Production improvement options 1500
Maia: Maia:
Option A 0 0 9600
Maia: Maia:
Option B
Maia: Maia:
Option A S/Q rating 4 3 4.5 0 5.2 4.6 6.3 5 7 5.2 7.6
End of Year Inventory (Pairs) 45 481 831 1319 1648 1259
Inventory clearance ($000) 0 0 13271 20607 29371 12296
operating profit margin 21.9% 17.5% 21.9% 17.8% 29.2% 28.8% 29.9% 24.9% 26.6% 28.9% 25.3% 33.6%
LEARNING & DEVELOPMENT Training expenditure 457 998 1013 1369 1604 1536
Employee's productivity 3500 3607 3552 3506 3741 3907
Number of employees 1143 1663 1689 1711 1604 1536
Incentive pay % 10.40% 19.50% 15.50% 15.20% 15.30% 15.40%
Number of supervisors 29 33 42 43 46 44
CUSTOMERS & MARKETING Advertising Spend 6800 1200 8658 1342 8415 1585 8658 1842 17184 3816 16154 3914
Celebrity Endorsement payments 0 0 171 32 163 35 168 37 1461 303
Price per pair 48 32 67 49 30 70 58 40 83 65.05 37 91 66.55 37 93 66.25 93
Market Share 8.30% 8.30% 8.80% 7.20% 9.00% 8.10% 7.80% 7.40% 8.40% 7.80% 11.50% 9.30%
Retailer support 1925 2100 1977 2499 7107 13087
Sales $ 61200 6400 17888 73353 19140 109285 29796 122059 30030 152737 38502 194821 53103
Sales units (000s) 1275 225 1497 232 1657 312 1551 330 1864 414 2756 571
Search engine advertising 4000 4250 4500 3750 4000 4250
Total marketing expenses 11275 6350 13752 6938 13877 8267 16904 7977 29645 10203 40624 10249
RETAIL OUTLETS 700 700 659 769 971 2276
Maia: Maia:
2nd highest in industry
Latin America
ALL SPORTS SHOES CO. Latin America
YEAR 10 YEAR 11 YEAR 12 YEAR 13 YEAR 14 YEAR 15
BRANDED P/L INTERNET BRANDED P/L INTERNET BRANDED P/L INTERNET BRANDED P/L INTERNET BRANDED P/L INTERNET BRANDED P/L INTERNET
reject rate % 7.00% 4.20% 7.70% 3% 7% 3% 3.7% 1.3%
cost of Rejected pairs ($000) 6294 8452 353 9557 6182
% Superior materials 56.00% 64.00% 24.09% 70.00% 90.00%
Materials costs per pair $ 10.07 10.7 10.91 11.69
no of models produced 0 100 0 0 400 100 500 100 500 100 500 0
TQM spend per pair 2.8 2.71 3.35 3.43
Production costs per pair 26.86 28.33 29.03
COG sold per pair 27.86 29.33 30.03 29.84
Total Production (incl rej) 3600 4750 4800 6000
Capacity utilization 0% 0% 120% 119% 113% 120%
Completion of new/ add space (000s of pairs) 0 0 5000 0
Purchase of new equipment (000s of pairs) 0 0 3000 1000 250 750
Production improvement options 0 0 0 10625
Maia: Maia:
Option A 24000
Maia: Maia:
Option C
S/Q rating 3 6.6 6.5 5 7.2 5 8.1
End of Year Inventory (000s) 45 395 407 737 513 364
Inventory clearance ($000) 0 0 18231 16026 19359 11064
operating profit margin 9.1% 9.8% 6.1% 10.5% 41.8% 42.0% 37.9% 12.6% 36.8% 9.4% 15.2% 28.4% 41.3%
LEARNING & DEVELOPMENT Training expenditure 478 812 1046 1188
Employee's productivity 3764 3940 4064 4210 0.0359251969
Number of employees 797 1015 1046 1188
Incentive pay % 11.40% 28.40% 24.70% 21.40%
Number of supervisors 40 51 42 48
11313
CUSTOMERS & MARKETING Advertising Spend 6375 1125 9169 1331 8415 1658 9584 1916 17195 3805 15752 4248
Celebrity Endorsement payments 200 37 198 40 198 44 1115 301
Price per pair 53 37 72 54 35 75 60 42 84 65.75 34 92 66.55 35 94 66.35 94
Market Share 8.30% 8.30% 8.60% 0.00% 6.60% 10.20% 0.00% 9.30% 9.10% 8.20% 9.70% 9.00% 8.40% 9%
Retailer support 1925 2100 1797 3570 7107 17164
Sales $ 67575 7400 19013 80352 18900 131079 34933 138079 18190 34684 169714 45778 149015 53298
Sales units (000s) 1275 200 225 1488 216 1931 362 1886 535 377 2200 487 2103 567
Search engine advertising 4000 3500 4500 3750 4000 4250
Total marketing expenses 10850 6275 14245 6119 14701 8145 20142 8056 30550 10199 41602 11149
RETAIL OUTLETS 700 700 599 1020 1236 2985
Maia: Maia:
highest in industry
Maia: Maia:
Option A
OPERATION ANALYSIS
STOCK LEVEL
NA EA AP LA TOTAL OVER STOCK
YEAR 10 71 60 45 45 221 2.7%
YEAR 11 369 657 481 395 1902 23.1%
YEAR 12 1156 641 831 407 3035 31.4%
YEAR 13 981 1660 1319 737
YEAR 14 1307 1305 1648 513
YEAR 15 480 1097 1259 364
INVENTORY CLEARANCE 61549
8.9%
PRODUCTION LEVEL
NA EA AP LA
YEAR 10 4,463 - 0 4,693 - 0
YEAR 11 4,000 - 0 6,800 - 0
YEAR 12 4,000 - 0 6,000 3,600
YEAR 13 4200 - 0 6900 4750
YEAR 14 4800 - 0 7200 4800
YEAR 15 0 0 7200 6000
PRODUCTIVITY $ '000 NA AP LA
ALL SS IA ALL SS IA ALL SS IA
YEAR 11 5,045 AVERAGE 3,607 AVERAGE - 0 -
YEAR 12 4,912 AVERAGE 3,552 AVERAGE 3,764 LOW
YEAR...