to the Wheat Budget to ensure that any changes to the data will flow through the other worksheets correctly. 3. Answer the In-chapter questions in Chapter 3 Margin. Take a screen shot of your answers and paste them in front of the exercise answers for Chapter 1. (1\%) Answer the following Margin exercise questions. (1.5\%) A. Put together a Microsoft Excel worksheet like the one shown in the e-textbook with a screen shot. Find the futures prices on the Chicago Mercantile Exchange website for futures markets which are about four months ahead (i.e. as close to four months ahead as possible since there are not necessarily futures contracts for every month of the year). These include the futures contracts for lean hogs, corn, soymeal, and currency. We're assuming that we can defer paying for the corn and soybeans until four months ahead and that we'll get paid for the hogs right away upon selling them then. Calculate the current hog margin over feed. 4. Answer the In-chapter questions in Chapter 4 Risk and Return. Take a screen shot of your answers and paste them in front of the exercise answers for Chapter 4. (1\%) Answer the following Risk and Return exercise questions. (1.5\%) A. Put together an Excel worksheet and solver to find the proportions of crops B and C to include in a two-crop portfolio to minimize risk subject to a minimum acceptable portfolio return. Use the annual returns over 10 years for crop B which are given in the illustrated Excel worksheet. For the ten years of annual returns for crop C use 10,16,5,16,7,18,14,2,16, and 8 . Specify 2.69 as the minimum acceptable portfolio return. 5. Answer the In-chapter questions in Chapter 3 Efficiency. Take a screen shot of your answers and paste them in front of the exercise answers for Chapter 5. (1\%) Answer the following Efficiency exercise questions. (1.5\%) A. Set up a Microsoft Excel sheet and solver to solve for the least cost feed ration that meets the nutritional requirements of the pigs and optimizes rate of growth and feed conversion ratio. Use the nutrient profiles for the ingredients and nutrient requirements for the pigs as shown in the tables above. For prices use 140 for wheat, 230 for corn, 180 for barley, 330 for soymeal, 1450 for premix, and 1800 for lysine