Help solve. If needed to clear spreadsheet please address where.

The CFO wants to immediately cut company expenses by 10% in 2Q2020. Your business unit's finance partner has approached you with that directive and has informed you that you need to reduce your project's planned expenditures in 2Q2020 by 10%. This reduction only applies to 2Q2020 and does NOT affect your project's overall cost baseline, allowing you to move expenses to future quarters. The finance partner needs you to determine how you are going to do that and report back the next morning so that an aggregate reduction implementation plan can be presented to the CFO. G G H 1 J K L M Jun-20 $180,000 $105 000 $100.000 302020 402020 Jul-20 Aug-20 Sep-20 Oct-20 Nov-20 Dec-20 $210.000 $240,000 $270,000 $270,000 $225,000 $165,000 $120,000 $135,000 $120,000 $120,000 $105,000 $75,000 For each change you make, please comment on the risk Qa Calibri 11. BIUSA f B D E F 1 Week 5 Lab Assignment: Project cost summary 2 3 102020 202020 4 Budget Line item Jan-20 Feb-20 Mar-20 Apr-20 May-20 5 Salaries $120,000 $135,000 $150,000 $150,000 $165,000 6 Contractor labor $75,000 7 Prototypes Rev 1 laty 20, $5,000 each) 8 Lab materials to be used with prototypes (Rev 1) $60,000 9 Equipment rental to test prototypes 10 Prototypes Rev 2 (gty 40, $5,000 each) 11 Lab materials to be used with prototypes (Rev 2) 12 Compliance testing 13 Beta testing expenses 14 Marketing expenses 15 Month totals $120,000 $135,000 $150,000 $150,000 $300,000 16 Quarter totals $405,000 17 Year total 18 19 20 21 Change Made Assessment of the risk to the project $10,000 $10,000 $5,000 $10,000 $10,000 $10,000 $10,000 $10,000 $200,000 $120,000 $10,000 $10,000 $20,000 $385,000 $600,000 $530,000 $340,000 $280,000 $1,330,000 $1,150,000 $3,730,000 $345.000 $395 000 $845.000 The CFO wants to immediately cut company expenses by 10% in 2Q2020. Your business unit's finance partner has approached you with that directive and has informed you that you need to reduce your project's planned expenditures in 2Q2020 by 10%. This reduction only applies to 2Q2020 and does NOT affect your project's overall cost baseline, allowing you to move expenses to future quarters. The finance partner needs you to determine how you are going to do that and report back the next morning so that an aggregate reduction implementation plan can be presented to the CFO. G G H 1 J K L M Jun-20 $180,000 $105 000 $100.000 302020 402020 Jul-20 Aug-20 Sep-20 Oct-20 Nov-20 Dec-20 $210.000 $240,000 $270,000 $270,000 $225,000 $165,000 $120,000 $135,000 $120,000 $120,000 $105,000 $75,000 For each change you make, please comment on the risk Qa Calibri 11. BIUSA f B D E F 1 Week 5 Lab Assignment: Project cost summary 2 3 102020 202020 4 Budget Line item Jan-20 Feb-20 Mar-20 Apr-20 May-20 5 Salaries $120,000 $135,000 $150,000 $150,000 $165,000 6 Contractor labor $75,000 7 Prototypes Rev 1 laty 20, $5,000 each) 8 Lab materials to be used with prototypes (Rev 1) $60,000 9 Equipment rental to test prototypes 10 Prototypes Rev 2 (gty 40, $5,000 each) 11 Lab materials to be used with prototypes (Rev 2) 12 Compliance testing 13 Beta testing expenses 14 Marketing expenses 15 Month totals $120,000 $135,000 $150,000 $150,000 $300,000 16 Quarter totals $405,000 17 Year total 18 19 20 21 Change Made Assessment of the risk to the project $10,000 $10,000 $5,000 $10,000 $10,000 $10,000 $10,000 $10,000 $200,000 $120,000 $10,000 $10,000 $20,000 $385,000 $600,000 $530,000 $340,000 $280,000 $1,330,000 $1,150,000 $3,730,000 $345.000 $395 000 $845.000