Logistics Excel Assignment

Logistics
Excel Assignment

This week is devoted to Time-Collection Forecasting methods. Begin within the Classes part of the classroom by finishing the studying and viewing assignments. Do not even take into consideration attempting to finish this homework task with out understanding the ideas concerned in Forecasting Time-Collection information. After getting the ideas down in chapter 5, and have accomplished the Dialogue discussion board, you’re prepared to start out this task. Obtain the Excel Template connected to this task onto your laptop, open it up, and skim by way of the “Pink Snapper Situation” on the prime of the web page. All of this week’s assignments focuses on historic Pink Snapper Catches for 2015 by way of 2018 (by Quarter) off the coast of Louisiana. The final 4 rows of the desk are empty as 2019 is what you’ll forecast utilizing the historic information for 2015 by way of 2018. As you scroll down by way of the Spreadsheet, you’ll discover within the far left column, there are 5 duties so that you can full this week. Each considered one of these duties is mirrored within the three YouTube movies under. Though this undertaking is about Pink Snapper Catches (your trustworthy designer’s favourite fish to catch and eat out of the southern bays of Louisiana) and the movies forecast Automotive gross sales, the method for forecasting the long run 12 months (in our case 2019) is similar.

You’ll want to watch these movies as you full every of the 5 duties. The place you wish to transition from video 1 to video 2 and from video 2 to video three may be very simple to see. One simple method to get began is to have a video open on one facet of your display screen and the excel template on the opposite.

Excel – Time Collection Forecasting – Half 1 of three (18:06 Minutes) https://www.youtube.com/watch?v=gHdYEZA50KE&t=1s

Excel – Time Collection Forecasting – Half 2 of three (15:00 minutes) https://www.youtube.com/watch?v=5C012eMSeIU

Excel – Time Collection Forecasting – Half three of three (17:02 minutes) https://www.youtube.com/watch?v=kcfiu-f88JQ&t=2s

Directions:

Obtain the template connected under for this task onto your laptop. Label this file as: Johnston_Assignment_5
It is vital that you just full the studying assignments first earlier than you deal with this task.
There are a number of “Duties” within the workbook; scroll down and ensure you have accomplished all 5 of the duties on this task earlier than pushing the ship button. Whenever you first open the Template, you might say “OMG, what have I gotten myself into?” Rightfully so, it is a huge undertaking, and, like consuming an 18 inch pizza, it is best executed one chew at a time. So, look over the duties after which entry the primary video and get going. It is in all probability a good suggestion to observe the primary video all over to get a really feel for the place you’re going earlier than beginning on the primary activity. In the event you get misplaced and might’t fairly work out easy methods to proceed, message your teacher, we’re at all times glad to assist.
This weeks task is greatest accomplished whereas watching the movies above; so as. It is strongly recommended that you’ve got the video open on one facet (half of) of your display screen and the homework template on the second half of the display screen. That approach, you possibly can watch the video and full the task synchronously. Make sense?
Here is a (hand-crafted) assist video that exhibits easy methods to full the Excel Spreadsheet: