could I please have help with this. Attach. the document. Tab one, two and three. Thanks
A stable owner 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 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 (A-E) 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 is the maximum amount that a horse shoule be fed. Use Solver to find the optimal daily mix of the three feeds that minimizes the total cost of the mix. Amount to Use Objective Function Constraints Oat Product (Units/Lb) 2 0.5 3 1 0.5 $0.18 Enriched Grain (Units/Lb) 3 1 5 1.5 0.5 $0.27 Mineral Product (Units/Lb) 1 0.5 4 2 1.5 $0.34 Oat Ingredients A B C D E Cost/lb Grain Mineral Minimum Daily Requirement (Units) 6 2 9 8 5 Jessica Jones is planning a marketing campaign for a politician's re-election campaign. She has selected four ways to advertise: television ads, radio ads, billboards, and newspaper ads. The costs of these and the audience reached by each type of ad is shown in the table below. She has decided: >There should be at least six ads on TV or radio or some combination of those two. >The amount spent on billboards and newspapers together must not exceed the amount spent on TV ads. >No type of ad may be used more than 10 times. >The monthly budget for advertising has been set at $14,000. How many ads of each type should be placed to maximize the total number of people reached? (Do not round) TV Cost per Ad Reach per Ad $800 30,000 TV Number to Air Objective Function Constraints Radio $400 22,000 Billboards $500 24,000 Newspapers $100 8,000 Radio Billboards Newspapers Aaron has identified five stocks that he may wish to invest in. He has determined the expected return for each stock, as well as the risk of each stock as shown by a measure called beta. A lower beta means a lower risk. Aaron's objective is to minimize the beta (risk) of the stock portfolio (calculated using the sum product of each stock's beta and the proportion of the investment in that stock). He requires an expected return of at least 11%. In addition, Daniel has decided that no more than 35% of the portfolio should be invested in any one stock. Use solver to determine the proportion of the portfolio that should be in each stock. (For example, if 20% of the portfolio is in stock A, you will get an answer of 0.2). Since you are working with proportions, you will need a constraint that the sum of the proportions is equal to 1. Expected Return (%) Beta Stock A Stock B Stock C Stock D Stock E 11 9 6.5 15 13 1.2 0.85 0.55 1.4 1.25 Stock A Proportion Objective Function Constraints Stock B Stock C Stock D Stock E
