a commercial bakery has recorded sales (in dozens) for three products, as shown below:
Forecasting & Smoothing Methods
Solved Problem #1: see text book
Solved Problem #2: see textbook (manual example using seasonal relatives)
Solved Problem #3: see textbook
Solved Problem #4: see textbook (you do not have to do this problem manually, use the template and notice how the template answers differ slightly from the seasonal relatives provided in the manual example)
To avoid manually entering the data into the templates it can be copied and pasted from Data Sets on the Lesson Page. Use “copy, paste special, values” to transfer the data to the template.
#1: A commercial bakery has recorded sales (in dozens) for three products, as shown below.
|a. Determine the Naïve forecast for day 16.|
b. What does the use of sales data rather than demand data imply?
#2: National Scan, Inc., sells radio frequency inventory tags. Monthly sales ($000) for a seven-month period were as follows:
- Plot the monthly data.
- Forecast September sales volume in thousands of dollars using the following methods: Show your answers in the space provided.
2. Five-month moving average
3. Weighted moving average using .60 for August, .30 for July, and .10 for June
4. Exponential smoothing with a smoothing constant of .20
5. Linear trend equation.
#3: A cosmetics manufacturer’s marketing department has developed a linear trend equation that can be used to predict annual sales of its popular Hand & Foot Cream.
Ft =80+15t where
F t= annual sales (000 bottles)
t = 0corresponds to1990
- Indicate how much the sales are increasing or decreasing?
- Predict sales for the year 2006 using the equation? This is a manual problem!
#4: Freight car loadings over a 12-year period at a busy port are as follows: The units are in thousands of tons.
- Determine the linear trend equation for the freight car loadings.
- What is the slope? Interpret it.
|c.||Use the trend equation to predict the freight loadings for years 20 and 21.|
|d.||The manager intends to install new equipment when the loadings exceeds 800 (thousand tons) per|
|year. Assuming the current trend continues the loading volume will reach that level in|
|approximately what year? This is a manual problem!|
#5: A manager of a store that sells and installs spas wants to prepare a forecast for January, February and March of next year. Her forecasts are a combination of trend and seasonality.
The linear trend equation is
Ft =70+5t where
t =0 corresponds to June of last year
The seasonal relatives are 1.10 for January, 1.02 for February, and .95 for March.
- What demand should she predict for January, February and March of next year? This is a manual problem! If you need some hints on this problem, refer to solved problem #2 in the textbook.
#6: Obtain estimates of daily relatives for the number of customers at a restaurant for the evening meal given the past 4 weeks of historical data. Day 1 is day 1 of week 1, day 8 is day 1 of week 2, etc.
a. Construct a graph that will enable you to visualize the daily variation in meals served.
b. What are the daily adjusted seasonal relatives?
c. Plot the adjusted seasonal relatives on a graph for each day of the week?
- Determine the forecast for meals to be served for the next 7 days.
- Plot historical demand with forecast on the same graph.
#7: A farming cooperative manager wants to estimate quarterly relatives for grain shipments, based on the 5 years of data shown below (quantities are in metric tons). You will have to enter this data into the template manually.
a. Calculate the quarterly adjusted seasonal relatives.
b. Use the adjusted seasonal relative to determine what percentage shipments in quarter 4 are greater than shipments quarter 3.
|Category||Business & Management|
|Paper Type||Case Study Writing|
Our Online Writers
Check Our Live Stats
Frequently Asked Questions
Private and Confidential
Client’s all information is private and confidential; it is not shared with any other party. Even, we don’t ask client name and give user name to his/her profile. So, no one will know that you have taken help for your Academic paper from us.
We only accept PayPal as our payment method. It is 100% secure. As, We don’t take and store any Credit/Debit card information.
It is guaranteed all your Homework/Assignments Solutions are plagiarism free and original. Writers here charge for their efforts not for Copy/Paste work and TOS management takes strict action against those writers.
All the writers working here are recruited and chosen after taking strict evaluation of their Academic degrees, Experience and background. Then, they are allowed to work here as providing quality homework solution is our first priority.
24/7 online Writers
Our website is worldwide forum, where 100s of experts all over the world remain online round a clock, so, you can come at anytime and get the help from any of your homework. Even Urgent within 1 hour!
Prices at TutorsOnSpot.com
Prices at tutorsonspot.com are very competitive and low. As, tutorsonspot.com is marketplace so, all the writers bid for getting the work and competition among the writers lowers the price and you get your work done at low minimal prices.
- Our service provides you with original content that does not have plagiarism in it. We are renowned for providing our customers with customized content that is written specifically for them. If you are thinking, can someone help me with my research paper? You can depend on us to help you out.
- Our motto is to meet deadlines and deliver your solution right on time.We understand that you want to save your time and we respect it. Regardless of the difficulty, we deliver an unparalleled solution without any delay. Moreover, you get a money back guarantee in case you are not satisfied with our service. To understand this guarantee, check our terms and conditions related to it.
- We perform a detailed research when writing your paper. With all of our services, we ensure to perform extensive research before creating your solution. Furthermore, if you have any questions, just reach out to our customer service team that is available all the day.
- It is our primary goal to satisfy you. Thus, if you are thinking: can someone write my research paper? Just contact us and get the best services that you can get.
Homework Questions in Business & Management
- How to Sell Anything to Anyone Udemy Free Download
- Business Analysis Fundamentals Udemy Free Download
- Build Internet of Things with ESP8266 & MicroPython
- The Complete Guide to League of Legends
- 2020 Complete Guide to YouTube Channel & YouTube Masterclass
- The Complete Final Cut Pro X Video Editing Crash Course
- C# Basics for Beginners – Learn C# Fundamentals by Coding
- MERN Stack React Node Ecommerce from Scratch to Deployment
- Learn Illustrator CC: Create Simple Flat Vector Characters
- Learn Python With 20+ Real World Projects [In 2020]
- A Complete Guide on TensorFlow 2.0 using Keras API
- Instagram marketing 2020 hashtags live stories ads & more
- Fullstack GoLang React Insanity Volume 1
- Blockchain Web Development on Ethereum 
- Microsoft Excel: Data Analysis using Excel Pivot Tables
- The Last Amazon FBA Course – [ 2020 ] Private Label Guide
- Excel vba programming – the complete guide
- Blender character creator v2.0 for video games design
- The Complete React Native + Hooks Course [2020 Edition]
- [Udacity] Become a Sensor Fusion Engineer
- [PacktPub] Hands-On Machine Learning for .NET Developers
- [Frontend Masters] Angular 9 Fundamentals
- Technical Analysis MasterClass:Trading By Technical Analysis
- Transformational Leadership – Leadership Course & Training
Best Service for the Struggling Students
Services For All Subjects
We have experienced tutors and assignment experts from all over the world for all subjects.
24/7 Live Writers
100's of qualified phd tutors round the clock.
Best Price Guarantee
Compare our price. Our services are of highest quality and lowest price, Guaranteed.
Plagiarism Free Work
Safe Payment Options
Pay using paypal though verified gateway for maximum safety, No risk.
100% Privacy Guaranteed
Scan our work with all plagiarism checking tools, Result will always be 0%.