Food & Agriculture: shopping at the global marketplace
GEOG 111 Exercise #4 - 70 points
Instructor:  P. Kaldjian

 

PLEASE NOTE:  This exercise requires you to gather Web data from some sites that have been undergoing revisions.  Please start early, otherwise you may get frustrated if you cannot get access because there is too much traffic.  The data gathering part of the assignment should not take long.

This exercise has some similarities to exercise #2. This time, however, we are interested in the sources of our food.  Specifically, the series of questions is to help us think about the extent to which places consume from and produce for the global marketplace, where food comes from and why it comes from there.  

According to the Food and Agriculture Organization, world trade in agricultural, fisheries and forestry products totals some $460 billion annually. Food is moving everywhere, yet, in a world of plenty, there were still around 840 million undernourished people in 1998-2000, 799 million in the developing countries, 30 million in the countries in transition and 11 million in the world's core; progress in reducing global hunger has all but stopped (FAO, 2002 ). While daily calorie supply per person worldwide was about 110% of the overall requirement already 10 years ago (New Internationalist, 1993), around 15% of the world’s people still do not get enough to eat. And recently, world food prices have shot up significantly. What are the patterns? What are the causes and consequences?

For the following questions, type your answers onto the answer sheet that has been prepared for you.

The sources of our food

INCLUDE A QUESTION ABOUT SOURCES OF FOOD -- COMPARE TO HMWRK #2

 I.  Begin by going to the website of the Food and Agriculture Organization; follow the link  to Statistical Databases (look down the left-hand side) and on to FAOSTAT. Unfortunately, until the FAO concludes their work on their core data, we have to used archived data, the most recent year being 2007. So, click on Food Balance Sheets. From the list of countries, select United States of America and leave the year at 2007.  Click on Show Data. You can print or save this to your own folder. From the Food Balance Sheet you generate, answer the following questions onto the answer sheet.

1. In terms of calories/capita/day, how much food is available to each person in the United States per day on the average? 
2. From the food balance sheet, identify and list all the agricultural products (in the blue shaded rows) for which the United States imports at least as much as it produces domestically.
3
. Now, in the same way, look at the food balance sheet for Guatemala, 2003.  How does Guatemala’s  caloric intake compare with the USA’s and with the worldwide recommended average number of calories, roughly 2400 per person per day.

II.  Next, go to the Trade Data Website of the USDA’s Foreign Agricultural Research Service and follow the link to the Standard Query on the left. Once here, on the bar at the top, make sure Data Source is FAS U.S. Trade, Product Type is Imports-General, and Product Groups is BICO (HS-10). Then, under Partners, choose World; from Products select bananas and plantains. (Note: If you do not see Bananas and Plaintains, click on Fresh Fruit, and follow the instructions below. After you hit Retrieve Data, look again for Bananas and Plantains, it should now be there. Yes, strange).  Then click on the Search button. On the next page that pops up, click on Calendar Year.   Leave Value at value and thousands, and leave Quantity blank, and leave Dates and Settings the same. Click on Retrieve Data. You will then have in front of you a table of the total dollar amount of the last five years of imports of bananas and plantainsto the USA. Click on the little plus sign ('+') next to bananas and plantains. Then, click on the little plus sign ('+') that is next to the World Total that is next to Bananas, Fresh. You now have a listing of the countries from which the US imports bananas, ranked by most to least, and the value, for the last five years.

4.
Identify the three countries from which the United States imported the most bananas (by value) in the year 2009.
5.
Go back up and find cocoa beans from the list of products. From which three countries did the United States import the most cocoa beans (by value) in the year 2009?

6. From which three countries did the United States import the most cocoa paste and cocoa butter (by value) in the year 2009 (Find under intermediate products -- you may have to try few different things on the list)? Notice that the leading supplier is about as much as the next three!

7. What might explain the difference between leading supplier(s) of cocoa beans and those that supply cocoa paste/butter?  (NOTE: Cocoa beans is used for cocoa paste/butter, which is the primary ingredient in chocolate). In other words, wouldn't you expect them to be the same country?  Why aren't they? Think of core and periphery, primary, secondary and tertiary.

8. From which three countries did the United States import the most coffee (unroasted, by value) in the year 2009?

9. now, change the year rangeunder Dates from 2005 to 1997. Click on Retrieve Data.  You will will see that the value of coffee imports dropped through 2003, then started rising again.  Why? Give two possible explanations. If you select Quantity under Statistics (also be sure to change Value to a blank), you will see that coffee imports have been steadily rising during this entire time. How can this be explained? Click on the '+' next to World (the '+' may be hidden, so click on the small, grey box), to see if the amounts the US imported from each country changed.

10.  Now, Under Dates, change the year range to 2009 to 2010, select World Total from Partners and Agricultural Products from Products, and click on Retrieve Data. Compare them to answer the following questions for 2009. 

     a. What group of agricultural products (choose from bulk, intermediate and consumer-oriented products) does the US import the most by value? Now, click on the plusses -- what specific products does the US import the most of, by value. Why is this?

     b. At the top, under product type, change imports to exports . What agricultural products (choose from bulk, intermediate and consumer-oriented products)does the US export the most by value? Now, click on the plusses -- what specific products does the US export the most of, by value. Why is this?

     c. What patterns do you observe and what explains them -- that is, think about what the United States specializes in and produces for the world marketplace and why?  Come up with at least 2 reasonable explanations.


III.  Now, return again to the Food and Agriculture Organization’s FAOSTAT database and click on Production on the blue bar across the top, then Crops from the green bar. Under country select World >, under element select Production Quantity under element and then bananas under item. Choose the year 2008 and click on Show Data.

 

11. Which countries are the world’s four leading banana producers (by quantity)?

12. Does the United States import bananas from the main banana producers (compare to 4 above)?  Why or why not, do you think?

13. Repeat the search for cocoa beans. Which are the four biggest cocoa bean producers in the world?

14. Repeat the search for coffee, green (meaning unroasted). Which are the three biggest raw coffee bean producers in the world?

15. How are the top three coffee bean producers in the world different from the top three in 1990? Why is this and how might this be related to 9 above?

16. Regarding tree nuts, which country is the biggest producer of: a.) Hazelnuts b.) Pistachios c). Cashew nuts?
17. Which 3 countries are the greatest producers of wheat?

18. Now, change the element to area harv(ested) as the subject and Guatemala as the country. Using the shift key again, highlight all the commodities and choose the year 2008.  Click on Show Data.  Compare and comment on the area dedicated to producing export crops (coffee, spices, rubber, sesame seeds, bananas, etc)  and those dedicated to basic food crops in light of the fact that Guatemalans don't have enough to eat, and we here in the US have plenty.  Refer back to Guatemala's Food Balance sheet if necessary.

IV.  Now, go to Trade (from blue bar across the top) data base.  Click on TradeSTAT from the green bar and then Crops and Livestock Products in the orange bar. Choose Export Quantity from the subject, Wheat+Flour, Wheat Equiv. > from the commodity, and World > from county.

19. Which six countries are the world’s leading exporters of wheat (by quantity) in 2008?
20. Explain the difference between the biggest producers of wheat and the biggest exporters of wheat (See Question 17).  What do you think is going on?

21. Change the subject to Import Quantity. What countries are the six leading importers of wheat (by quantity)?

IV. According to The "Banquet de l'Humanité," people around the world eat according to their income, their food resources and their cultural background. To help us understand this, we will use FAO data to make food consumption models for three countries around the world (click here for examples). You will then compare them to the United States. The first two food consumption models will be for Guatemala and Cote d'Ivoire; the third will be for a country of your choice.

To make the models, you will use data from the the 2007 Food Balance data from FAO and place it in the Excel worksheet that has been prepared for you (worksheet). By filling in the worksheet, you will generate the data you need to create the Food Consumption Models for Guatemala, Cote d'Ivoire and the country of your choice. To find the data you need, generate a Food Balance Sheet for Guatemala, Cote d'Ivoire and the country of your choice, just as you did for #1 above.

For each row in your worksheet, you are to fill in the Kcalories/capita/day with data from the Food Balance Sheet. for example, cereals for Guatemala would be 1106, starchy roots would be 18, and so on. Combine fruits with vegetables and nuts; add meat together with eggs and "fats, animals, raw" and include the fish oils with fish; for dairy products combine milk with butter/ghee and cream, and; add oilcrops to vegetable oils. (NOTE: If you open the table and see one of the columns already filled in for Turkey, click on the tab at the bottom edge of the spread sheet labeled GEOG 111 #4 Worksheet.)

The Excel program (the spread sheet in which you entered the data) can make the Food Consumption Model for you. After you have finished filling in Table 1, Table 2 is automatically filled in for you. To make the Food Consumption Model, carefully carry out the following steps for Table 1.
1. Highlight the rows and columns for all of your data, including the row and column names. This should be columns A-E, rows 6-16 in Table 1;
2. From the blue bar across the top, click on INSERT. From the icons that pop up, in the section entitled Charts, click Other Charts. From the pop-down menu that appears, go to where it says Radar, and clicked on the third one with filled polygons. Voila. A food consumption model should pop up for you, one that shows all four of the countries in your table. If one or another of your countries is blocked by the others, you can make a couple of charts with only two countries each. Or, you can make the color transparent so you can see through some of them. If you want to change the scale, double click on the numbers along the axis and change the axis options.

At the bottom edge of your Excel worksheet, click on Example-Turkey to see how your work should look. I have used the country of Turkey as an example (you are to choose a different country).

Follow the steps above for Table 2. This will show the proportion of calories others eat in relationship to how much we eat here in the United States.

Print off a nice copy of your tables and of each Food Consumption Model (you may want to cut and past them into a word document).

23. Based on your food consumption models for each country, and other information from this assignment and the course, how do these demonstrate that people eat according to their income, their food resources (their environment and geography, really) and their culture? Be sure to look at the sub categories. For example, the cereals eaten in each country differ. Why?
24. Include final thoughts or a response to what you have learned.

You are to turn in your typed answer sheet, your filled in work sheet, and your food consumption models. Staple them together. The assignment is to be submitted through D2L to me as an MS Word and MS Excel (or .PDF) documents with yourlastnameEX4 as the file name before class begins on the day that it is due. If you do not know how to submit a homework assignment through D2L, the kind people at the computer helpdesk in the Old Library are waiting to help you.

Good Job.