• Join over 1.2 million students every month
  • Accelerate your learning by 29%
  • Unlimited access from just £6.99 per month

A business analysis of Alt Ausee Ice Cream.

Extracts from this document...

Introduction

Contents List Page no. 1.1 Report Objectives 2 1.2 Methodology / Models used 2 1.3 Key Business points re. Alt Ausee Ice Cream 2 1.4 Key Results of Report 2 1.5 Assessment of expansion proposal; 3 1.6 Other Management options 3 1.7 Conclusions / recommendations 4 1.8 Appendix inc.Graphs , Charts, Comments & data. 5 to 11 inc. 1.1 Report Objectives; To forecast sales & profits for Alt Ausee Ice Cream for next 12 months and use results to advise on specific investment proposal (expansion ) taking account of relevant factors ( real or potential ) and available information. Conclusions, explanations & recommendations to be included.. 1.2 Methodology / Models used; Forecasting future performance based on understanding past performance ( i.e. Regression ) Based on figures only ( i.e. Quantitative forecasting). Using Excel to predict the future ( i.e. extrapolating the trend ) allowing for seasonal variations. Assessing the risk ( i.e. acceptable or not ) 1.3 Key Business points re. Alt Ausee Ice Cream. High quality product i.e. high margins Growing business ... present production capacity almost reached Seasonal peaks ( Dec & Aug ) and lows ( Nov & Feb ) Expansion costly ( increase fixed costs by 20% ) Market split between Great Britain (60%) and Germany (40%) Germany over 20% more profitable New products have increased recent sales Storage problems 1.4 Key Results of Report While initial results would seem to indicate a promising future for Alt Ausee Ice Cream further examination indicates that the proposed expansion should not be undertaken at this stage without further information or investigation. ...read more.

Middle

COMMENT; Graph shows steady growth in sales for both Great Britain and Germany. GB and Ger both increase by over 39% from 99/00 to 01/02. Based on this past performance ( which represents annual summaries ) future looks positive for continued sales increases. NB Based on 60% / 40% split of sales between GB & Ger resp. FIG 1 Source Data Sales total by location 1999 to 2002 inc. GB Ger 1999/2000 303.6 202.4 2000/2001 343.2 228.8 2001/2002 423 282 Chart source; Excel 97 Basic skills; J Muir, 1997,unit 12, page 149 to 160 COMMENT; Trend line indicates strong " positive "relationship between time and sales, i.e. this would indicate that sales look set to continue to increase. Strength of the relationship has been reduced by seasonal figures which have the affect of giving a low R2 value ( 0.097 in this case ) Important factor is that there is a "slope" FIG.2 source data Total Sales by \quarter total sales ( tonnes ) 1999 2 1 115 1999 3 2 181 1999 4 3 142 2000 1 4 68 2000 2 5 134 2000 3 6 168 2000 4 7 169 2001 1 8 101 2001 2 9 152 2001 3 10 247 2001 4 11 187 2002 1 12 119 Chart source; Excel 97, further skills, J Muir; Unit 9, pages 129 to 139 COMMENT; Using forecast trend functions ( which account for variations such as seasonal factors in historical data ) ...read more.

Conclusion

This assumes sales volumes and exchange rate remain unchanged. Source data for FIG.6 Total Sales by \quarter Total Returns Fixed costs net profits Net profits var costs deducted (* = add. equip) pre-project post project 1999 2 1 �1,260,400 �1,250,000 �10,400 �10,400 1999 3 2 �1,982,800 �1,250,000 �732,800 �732,800 1999 4 3 �1,556,800 �1,250,000 �306,800 �306,800 2000 1 4 �744,800 �1,250,000 -�505,200 -�505,200 2000 2 5 �1,469,600 �1,250,000 �219,600 �219,600 2000 3 6 �1,843,200 �1,250,000 �593,200 �593,200 2000 4 7 �1,840,800 �1,250,000 �590,800 �590,800 2001 1 8 �1,093,600 �1,250,000 -�156,400 -�156,400 2001 2 9 �1,666,400 �1,250,000 �416,400 �416,400 2001 3 10 �2,707,600 �1,250,000 �1,457,600 �1,457,600 2001 4 11 �2,050,000 �1,250,000 �800,000 �800,000 2002 1 12 �1,305,200 �1,250,000 �55,200 �55,200 est 2002 2 13 �1,918,000 �1,500,000 �668,000 �418,000 est. 2002 3 14 �1,853,200 �1,500,000 �603,200 �353,200 est. 2002 4 15 �1,895,600 �1,500,000 �645,600 �395,600 est. 2003 1 16 �1,950,400 �1,500,000 �700,400 �450,400 Cumulative �7,138,400 �6,138,400 Chart source; Excel 97 Basic skills; unit 5, page COMMENT; Exchange rate fluctuation will have a major affect on net profits. i.e. 20 to 25 % decrease. If combined with comparison with increased fixed costs then affect could be decrease of over 50% in net profits Source data for FIG. 7 est 2002 2 Fixed costs Net profit Net profit Net profit est. 2002 3 post-project pre-project post-project post project est. 2002 4 euro=1.65 euro=1.48 euro = 1.65 est. 2003 1 �1,500,000 �668,000 �331,200 �418,000 �1,500,000 �603,200 �268,880 �353,200 �1,500,000 �645,600 �310,040 �395,600 �1,500,000 �700,400 �362,360 �450,400 49a2, Assign # 2, Alt Ausee Ice Cream; Student Reg. No 1022033 1 ...read more.

The above preview is unformatted text

This student written piece of work is one of many that can be found in our AS and A Level Structures, Objectives & External Influences section.

Found what you're looking for?

  • Start learning 29% faster today
  • 150,000+ documents available
  • Just £6.99 a month

Not the one? Search for your essay title...
  • Join over 1.2 million students every month
  • Accelerate your learning by 29%
  • Unlimited access from just £6.99 per month

See related essaysSee related essays

Related AS and A Level Structures, Objectives & External Influences essays

  1. Btec National Business Level 3 Year 1 - Exploring Business Activity

    Voluntary sector services: In the voluntary sector much of the emphasis in the aims and strategies of businesses is on providing service. E.g. Oxfam Ambulance service and their voluntary organisation designed to provide medical support to the public at times of need.

  2. The Business Environment Coursework. Describe the type of business, purpose and ownership of ...

    shopping there if the prices rose and they decided they would be better off to take the loss themselves as opposed to losing many of their customers. M&S has also introduced electronic tagging and, prompted by increased levels of shoplifting in the recession, is now electronically protecting products in 50 of its branches.

  1. Departments and their roles within a business.

    E.g. applying finishes (varnish, stainless steel veneers etc.) to increase aesthetic properties of products. Operations department will have to wait and confirm with the marketing department before starting production lines because if the operations department begin making a product using certain resources and technology, making the cost price �25.00 per product but the marketing department plan to price

  2. Introduction to J Sainsbury plc

    The culture of Sainsbury's is a role culture or bureaucracy. The role culture or bureaucracy of Sainsbury's is typical of bureaucracies with a formal structure, which is hierarchical. It has many layers of hierarchy and is based on a top-down approach, with an emphasis on communication down the line.

  1. This is a detailed business report on Sainbsurys.

    at those stores and then get something in conjunction with how many points they have. We can see that as times are changing Sainsburys need to keep up to date with the latest technology in all areas. We will now see the vital role of setting objectives plays in Sainsburys and how each department assists in reaching them.

  2. Company law - Advise critically Alice Lau and Benson Cheung, with strategic proposal, how ...

    It also permits a limited company to have at least one director2. Limited by guarantee Most of companies, formed for profit-making purposes, are private companies limited by shares. For those limited by guarantee limits the liability of its members to such amount they undertake to contribute to the company in case of winding up.

  1. Business report on J Sainsbury's.

    * Survival In general: While businesses such as BT and BP think in � billions, at the other extreme some businesses think of surviving. Survival is the main objective of every business. This is particularly relevant during a recession. Most new businesses have survival as the main aim of the first years of operating.

  2. Investigating Business. Tesco PLC. I will be describing the aims and objectives of ...

    a lot of kinds of insurances including car, pet, health, home, travel, life, dental and so on. These services are put in place to meet the increasing number of needs from Tesco?s loyal customers. For example: Tesco Bank and Tesco Mobile make significant contribution to the company?s sales and revenue

  • Over 160,000 pieces
    of student written work
  • Annotated by
    experienced teachers
  • Ideas and feedback to
    improve your own work