PLease answer given question according to LP given.

Star Coffee House (SCH) is a large coffee retailer who sells many fancy brands of coffee. SCH has purchased 550 pounds of Arabica beans, 150 pounds of Columbian beans, 90 pounds of African beans, and 70 pounds of Mexican beans. SCH packages and sells four varieties of mixed coffee brands in standard 8-ounce (half-pound) bags. The mix requirements and net wholesale prices are shown in the Table below. The company can sell all that it can produce at these prices. The LP model was formulated and solved to determine what brands of coffee should company produce to maximize its revenue. The Linear Program model along with LINDO solution is shown on the next two pages. The following decision variables were used: A1, A2, A4 = pounds of Arabica beans used in mix 1, 2, 4 (respectively); C2, C3, C4 = pounds of Columbian beans used in mix 2, 3, 4 (respectively); F2, F4 = pounds of African beans used in mix 2, 4 (respectively); M2, M4 = pounds of Mexican beans used in mix 2, 4 (respectively); Note that coefficients in the objective function are double of the price per bad given in the above Table: the objective function coefficients represent price per pound rather than price per bag (two bags = one pound). Max 52A1+80A2+80C2+80F2+80M2+102C3+104A4+104C4+104F4+104M4 Subject to A1+A2+A4=00.9F20.1A20.1C20.1M2>=00.7C40.3A40.3F40.3M4>=00.8F40.2A40.2C40.2M4>=00.7M40.3A40.3C40.3F4>=0 Arabica beans availability Columbian beans availability African beans availability Mexican beans availability CHOICE MIX requirement for Arabica beans CHOICE MIX requirement for Columbian beans CHOICEMIXrequirementforAfricanbeans PREFERED MIX requirement for Columbian beans PREFERED MIX requirement for African beans PREFERED MIX requirement for Mexican beans 1. ITERATIONS =10 RANGES IN WHICH THE BASIS IS UNCHANGED: QUESTIONS TO ANSWER: 1) If management could purchase more coffee beans, which type should they obtain and what is the highest price they should be willing to pay? Explain all your answers! 2) Suppose the price per bag on Arabica Mix changed from $0.26 to $0.29 per can. What effect does this change have on the optimal solution, if at all? How does the revenue change, if at all? If yes, then by how much? 3) By how much should the price per bag of SELECT MIX change in order for SCH to start producing at least some SELECT mixes? 4) Consider the optimal coffee bean composition in the CHOICE MIX. Will there be more Columbian beans supplied in the mix than the minimum requirement stipulates? Will there be more African beans supplied in the mix than the minimum requirement stipulates? If yes to either question, how much more will be supplied? 5) The management just found out that out of 90 pounds of African beans 30 pounds are unusable due to spoilage. How does this affect the optimal mix of products SCH makes What is the effect of this loss on revenues? 6) SCH 's supplier just offered to sell 100 additional pounds of either Columbian beans or African beans (but not both) at $0.60 a pound. Which coffee beans should SCH buy (if all) and why