Management at Global Development Systems (GDS) asks for you to provide a report that will demonstrate...

 

Transcribed Image Text:

Management at Global Development Systems (GDS) asks for you to provide a report that will demonstrate and explain how the budget variance of the PMO Cloud Implementation Project will be analyzed, tracked and monitored. Management is also interested in using conditional formatting to tell if an information technology project is on-budget easily. Instructions Prepare a one-page report explaining how budget variances will be analyzed, tracked and monitored. Demonstrate the use of conditional formatting to tell if an IT project is on-budget easily. Using a Word document, provide a one-page report that will demonstrate and explain how the budget variance of the PMO Cloud Implementation Project will be analyzed, tracked and monitored. Using the conditional formatting tool in Excel, demonstrate how to tell if an information technology project is on-budget easily. Using an Excel Spreadsheet template, create a budget that considers the totals for Hardware, Software, and Labor. Hardware Requirements: Front-end web server- $2,999.00 Application server -$2,999.00 SQL Server -$2,999.00 Software Requirements: Database server (SQL Server) & CAL- $20,000.00 Project Server 2016 Enterprise & CAL - $50,000.00 SharePoint Server 2013 Enterprise & CAL - $40,000.00 Windows Server 2012 (64-bit) - CAL- $9,000.00 Labor: $175.000.00 . Project Project manager Project artifacts Approved Budget $302,997.00 Additional $ needed Internal Expenses Labor 175000 175000 175000 Type of resource Type of resource Type of resource Other Internal Expenses 5000 3000 6000 Total Internal Expenses External Expenses Consulting Costs 3000 5000 2000 Capital Expenditures 10000 15000 20000 Total External Expenses Total Budget Planned Expenditures to Date $11,000.00 Planned Remaining Budget $291,997.00 Hourly Rate $50.00 $50.00 $50.00 $0.00 $0.00 $0.00 Budget Project # Sponsor Updated Budget Status Actual Expenditures to Date $8,500.00 Actual Remaining Budget $294,497.00 Budget Details Budget # Hours 160.00 200.00 180.00 0.00 0.00 0.00 Variance $2,500.00 Variance -$2,500.00 Total Cost $8,000.00 $10,000.00 $9,000.00 $0.00 $0.00 $0.00 Total Cost $13,000.00 $13,000.00 $15,000.00 Total Cost $0.00 $0.00 $0.00 $5,000.00 $7,000.00 $3,000.00 $68,000.00 $15,000.00 $83,000.00 Project Project manager Project artifacts Description Cost of Project Development Salaries Other internal expenses Consulting costs Capital expenditures Total project costs Cost of Support Operational Nonrecurring costs Recurring costs Total ongoing support costs Current Process Total annual price New Process Total annual price Annual savings Cumulative savings Cumulative costs Cumulative total net savings Present Value Future Value $0.00 Cost/Benefit Analysis Project Development and Maintenance Costs FY02 FY03 FY01 Benefits/Savings FY02 FY01 FY03 $25,000.00 $26,000.00 $27,000.00 Project # Sponsor Updated $30,000.00 $32,000.00 $35,000.00 $38,000.00 $5,000.00 $5,500.00 $6,000.00 $6,500.00 $8,000.00 $8,500.00 $9,000.00 $9,500.00 $15,000.00 $16,000.00 $17,000.00 $18,000.00 $19,000.00 $58,000.00 $62,000.00 $67,000.00 $72,000.00 $76,000.00 $0.00 Future Value $4,000.00 $4,200.00 ,500.00 $4,700.00 $5,000.00 $2,000.00 $2,100.00 $2,200.00 $2,300.00 $2,400.00 $3,000.00 $3,100.00 $3,200.00 $3,300.00 $9,000.00 $9,400.00 $9,900.00 $10,300.00 Interest Rate FY04 Present Value Interest Rate FY05 $40,000.00 $7,000.00 $10,000.00 # Periods FY05 FY04 $28,000.00 $29,000.00 $0.00 $22,000.00 $23,000.00 $24,000.00 $25,000.00 $26,000.00 $3,000.00 $3,000.00 $3,000.00 $3,000.00 $3,000.00 $9,000.00 $12,000.00 $15,000.00 $15,000.00 $10,800.00 $0.00 $4,200.00 $15,000.00 $3,000.00 $6,000.00 $9,000.00 $9,400.00 $9,900.00 $10,300.00 -$6,000.00 -$3,400.00 -$900.00 $1,700.00 # Periods $3,400.00 $10,800.00 Total $0.00 Total Future Value $0.00 Present Value $0.00 Period 1 2 3 4 5 Totals Project development cost Net present value Cost/Benefit Analysis Net Present Value Cash Flow $0.00 Present Value $0.00 $0.00 $0.00 Management at Global Development Systems (GDS) asks for you to provide a report that will demonstrate and explain how the budget variance of the PMO Cloud Implementation Project will be analyzed, tracked and monitored. Management is also interested in using conditional formatting to tell if an information technology project is on-budget easily. Instructions Prepare a one-page report explaining how budget variances will be analyzed, tracked and monitored. Demonstrate the use of conditional formatting to tell if an IT project is on-budget easily. Using a Word document, provide a one-page report that will demonstrate and explain how the budget variance of the PMO Cloud Implementation Project will be analyzed, tracked and monitored. Using the conditional formatting tool in Excel, demonstrate how to tell if an information technology project is on-budget easily. Using an Excel Spreadsheet template, create a budget that considers the totals for Hardware, Software, and Labor. Hardware Requirements: Front-end web server- $2,999.00 Application server -$2,999.00 SQL Server -$2,999.00 Software Requirements: Database server (SQL Server) & CAL- $20,000.00 Project Server 2016 Enterprise & CAL - $50,000.00 SharePoint Server 2013 Enterprise & CAL - $40,000.00 Windows Server 2012 (64-bit) - CAL- $9,000.00 Labor: $175.000.00 . Project Project manager Project artifacts Approved Budget $302,997.00 Additional $ needed Internal Expenses Labor 175000 175000 175000 Type of resource Type of resource Type of resource Other Internal Expenses 5000 3000 6000 Total Internal Expenses External Expenses Consulting Costs 3000 5000 2000 Capital Expenditures 10000 15000 20000 Total External Expenses Total Budget Planned Expenditures to Date $11,000.00 Planned Remaining Budget $291,997.00 Hourly Rate $50.00 $50.00 $50.00 $0.00 $0.00 $0.00 Budget Project # Sponsor Updated Budget Status Actual Expenditures to Date $8,500.00 Actual Remaining Budget $294,497.00 Budget Details Budget # Hours 160.00 200.00 180.00 0.00 0.00 0.00 Variance $2,500.00 Variance -$2,500.00 Total Cost $8,000.00 $10,000.00 $9,000.00 $0.00 $0.00 $0.00 Total Cost $13,000.00 $13,000.00 $15,000.00 Total Cost $0.00 $0.00 $0.00 $5,000.00 $7,000.00 $3,000.00 $68,000.00 $15,000.00 $83,000.00 Project Project manager Project artifacts Description Cost of Project Development Salaries Other internal expenses Consulting costs Capital expenditures Total project costs Cost of Support Operational Nonrecurring costs Recurring costs Total ongoing support costs Current Process Total annual price New Process Total annual price Annual savings Cumulative savings Cumulative costs Cumulative total net savings Present Value Future Value $0.00 Cost/Benefit Analysis Project Development and Maintenance Costs FY02 FY03 FY01 Benefits/Savings FY02 FY01 FY03 $25,000.00 $26,000.00 $27,000.00 Project # Sponsor Updated $30,000.00 $32,000.00 $35,000.00 $38,000.00 $5,000.00 $5,500.00 $6,000.00 $6,500.00 $8,000.00 $8,500.00 $9,000.00 $9,500.00 $15,000.00 $16,000.00 $17,000.00 $18,000.00 $19,000.00 $58,000.00 $62,000.00 $67,000.00 $72,000.00 $76,000.00 $0.00 Future Value $4,000.00 $4,200.00 ,500.00 $4,700.00 $5,000.00 $2,000.00 $2,100.00 $2,200.00 $2,300.00 $2,400.00 $3,000.00 $3,100.00 $3,200.00 $3,300.00 $9,000.00 $9,400.00 $9,900.00 $10,300.00 Interest Rate FY04 Present Value Interest Rate FY05 $40,000.00 $7,000.00 $10,000.00 # Periods FY05 FY04 $28,000.00 $29,000.00 $0.00 $22,000.00 $23,000.00 $24,000.00 $25,000.00 $26,000.00 $3,000.00 $3,000.00 $3,000.00 $3,000.00 $3,000.00 $9,000.00 $12,000.00 $15,000.00 $15,000.00 $10,800.00 $0.00 $4,200.00 $15,000.00 $3,000.00 $6,000.00 $9,000.00 $9,400.00 $9,900.00 $10,300.00 -$6,000.00 -$3,400.00 -$900.00 $1,700.00 # Periods $3,400.00 $10,800.00 Total $0.00 Total Future Value $0.00 Present Value $0.00 Period 1 2 3 4 5 Totals Project development cost Net present value Cost/Benefit Analysis Net Present Value Cash Flow $0.00 Present Value $0.00 $0.00 $0.00