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

  Select two of the unit student learning outcome (USLO) prompts below to respond to in this week’s reflection. Identify receptors related to the

  Select two of the unit student learning outcome (USLO) prompts below to respond to in this week’s reflection. Identify receptors related to the general and special senses.  Identify the structures and functions involved in olfaction.  Identify the structures and functions involved in gustation.  Identify the structures and functions involved