Help? Assessment 4 ECO-FP1100: Assessment 4 Enter data Note:

Help?

Assessment 4

ECO-FP1100: Assessment 4 Enter data Note: Remember to create graphs for each of the three budgets in this template.
Populates Automatically
Current Year Budget $ 1,800,000.00 Year-to-Date Budget $ 1,800,000.00 Proposed Budget
user: user:
You will enter this number after you have populated your budget for next year. You will be entering the number that appears in the blue cell: H23
Proposed Budget Rationale Notes (Note how you built in the considerations from the assignment instructions here: Cost of Living increase; Planning for issues like outdated equipment; Vehicle considerations; Any other specific decisions you made.):
9 months of info (3 Qtrs)
Personnel Personnel Personnel
Salaried Employees 8 FTE $ 600,000.00 Salaried Employees 8 FTE $ 450,000.00 Salaried Employees 8 FTE
Non Salaried Employees 13 FTE $ 450,000.00 Non Salaried Employees 13 FTE $ 298,500.00

user: user:
Some turnover in this area created what appears to be a surplass but you should budget to meet or exceed original budget

Non Salaried Employees 13 FTE
Benefits $ 315,000.00 Benefits $ 224,550.00 Benefits
Operating Funds Operating Funds Operating Funds
Office Supplies $ 30,000.00 Office Supplies $ 30,000.00 Office Supplies
Utilities $ 45,000.00 Utilities $ 34,762.50

user: user:
You were notified of a 3% increase at the start of the new fiscal year and you are over on your projection here now

Utilities
Vehicle Maintenance $ 900.00 Vehicle Maintenance $ 475.00 Vehicle Maintenance
Liability Insurance $ 65,000.00 Liability Insurance $ 48,749.99 Liability Insurance
Contracts $ 38,000.00 Contracts $ 24,750.00 Contracts
Capital Capital Capital
Computers $ 35,000.00 Computers $ 41,950.00 Computers
Vehicles $ 145,900.00 Vehicles $ 124,973.00 Vehicles
Infrastructure $ 65,000.00 Infrastructure $ 73,000.00 Infrastructure
Miscellaneous Miscellaneous Miscellaneous
Petty cash $ 200.00 Petty cash $ 100.00 Petty cash
Other expenses $ 10,000.00 Other expenses $ 3,756.00 Other expenses
$ 1,800,000.00 $ 1,355,566.49 Subtotal (Should Match H4) $ – 0
Note: Remember to create graphs for each of the three budgets in this template.

Share This Post

Email
WhatsApp
Facebook
Twitter
LinkedIn
Pinterest
Reddit

Order a Similar Paper and get 15% Discount on your First Order

Related Questions

CHECK THE FILE 6 Urinary System WORK ON ALL THE HIGHLIGHTED QUESTIONS Key Terms

CHECK THE FILE 6 Urinary System WORK ON ALL THE HIGHLIGHTED QUESTIONS Key Terms Gross Structures of the Kidney Renal cortex __________________________________________________________________________________________ ______________________________________________________________________________________________________ Renal medulla ________________________________________________________________________________________ ______________________________________________________________________________________________________ Renal pyramid _______________________________________________________________________________________ ______________________________________________________________________________________________________ Renal column ________________________________________________________________________________________ ______________________________________________________________________________________________________ Renal pelvis __________________________________________________________________________________________ ______________________________________________________________________________________________________ Major and minor calyces ___________________________________________________________________________ ______________________________________________________________________________________________________ Other Structures of the Urinary