In 2018, the Board of Directors of the business decided to introduce a new Section into the Furniture Department of the Manchester store. This Garden Room Section supplies patio and conservatory furniture such as tables, chairs and sofas in oiled teak, cane, rattan etc. The new section was introduced as a trial on the basis that, if it proved successful, then similar sections would be opened in the other stores. The new section has been introduced into part of the sales area occupied by the existing Furniture Department; no additional space has been made available on the shop floor. (The original four sections —dining room, living room, bedroom, home office — still exist as before but in a bit less space). The new Section has run for a full year (August 2019 to July 2020). (Ignore COVID) It is time to evaluate its performance.
You are required to take the role of the manager of the Furniture Department in the Manchester store. You are required to prepare a presentation for the next meeting of the Board of Directors of the business in which you assess the trial and make a recommendation about the continuation of the new Section within the Furniture Department.
You are provided with the monthly revenue figures for each Section of the Furniture Department in each of the stores from August 2018 and to July 2020. This data is available in the Referred Project 1 data file in the same folder as this document.
Analysis: The purpose of the presentation, which you are to prepare, is to describe and evaluate the performance of the new Section in its own right and, to compare and evaluate the performance of the Furniture Departments over the two 12 month periods:
August 2018 — July 2019 (2018/19) without the new Section
August 2019 — July 2020 (2019/20) with the new Section.
1. the performance of the new Section over the 12 months that it has existed (August 2019 — July 2020).
2. a comparison between the performance of the Manchester Furniture Department as a whole in August 2018 - July 2019 with that in August 2019 - July 2020.
3. a comparison across all comparable stores of the performances of the Furniture Departments in 2018/19 and in 2019/20.
4. a conclusion in which all of these analyses are pulled together and you assess the potential of the new Section and make a recommendation.
You are not required to give the presentation but you are required to prepare the slides including relevant charts and summary statistics which you would use at such a presentation, together with a set of speaker's notes which highlight and explain the points of information which you would provide verbally.
You should produce a maximum of six slides which contain charts and relevant summary statistics (mean, standard deviation, % changes, indexing etc.) plus a title slide and a concluding slide.(ie a maximum of 8 slides in total).This can be done in word or powerpoint.
These should be in bullet point format and a maximum of two sides of A4.
You should explain clearly but briefly the main points shown by your charts and measures and how these relate to the business problem you are addressing.
Referred Project 2 Analysis & Report
You are required to investigate the data provided and associated factors in order to make a recommendation to the store manager about the whether the development should proceed or not.
a) Use the file Cash flow Referred Project 2021.xls.
The file contains a framework for calculating the quarterly net cash flow to be expected from the development, together with the net present value as a measure of performance. • Investigate the structure of the model to ensure that you understand how it works. Some of the data values have already been input.
• In the cells shaded in blue, enter the remaining data values from the project brief above.
• The cells shaded in grey require formulae to be entered. The formulae will either be single entries in column B, or entries in column C which are then auto-filled across the three years.
• Enter the required formulae and auto-fill across the 3 years where appropriate.
Note that all formulae should be based on cell references — no numerical data values should be entered. You will need to use absolute cell references in a lot of cases.
b) Set your model up for printing in normal view (excel file - analysis submission).
Your model should:
i) show all 3 years
ii) be landscape view and a maximum of 2 pages
iii) contain your name and 'Referred Project 2' as a header iv) show gridlines
v) the headings in rows 5, 6 and 7 should be repeated at the top of each page
c) Once set up as above also save the file as a pdf file (to include in appendix to report) or copy and paste into appendix of report making sure it can be read. The analysis must be in the appendix (at the end) of the Report
d) Write a report (word doc - report submission) for the manager of the Bristol store with the following sections:
Briefly outline the basis of your analysis i.e. what you have done in part a) and explain the meaning of the terms used such as net cash flow, discount factors, present values and net present values and why you have done this i.e. refer to the brief. Initial Conclusion Using the net present value, along with the cash flow, decide whether or not the development is financially worthwhile and explain why/why not.
Identify at least four key factors from the cash flow that you think influence your decision above. Make reasonable changes to the values of these factors and determine how these changes affect your decision above. Determine the value that each key factor would have to take in order to reverse the decision above and comment on its likelihood.
Gather market intelligence on the designer clothing market and Bristol together with details competition.
Draw all of the material together and make a final recommendation. Include any other relevant information. The recommendation must be supported by clear reasons and stem from the evidence you have reported.
CS 340 Milestone One Guidelines and Rubric Overview: For this assignment, you will implement the fundamental operations of create, read, update,
Retail Transaction Programming Project Project Requirements: Develop a program to emulate a purchase transaction at a retail store. This
7COM1028 Secure Systems Programming Referral Coursework: Secure
Create a GUI program that:Accepts the following from a user:Item NameItem QuantityItem PriceAllows the user to create a file to store the sales receip
CS 340 Final Project Guidelines and Rubric Overview The final project will encompass developing a web service using a software stack and impleme
