To complete this assignment you will need to download the Project_03-V4.docx and IT Budget Excel Workbook.
In thisProjectassignment you will evaluate, synthesize, and complete the following:
- IT Department Budget Tab: This is the IT Budget Dashboardwhich will self-populate when the other worksheets have been completed. You will use the dashboard line items to compare the budget numbers provided in the Project-03 guideline document.
- IT Department Budget Worksheet Tab– This is the primary worksheet used to formulate the IT budget. You will complete all of the IT budget sections (e.g., Personnel, Computing Equipment, Software, Enterprise Data Center, and General & Administrative) by entering the appropriate dollar values for each month. You will need complete and/or use the other worksheet tabs in the IT Budget workbook (e.g., G& A, Personnel, and Software-Equipment-Services) to properly complete the IT Department Budget Worksheet.
- Software-Equipment-Service Worksheet Tab: This worksheet does need to be analyzed, modified, and referenced to complete the corresponding G&A budget line items in the IT Department Budget Worksheet. You will need to determine the correct “Expenditure Type” (CAPEX or OPEX) by first completing the Software-Equipment-Services worksheet and then make the corresponding budget line item entry and amount into the IT Department Budget Worksheet.
- Personnel Worksheet Tab: This worksheet does need to be analyzed and referenced to complete the corresponding Personnel budget line items in the IT Department Budget Worksheet (e.g., Item names, estimated costs, salaries, head-counts per month, billing frequency, occurrence, and billing month).
Complete the IT Budget workbook as outlined in the Project-03 document. Submit completed IT Budget Workbook;