3. Use the activity duration schedule provided From the project activity list and activity duration schedule, determine the Total Budgeted Cost (TBC) for the Astin Martin Electronics project. Provide the information in table format mu. ijectiye evidence of derived costs is required for credit Create the summary diagram as noted below for each high-level task {more it want. but not less}. mm table must be calculated from original data (ie: not copied). There is a potential for data integrity issues when this is done. [Example Template: Does not reflect tasks associated with this assignment. Be sure and remove any examples in your management response document.) 4. Provide a cumulative budgeted cost curve id monthly budget curve for the Astin Marlin Electronics project. Provide in appropriate graph format. This should represent both monthly budget and T30 over the period of performance of the project. Create the representative graphs from the original data. Meaning: Do not copy the data from the schedule and paste in different cells. There is a potential for data integrity issues when this is done. Label the graphs appropriately. Make the graphs consistent with what was presented in the course material. Make clean screen snaps from the objective evidence document and paste into the management response document. X AutoSave Off data Search (Alt+Q) A 8 X File Home Insert Page Layout Formulas Data Review View Help Comments Share Calibri ~ 11 ~ A" A = = =2 al Wrap Text Accounting AutoSum AY O BIUVFDAY E Merge & Center $ ~ % 9 Conditional Format as Cell Fill Paste Insert Delete Format Sort & Find & Analyze Formatting Table Styles v Clear Filter * Select Data Undo Clipboard Font Alignment Number Styles Cells Editing Analysis AA25 vi X fx =(Z25*0.064)+(Z25*0.051)+(Z25*0.022)+(Z25*0.019)+(Z25*0.062) Tarkr Project Management Employee Work Hours Labor Rate Labor Cart Overhead Total Employee Work Hours Later Rate Labor Cart Overhead Total Employee Work Hours Labor Fiate Labor Cart Overhead Total Employee Work Hours Labor Rate Labor Cart Overhead Total Employee Work Hours Labor Rate Labor Cart Overhead Total Employee Work Hours Labor Rate Labor Cart Overhead Total Employee Work Hours Labor Fate Labor Cart Overhead Total 46.61 to the " 49.38 5 Code and Unit Test 1.3.2 (modules 3,4) 8 3 12 38 5 D 5 41 38 3 43.38 53,31040 $ Code and Unit Test 3 modules 5.6) S.Yet FREE 19 38 53,310.40 Derive Sell-Off Acceptance Criteria LSDE $2.01 5 ECECE HE SEEM 52.01 Derive Syshim and Enterprise 1.5/ 3.6 Exitube Function Test BELEG LISTE 53 21 STE3 LSTE arform Envin STE! BEE BE . .. . .. Run Test er Live ESTE Environment STET Environment STEZ D 5 47 25 332 96 STE3 Quality Control Provide Quality Check - in in in in in in . .. new quality Chick EDE 565 Provide Quality Chuck - . . ..... To Ship Review ind Acceptance Test Monthly Totalr: System Engineer 1 System Engineer 3 Load System Engineer Software Engineer 1 Software Engineer 3 Lead Software Engineer Activity Cost Detail + Ready 1Accessibility: Good to go Display Settings 0 - - 36% W P X 3:23 PM 4/27/2022 17