Please answer the full question with all parts 1 to 7 the question is sent as photos and is as follows:
. \"Business relationships are really uncertain in Russia just now. I am nervous that the farm manager selling me the potatoes will not honor his promise to deliver the 600 kilograms. If he delivers only 500 kilograms of potatoes, how much will I be hurt and what changes do I need to make in my decisions?\" (6 points) . \"Are there any alternate ways for me to achieve the same optimal operating income, involving, for example, different purchases of corn, food, or potatoes?\" If so, what are they?\" asks Igor. (4 points) . \"An international saluman from the Ralston-Purina Company stopped by the farm and wants to sell me prepackaged dry hog feed imported from Poland. He wants to charge me 16 rubles per kilogram for the packaged hog food, which includes transportation from Poland. He says each kilogram of his product provides 16 units of crude protein and 150 kilocalories. Should I start importing hog feed from Poland? And how much should I buy, if any, and what would be the impact of this opportunity on my optimal operating income?\" asks Igor. (7 points) H C F P Food Corn scraped Potatoes Hogs Sold purchased purchased purchased Decisions 100.000 95.238 742.857 600.000 26,761.90 Price $450.00 -$19.00 -$10.00 -$15.00 Constraints: LHS RHS Hogs supply limit 1 100 100 Food scraped supply limit 1 742.857 800 Potatoes supply limit 1 600 600 Crude Protein Net Excess Nutrients -174 18 9 15 0 >E 0 Kilo-Calories Net Excess Nutrients -1400 30 120 80 0 >= 0 The Excel model above shown displays the optimum answer to maximize Igor's operating income. The corresponding solver Sensitivity Report is also presented: Igor has many questions to ask about operating his farm, which you will expertly answer by examining the Sensitivity Report and/or the Excel solver output provided above.Variable Cells Final Reduced Objective Allowable Allowable Cell Name Value Cost Coefficient Increase Decrease $B$19 Decisions Hogs Sold 100.000 0 450 1E+30 261.048 $C$19 Decisions Com purchased 95.238 0 -19 1.917 $D$19 Decisions Food scraped purchased 742.857 0 -10 0.5 24.694 $E$19 Decisions Potatoes purchased 600.000 0 -15 1E+30 1.095 Constraints Final Shadow Constraint Allowable Allowable Cell Name Value Price R.H. Side Increase Decrease $F$22 Hogs supply limit LHS 100 261.048 100 5.405 21.739 $F$23 Food scraped supply limit LHS 742.857 800 1E+30 57.143 $F$24 Potatoes supply limit LHS 600 1.095 600 166.667 109.091 $F$25 Crude Protein Net Excess Nutrients LHS 0 1.048 0 46800 1500 $F$26 Kilo-Calories Net Excess Nutrients LHS 0 -0.005 0 6000 78000 Some of Igor's questions cannot be answered from the Solver information given on the previous page. If so, answer as best you can from the information, state why a more detailed answer is not available, and if appropriate, modify the "Yeltsin.xlsx" model posted on the course website below the link of assignment #2 and rerun Solver to produce the answers he seeks. Questions: 1. "If I follow your recommended approach to managing my farm so as to maximize my operating income next month, how much will I earn from selling the 100 hogs?" asks Igor. "How many hogs will I sell, and how much corn, food scraps, and potatoes should I now purchase in that case?" (4 points) 2. "I am confused", laments Igor. "You are telling me to buy fractional kilograms of corn and food scraps for my hogs. I have to make my purchases in whole kilograms. What should I do?" (4 points)The table below presents the monthly requirements per hog in units of protein and thousands of calories (i.e. Kilo-calories). It also presents, for the three sources of animal feed, the amount of crude protein and Kilo-calories supplied per kilogram. MINIMUM REQUIREMENT AMT. SUPPLIED AMT. SUPPLIED AMT. SUPPLIED PER HOG PER PER KILOGRAM PER KILOGRAM PER KILOGRAM NUTRIENT MONTH OF CORN OF FOOD WASTE OF POTATOES Crude Protein 174 18 9 15 Kilo-calories 1400 30 120 80 To help Igor understand how to run his farm, another United Nations consultant has built the following LP algebraic formulation and its corresponding Excel model: "Yeltsin.xIsx" (posted on the course website below the link of assignment #2) H= number of Hogs Sold C= Com Purchased (in Kg) F= Food scraped Purchased (in Kg) P=Potatoes purchased (in Kg) Objective function: Maximize net revenue=450H-19C-10F-15P Subject to: H= 174H (amount of crude protein) 30C+120F+80P>= 1400 H (amount of kilo-calories) H, C, F, P>=0Igor Yeltsin operated a farm under the former Russian collective farm system. The collective fam'r raised hogs for distribution by the central government as its main activity. Previously, Igor was told how many hogs to raise each year by Moscow's central planning agency and was allocated the necessary animal feed to raise the hogs. With the new market- driven economy, Igor receives no instructions on how to operate his hog farm and must survive as best he can on his own by buying animal feed, raising hogs, and selling them to any buyers he can find. Hogs were fed a combination of corn and potatoes mixed to assure that minimum amounts of two primary nutrients were met: crude protein and calories. Com and potato supplies have become less certain, and Igor has contracted to buy waste food scraps from a nearby food processing plant to supplement the previous hog diet of com and potatoes. Igor has turned to you, a recently arrived United Nations consultant, for help in managing his farm in the new and very uncertain Russian market economy. On his own, Igor contracted to sell up to 100 hogs to a Moscow butcher in the next month for a xed price of 450 rubles per hog. In addition, Igor contracted to buy up to 800 kilograms of waste food 'om the processing plant for a price of ll] rubles per kilogram. He believes he can buy any amount of com for 19 rubles per kilogram and can purchase up to 600 kilograms of potatoes from a nearby potato farm for 15 rubles per kilogram. . \"I think I can persuade the butcher to buy another 5 hogs from me at the same 450 ruble price. Would my situation improve if I try to sell him 105 hogs instead of 100'? By how much would my operating income be improved, if at all?\" asks Igor. (5 points) . \"You have to understand that everything is very volatile just now\". Igor comments. \"For example, it could easily happen that the cost of the com that I buy might suddenly change. How much could the cost of corn increase before I would have to change my plans?' (4 points)