Coursework 1: Analysis of Expenditure, Project Management, and Financial Planning

Coursework 1

Contents
PART 1...................................................................................................................................................5
TASK 1....................................................................................................................................................5
(a) Find the sum and variance in excel...............................................................................................5
(b) Interpret and analyze mean and standard deviation...................................................................5
TASK 2....................................................................................................................................................5
(a) Construct the three tables in excel and paste it here by calculate the value given......................5
(b) Why there is a difference in the mean and standard deviation of grouped and ungrouped data
and which one is more accurate?......................................................................................................6
(c) Give a comment on the minimum amount of the consumer needs estimated to spend on the
top 25% of the expenditure...............................................................................................................7
TASK 3....................................................................................................................................................7
Give the difference between the cross – sectional data and time series data with reference to the
examples considering the demographic profile and lifestyle nature of the consumers....................7
TASK 4....................................................................................................................................................8
(a) Draw a network diagram which shows the movement of forwards and backward passes..........8
(b) Identify the critical path and duration of the project...................................................................9
(c) Distinguish between critical and non – critical activities............................................................10
TASK 5..................................................................................................................................................10
(a) Construct a correlation matrix and calculate the coefficients between quarterly sales and total
cost and average order value and gross profit................................................................................10
(b) Identify the best predictor of the quarterly sales, explain the reason.......................................10
(c) Draw a scatter graph and show a trend line of the regression equation....................................11
(d) Interpret the coefficient of correlation and determination........................................................11
(e) State the equation of regression and interpret the value of intercepts.....................................11
TASK 6..................................................................................................................................................12
1. Calculate the coefficients of variation for business A and B........................................................12
2. By assuming that the risk of retailer is negative, which project should be chosen?....................12
TASK 7..................................................................................................................................................12
Give a reflective learning through the project.................................................................................12
PART 2.................................................................................................................................................12
1. Estimate the variable cost through high – low method...............................................................12
2. Calculate the monthly fixed cost.................................................................................................13
3. Calculate break even of January 2021.........................................................................................13
4. How many t-shirts should be sold to achieve the target profit in January 2021..........................13
5. Calculate margin of safety...........................................................................................................13

6. Interpret the above calculations..................................................................................................13
REFERENCES........................................................................................................................................14

PART 1
TASK 1
(a) Find the sum and variance in excel sheet.
Expenditure (£) on Stand Mixers
Mean 224.00
Standard Error 6.58
Median 224.00
Mode 224.00
Standard Deviation 75.00
Sample Variance 5625.00
Kurtosis -0.49
Skewness -0.32
Range 301.00
Minimum 68.00
Maximum 369.00
Sum 29120.00
Count 130.00
Coefficient of Variation 33.5%
(b) Interpretation and analysis of mean and standard deviation.
From the data it has been interpreted that, the mean is stated as 224 and standard
deviation is stated as 75. It means that there is a significant difference between the both
factors. Therefore, it is revealing that the data point which are used, are very far from the
value of the mean.
TASK 2
(a) Construction of the three tables in excel and paste it here by calculating the value given.
Table 1
Expenditure (£) Frequency
Frequency
(%)
Under 100 14 11%
100 and under 200 35 27%
200 and under 300 65 50%