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?

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…

Online Course Support | Operations Analytics

Suppose that Zooter considers producing 400 Razor scooters and 800 Navajo scooters. What is the objective function value, in $, corresponding to this solution?

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

Online Course Support | Operations Analytics

Irrespective of feasibility, what will be the total shipping cost, in $, that KDGL would incur under the shipping plan described in Q8?

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

Online Course Support | Operations Analytics

This question relates to the details of spreadsheet implementation of optimization models in Excel covered in Session 2.

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

Online Course Support | Operations Analytics

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

Online Course Support | Operations Analytics

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…

Online Course Support | Operations Analytics

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…

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

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

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,

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