PART ONE,st.Refer to tabulated data in Example 2 Lecture 14 to answer the followingquestions:1. Assume dedicated storage policy and 5 ft * 5 ft- bay to allocate storage spaces to all products.Use Excel to draw the distance matrix, and then allocate the spaces. You must show thedistance and the allocation matrices, in addition to the calculations necessary for the allocationprocess*2. For every bay, calculate the average utilization and the average distance traveled. Example 2: Six products are received by a warehouse according to the schedule belowTable 7.4 Inventory Levels for Six Products in a Warebouse, Expressed in Pallet Loadsof ProductPRODUCTSPeriod12346Aggregate124122121112736622288106.46.513420182460336483162.20724105141633302721988368126.12188104.8415824431253106218242701241146.6.3182055122151664131424122.122324972288222190201316156.42113751684336242015172019121051814163330813986.6.8368191212172010278163218242.415247722212414219423244186.20131879215416121564

le 7.4 Inventory Levels for Stx Products in a Warehouse, Expressed in Pallet Loads Рroduct PRODUCTS riod 1 2 3 4 Aggregate 24 12 12 12 73 66 11 2 22 8 10 3 20 51 18 3 24 8 60 16 36 33 30 27 20 7 24 105 14 16 6. 21 98 83 68 53 70 12 12 18 10 15 8 24 3 12 10 11 12 13 14 15 16 17 18 19 20 21 21 24 2 4 18 20 1 55 64 2 15 16 24 3 12 23 22 24 97 90 24 12 22 21 20 4 21 13 75 13 16 3 36 33 30 24 20 15 84 20 16 19 12 105 14 13 98 12 12 17 6. 83 68 10 27 16 3 8. 24 15 77 1963

le 7.4 Inventory Levels for Stx Products in a Warehouse, Expressed in Pallet Loads Рroduct PRODUCTS riod 1 2 3 4 Aggregate 24 12 12 12 73 66 11 2 22 8 10 3 20 51 18 3 24 8 60 16 36 33 30 27 20 7 24 105 14 16 6. 21 98 83 68 53 70 12 12 18 10 15 8 24 3 12 10 11 12 13 14 15 16 17 18 19 20 21 21 24 2 4 18 20 1 55 64 2 15 16 24 3 12 23 22 24 97 90 24 12 22 21 20 4 21 13 75 13 16 3 36 33 30 24 20 15 84 20 16 19 12 105 14 13 98 12 12 17 6. 83 68 10 27 16 3 8. 24 15 77 1963

Functions and Change: A Modeling Approach to College Algebra (MindTap Course List)

6th Edition

ISBN:9781337111348

Author:Bruce Crauder, Benny Evans, Alan Noell

Publisher:Bruce Crauder, Benny Evans, Alan Noell

Chapter5: A Survey Of Other Common Functions

Section5.3: Modeling Data With Power Functions

Problem 6E: Urban Travel Times Population of cities and driving times are related, as shown in the accompanying...

See similar textbooks

Similar questions

Urban Travel Times Population of cities and driving times are related, as shown in the accompanying table, which shows the 1960 population N, in thousands, for several cities, together with the average time T, in minutes, sent by residents driving to work. City Population N Driving time T Los Angeles 6489 16.8 Pittsburgh 1804 12.6 Washington 1808 14.3 Hutchinson 38 6.1 Nashville 347 10.8 Tallahassee 48 7.3 An analysis of these data, along with data from 17 other cities in the United States and Canada, led to a power model of average driving time as a function of population. a Construct a power model of driving time in minutes as a function of population measured in thousands b Is average driving time in Pittsburgh more or less than would be expected from its population? c If you wish to move to a smaller city to reduce your average driving time to work by 25, how much smaller should the city be?
3) The following two sets of Excel output use are from the same data set as described above, but the first set of output is for the set of 35 CEO’s that earn the lowest total compensation and the second set of output is for a set of 40 CEO’s that earn the highest total compensation. a) What is heteroscedasticity? b) Why is heteroscedasticity a problem? c) Based on a comparison of the two sets of output, does it appear that there is heteroscedasticity in the data set? Explain.
A certain manufacturing company has the following data on quantities shipped and unit costs for each of its four products. Products Base-PeriodQuantities (Year 1) Mean Shipping Costper Unit ($) Year 1 Year 5 A 2,000 10.50 15.90 B 5,000 16.25 32.00 C 6,500 12.20 16.40 D 2,500 20.00 35.50 Use the price data to compute a Paasche index for the shipping cost if year 5 quantities are 4,500, 3,000, 7,500, and 3,000 for products A, B, C, and D, respectively. (Round your answer to the nearest integer.) I5 = ??
The data on profit and market capitalization for a sample of 15 different firms in Metro Manila are as below. Profits (In millions Pesos) y Market ( In millions Pesos) x 296.2 1936.9 -25 1171.8 4085 55135.8 6558 97417.2 12525 95198.9 3394 53579.7 442.8 12466.3 633.1 8894.3 3528 65872.4 2698 25661.3 1200.65 19854.7 11.987 195643.8 641.8 10447.8 5043 66695.5 5206 53558.4 Develop a scatter chart for the above data. What does this chart indicate about the relationship between market capitalization and profit? Use the data to develop an estimated regression equation that could be used to estimate a firm’s profit based on its market capitalization. What is the estimated regression model? What is the predicted profit for the market capitalization of 70721.3 (In million Pesos)?
ABC Company has decided to use 20 test markets to examine the sensitivity of demand for its new product, Hand Sanitizer, to various prices, as shown in the following table. Each market had approximately the same level of business activity and population. Test Market Quantity sold (Thousands of Pens) Price Charged (cent) 1 20 50 2 21 50 3 19 55 4 18 60 5 20 60 6 14 65 7 16 65 8 20 70 9 12 70 10 14 80 11 12 70 12 10 70 13 14 65 14 16 90 15 18 45 16 16 70 17 20 65 18 12 80 19 18 70 20 10 50 Q.1. Using a linear regression model, estimate the demand function for ABC Company’s new product, Hand sanitizer. Q.2. Interpret the coefficient value of the independent variable of the estimated demand function. Q.3. What will be the predicted/estimated sale for each price shown in column 2? Q.4. Find the prediction interval at…