Business & Finance SCMG201 Week 8 Assignment

3/26/23, 8:50 AM Weeks 7&8: Project 4 - SCMG201 I001 Winter 2023 - APEI

https://myclassroom.apus.edu/d2l/lms/dropbox/user/folder_submit_files.d2l?db=300134&grpid=0&isprv=0&bp=0&ou=78650 1/2

Weeks 7&8: Project 4

Hide Assignment Informa�on

Instructions

SCMG201 I001 Winter 2023 LE

Assignments Weeks 7&8: Project 4

Assignment Instructions

Weeks 7&8 Project 4: Excel Data Analysis

Course Objectives:

CO8: Evaluate the impact of the forecasting processes and demand planning on a supply chain's effectiveness.

CO9: Evaluate the impact of Inventory management systems on a supply chain network's effectiveness

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:

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. Use the following naming convention JSmith_Project4

3/26/23, 8:50 AM Weeks 7&8: Project 4 - SCMG201 I001 Winter 2023 - APEI

https://myclassroom.apus.edu/d2l/lms/dropbox/user/folder_submit_files.d2l?db=300134&grpid=0&isprv=0&bp=0&ou=78650 2/2

Add a File Record Audio Record Video

Due Date

Apr 2, 2023 11:59 PM

Attachments

Project 4 Excel Template.xlsx (69.29 KB)

Download All Files

Submit Assignment

Files to submit

(0) file(s) to submit

After uploading, you must click Submit to complete the submission.

Comments

Submit Cancel