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 using Excel. Only use Excel if you cannot answer this question otherwise.

ByAdmin August 3, 2021August 4, 2021

Question 4

In a typical week, Zooter has ample warehouse capacity to store the scooters it manufactures. The company has just learned that one of its warehouses got flooded and will not be available to store scooters produced in the coming week. As a result, Zooter projects that its total storage capacity for the coming week will be limited to 8000 cubic feet. One unit of Razor model requires 6 cubic feet of storage capacity and one unit of Navajo model requires 7 cubic feet of storage capacity. In terms of decision variables R and N, which algebraic expression represents the constraint “the total storage capacity required for the next week’s production cannot exceed 8000 cubic feet”?

1 point

Online Course Support | Operations Analytics

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
ByAdmin August 4, 2021August 4, 2021

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….

Read More 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
Online Course Support | Operations Analytics

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,
ByAdmin August 4, 2021August 4, 2021

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….

Read More 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,
Online Course Support | Operations Analytics

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.
ByAdmin August 4, 2021August 4, 2021

9. Question 9 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. The…

Read More 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.
Online Course Support | Operations Analytics

The formula in cell C5 is “=SUMPRODUCT($A$1:$C$1,A2:C2)”. If one copies and pastes the formula from the cell C5 into the cell C6, what numerical value will appear in the cell C6?
ByAdmin August 4, 2021August 4, 2021

7. Question 7 This question relates to the details of spreadsheet implementation of optimization models in Excel covered in Session 2. You should be able to answer this question using…

Read More The formula in cell C5 is “=SUMPRODUCT($A$1:$C$1,A2:C2)”. If one copies and pastes the formula from the cell C5 into the cell C6, what numerical value will appear in the cell C6?
Online Course Support | Operations Analytics

Suppose that, in evaluating the old and the new data plan for our consultant, we set-up a simulation with n=5 simulation runs and use Excel to generate the following random instances of her data usage, in GB: 14.6, 27.4, 19.6, 30.8 and 25.6. Calculate the corresponding 5 values of the monthly payments under the old plan. What is the sample mean, in $, of these payment values? Choose the closest answer from the choices below.
ByAdmin August 4, 2021August 4, 2021

7. Question 7 You can answer this question using only the information provided below. You can also use the file DataPlan10.xlsx we created in Session 2 to answer the question….

Read More Suppose that, in evaluating the old and the new data plan for our consultant, we set-up a simulation with n=5 simulation runs and use Excel to generate the following random instances of her data usage, in GB: 14.6, 27.4, 19.6, 30.8 and 25.6. Calculate the corresponding 5 values of the monthly payments under the old plan. What is the sample mean, in $, of these payment values? Choose the closest answer from the choices below.
Online Course Support | Operations Analytics

Demand at a store can be modeled by a random variable which takes the following values across four different scenarios that occur with following probabilities
ByAdmin August 4, 2021August 4, 2021

2. Question 2 This question relates to concepts covered in Lectures 1 & 2. You can use any of the excel files posted to work through the question. Demand at…

Read More Demand at a store can be modeled by a random variable which takes the following values across four different scenarios that occur with following probabilities

Similar Posts