Answered step by step
Verified Expert Solution
Question
1 Approved Answer
fZ. When are bouk sales the highest? f3. When are beak sales the lowest? 9. Predicl book sales for the nexl 9 months. {Round your
fZ. When are bouk sales the highest? f3. When are beak sales the lowest? 9. Predicl book sales for the nexl 9 months. {Round your answers to 4 decimal places.) h. In yourjudgmenl: are the forecasts \"g and\"? What disclaimer would you include wilh yourlu-recasl? OYes. forecasts assume that the future sales will be similar tn sales over the previous 39 months. ONO. forecasts assume that the future sales will not be similar to sales over the previous 39 months. 12 1,234 N 756 38 775 MAD= e. What is the average monthly trend in book-store sales? (Negative amounts should be indicated by a minus sign. Round your answer to 4 decimal places.) Average monthly trend in book-store sales million dollars per month f-1. What are the monthly indexes? (Round your answers to 4 decimal places.) Month Index 2 3 6The following data report total, monthly U.S. book-store sales in millions of dollars from January 2016 to March 2019. (Go to https://www.census.gov/retail/index.html#mrts, find "Monthly Retail Trade Report," then select "Time Series/Trend Charts" to find the data for the total U.S. bookstore sales.) Year Month 2016 2017 2018 2019 January 1.558 $ 1,476 $ 1,361 $ 1.234 February 817 721 799 758 March 809 797 824 776 April 798 819 800 May 868 871 877 June 803 817 July 777 August 1.614 1,464 1,454 September 1 154 1.087 1 076 October 805 779 831 November 793 858 December 1.346 1.247 1.349 Click here for the Excel Data File C. Which forecasting model is appropriate based on the data for the total U.S. bookstore sales? Appropriate model d. Evaluate a seasonally adjusted trend forecasting model. What is the MAD? (Round your answers to 4 decimal places.) Month Number S Sales Period Trend Index Absolute Millions) Forecast Error 1.55 N 817 809 799 G UI A W N 868 803 777 1,614 1.154 871 794 1.464 1.087 779
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