Ahmed, the owner of a small clothing shop, realised the importance of analysing the store’s product sales using statistical analysis while studying business in college. He has collected some data but is finding it difficult to analyse it. So he has decided to hire you as his consultant.
The data below shows the number of clothes sold in different price spent by 1000 customers
Amount Spent (AED)
No. of clothing items
NIVE | Assignment Brief | Jan 2016 Page 4 of 6
You are required to calculate and analyse the given data, decide and explain how to represent this data and help Ahmed understand the business impacts of this data on his business.
Task 2 (P2, M1)
2.1 Calculate and analyse the given data to get mean, median and mode and advise Ahmed on the best price range for his clothes. P2.1
2.2 Looking at the results, analyse the data such as the range and standard deviation and how this information will help Ahmed. P2.2
2.3 Identify and show the 25th Percentile (Lower Quartile) and 75th Percentile (Upper Quartile) and explain the use of percentile which would aid Ahmed in making decisions for his shop. P2.3
2.4 Explain how inter-quartile range would help Ahmed make decisions for his business. P2.4
Guidelines: show all formulas and workings clearly, provide explanations where required and the methodology you used to achieve P2. You can achieve M1 by analysing and processing the information/data with more than one variable.
You work in ENOC Petroleum College as a Business Administrator; your manager has provided you with the following data:
You have been asked by the College Management to forecast future sales and profit for the upcoming annual Management Meeting. You should include the following in your answer:
Task 3 (P3, M3, D3)
3.1 Produce a column/bar graph showing sales, cost and profit using Microsoft Excel. P3.1
3.2 Produce a sales and profit scatter graph showing trend lines and project sales and profit for the next five years. P3.2
NIVE | Assignment Brief | Jan 2016 Page 5 of 6
The Management meeting of ENOC Petroleum College is fast approaching and you have been asked to present your findings in the meeting. You have to produce a report and a PowerPoint presentation to the board:
3.3 Use Microsoft PowerPoint to make a presentation (minimum of 10 slides) P3.3
3.3.1. Explain what forecasting is and its benefits to an organisation.
3.2.2. Explain the relation between sales, cost and profit of the organisation.
3.4 Write a formal business report using the correct format to discuss the future prospects of the organisation and show the regression equation separately on the graph.P3.4
Guidelines for Learning Outcome 3: Provide evidence in Task 3 that a range of methods of presentation (such as the production of charts and reports have been used) and technical language has been accurately used to achieve M3.
Demonstrate how you are able to forecast and help in the defined business problem and that convergent and lateral thinking have been applied throughout Task 3 to achieve D3.
The ENOC Petroleum College has the goal of providing world class training to current and future employees and to develop them for future projects. The College needs to develop curriculum, systems, computers etc. for this vocational training. You as consultant need to help develop operational, tactical and strategic programs for the Management.
Task 4 (P4, D2)
4.1 Explain the use of appropriate information processing tools, management information systems, computers and information processing tools for operational, tactical and strategic levels of the organisation, ENOC Petroleum College, and suggest how it is suitable. P4.1
The activities involved in a fashion project for Debenhams are given below:
Developing the concept
Testing the concept
Project presentation and CEO approval
Recruitment and personnel training
Product features amendments
NIVE | Assignment Brief | Jan 2016 Page 6 of 6