Assignment-03

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;