Project Management Data Sheet. Due 7PM Monday 2/12

Data-Driven Decision Making Using Microsoft Excel This assignment must be completed and submitted using a Microsoft Excel spreadsheet (.xls). Provide a origin for each equation you use. Sources must be listed at the depth of the spreadsheet. No designation page or joined formatting is required. Channels of Communication It has been estimated that plan managers exhaust up to 90% of their occasion communicating and your position at Roto Air is usual. Calculate the reckon of practicable channels of despatch if the plan team were to become to nine members, Important: semblance your is-sue. The aggregate reckon of stakeholders, including the plan team, is estimated at 75 community. Calculate how sundry past practicable channels of despatch the joined stakeholders aggravate the team members denote. Important: semblance your is-sue. Benefit Cost Ratio (BCR) Roto Air plans to exhaust $1,000,000 on this plan, fruiting in a aggregate savings of $2,500,000 aggravate the duration of the plan. Calculate the Benefit Cost Ratio. Important: semblance your is-sue. Ignore any goods of the occasion prize of capital. Roto Air as-well considered another plan that would feel hardly affable their needs. It would feel required a $750,000 bombardment and would fruit in a savings of $125,000 per year for 10 years. Calculate the Benefit Cost Ratio. Important: semblance your is-sue. Ignore any goods of the occasion prize of capital. Comparing simply the BCRs, decipher which plan should Roto Air should feel chosen. Ignore any goods of the occasion prize of capital. Payback Period Calculate the payback date for the $1,000,000 bombardment semblancen overhead. Important: semblance your is-sue. Ignore any goods of the occasion prize of capital. Calculate the payback date for the $750,000 bombardment semblancen overhead. Important: semblance your is-sue. Ignore any goods of the occasion prize of capital. Comparing simply on the payback dates, decipher which plan should Roto Air feel chosen. Ignore any goods of the occasion prize of capital. Net Present Prize (NPV) Calculate the Net Present Prize of Roto Air’s $1,000,000 bombardment after a while a $250,000 annual savings for 10 years when the profit reprove averages 3% every-year. Important: semblance your is-sue.