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

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Finance Questions!