will receive no points. Part 2a. Recreate the analysis above in Excel using the file entitled A5 Template posted to Blackboard. In that template, type your first name in cell B2 and your last name in cell C2 (2 pts). In cells B6:B9 enter the parameters a thru d calculated in A4 but with the tax on suppliers incorporated appropriately (4 pts). The tax on suppliers goes in cell C4. (Parameters and the tax can be entered as numbers rather than formulas.) Using formulas to be entered into the following cells, calculate: 1. (2 pts) the new Qe in cell Co 2. (2 pts) the new Pe in C7 3. (10 pts) Consumer's surplus, producer's surplus, tax revenue, economic surplus, and deadweight loss at the new equilibrium in E6, E7, E8, E9, and E10, respectively 4. (4 pts) the tax incidence in absolute dollars on consumers and producers in G7 and G8, respectively 5. (4 pts) the tax incidence as a percentage of the total tax on consumers and producers in H7 and H8, respectively Assumption 1 Terms of Trade: 0.00 cherries per apple Assumption 2 Jack trades up to 0.00 Jack's Production Possibility Frontier... 25 20 ....without Trade 15 ... with Trade 10 Jack's Production & Consumption of: Without Trade With Trade Cherries Apples Cherries Apples 0.00 22.00 0.71 20.95 1.43 19.90 2.14 18.86 2.86 17.81 3.57 16.76 4.29 15.71 5.00 14.67 5.71 13.62 6.43 12.57 7.11 11.52 7.86 10.48 8.57 9.43 9.29 8.38 10.00 7.33 10.71 6.29 11.43 5.24 12.14 4.19 12.86 3.14 13.57 2.10 14.29 1.05 15.00 0.00 Jill's Production & Consumption of: Without Trade With Trade Cherries Apples Cherries Apples 45.00 0.00 42.86 0.95 40.71 1.90 38.57 2.86 36.43 3.81 34.29 4.76 32.14 5.71 30.00 6.67 27.86 7.62 25.71 8.57 23.57 9.52 21.43 10.48 19.29 11.43 17.14 12.34 15.00 13.33 12.86 14.29 10.71 15.24 8.57 16.19 6.43 17.14 4.29 18.10 2.14 19.05 0.00 20.00 Apples 5 0 0 5 10 15 20 Cherries Jill's Production Possibility Frontier... 20 ....without Trade 15 +...with Trade 10 Jack's OC. - 1.47 Apple is the fruit that Jack has a comparative advantage in lack's OC, = 0.68 Cherry is the fruit that will has a comparative advantage in. Jill's OC.-0.11 Jills's OC -2.25 Min Max Trade benefits both when the terms of trade of cherries per apple is between: : is the midpoint of the range of terms of trade in which Jack and Jill both benefit from trade Apples 5 0 0 10 20 30 40 50 Cherries will receive no points. Part 2a. Recreate the analysis above in Excel using the file entitled A5 Template posted to Blackboard. In that template, type your first name in cell B2 and your last name in cell C2 (2 pts). In cells B6:B9 enter the parameters a thru d calculated in A4 but with the tax on suppliers incorporated appropriately (4 pts). The tax on suppliers goes in cell C4. (Parameters and the tax can be entered as numbers rather than formulas.) Using formulas to be entered into the following cells, calculate: 1. (2 pts) the new Qe in cell Co 2. (2 pts) the new Pe in C7 3. (10 pts) Consumer's surplus, producer's surplus, tax revenue, economic surplus, and deadweight loss at the new equilibrium in E6, E7, E8, E9, and E10, respectively 4. (4 pts) the tax incidence in absolute dollars on consumers and producers in G7 and G8, respectively 5. (4 pts) the tax incidence as a percentage of the total tax on consumers and producers in H7 and H8, respectively Assumption 1 Terms of Trade: 0.00 cherries per apple Assumption 2 Jack trades up to 0.00 Jack's Production Possibility Frontier... 25 20 ....without Trade 15 ... with Trade 10 Jack's Production & Consumption of: Without Trade With Trade Cherries Apples Cherries Apples 0.00 22.00 0.71 20.95 1.43 19.90 2.14 18.86 2.86 17.81 3.57 16.76 4.29 15.71 5.00 14.67 5.71 13.62 6.43 12.57 7.11 11.52 7.86 10.48 8.57 9.43 9.29 8.38 10.00 7.33 10.71 6.29 11.43 5.24 12.14 4.19 12.86 3.14 13.57 2.10 14.29 1.05 15.00 0.00 Jill's Production & Consumption of: Without Trade With Trade Cherries Apples Cherries Apples 45.00 0.00 42.86 0.95 40.71 1.90 38.57 2.86 36.43 3.81 34.29 4.76 32.14 5.71 30.00 6.67 27.86 7.62 25.71 8.57 23.57 9.52 21.43 10.48 19.29 11.43 17.14 12.34 15.00 13.33 12.86 14.29 10.71 15.24 8.57 16.19 6.43 17.14 4.29 18.10 2.14 19.05 0.00 20.00 Apples 5 0 0 5 10 15 20 Cherries Jill's Production Possibility Frontier... 20 ....without Trade 15 +...with Trade 10 Jack's OC. - 1.47 Apple is the fruit that Jack has a comparative advantage in lack's OC, = 0.68 Cherry is the fruit that will has a comparative advantage in. Jill's OC.-0.11 Jills's OC -2.25 Min Max Trade benefits both when the terms of trade of cherries per apple is between: : is the midpoint of the range of terms of trade in which Jack and Jill both benefit from trade Apples 5 0 0 10 20 30 40 50 Cherries