Please help with #1) Figure out the final demand matrix using excel

D E F G H I J K L M N O P Q R S T U A B Given below is the l-O transaction table for the economy in 2002 at the 15 sectors level Sector Name total Output, $Million 2002 01 02 03 04 05 06 07 Agriculture, forestry, fishing and hunting Mining Utilities Construction Manufacturing Wholesale trade Retail trade Transportation and warehousing Information Finance, insurance, real estate, rental, and leasing Professional and business services Educational services, health care, and social assistance Arts, entertainment, recreation, accommodation, and food services Other services, except government Government 08 09 Agriculture Mining Utilities Constructid Manufactu Wholesale Retail trade Transportation and Information Finance, ing Professiona Educationa Arts, enter Other servi Government 72027.7 360.806 0.315709 2762.913 145715.5 10.7198 967.4245 18.9081248 0.277126 1336.728 886.1166 240.901 4855.635 85.8915 1652.654 703.2018 8610.695 61790.01 9234.178 140728.1 73.55701 74.96046 1156.704535 263.8235 696.9176 441.079 295.8188 346.8736 179.2099 7908.863 6330.308 5491.8 372.5055 4674.437 69853.49 4963.093 13179.73 4162.623675 4525.091 20584.27 10619.44 17456.49 17685.27 6003.674 30060.45 1168.306 6620.707 7240.7 717.8021 12207.54 1054.898 2914.043 4487.370718 5315.915 55763.63 4991.464 2562.577 2911.208 2731.69 42455.56 40495.29 17121.51 8406.805 253489.3 1343085 30579.23 28336.78 65415.7894 54210.01 36997.62 70233.65 111366.4 88790.49 62889.93 198599.8 10469.6 2584.404 1339.997 29569.77 192383.9 26780.41 10772.94 8402.002519 7002.778 10809.1 8960.55 18770.32 15181.08 8989.58 29177.23 226.7081 434.2037 53.70217 51238.76 9156.702 839.6306 2382.801 2446.002294 184.658 4355.647 946.1217 2255.19 1997.277 4901.315 280.4944 6872.698 3696.407 22500.8 17890.03 88745.23 27448.7 25889.7 68830.41948 12132.74 12445.81 24083.91 10468.2 8396.575 10332.61 37494.69 383.397 576.4037 1042.188 9058.057 31106.14 7472.398 10265.87 6273.774897 129200.7 28519.69 59294.6 18402.8 9092.332 10635.3 57912.65 29997.79 23392.21 8566.585 35852.83 90116.42 42056.04 90133.53 48353.9839 49034.78 668832.2 157632.5 141140.8 56975.78 76466.28 60557.1 4128.799 22026.29 14339.39 88656.14 385541.6 98829.94 83649.36 57498.7212 112641.7 211713.5 291378.4 124479.5 83147.02 48493.72 247411.4 1057.691 0.4983 129.3146 39.95245 83.98193 426.7004 2036.879 64.58306377 403.2177 72.2651 490.6665 20936.9 405.0829 1686.705 17762.92 317.3099 237.7998 3908.198 3294.787 17091.47 4073.176 5014.203 5172.908418 19197.04 24682.94 42639.23 13557.58 19829.48 6859.981 22847.11 1266.392 373.2081 686.8889 15885.07 20049.16 6404.514 6731.232 5684.373194 7946.299 27454.75 22025.41 12815.04 8500.786 6676.803 25921.13 70.39882 12.90043 261.0917 55.54113 2340.424 6970.223 6252.318 13010.97611 3722.813 6618.426 6335.328 7237.709 7744.289 3201.173 9686.088 271,181.9 184,555.5 315,709.4 1,032,363.1 3,817,360.3 871,528.5 905,319.6 590,878.9 923,751.9 3,525,127.0 2,083,509.6 1,271,245.5 744,364.0 566,940.6 2,076,198.4 10 11 12 13 14 15 One biofuel technology makes $1000 product with $300 crops and $400 cost in manufacturing. Find the total supply chain purchases 1 figure out final demand matrix (5') 2 calculate requirement matrix (15') 3 solve for total supply chain (20") D E F G H I J K L M N O P Q R S T U A B Given below is the l-O transaction table for the economy in 2002 at the 15 sectors level Sector Name total Output, $Million 2002 01 02 03 04 05 06 07 Agriculture, forestry, fishing and hunting Mining Utilities Construction Manufacturing Wholesale trade Retail trade Transportation and warehousing Information Finance, insurance, real estate, rental, and leasing Professional and business services Educational services, health care, and social assistance Arts, entertainment, recreation, accommodation, and food services Other services, except government Government 08 09 Agriculture Mining Utilities Constructid Manufactu Wholesale Retail trade Transportation and Information Finance, ing Professiona Educationa Arts, enter Other servi Government 72027.7 360.806 0.315709 2762.913 145715.5 10.7198 967.4245 18.9081248 0.277126 1336.728 886.1166 240.901 4855.635 85.8915 1652.654 703.2018 8610.695 61790.01 9234.178 140728.1 73.55701 74.96046 1156.704535 263.8235 696.9176 441.079 295.8188 346.8736 179.2099 7908.863 6330.308 5491.8 372.5055 4674.437 69853.49 4963.093 13179.73 4162.623675 4525.091 20584.27 10619.44 17456.49 17685.27 6003.674 30060.45 1168.306 6620.707 7240.7 717.8021 12207.54 1054.898 2914.043 4487.370718 5315.915 55763.63 4991.464 2562.577 2911.208 2731.69 42455.56 40495.29 17121.51 8406.805 253489.3 1343085 30579.23 28336.78 65415.7894 54210.01 36997.62 70233.65 111366.4 88790.49 62889.93 198599.8 10469.6 2584.404 1339.997 29569.77 192383.9 26780.41 10772.94 8402.002519 7002.778 10809.1 8960.55 18770.32 15181.08 8989.58 29177.23 226.7081 434.2037 53.70217 51238.76 9156.702 839.6306 2382.801 2446.002294 184.658 4355.647 946.1217 2255.19 1997.277 4901.315 280.4944 6872.698 3696.407 22500.8 17890.03 88745.23 27448.7 25889.7 68830.41948 12132.74 12445.81 24083.91 10468.2 8396.575 10332.61 37494.69 383.397 576.4037 1042.188 9058.057 31106.14 7472.398 10265.87 6273.774897 129200.7 28519.69 59294.6 18402.8 9092.332 10635.3 57912.65 29997.79 23392.21 8566.585 35852.83 90116.42 42056.04 90133.53 48353.9839 49034.78 668832.2 157632.5 141140.8 56975.78 76466.28 60557.1 4128.799 22026.29 14339.39 88656.14 385541.6 98829.94 83649.36 57498.7212 112641.7 211713.5 291378.4 124479.5 83147.02 48493.72 247411.4 1057.691 0.4983 129.3146 39.95245 83.98193 426.7004 2036.879 64.58306377 403.2177 72.2651 490.6665 20936.9 405.0829 1686.705 17762.92 317.3099 237.7998 3908.198 3294.787 17091.47 4073.176 5014.203 5172.908418 19197.04 24682.94 42639.23 13557.58 19829.48 6859.981 22847.11 1266.392 373.2081 686.8889 15885.07 20049.16 6404.514 6731.232 5684.373194 7946.299 27454.75 22025.41 12815.04 8500.786 6676.803 25921.13 70.39882 12.90043 261.0917 55.54113 2340.424 6970.223 6252.318 13010.97611 3722.813 6618.426 6335.328 7237.709 7744.289 3201.173 9686.088 271,181.9 184,555.5 315,709.4 1,032,363.1 3,817,360.3 871,528.5 905,319.6 590,878.9 923,751.9 3,525,127.0 2,083,509.6 1,271,245.5 744,364.0 566,940.6 2,076,198.4 10 11 12 13 14 15 One biofuel technology makes $1000 product with $300 crops and $400 cost in manufacturing. Find the total supply chain purchases 1 figure out final demand matrix (5') 2 calculate requirement matrix (15') 3 solve for total supply chain (20")