Report on refurbishment or redevelopment of Leeds Foodhall
Report on refurbishment or redevelopment of Leeds Foodhall
In this report we have collected figures internally and externally to evaluate and aid in the decision making process. The forecasts and analysis relate to the decision to either refurbish the foodhall, or redevelop the area into a new ‘Toys and Games’ department
For the attention of: Michelle Hardman
Manager, Leeds Store
Authors: David Shaw & Sam Morris
Date: 6/4/2011
Table of contents
Page
Introduction ……………………….……….……………………………...3
Methodology……………………….……….……………………………..3
Initial Findings……………………….....….……………………………...3
Sensitivity Analysis………………….....…….….…….….….….....….....4
Environment………….…….….……………….………….……………...4
Final Conclusion and Recommendation…….………….……………...5
References…………………….……………….........….…………………5
Appendices……………………..…………………………………………6
Introduction
This report will evaluate the figures collected for the foodhall section of the Leeds store, and compare it to data collected on a new development, Toys and Games to see which could provide a greater value to the company. After evaluating the figures we will draw conclusions on which choice would be best for the company to take and provide evidence why.
Methodology
At first we used the revenue figures collected to get a four part moving average and then created a centred moving average of these. By calculating the centred moving average we could get a middle value from the four point moving average which aided us in working out other equation values in the forecasting table.
After this we then found the estimated seasonal trends and gathered an average of the seasonal components, this was done by taking the centred average from the original revenue values. From this we were able to calculate the deseasonalised trend for each quarter of revenue, these figures helped to give the average of the
In this report we have collected figures internally and externally to evaluate and aid in the decision making process. The forecasts and analysis relate to the decision to either refurbish the foodhall, or redevelop the area into a new ‘Toys and Games’ department
For the attention of: Michelle Hardman
Manager, Leeds Store
Authors: David Shaw & Sam Morris
Date: 6/4/2011
Table of contents
Page
Introduction ……………………….……….……………………………...3
Methodology……………………….……….……………………………..3
Initial Findings……………………….....….……………………………...3
Sensitivity Analysis………………….....…….….…….….….….....….....4
Environment………….…….….……………….………….……………...4
Final Conclusion and Recommendation…….………….……………...5
References…………………….……………….........….…………………5
Appendices……………………..…………………………………………6
Introduction
This report will evaluate the figures collected for the foodhall section of the Leeds store, and compare it to data collected on a new development, Toys and Games to see which could provide a greater value to the company. After evaluating the figures we will draw conclusions on which choice would be best for the company to take and provide evidence why.
Methodology
At first we used the revenue figures collected to get a four part moving average and then created a centred moving average of these. By calculating the centred moving average we could get a middle value from the four point moving average which aided us in working out other equation values in the forecasting table.
After this we then found the estimated seasonal trends and gathered an average of the seasonal components, this was done by taking the centred average from the original revenue values. From this we were able to calculate the deseasonalised trend for each quarter of revenue, these figures helped to give the average of the
References: http://academic.mintel.com/sinatra/oxygen_academic/search_results/show&/display/id=480969 http://academic.mintel.com/sinatra/oxygen_academic/my_reports/display/id=545274&anchor=atom/display/id=569161 http://academic.mintel.com/sinatra/oxygen_academic/my_reports/display/id=479963&anchor=atom/display/id=554909 http://academic.mintel.com/sinatra/oxygen_academic/my_reports/display/id=479972&anchor=atom/display/id=554780?select_section=554788 Appendix