Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Please complete the budgeting analysis by filling out the chart below. you must use excel for credit Fringe benefits, both budgeted and actual) are 45.2%

image text in transcribed
Please complete the budgeting analysis by filling out the chart below. you must use excel for credit Fringe benefits, both budgeted and actual) are 45.2% of Salaries Equipment is budgeted at 3% less than supplies but actual dollars spent were 4.2% less than budgeted What is your observation of each line item? Adopted vs Actual Budget (Fiscal Year Ended 12/31/2019) LIU HEALTHCARE WALK-IN CLINIC EXPENDITURES BY TYPE End of Year (December Adopted Budget in 2019 beginning of Actual/Spent) (January 2019) Year Percent Percent of Change Total Net Change Budgeted vs. Expenditures (Variance) Actual Spent Analysis/Observation Personnel Expenditures Salaries $1,855,250 $1,655,250 Fringe Benefits $1,855,250 $1,655,250 Total Personnel Expenditud Operating Expenditures Supplies $525,000 $450,000 Equipment Subtotal Operating Expenditures Total Expenditures

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

Accounting

Authors: Carl S. Warren, Philip E. Fess, James M. Reeve, C.Rollin Niswonger, Jim Reeve

18th Edition

0538839333, 978-0538839334

More Books

Students also viewed these Accounting questions

Question

Describe some common hazards in the contemporary workplace

Answered: 1 week ago