Paul Johnson manages a family-owned farm. To supplement several food products grown on the farm, Fred also raises pigs for market. He now wishes to determine the quantities of the available types of feed (Corn, Barley, Soy) that should be given to each pig. Since pigs will eat any mix of these feed types, the objective is to determine which mix will meet certain nutritional requirements at a minimum cost. The number of units of each type of basic nutritional ingredient contained within a kilogram of each feed type is given in the following table, along with the daily nutritional requirements and feed costs: Nutritional Ingredients Kilogram of Com Kilogram of Barley Kilogram of Soy Minimum Daily Requirements \"1-.- - mice...) " 1. IN THE TEXTBOX BELOW, identify the type of problem and the answers to our "three questions\" (1. What is the problem to be solved? 2. What are the constraints? 3. How will the results be measured?) 2. Develop a spreadsheet using the appropriate model. To receive full credit you must name your cell ranges. UPLOAD your