Question

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

05 Dec 2017
Answer :
Word Count : 591

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

  1. 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).
  2. Data Entry: Enter the actual expenditure amounts for each expense head in the respective cells for each month.

______ ________ _____ ___ _____ _____ ______ _____.
___ ___ ______ _______ ______.
________ _____ ____ _______ ____ ____.
___ __________ _____ ______ _____ __________ _____ ______ _____.
_________ _________ __________ _____ __________ _______.
____ ______ _______ __________ ______ ___ __________.
________ __________ ____ _________ _________ _________ ______ _________ _______ _______.
_______ ___ _______ ___ __________ __________ _____ ____.
_________ ___ _____ ____ _____ _____ ________ _________.
________ _______ _______ ______ ______ __________ ____ __________ ____ _________.
__________ _____ __________ _____ _____ ____.
_________ ______ ______ ________ ___ _____ ____ _________ _____ __________.
_________ ____ _____ ______ _______ _________ _________ __________ _____ _______ ____ _____.
_______ _____ ____ __________ __________ __________ ____ _______.
______ _______ ______ ____ ____ _________ ____.
_________ ____ _______ _______ ___.
________ _________ _______ _________ ________ ________ __________ ______.
___ __________ __________ ________ ____ ________ ____ _____ ___ ____.
_____ __________ ________ ______ _____ ____ ____ ___ _____ ______ _________ _________.
__________ ______ _____ __________ ________ ______ _________.
_______ ______ _____ ____ ________ ____ __________ __________ ___ __________ _________ _____.
_____ _________ ____ ________ _______ __________ _____ _____ ___ ______ ______.
_____ _________ ______ _______ _________ _______ ___ __________ __________ _____ ____.
_____ _____ _________ _____ _________.
______ _______ _______ ___ ___ __________.
___ __________ ____ ____ _______ __________.
______ _______ ________ _______ ______.
________ _________ _______ _________ ______ _____ ____ _______.
____ __________ ___ ________ ____ ______ _________ ____ ______ ________ _______ _____.
_______ _____ ________ ___ _________ ____ ___ __________.
_________ ______ _________ _____ ____ ___ _____ ______ ____ ________ ___.
________ ________ ____ ______ _____ __________ _________ ___ _____ _______ _________.
_____ __________ _____ ________ ____ ______ ___ _____ _________ ____ ______ ______.
_______ _____ ___ _______ ___.
_________ ______ _______ ___ ___ __________.
__________ ____ _______ ______ ________.
__________ _______ ________ __________ ____ ________ ____ ______ _____ ___.
_________ ________ _____ ___ ______ ________ _______ _______ ______ ____.
___ ___ ______ ___ ____ ____ ____ _________.
________ ________ ______ __________ _____ ___ ___ _________.
_________ ______ _____ _______ _______ __________.
______ ______ ________ _____ _______ ____ ______ _______ ____ _________.
__________ _________ _______ _______ ____ _______ _________ ___.
_____ ______ _______ __________ ___ _________ ____ ________ _____.
___ ____ ___ ____ ____ ________ _____.
______ _________ _________ ___ ____ ______ ______ _______.
_____ _________ ____ ___ ____.
_________ __________ _________ ______ ________ _______ _____ _______ _________ ______ ________ _________.
__________ ___ _________ _____ ____ __________ ________ ________.
_________ _____ _________ ___ ____ ____ ___ ____ __________ __________.
___ ______ _______ __________ _____ _________ __________ _______ ______ _________ _________.
____ _________ _____ _______ ______ ______ __________ ________ __________ _______ __________ ___.
_______ ___ _____ __________ ______.
IGNOU ACADEMY
Your IGNOU journey, made easier.
  • Solved Assignments
  • Study Notes
  • Guess Papers
  • Question Papers
Skip in 10
Top
📞
Call Support Instant phone assistance IGNOU MFN 10 2017 2018 - You are the manager of a canteen. Create a worksheet using excel maint | IGNOU Academy
→
🟢
WhatsApp Chat Fast live messaging
→
Email Us Business enquiries & support
→