Milestone Two

As you create your department’s budget, consider items such as hiring new staff, training, technology, and any other related costs. Also account for the potential revenue generated as a result of implementing the capital budget item as well as any potential expenses incurred by your department. These should be high- level estimates.
To complete this part of the assignment, the following items, as well as those listed above, must be addressed:
I. Budget (Please Note: Respond to the following critical elements in the proposal outline, with the exception of element G below, which should be
submitted as an Excel spreadsheet)
A. Statements: What statements were utilized for formulating your proposal and why? Select the appropriate statements for analysis and defend
your choices.
B. Expenses: What major expenses are associated with your proposal items?
C. Budgetary Accounts: What budgetary accounts (i.e., salaries) are impacted and in what way?
D. Reasoning: Based on the previous year’s budget data, why did you select these budget items for adjustment over other options?
E. Ratios: Research the various ratio options (including ROI) used for reviewing financial statements. Determine what ratios you will use for your
proposal items and explain why.
F. Ratio Calculations: Using budget statements, formulate calculations that support each recommendation.
G. Projected Departmental Budget: Create a projected departmental budget for the upcoming year that incorporates the costs of the proposed
changes. (This will be submitted as an Excel spreadsheet)
Guidelines for Submission: You will submit two deliverables for this assignment. Your departmental budget must be submitted as an Excel spreadsheet. Your proposal outline must be submitted as a single document. It should be 1–3 pages in length with double spacing, 12-point Times New Roman font, one-inch margins, and citations in APA style where applicable.