Question: Using the data below: 1. please enter the data into an Excel spreadsheet, 2. categorize the expenses into the appropriate accounts 3. Prepare a summary
Using the data below: 1. please enter the data into an Excel spreadsheet, 2. categorize the expenses into the appropriate accounts 3. Prepare a summary report of September's expenses with the total expenditures for each category (use graphs as necessary) 4. Calculate the monthly profit, given the monthly revenue for September is $77,000.00
Office Supplies:
a. Receipt #001: Date - 09/05/2023, Amount $250.00
b. Receipt #002: Date - 09/12/2023, Amount $180.00
c. Receipt #003: Date 09/20/2023, Amount $300.00
Utilities:
a. Invoice #U12345: Date-09/10/2023, Amount $800.00
b. Invoice #U12346: Date-09/25/2023, Amount $750.00 c. Invoice #U12347: Date-09/15/2023, Amount $850.00
Marketing:
a. Invoice #M56789: Date-09/15/2023, Amount $1,200.00 b. Invoice #M56790: Date-09/28/2023, Amount $980.00 c. Invoice #M56791: Date-09/05/2023, Amount $1,500.00
Rent:
a. Invoice #R98765: Date 09/01/2023, Amount $3,500,00
Salaries for Staff:
a. Payroll #S001: Date 09/30/2023, Amount $8,000.00 (Total monthly payroll) b. Payroll #S002: Date 09/15/2023, Amount $4,000.00 (Mid-month payroll)
Salaries for Teachers: a. Payroll #T001: Date 09/30/2023, Amount $13,000.00 (Total monthly payroll)
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
