Plot the relationship between agricultural commodity prices (Farm Product Price Index) & retail food prices (Food CPI). Do this for Jan 2020 through to July March 2022. Pleas

Assignment 1 (FRE 501) Name & Student ID:

Instructions: i. Data for the questions are provided in the accompanying excel file

ii. Please submit the following on Canvas: o Your typed answers as a PDF file o Your completed excel file o Your class participation record (Lectures 1 to 4)

Question 1: (23 marks total)

a. Plot world wheat prices from Jan 2015 to July 2022. (1) b. On the same graph, plot inflation rates over the same period and on the secondary axis

(view example on the excel file). (1) c. What is the relationship between the two? Run a regression to show the relationship

statistically, wheat prices as the independent variable and inflation as the dependent variable. (2)

d. State the month when inflation really begins to take off (increase)? (1) e. Now re-run the regression in two parts, first for the period from Jan 2015 to Dec 2020;

second from Jan 2021 to July 2022. Explain your results. (3) Background Information:

Use Canada as an example of a wheat producer/exporter. Note that the production of wheat each year requires farmers to decide in March-April which crops they will grow. If they wish to produce more wheat, they will allocate more of their land to wheat and away from the alternative crop they would otherwise be growing (e.g., canola). In anticipating their wheat production, they will have to acquire adequate supplies of fertilizer and other farm inputs, typically making purchases also in those early spring months. The wheat price will be determined by the world supply and demand. Some supplies of wheat will be determined even earlier if there is planting of winter wheat or an earlier growing season.

f. Describe the process by which inflation will affect Canadian wheat prices. (3) More information:

Suppose inflation in wheat producing countries starts to rise in (Canadian data follows) July 2021, jumping from 3.1 to 3.7%, and only begins to rise seriously in Jan 2022 (monthly inflation hits 5%), rising each month to June (8.1%). By planting decision time, inflation is running at annual rate of 5-7% (year over year, calculated each month.

g. How will that affect wheat prices over the period from January to July 2022 that we have so far observed? Putting this differently, if there was no significant inflation in 2021 through to date, how would this have changed the observed rise in global wheat prices? (3)

h. How would the actual observed inflation affect world wheat prices looking forward (in the future), ignoring other factors in the wheat market such as the war in Ukraine? (2)

i. Assume that fertilizer input costs account for 30% of total revenues. If fertilizer costs doubled, and if wheat prices increased by 50%, we wish to calculate the net effect on profits and planting decisions (these are roughly realistic numbers for spring 2022).

i. Calculate the effect on net profit or earnings before taxes for “Wheat-Hard Red Spring” (The relevant financial data can be found on Page 4 of the following document: https://www.gov.mb.ca/agriculture/farm- management/production-economics/pubs/cop-crop-production.pdf) (3)

ii. What is the effect on farmer’s planting decision from this change in profit? i.e., will they increase wheat plantings, given both an increase in fertilizer costs and an increase in the wheat price? (2)

j. Now show how this example of the long term effect of inflation will likely affect wheat prices (for late 2022, 2023)? (2)

Question 2: (9 marks total)

a. Plot the relationship between agricultural commodity prices (Farm Product Price Index) & retail food prices (Food CPI). Do this for Jan 2020 through to July 2022. (1)

i. What is the relationship between the two? (1) b. Conduct regressions and interpret the corresponding R Squared values

i. Food CPI in period t-1 (Independent variable) on Farm Product Price Index in period t (Dependent variable). (2)

ii. Farm Product Price Index in period t-1 (Independent variable) on Food CPI in period t (Dependent variable). (2)

iii. Contemporaneous effects, Farm Product Price Index in period t (Independent variable) on Food CPI in period t (Dependent variable). (1)

c. Give some economic arguments for why one direction of causation would be more plausible than another (comparing i. with ii.)? (2)

Question 3: (8 marks total)

a. On excel, convert the monthly Farm Product Price Index & Food CPI data into a quarterly series. (1)

b. Create 2 new data series that depicts the quarterly change in both Farm Product Price Index & Food CPI. (2)

c. Plot the quarterly percentage change in Farm Product Price Index & Food CPI from Q2- 2000 to Q1-2022. (1)

i. Comment on the relationship between the quarterly percentage change in Farm Product Price Index and Food CPI. (1)

ii. Provide reasons for the difference in volatility between the quarterly percentage change in Farm Product Price Index & Food CPI. (3)

Qn 1

Qn 2

	Data Sources
	Statistics Canada. Table 32-10-0098-01  Farm product price index (FPPI), monthly https://www150.statcan.gc.ca/t1/tbl1/en/tv.action?pid=3210009801
	Statistics Canada. Table 18-10-0004-01  Consumer Price Index, monthly, not seasonally adjusted https://www150.statcan.gc.ca/t1/tbl1/en/tv.action?pid=1810000401
	Date	Farm Product Price Index	Food CPI
	Jan-20	132.4	153.5		Question 2a)
	Feb-20	132.4	152.9
	Mar-20	132.7	152.8
	Apr-20	130.5	154
	May-20	134.5	154.3
	Jun-20	133	154.8
	Jul-20	132.5	155
	Aug-20	132.9	153.8
	Sep-20	134.3	152.6
	Oct-20	137.3	153.3
	Nov-20	138.2	153.9
	Dec-20	139.5	153.6
	Jan-21	143	155
	Feb-21	147.9	155.6
	Mar-21	153.1	155.5
	Apr-21	158.5	155.4		Question 2bi)
	May-21	158.6	156.6
	Jun-21	164.4	156.8
	Jul-21	167.5	157.6
	Aug-21	163.8	158
	Sep-21	167	158.5
	Oct-21	167.4	159.2
	Nov-21	173.6	160.7
	Dec-21	175.7	161.6
	Jan-22	185.7	163.9
</t Collepals.com Plagiarism Free Papers Are you looking for custom essay writing service or even dissertation writing services? Just request for our write my paper service, and we'll match you with the best essay writer in your subject! With an exceptional team of professional academic experts in a wide range of subjects, we can guarantee you an unrivaled quality of custom-written papers. Get ZERO PLAGIARISM, HUMAN WRITTEN ESSAYS Why Hire Collepals.com writers to do your paper? Quality- We are experienced and have access to ample research materials. We write plagiarism Free Content Confidential- We never share or sell your personal information to third parties. Support-Chat with us today! We are always waiting to answer all your questions. Please see the attached word document and responses to person 1 and person 2 based on their discussion.? Respond to your 2 people: Respond to at least two people, constructively co Policy work requires shared information, knowledge, effective communication, and professionalism. Core competencies for policy professionals include the ability to engage in critical Related Posts Uncategorized Prepare a 2- to 3-page paper (not counting the cover and reference pages) discussing how the Family and Medical Leave Act, the Pregnancy Discrimination Act, the Americans with Disabilities Act, safety laws, or other state laws might apply to the following scenario. Uncategorized Capital Budget Methodologies Uncategorized Case Study Literature Review Assignment ? Read: Thomas (2021): Chapter 3 Read: Literature review as a research methodology: An overview and All Rights Reserved Terms and Conditions College pals.com Privacy Policy 2010-2018