Chapter 7 Homework 2Problem 1Amalgamated Products has just received a contract to construct steel body frames for automobiles that are to be produced at the new Japanese factory in Tennessee. The Japanese auto manufacturer has strict quality control standards for all of its component subcontractors and has informed Amalgamated that each frame must have the following steel content:MaterialMin percentage (%)Manganese2.3Silicon4.6Carbon5.35Amalgamated mixes batches of three different available materials to produce a steel used in the body frames. The following table give details these materials. Material AvailableManganese (%)Silicon (%)Carbon (%)Cost per Pounds ($)Alloy 7015312Iron 11039Carbide0241810Formulate the LP model that will indicate how much each of the three materials should be blended into a steel so that Amalgamated meets its requirements while minimizing costs. using Solver in excel.Problem 2The Battery Park Stable feeds and houses the horses used to pull tourist-filled carriages through the streets of Charleston’s historic waterfront area. The stable owner, an ex-racehorse trainer, recognizes the need to set a nutritional diet for the horses in his care. At the same time, he would like to keep the overall daily cost of feed to a minimum. The feed mixes available for the horses’ diet are an oat product, a highly enriched grain, and a mineral product. Each of these mixes contains a certain amount of five ingredients needed daily to keep the average horse healthy. The table on this page shows these minimum requirements, units of each ingredient per pound of feed mix, and costs for the three mixes. In addition, the stable owner is aware that an overfed horse is a sluggish worker. Consequently, he determines that 6 pounds of feed per day are the most that any horse needs to function properly. Formulate this problem and solve for the optimal daily mix of the three feeds using Solver in excel.

APA format Proper citations in apa format writingProper 2 or more APA format references in ABC's orderProper heading in paper and the length is 6 paragraph in detailed writing and explanation.Assignment:Clark Dale is one of the investment portfolio managers at ACG in charge of managing a $15 million Treasury bond portfolio account for a trust fund. He is considering the use of Treasury bond futures in an attempt to hedge the account portfolio. He consults with you with regard to the best plan of action for investment and portfolio management of this account. How would you counsel Clark?Is a hedging strategy the best plan of action?Explain why you think Clark is considering this strategy.What is the relationship between bond prices and interest rate fluctuations?Should he consider a long or short hedge strategy?Explain your reasoning behind your suggestion. What will the return be?Heading:IntroductionHedging StrategyTo Choose Long or short hedge strategy and whyYour Reasoning and The return why?ConclusionReferencesThanks