To complete this assignment you will need to download the Project_03-V4.docx and IT Budget Excel Workbook.
In this Project assignment 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;