Create Budget Spreadsheet
QuTee1
pp610_unit07_checklist.docUnit 7 Assignment
Budget for CRAC
Utilizing one of the excel templates provided, or a budget of your own design, submit a budget for the Cryonic Regulatory and Advisory Commission. Although your budget may not require entries for all of the items listed in the template, the expenditures should include all administrative, human resources, and facilities costs, as well as a revenue source. The budget must be balanced, self-funded, and have a net zero cost. Be certain to allow for the cost of evaluating performance.
The templates provided include, as an example, the following types of broad expenditures (sub-categories would also be included, i.e. a chart of accounts)
· Salaries and Benefits
· Facility Purchase/Lease
· Utilities
· Maintenance
· Equipment Purchase
· Equipment Rentals
· Service Contracts
· Travel and Conference
· Communications/Telecommunications/Information Technology Costs
· Other
You should also submit a budget narrative that explains and justifies the items of the budget. In particular, focus on the human resource costs, administrative costs, and the revenue sources. The narrative concerning the revenue sources should include an explanation of the sustainability of the source in future budget years. You also want to explain the milestones for evaluating the program’s success and include any type of contingency plans.
Checklist for the Unit 7 Assignment
|
Criteria: Ask yourself the following questions. |
Not Yet |
Yes |
|
Content |
|
|
|
Did you identify all elements of budget preparation? |
|
|
|
Did you identify the interrelation of all elements required to develop a budget? |
|
|
|
Did you employ all fiscal practices in the development of a balanced budget? |
|
|
|
Did you analyze the budget for accuracy of categorized items in all of the elements set forth below? 1. Expenditures: salaries, benefits, services, supplies 2. Revenues: taxes, user fees, license fees 3. Fund Type: General, special revenue, enterprise, internal service, debt service, restricted, unrestricted 4. Fund Balance: revenues exceed expenditures 5. Net Cost/Contribution: Expenditures exceed revenues 6. Debt: Internal, external, bonds |
|
|
|
Did you create a balanced budget incorporating all of the following elements? 1. Expenditures 2. Revenues 3. Fund Type 4. Fund Balance 5. Net Cost/Contribution 6. Debt |
|
|
|
Did you explain the milestones for evaluating the program’s success and include any type of contingency plans? |
|
|
|
|
|
|
|
Research |
|
|
|
Is your research current ? |
|
|
|
Did you discuss all the required areas in a substantive manner? |
|
|
|
Did you use appropriate reference material to support major statements? |
|
|
|
|
|
|
|
Quality |
|
|
|
Is your content complete enough to address the topic and questions? |
|
|
|
Is there a logical flow to your ideas? |
|
|
|
Did you present the material in a clear and concise manner to provide easy readability? |
|
|
|
|
|
|
|
Format |
|
|
|
Did you prepare your project as both a Microsoft Excel document as well as a Microsoft Word document? |
|
|
|
Did you label your file correctly? |
|
|
|
Did you use APA format to cite your sources? |
|
|
|
Did you check your document for grammar and spelling? |
|
|
|
|
|
|
