What other analyses can you do? Make comparisons of profit values and observe changes, try to figure out why those observations and behavior exist and what the root causes are by investigating factors that affect profit. Include appropriate graphs.

The following table shows the number of units of a product sold each month by a shop, the amount the shop paid for each unit, and the selling price. Use a spreadsheet to find the total values of sales, costs, income and profit.
What other analyses can you do? Make comparisons of profit values and observe changes, try to figure out why those observations and behavior exist and what the root causes are by investigating factors that affect profit. Include appropriate graphs.

Think outside the box and consider a combination of different options.

Also, use graphs to show your analysis; e.g. trend and fluctuation in sales. Make sure that you provide an analysis for your drawn graphs and you tell a comprehensive story of your conducted quantitative/numerical analysis.

In addition, include backup Excel file in which you conducted numerical analysis and drew graphs.

Last Completed Projects