Please also show the method and how you got the answer, step by step. Thank you

Unfortunately, only this much information was given to us.

Question 2: (20 points) Complete the attached tender summary form using the following information: Indirect Costs (IDC) = $1,650,000 Contingency (risk/opportunity allowance) = $700,000 Margin- $9% of subtotal cost Distribute both indirect costs and contingency to all appropriate items (i.c. excluding the items that should not receive indirect cost spread or contingency spread as discussed in the lecture), in proportion to their contribution to the total direct cost (DC) (excluding the cost of all items that do not receive indirect cost spread or contingency spread). Distribute margin to all appropriate items (as discussed in the lecture), in proportion to each item' contribution to the subtotal cost Note: please show your calculate steps: You could submit your answer and calculations to the 2 questions in Excel Dewrites Temp Perm Material Material Card Rented wipe Equip 11s 37000 42000 15 55000 594006 80000 68000 55450 25000 400000 160000 Remorcement 2300 on 2300 12000 38500 67500 550 520 26000 1100 167000 Excavating of Recruys 51 10 10 2100000 1 1 0 00000 Erect Bridges Traffic Diversion - Landscaping TOTALS 1 1 0 0 00 450000 Detailed Estimating and Bidding Example of front-end loading of bid prices TENDER SUMMARY Description Bu Est Unit Labour Temp Perm Material Material Subs Total Owned Equipe Renried Equat IDC Spread Subtotal Conting Cost Spread Margin Total Spread Bid Price Final Bid Bid Rate 11 River Diversion 1 1 LS 35000 5000 50000 100000 16000 200000 300000 506000 400000 54314960314960314 21 Excavate Foundations 77000 30000 m3 315300 154000 450000 135600 0 1056900 450000 1505900 100000 161642 1757542 2296 1767542 8.1 Excavate rock 320000 350000 m3 15910001878000 4730001000000 1942000 400000 5542000 5948736136873 10:16 6136873 and deliver 600 800 m 39500 7400 0 38000 0 0 79000 0 79000 8480 87480 145.8087480 16.1 Dirt grout holes provis. 162 Grouting provisional 2000 2000 bags 148400 0 37600 112000 ob 0258000 298000 o 31987329987 164.99 329987 17.1 Metalwork prime cost 1 1 LS 0 0 0 0 of 600000 600000 500000 0 0 00000 600000 600000 201 Concrete in per shatts 460 485m 16436 6280 58200 o 9960 9700 94505 150000 244565 26251 270816 58873 270816 TOTALS 214073520506801458001173000 116156050370072754651500000 B7754455000001877547101520121 0 151012 Indirect costs - 1500000 Contingency - 500000 Indirect costs and contingency spread to front-end load bid Margin = 10% of subtotal costs = 0.10 6775465877547 Total subtotal cost of items that receive margin spread 8775465-600000 = 8175465 Question 2: (20 points) Complete the attached tender summary form using the following information: Indirect Costs (IDC) = $1,650,000 Contingency (risk/opportunity allowance) = $700,000 Margin- $9% of subtotal cost Distribute both indirect costs and contingency to all appropriate items (i.c. excluding the items that should not receive indirect cost spread or contingency spread as discussed in the lecture), in proportion to their contribution to the total direct cost (DC) (excluding the cost of all items that do not receive indirect cost spread or contingency spread). Distribute margin to all appropriate items (as discussed in the lecture), in proportion to each item' contribution to the subtotal cost Note: please show your calculate steps: You could submit your answer and calculations to the 2 questions in Excel Dewrites Temp Perm Material Material Card Rented wipe Equip 11s 37000 42000 15 55000 594006 80000 68000 55450 25000 400000 160000 Remorcement 2300 on 2300 12000 38500 67500 550 520 26000 1100 167000 Excavating of Recruys 51 10 10 2100000 1 1 0 00000 Erect Bridges Traffic Diversion - Landscaping TOTALS 1 1 0 0 00 450000 Detailed Estimating and Bidding Example of front-end loading of bid prices TENDER SUMMARY Description Bu Est Unit Labour Temp Perm Material Material Subs Total Owned Equipe Renried Equat IDC Spread Subtotal Conting Cost Spread Margin Total Spread Bid Price Final Bid Bid Rate 11 River Diversion 1 1 LS 35000 5000 50000 100000 16000 200000 300000 506000 400000 54314960314960314 21 Excavate Foundations 77000 30000 m3 315300 154000 450000 135600 0 1056900 450000 1505900 100000 161642 1757542 2296 1767542 8.1 Excavate rock 320000 350000 m3 15910001878000 4730001000000 1942000 400000 5542000 5948736136873 10:16 6136873 and deliver 600 800 m 39500 7400 0 38000 0 0 79000 0 79000 8480 87480 145.8087480 16.1 Dirt grout holes provis. 162 Grouting provisional 2000 2000 bags 148400 0 37600 112000 ob 0258000 298000 o 31987329987 164.99 329987 17.1 Metalwork prime cost 1 1 LS 0 0 0 0 of 600000 600000 500000 0 0 00000 600000 600000 201 Concrete in per shatts 460 485m 16436 6280 58200 o 9960 9700 94505 150000 244565 26251 270816 58873 270816 TOTALS 214073520506801458001173000 116156050370072754651500000 B7754455000001877547101520121 0 151012 Indirect costs - 1500000 Contingency - 500000 Indirect costs and contingency spread to front-end load bid Margin = 10% of subtotal costs = 0.10 6775465877547 Total subtotal cost of items that receive margin spread 8775465-600000 = 8175465