Please also show the method and how you got the answer. 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.e. 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's contribution to the subtotal cost. Note: please show your calculate steps: You could submit your answer and calculations to the 2nd questions in Excel Perm Description Bill Est Unit Labour Owned Material Material Equipt Rented Equipt Subs Total DC IDC Spread Subtotal Cost Contingency Cost Margin Spread Total Bid Price Bid Price 1 1 37000 110000 0 2.1 316300 42000 0 1570000 80000 0 8000 5 5450 2.2 79000 82000 m 55000 62000 7000 6200 m3 m2 594000 68000 462000 1376000 255000 14320 0 40000 0 3.1 0 2300 2300 T 120000 38500 160000 58000 550 520 m 26000 0 675000 6000 0 Site Establishment Bulk Excavation Detailed Excavation Formwork for Footings Reinforcement for Foolings Concrete for footings Drilling of rock- Provisional Excavating of Rock-Provs. Erect Bridges Traffic Diversion - Prime Cost Landscaping TOTALS 11000 11000 m 400000 71000 0 550000 1670000 8500 8500 m3 355000 46000 453000 53000 0 0 0 5.1 10 1 0 item 0 0 0 0 2100000 1 1 Ls Ls 0 0 0 0 0 0 0 0 900000 455000 0 Detailed Estimating and Bidding Example of front-end loading of bid prices TENDER SUMMARY Description B st Unit Labour Temp Perm Material Material Owned Equip Rented Equiot Subs Total DC 10C Spread Subtotal Conting Cos! Spread Margin Spread Total Bid Price Bid Rate Bid Price LS 1.1 River Diversion 35000 5000 50000 100000 10000 0 206000 300000 50000 400000 540014960314960914960314 21 Excavate Foundations 77000 30000 m3 316300 154000 450000 135600 1055900 450000 1505900 100000 161642 1767542 22 16 1787542 8.1 Excavate rock 320000 35000031591000 1878000 0 473000 1000000 0 4942000 5000005542000 0 594873 613887319.18 6136873 and deliver 16.1 Dirl grout holes provis. 600 800 m 39800 7400 38000 0 0 79000 0 79000 O MRO 17480 145.80 87480 162 Grouting provisional 2000 2000 bags 148400 37800 112000 o o 299000 298000 o 31987329987 164.99229987 0600000 600000 600000 0 6 00000 600000 600000 17.1 Metalwork prime cost 20.1 Concrete in pier shatts 460 485m 164356280 58200 of 9850 370094565 150000244565 0 26251 270816 588.73 270816 TOTALS 1 2140735205220145800 11730001161550 603700727565 1500000 6775488500000 87754710152012 1 015912 Indirect costs - 1500000 Contingency - 500000 Indirect costs and contingency spread to front-end load bid Margin 10% of subtotal costs 0.1046775465 - 877547 Total subfotal 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.e. 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's contribution to the subtotal cost. Note: please show your calculate steps: You could submit your answer and calculations to the 2nd questions in Excel Perm Description Bill Est Unit Labour Owned Material Material Equipt Rented Equipt Subs Total DC IDC Spread Subtotal Cost Contingency Cost Margin Spread Total Bid Price Bid Price 1 1 37000 110000 0 2.1 316300 42000 0 1570000 80000 0 8000 5 5450 2.2 79000 82000 m 55000 62000 7000 6200 m3 m2 594000 68000 462000 1376000 255000 14320 0 40000 0 3.1 0 2300 2300 T 120000 38500 160000 58000 550 520 m 26000 0 675000 6000 0 Site Establishment Bulk Excavation Detailed Excavation Formwork for Footings Reinforcement for Foolings Concrete for footings Drilling of rock- Provisional Excavating of Rock-Provs. Erect Bridges Traffic Diversion - Prime Cost Landscaping TOTALS 11000 11000 m 400000 71000 0 550000 1670000 8500 8500 m3 355000 46000 453000 53000 0 0 0 5.1 10 1 0 item 0 0 0 0 2100000 1 1 Ls Ls 0 0 0 0 0 0 0 0 900000 455000 0 Detailed Estimating and Bidding Example of front-end loading of bid prices TENDER SUMMARY Description B st Unit Labour Temp Perm Material Material Owned Equip Rented Equiot Subs Total DC 10C Spread Subtotal Conting Cos! Spread Margin Spread Total Bid Price Bid Rate Bid Price LS 1.1 River Diversion 35000 5000 50000 100000 10000 0 206000 300000 50000 400000 540014960314960914960314 21 Excavate Foundations 77000 30000 m3 316300 154000 450000 135600 1055900 450000 1505900 100000 161642 1767542 22 16 1787542 8.1 Excavate rock 320000 35000031591000 1878000 0 473000 1000000 0 4942000 5000005542000 0 594873 613887319.18 6136873 and deliver 16.1 Dirl grout holes provis. 600 800 m 39800 7400 38000 0 0 79000 0 79000 O MRO 17480 145.80 87480 162 Grouting provisional 2000 2000 bags 148400 37800 112000 o o 299000 298000 o 31987329987 164.99229987 0600000 600000 600000 0 6 00000 600000 600000 17.1 Metalwork prime cost 20.1 Concrete in pier shatts 460 485m 164356280 58200 of 9850 370094565 150000244565 0 26251 270816 588.73 270816 TOTALS 1 2140735205220145800 11730001161550 603700727565 1500000 6775488500000 87754710152012 1 015912 Indirect costs - 1500000 Contingency - 500000 Indirect costs and contingency spread to front-end load bid Margin 10% of subtotal costs 0.1046775465 - 877547 Total subfotal cost of items that receive margin spread - 8775465-600000 - 8175465