3.5-5.* Fred Jonasson manages a family-owned farm. To supple- ment 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, tankage, and alfalfa) 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 nutri- tional 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:

Consider the product structure of end item PR-1 given in Figure P10.1. The end-item demand from the master production schedule for the period of weeks 3, 4, 5, 6, 7, 8, 9,and 10 is 40, 30, 20, 10, 50, 30, 70, and 20 units, respectively. The manufacturing and assembly lead times for PR-1, SA-12, and C-122 and the ordering lead time for M-4 are given below. Carry out the material requirements planning procedure for raw material M-4 required to manufacture component C-122 if one unit of M-4 is required to produce one unit of C-122. Lead time for assembling PR-1 =1 week. Lead time for assembling SA-12 = 1 week.|| Lead time for manufacturing C-122 = 2 week; 100 units on-hand inventory are given and 40 units are scheduled to arrive in period 2. Procurement lead time for raw material M41 week; 40 units on-hand inventory are available.

1. Perform a runs test for the sales data shown below. Does the data have a trend? Explain.

1. The following is the mattress sales data for the previous two years. Using Microsoft excel, do the following: a. Construct descriptive statistics report of sales b. Display the sales data using a scatter diagram c. Construct a histogram and a Pareto chart for sales. d. Fit a line through the data using regression analysis. Write the equation of the line.

Question 1) Tom Cruise, Freddy Prinze Jr., Harrison Ford, and Matt Le Blanc are marooned on a desert island with Jennifer Aniston, Courtney Cox, Gwyneth Paltrow, and Julia Roberts. The"compatibility measures" in Table 2 indicate how much happiness each couple would experience if they spent all their time together. The happiness earned of time they spend together.a couple is proportional to the fraction A)Formulate an LP whose solution will maximize the total happiness, considering x_ij as the fraction of time ih man spends with j™ woman. b) Solve it with Lingo, did you find an integer solution? What do you think it means?

9.5-3. The next diagram depicts a system of aqueducts that originate at three rivers (nodes RI, R2, and R3) and terminate at a major city (node T), where the other nodes are junction points in the system. The city water manager wants to determine a flow plan that will maximize the flow of water to the city. Using units of thousands of acre feet, the tables below the diagram show the maximum amount of water that can be pumped through each aqueduct per day.

2. Which of the following forecasting models is superior for predicting future sales based on the sum of squared differences criterion? a) Constant model with a constant prediction of 102 b) Last period model c) Moving average model with n = 2 d) Moving average model with n= 3 e) Weighted moving average model with n= 2, C1 =0.6 , C2 =0.4 f) Weighted moving average model with z-3, C1= 6, C2 = 4, C3= 2 g) Exponentially weighted moving average model with xo = 76 and a = 0.35 h) Exponentially weighted moving average model with xo = 76 and a = 0.7

3. What are some possible sources of data needed to derive parameters of OR models?

16. Given the following stages of contingency planning, which is the correct order of performing the stages according to NIST SP 800-34? 1. Conduct business impact analysis 2. Develop recovery strategies 3. Develop contingency plan 4. Identify preventive controls 5. Develop contingency planning policy а. 1, 3, 5, 2, 4 b. 1, 2, 3. 4.5 С.5, 1, 4, 2, 3 d. 1, 5, 2, 4, 3 е.None of the above

The distance (in kilometres) between the following residential areas of Kuwait Alsalam, Alnuzha, Bayan, Salmiya, and Hawalli are shown in the table below. It is necessary to build a state road system that connects all these cities. Assumes that for construction obstacles no road can be built connecting Alsalam and Alnuzha, and no road can be built connecting Hawalli and Bayan. What is the minimum length of the road required?