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

..write about the following death cause and evidence collected:  A –

..write about the following death cause and evidence collected:   A – E  Suicides:  · Blood  · Urine  · Vitreous humor  · Liver tissue   Do a  library and/or web search to find at least one  credible information sourceand use that to explain one reason why the collection of the listed samples could be

Follow the attach instructions to complete this work.Recent Molecular and Cell Research  Subscribe This week we are covering macromolecules

Follow the attach instructions to complete this work. Recent Molecular and Cell Research   Subscribe This week we are covering macromolecules (carbohydrates, proteins, nucleic acids, and lipids), the structure and function of cells, including cellular transport mechanisms.   Find a news article from the  Science Daily ( that describes a recent research

Powder Brows: Soft, Flawless, and Long-Lasting Beauty Powder brows, also known as ombré shading, are a popular semi-permanent makeup technique that

Powder Brows: Soft, Flawless, and Long-Lasting Beauty Powder brows, also known as ombré shading, are a popular semi-permanent makeup technique that delivers soft, powdery, and defined eyebrows with a makeup-like finish. Unlike microblading, which mimics individual hair strokes, powder brows use a shading method to create a gradient effect, transitioning