Scenario
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
200-300
120
300-400
150
400-500
160
500-600
200
600-700
140
700-800
100
800-900
70
900-1000
60
NIVE | Assignment Brief | Jan 2016 Page 4 of 6
L5
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.
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.
Scenario
You work in ENOC Petroleum College as a Business Administrator; your manager has provided you with the following data:
Year
Sales (AED’000)
Cost (AED’000)
Profit (AED’000)
2002
2500
2000
500
2003
2800
1900
900
2004
3000
2000
1000
2005
3100
2000
1100
2006
3500
1900
1600
2007
3300
1900
1400
2008
3000
1800
1200
2009
2800
1600
1200
2010
2800
1700
1100
2011
3000
1700
1300
2012
3500
1900
1600
2013
3600
1900
1200
2014
3800
1900
1100
2015
3900
2000
1600
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:
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
L5
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.
Scenario
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.
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
Scenario
The activities involved in a fashion project for Debenhams are given below:
Description
Activity
Preceding Activity
Days
Market research
A

4
Developing the concept
B
A
2
Testing the concept
C
A
36
Project presentation and CEO approval
D
B
15
Budget allocation
E
D
4
Recruitment and personnel training
F
E
9
Manufacturing starts
G
F
9
Quality checks
H
C
2
Product prelaunch
I
B
10
Product features amendments
J
D
9
Product launch
K
G,H,I,J
20