Spreadsheet modeling instructions

1. Create a budget table for your project

• You can use the points from the revenue heading
• You can also add any other suitable income
• Assume suitable values for each category
• You can take help from online resources for assuming the amount

1. Create an estimation table for your project

• You can use the points from the expenses heading
• You can also add any other suitable expense
• Assume suitable values for each category
• You can take help from online resources for assuming the amount

1. Create an actual spending table for your project

• You can use the points from the Spending Allocation heading
• You can also add any other suitable expense
• Assume suitable values for each category
• You can take help from online resources for assuming the amount

1. Calculate the total budget
2. Calculate the total estimate
3. Calculate the total actual spending
4. Calculate the difference between estimate and actual spending
5. Calculate the difference between total budget and total estimate
6. Calculate the difference between total budget and total actual spending. Call it your monthly saving.
7. Add your saving and contingency. Call it your annual saving.
8. Calculate the difference between total estimate and total actual spending
9. First, identify if the difference between the total budget and the total actual spending is positive or negative. If it is negative then make changes accordingly, and include the details of the change in the Monitoring and control section.
10. Secondly, identify if the difference between the total estimate and the total actual spending is positive or negative. If it is negative then make changes accordingly, and include the details of the change in the Monitoring and control section.
11. Create a pie chart for the budget
12. Create a pie chart for the actual spending
13. Create a pie chart for the estimation
14. Create a bar/column chart for the actual and estimate spending
15. Create a combo chart of the actual spending, estimate, and their difference. Show the difference using a line and the actual and estimate as bars/columns in this chart
16. Create a line chart of the budget. Identify a trend. If no trend exists, then adjust the values accordingly
17. Create a line chart of the actual spending. Identify a trend. If no trend exists, then adjust the values accordingly. Adjust these values by making a separate table for each change, and include the change in estimate and actual spending. Highlight the changed values. (Note: remember some values cannot be changed since they are absolute value, e.g., the university fees in the example discussed during the class)
18. Explain the results obtained from point d to point m in the conclusion section
19. Explain the charts obtained from point n to point t in the conclusion section

Project submission guidelines

1. Create a .zip or .rar folder, and include the excel file, the word file, and the pdf file into the folder, and upload the folder on LMS before the deadline.
2. For the pdf file, you are to generate a pdf file by converting the word file to pdf.
3. When you come for viva, bring a printed copy of the report
4. Your report will be checked for plagiarism. Including AI plagiarism