Question: Section F : Resource allocation and budgeting [To complete this section, follow the instructions in the worksheet F. RESOURCES & BUDGET tab in the MGMT404_Worksheet_template.xlsx
Section F : Resource allocation and budgeting [To complete this section, follow the instructions in the worksheet F. RESOURCES & BUDGET tab in the MGMT404_Worksheet_template.xlsx Excel file. Complete the worksheet, print page 1, and paste your work after removing image below. The Excel template is in the course project overview section.] Methodology 1 Determine the manpower/skills and resource requirements needed for the project (ie, Work, Materials Fixed Ci Cost) 2 Determine the Team Skills/capabilities to do the work 3 Determine the skill gaps and decide whether to oursource or adding more team member with the skills still needed a cost-benefit and risk analysis on oursoucing vs. inhouse. 4 Allocate resources to tasks (to create a resource schedule) and calculate budget requirements Project Resources Allocation & Budgeting Table 1. RESOURCE TYPE: WORK Skills Required for project Qty. Resource Name AVAL. % Hr. Rate A Project Manager 1 IMA PAYNE 100% $4 B Developer 1 1 Enter name 100% $4 C Developer 2 1 Enter name 100% $4 D Data Architect 1 Enter name 100% $5 E Data Specialist 1 Enter name 50% $6 WORK COST imated was Assigned Tasks Mr. Regud Cou 111, 112, 123,122,123,151,152,15.,161 216 s 864 360 $ 1,440 384 $ 1,536 384 $ 1,920 384 1,152 $ 6,912.00 Table 2. RESOURCE TYPE: MATERIAL Material Qty. Unit Cost 1 Software 25 7,000 2 PCS 3 $ 1,000 3 MATERIAL COST Notes Assigned to activity 1.2.3 Needed for remote work Elimded Meleri Cest S 14,000 $ 3,000 $ 17,000 Table 3. RESOURCE TYPE: FIXED COST SWII Gap required Qty. Contractor, Co. Assigned Tasks Developer of training modules 1 John Doe, ABC 1.51. Develop Training Modules b Trainer 1 Jane Doe XYZ 1.5.3 Conduct Training FIXED COST mated Fed con $ 10,000 $ 5,000 $ 15,000 DE ANIBEN DDAIERT DINA Section F : Resource allocation and budgeting [To complete this section, follow the instructions in the worksheet F. RESOURCES & BUDGET tab in the MGMT404_Worksheet_template.xlsx Excel file. Complete the worksheet, print page 1, and paste your work after removing image below. The Excel template is in the course project overview section.] Methodology 1 Determine the manpower/skills and resource requirements needed for the project (ie, Work, Materials Fixed Ci Cost) 2 Determine the Team Skills/capabilities to do the work 3 Determine the skill gaps and decide whether to oursource or adding more team member with the skills still needed a cost-benefit and risk analysis on oursoucing vs. inhouse. 4 Allocate resources to tasks (to create a resource schedule) and calculate budget requirements Project Resources Allocation & Budgeting Table 1. RESOURCE TYPE: WORK Skills Required for project Qty. Resource Name AVAL. % Hr. Rate A Project Manager 1 IMA PAYNE 100% $4 B Developer 1 1 Enter name 100% $4 C Developer 2 1 Enter name 100% $4 D Data Architect 1 Enter name 100% $5 E Data Specialist 1 Enter name 50% $6 WORK COST imated was Assigned Tasks Mr. Regud Cou 111, 112, 123,122,123,151,152,15.,161 216 s 864 360 $ 1,440 384 $ 1,536 384 $ 1,920 384 1,152 $ 6,912.00 Table 2. RESOURCE TYPE: MATERIAL Material Qty. Unit Cost 1 Software 25 7,000 2 PCS 3 $ 1,000 3 MATERIAL COST Notes Assigned to activity 1.2.3 Needed for remote work Elimded Meleri Cest S 14,000 $ 3,000 $ 17,000 Table 3. RESOURCE TYPE: FIXED COST SWII Gap required Qty. Contractor, Co. Assigned Tasks Developer of training modules 1 John Doe, ABC 1.51. Develop Training Modules b Trainer 1 Jane Doe XYZ 1.5.3 Conduct Training FIXED COST mated Fed con $ 10,000 $ 5,000 $ 15,000 DE ANIBEN DDAIERT DINA
