Question
Mal Foil the owner of Firefly Shipping has asked you to figure out a model to project the number of units they must be prepared
Mal Foil the owner of Firefly Shipping has asked you to figure out a model to project the number of units they must be prepared to ship in the first month of the new year. Mal has supplied you with a template of what he would like to see.
Download: Unit 06 Assignment - Firefly Shipping Model.xlsx Mal also has a specific set of requirements: o use a 3-month weighted average to forecast January. o see how the 3-month weighted average method would perform against historical data. o see the 3-month weighted average charted out within the model. o Mal is not sure how what weights he would like to use. Your model should allow him to adjust the weights, listed in G4-I4, and see these changes change the models output. The 3-month weighted average formula is listed below:
Unit 06 Assignment - Firefly Shipping Model.xlsx
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started