You are the manager of a canteen. Create a worksheet using excel maintaining the monthly expenses of the canteen under various heads, for a year. Your assignment should contain: Formulas that automatically calculate You must find the average expenses per month Automatically find the month when the minimum amount was spent Create a chart for head wise expenditure per month
To manage the monthly expenses of a canteen efficiently using Microsoft Excel, I would create a worksheet that tracks various heads of expenses over a year. The data can be organized into categories such as food costs, staff salaries, utilities, maintenance, and miscellaneous expenses. The goal is to automate the calculations and create a clear overview of the canteen’s financial performance each month.
Step 1: Organizing the Data
-
Columns and Rows Setup:
- Column A: Month (January to December).
- Column B to F: Different expense heads, for example, Food Costs, Staff Salaries, Utilities, Maintenance, and Miscellaneous Expenses.
- Column G: Total Expenses (sum of all the expense heads for each month).
- Column H: Cumulative Total Expenses (running total of all expenses till the current month).
-
Data Entry: Enter the actual expenditure amounts for each expense head in the respective cells for each month.
___ ___ ______ _______ ______.
________ _____ ____ _______ ____ ____.
___ __________ _____ ______ _____ __________ _____ ______ _____.
_________ _________ __________ _____ __________ _______.
____ ______ _______ __________ ______ ___ __________.
________ __________ ____ _________ _________ _________ ______ _________ _______ _______.
_______ ___ _______ ___ __________ __________ _____ ____.
_________ ___ _____ ____ _____ _____ ________ _________.
________ _______ _______ ______ ______ __________ ____ __________ ____ _________.
__________ _____ __________ _____ _____ ____.
_________ ______ ______ ________ ___ _____ ____ _________ _____ __________.
_________ ____ _____ ______ _______ _________ _________ __________ _____ _______ ____ _____.
_______ _____ ____ __________ __________ __________ ____ _______.
______ _______ ______ ____ ____ _________ ____.
_________ ____ _______ _______ ___.
________ _________ _______ _________ ________ ________ __________ ______.
___ __________ __________ ________ ____ ________ ____ _____ ___ ____.
_____ __________ ________ ______ _____ ____ ____ ___ _____ ______ _________ _________.
__________ ______ _____ __________ ________ ______ _________.
_______ ______ _____ ____ ________ ____ __________ __________ ___ __________ _________ _____.
_____ _________ ____ ________ _______ __________ _____ _____ ___ ______ ______.
_____ _________ ______ _______ _________ _______ ___ __________ __________ _____ ____.
_____ _____ _________ _____ _________.
______ _______ _______ ___ ___ __________.
___ __________ ____ ____ _______ __________.
______ _______ ________ _______ ______.
________ _________ _______ _________ ______ _____ ____ _______.
____ __________ ___ ________ ____ ______ _________ ____ ______ ________ _______ _____.
_______ _____ ________ ___ _________ ____ ___ __________.
_________ ______ _________ _____ ____ ___ _____ ______ ____ ________ ___.
________ ________ ____ ______ _____ __________ _________ ___ _____ _______ _________.
_____ __________ _____ ________ ____ ______ ___ _____ _________ ____ ______ ______.
_______ _____ ___ _______ ___.
_________ ______ _______ ___ ___ __________.
__________ ____ _______ ______ ________.
__________ _______ ________ __________ ____ ________ ____ ______ _____ ___.
_________ ________ _____ ___ ______ ________ _______ _______ ______ ____.
___ ___ ______ ___ ____ ____ ____ _________.
________ ________ ______ __________ _____ ___ ___ _________.
_________ ______ _____ _______ _______ __________.
______ ______ ________ _____ _______ ____ ______ _______ ____ _________.
__________ _________ _______ _______ ____ _______ _________ ___.
_____ ______ _______ __________ ___ _________ ____ ________ _____.
___ ____ ___ ____ ____ ________ _____.
______ _________ _________ ___ ____ ______ ______ _______.
_____ _________ ____ ___ ____.
_________ __________ _________ ______ ________ _______ _____ _______ _________ ______ ________ _________.
__________ ___ _________ _____ ____ __________ ________ ________.
_________ _____ _________ ___ ____ ____ ___ ____ __________ __________.
___ ______ _______ __________ _____ _________ __________ _______ ______ _________ _________.
____ _________ _____ _______ ______ ______ __________ ________ __________ _______ __________ ___.
_______ ___ _____ __________ ______.
- Solved Assignments
- Study Notes
- Guess Papers
- Question Papers
✓ Unlock up to 60% of the answer
✓ No payment required