Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Please explain this! On an excel spreadsheet you will use the following expense to fill out spread sheet entering each check number for payment starting

Please explain this! On an excel spreadsheet you will use the following expense to fill out spread sheet entering each check number for payment starting with check 101 on your spread sheet. the budget sheet is attached with the first quarter budget being $4, 987. title the excel sheet as follow rent, utilities, postage, lab/Xray, medical, office supplies, wages, insurance and taxes. Then after excel spread sheet is completed then you will answer following question from sheet to answer question in 500 word. This is a sample sheet and not original paper. I need to get clear explanation on how to do this.

1. State the given budget for the 1st quarter of the Neurology Department. Explain how much the neurology department was over their budget in total and in your estimation, also explain where the department went over their allotted budget.

2. Discuss and recommend opportunity to reduce waste and cut costs within the McGregor medical center neurology department.

3. Indicate at least two different strategies that you will implement to improve the overall finances of the department in the second quarter. be sure that the strategies are detailed. remember to use supporting data, scholarly , and knowledge gained from the course. image text in transcribed

McGregor Medical Center Neurology Department First Quarter Budget First Quarter Budget is $4,987 $1700.00 $850.00 $37.89 $384.57 $683.84 $32.00 $55.00 Jan 1 Payment to LaJolla Property Management for rent Jan 1 Payment to Anderson Janitorial for monthly office cleaning Jan 1 Payment to Office Depot for fax machine paper Jan 4 Payment to Pacific Telephone for monthly telephone services Jan 7 Payment to Pacific Gas Company for monthly gas and electric, Jan 10 Cash for stamps at the post office Feb 1 Payment to Uni Lab for bloodwork Feb 4 Payment to Harris Medical Supply for general medical supplies Feb 5 Payment to MediQuik X-Ray Feb 8 Payment to Staples Office Supply for general office supplies Feb 12 Payment to City Laundry (uniforms and towels Mar 1 Payment to Toni Guzzi (payroll) Mar 4 Payment to Terri Smart (payroll) Mar 7 Payment to Janet Garcia (payroll) Mar 12 Payment to James Smith (payroll), Mar 15 Payment to Toni Guzzi (reimbursement for travel expenses) Mar 20 Stamps at post office from petty cash Mar 21 Payment to MediQuik X-Ray Mar 25 Payment to World Wide Insurance Mar 30 Payment to IRS $75.00 $32.50 $68.24 $125.00 $176.08 $289.84 $125.00 $278.76 $12.50 $64.00 $35.87 $189.00 $537.00 McGregor Medical Center Neurology Department First Quarter Budget First Quarter Budget is $4,987 $1700.00 $850.00 $37.89 $384.57 $683.84 $32.00 $55.00 Jan 1 Payment to LaJolla Property Management for rent Jan 1 Payment to Anderson Janitorial for monthly office cleaning Jan 1 Payment to Office Depot for fax machine paper Jan 4 Payment to Pacific Telephone for monthly telephone services Jan 7 Payment to Pacific Gas Company for monthly gas and electric, Jan 10 Cash for stamps at the post office Feb 1 Payment to Uni Lab for bloodwork Feb 4 Payment to Harris Medical Supply for general medical supplies Feb 5 Payment to MediQuik X-Ray Feb 8 Payment to Staples Office Supply for general office supplies Feb 12 Payment to City Laundry (uniforms and towels Mar 1 Payment to Toni Guzzi (payroll) Mar 4 Payment to Terri Smart (payroll) Mar 7 Payment to Janet Garcia (payroll) Mar 12 Payment to James Smith (payroll), Mar 15 Payment to Toni Guzzi (reimbursement for travel expenses) Mar 20 Stamps at post office from petty cash Mar 21 Payment to MediQuik X-Ray Mar 25 Payment to World Wide Insurance Mar 30 Payment to IRS $75.00 $32.50 $68.24 $125.00 $176.08 $289.84 $125.00 $278.76 $12.50 $64.00 $35.87 $189.00 $537.00

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Unlimited Business Financing

Authors: Trent Lee, Dr Chad Lee

1st Edition

1934275050, 9781934275054

More Books

Students also viewed these Finance questions