Assignment Prompt: For Project 4, your assignment will be in Chapters 8 and 9. For the
next two weeks, you will be using the attached Excel Spreadsheet workbook to answer
6 data analysis questions. There are 6 tabs on the excel workbook, one for each of the
6 questions you will be answering. The first three tabs (1, 2, & 3) relate to Chapter 8
(Forecasting and demand planning) while tabs 4, 5, and 6 relate to calculations you will
be completing regarding chapter 9 (Inventory management). The 6 calculation problems
you will complete are all referenced back to an example in chapters 8 and 9. For most
of the tabs, there are multiple tasks to complete, all are sequential, so complete them in
order. The point values for each problem are in the instructions. Instructions: To receive
credit, you must use formulas to calculate all answers. If your Excel formulas skills are
rusty, a hyperlink is provided below to short tutorials in GCFLearnFree.org where you
can brush up on inserting formulas, summing tables of data, etc. It is recommended that
you review these early in Week 7. GCFLearnFree.org/Excel2016 Formulas (tutorials 2
trough 5) Finally, there are detailed instructions for how to complete each problem in the
Excel template below. Download the template, store it in your computer, then, please
read the instructions carefully. Upload the completed excel file to this week when you
are ready for it to be graded.