2e must be answered with excel 2.An economy is based on four sectors, agriculture (A), energy (E), manufacturing(M), and utilities. Production of a dollar's worth of agriculture requires an input of$0.2 from the agriculture sector, $0.35 from the energy sector, 0.15 frommanufacturing, and 0.05 from utilities. Production of a dollar's worth of energyrequires an input of $0.05 from agriculture, 0.30 from the energy sector and $0.25from the manufacturing sector and 0.20 from utilities. Production of a dollar'sworth of manufacturing requires an input of $0.1 from the agriculture sector, $0.1from the energy sector, $0.3 from the manufacturing sector, and 0.23 fromutilities. Production of a dollar's worth of utilities requires an input of $0.05 fromthe agriculture sector, $0.33 from the energy sector, $0.27 from the|manufacturing sector, and 0.13 from utilities. Find the output from each sectorthat is needed to satisfy a final demand of $22 thousand for agriculture, $13 thousand for energy, $27 thousand for manufacturing and $8 thousand forutilities.Write the technology matrix that describes the paragraph above. Makesure you label the rows and columns input and output.a.b.Is this an open or closed technology matrix? Why?С.Using the technology matrix, what type of sector is least dependent onitself?d.For each $1,000 of manufacturing sector produced, how much energywas required?e.Find the output for each sector that is needed to satisfy a final demand of$22 thousand for agriculture, $13 thousand for energy, $27 thousand formanufacturing, and $8 thousand for utilities.

Name: 2e must be answered with excel 2.An economy is based on four sectors,
Uploaded: 2024-03-20T07:06:41.000Z
Channel: Bartleby
Description: 2e must be answered with excel 2.An economy is based on four sectors, agriculture (A), energy (E), manufacturing(M), and utilities. Production of a dollar's worth of agriculture requires an input of$0.2 from the agriculture sector, $0.35 from the ene