Consider a solution R=800 and N=500. Is this solution feasible?
3. Question 3 This question relates to the Zooter Example discussed in Sessions 1 and 2, and tests your understanding of the algebraic model formulation. You can answer it without…
-
-
From the LA warehouse, it wants to ship 5 tons to each of three distributions centers From the Chicago warehouse, it wants to ship 6 tons to Denver distribution center, 7 tons to Austin distribution center, and 7 tons to Washington distribution center From the New York City warehouse, it wants to ship 10 tons to each of three distribution centers Is this a feasible shipping plan?
8. Question 8 This question relates to the KDGL example introduced in Session 3, and tests your understanding of the algebraic model formulation. You can answer it without using Excel….
-
Suppose now that the company considers a production plan that includes 500 Razor scooters and 700 Navajo scooters. How many frame manufacturing hours will this production plan require?
2. Question 2 This question relates to the Zooter Example discussed in Sessions 1 and 2, and tests your understanding of the algebraic model formulation. You can answer it without…
-
Zooter’s sales department has revised its projections for the profit contributions of the two scooter models. The department now estimates that the profit contribution for each unit of Razor model will be $135 and the profit contribution for each unit of Navajo model will be $170. If these new profit contributions are used in the Excel optimization model, and the Solver is re-run to find the new optimal solution, what is the new optimal value of the objective function, in $?
5. Question 5 This question relates to the Zooter Example discussed in Sessions 1 and 2, and tests your understanding of the algebraic model formulation. This question requires you to…
-
Mr. Cal Coolator uses a trend line forecasting model to forecast the daily demand for 1-quart water bottles at a convenience store based on the average temperature recorded outside during the day. The demand line is given by
7. Question 7 This question relates to concepts covered in Sessions 3 and 4. You can use any of the excel files posted online to work through the Quiz. Mr….
-
Using DemandData.xlsx file on the course website, and using the “Moving averages of 13” method, i.e., MA (13), calculate the moving averages for periods 81 through 100. In particular,
5. Question 5 Using DemandData.xlsx file on the course website, and using the “Moving averages of 13” method, i.e., MA (13), calculate the moving averages for periods 81 through 100….
-
Suppose you are a manager at a ski resort in Utah. The ski resort collects and keeps data on the demand for ski rentals over the past several seasons.
8. Question 8 This question relates to concepts covered in Sessions 3 and 4. You can use any of the excel files posted online to work through the Quiz. Suppose…
-
Consider the demand at a store given by the data in the previous question, i.e., the demand at a store that can be modeled by a random variable with values and corresponding probabilities shown in Q2. Which of the following statements about the standard deviation of the demand distribution is true?
3. Question 3 This question relates to concepts covered in Lectures 1 & 2. You can use any of the excel files posted to work through the question. Consider the…
-
-
The number of customer requests for car rentals recorded on each day at a Philly Cars rental location is as follows:
6. Question 6 The number of customer requests for car rentals recorded on each day at a Philly Cars rental location is as follows: Day Number of Car Rental Requests…