AutoSave OFF su NGT31488 Quc Home Insert Draw Page Layout Formulas Data Review View Tell me Share Q Comments fx . v Ifx V Text N o P Q ? A Define Name Es Trace Precedents Calculate Now Fa Trace Dependents Insert AutoSum Recently Financial Logical Date & Lookup & Math & More Show Error Create from Selection Function Calculation calculate Sheet Used Time Reference Trig Functions FRemove Arrows Formulas Checking Options J11 xv fx A B D E F G H J K L M 3 4 The contractor's proposal is for a base contract in the current year with priced options for years two and three. 5 6 The proposed raw material cost in the base contract is $100,000. 7 8 9 (i.e., year two is 2.5% more than year one, and year three is 2.5% more than year two). 10 The contractor has a proposed material scrap rate of 4%. 11 12 The proposed material handling cost (indirect cost) is 6% of the subtotal cost of raw materials. 13 14 Organize your spreadsheet such that a co-worker could replicate your work. 15 16 Contractor's Given Data Rates and Factors Cost Breakdown by Year 17 18 Cost Element Year 1 Year 2 Year 3 Cost Eleme Year 1 Year 2 Year 3 Cost Eleme Year 1 Year 2 Year 3 19 20 Raw Materials $100,000 $102,500.0 $105,062.5 Material Escalation Rate Raw Materials 21 22 Material Scrap Factor Scrap 23 24 Subtotal Materials 25 26 Material Handling Cost Materials Handling 27 28 Total 29 30 31 32 Q1 Q2 Q3 Q4 Q5 Sheet3 Sheet4 + Ready A + 142%