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

Help?

Assessment 4

ECO-FP1100: Assessment 4Enter dataNote: Remember to create graphs for each of the three budgets in this template.
Populates Automatically
Current Year Budget$ 1,800,000.00Year-to-Date Budget$ 1,800,000.00Proposed 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)
PersonnelPersonnelPersonnel
Salaried Employees 8 FTE$ 600,000.00Salaried Employees 8 FTE$ 450,000.00Salaried Employees 8 FTE
Non Salaried Employees 13 FTE$ 450,000.00Non 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.00Benefits$ 224,550.00Benefits
Operating FundsOperating FundsOperating Funds
Office Supplies$ 30,000.00Office Supplies$ 30,000.00Office Supplies
Utilities$ 45,000.00Utilities$ 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.00Vehicle Maintenance$ 475.00Vehicle Maintenance
Liability Insurance$ 65,000.00Liability Insurance$ 48,749.99Liability Insurance
Contracts$ 38,000.00Contracts$ 24,750.00Contracts
CapitalCapitalCapital
Computers$ 35,000.00Computers$ 41,950.00Computers
Vehicles$ 145,900.00Vehicles$ 124,973.00Vehicles
Infrastructure$ 65,000.00Infrastructure$ 73,000.00Infrastructure
MiscellaneousMiscellaneousMiscellaneous
Petty cash$ 200.00Petty cash$ 100.00Petty cash
Other expenses$ 10,000.00Other expenses$ 3,756.00Other expenses
$ 1,800,000.00$ 1,355,566.49Subtotal (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