Ladies and gents, please help me to solve this exercise. Unfortunately, CourseHero does not have a place to upload the files, so I share the link to homework (all requirements are mentioned within pdf file + there is supportive excel file based on which you have to solve the exercise)

Here is the link:

https://drive.google.com/drive/folders/1mMVOX8cbMNk2qmtuJge7xxX1XnMlZCCu?usp=sharing

HWl Exercise The labour intensity in cheese is 10 h/kg in the domestic country and 20 hfkg in the foreign country. The labour intensity in wine is 10 h/l in the domestic country and 30 h/l in the foreign country. The domestic country is endowed with 40 000 hours, the foreign country with 100 000 hours. The demand curves in both countries are identical (which implies we can use one RD curve like we did during the lecture and not think too much how to get an average one). The formula for the RD curve remains the same (as during the lecture, y=1fx) 1. Calculate the opportunity costs in wine for each country. 2. Determine the absolute and comparative advantages for wine and cheese. 3. Outline the relative supply and demand curves and nd the resulting relative price (of cheese or wine, depending on how you labeled the y and x axis) 4. Set the specialisation after economies start trading (Note: countries will not always fully specialise, sometimes they can produce both despite having only one comparative advantage. In case you observe this in the exercise, it is not a mistake) Calculate the gains from trade 6. Calculate the wage of domestic workers and the wage of the foreign workers P" HW1 calculating RCA Pick one country you will calculate the RCA for - Teams, excel ,,Country selection\" The data is available in file "Data_exports"' - File ,,Data_exports\" (the source of the data is here) If ou use the original Balassa index to calculate the RCA, you wi I do it for just one year - Briefly comment what did you obtain which are the HS categories with the highest advantagefdisadvantage, did it confirm your expectations? If you use one ofthe modified versions of the Balassa index, you can also compare the evolution of the RCA In time - This is more time consuming, so it comes with extra 3 points - The same as'above 'commentt your results - which are the HS. categories with the highest advantageldisadvantage, did it confirm your expectations, what is the evolution in time? Submit the results to InSis ' Upload your Excel file including the calculations {I should be able to see the formulas] - Delete the page ,,Data"', so your Excel le is not huge and can be uploaded When commenting the results you can also use the PCI - product complexity index (the highest the value of the index, the more complex the HS item is) A B C D E 1 hs_product_code year export_value pci location_code If you have 2 1995 20345 -0,511 ABW any 3 1996 0 -0,646 ABW A 1997 -0,479 ABW question O 5 1998 0 -0,508 ABW when doing 6 1999 16096 -0,577 ABW 7 2000 12576 -0,553 ABW the HW, let 8 2001 10545 -0,790 ABW me know! 9 2002 9014 -0,731 ABW 10 2003 478628 -0,712 ABW 11 2004 84537 -0,697 ABW 12 2005 96543 -0,730 ABW The Excel file has 5 sheets - check all of them Data HS codes description Country codes description Calculations - RCA Comments - RCA (+) 4\fExample of calculations - normalized BI A B C D NI1995 NI2005 NI2017 -1E-06 -5E-07 -4E-07 2 3,7E-06 -2E-06 -1E-06 O JOUAWN 3 8,9E-06 3,5E-06 -1E-07 4 -3E-06 -2E-06 4,5E-06 5 1,4E-06 5,5E-10 -2E-07 8 6 2,7E-05 1,6E-05 7,3E-06 9 7 9,2E-06 5,8E-06 4,9E-06 10 8 0,00023 0,00017 0,00019 11 9 8,2E-05 2,2E-05 1,6E-05 12 10 -6E-06 -5E-06 -4E-06 13 11 -6E-07 3,7E-07 1,2E-08 14 121 -9F-071 -2F-061 -3F-06