Company ABC specialises in crude oil refining. Your manager tasked you to develop a six-month sales forecast for the barrels, based on previous year's production numbers below. You are required to calculate: Previous year base (Barrels) Growth Base projection (Barrels) Promotion (Barrels) Sales forecast (Barrels) Your manager anticipates to factor in the 7% estimated in growth rate. In addition, your company thinks the promotion will this year result in a sales increase of 30 barrels in April and 30 barrels in June. Sales forecasting Previous year (Barrels) Promotion sales (Barrels) Jan. 223 Feb. 250 March April May 284 371 25 25 469 June 501

Essentials of Business Analytics (MindTap Course List)
2nd Edition
ISBN:9781305627734
Author:Jeffrey D. Camm, James J. Cochran, Michael J. Fry, Jeffrey W. Ohlmann, David R. Anderson
Publisher:Jeffrey D. Camm, James J. Cochran, Michael J. Fry, Jeffrey W. Ohlmann, David R. Anderson
Chapter8: Time Series Analysis And_forecasting
Section: Chapter Questions
Problem 11P: For the Hawkins Company, the monthly percentages of all shipments received on time over the past 12...
icon
Related questions
Question
100%
Company ABC specialises in crude oil refining. Your manager tasked you to develop a six-month
sales forecast for the barrels, based on previous year's production numbers below. You are
required to calculate:
Previous year base (Barrels)
Growth
Base projection (Barrels)
Promotion (Barrels)
Sales forecast (Barrels)
Your manager anticipates to factor in the 7% estimated in growth rate. In addition, your company
thinks the promotion will this year result in a sales increase of 30 barrels in April and 30 barrels in
June.
Sales forecasting
Previous year (Barrels)
Promotion sales (Barrels)
Jan.
223
Feb.
250
March April May
284
25
371
25
469
June
501
Transcribed Image Text:Company ABC specialises in crude oil refining. Your manager tasked you to develop a six-month sales forecast for the barrels, based on previous year's production numbers below. You are required to calculate: Previous year base (Barrels) Growth Base projection (Barrels) Promotion (Barrels) Sales forecast (Barrels) Your manager anticipates to factor in the 7% estimated in growth rate. In addition, your company thinks the promotion will this year result in a sales increase of 30 barrels in April and 30 barrels in June. Sales forecasting Previous year (Barrels) Promotion sales (Barrels) Jan. 223 Feb. 250 March April May 284 25 371 25 469 June 501
Expert Solution
steps

Step by step

Solved in 2 steps with 2 images

Blurred answer
Knowledge Booster
Receivables Management
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, accounting and related others by exploring similar questions and additional content below.
Similar questions
  • SEE MORE QUESTIONS
Recommended textbooks for you
Essentials of Business Analytics (MindTap Course …
Essentials of Business Analytics (MindTap Course …
Statistics
ISBN:
9781305627734
Author:
Jeffrey D. Camm, James J. Cochran, Michael J. Fry, Jeffrey W. Ohlmann, David R. Anderson
Publisher:
Cengage Learning
Entrepreneurial Finance
Entrepreneurial Finance
Finance
ISBN:
9781337635653
Author:
Leach
Publisher:
Cengage
EBK CONTEMPORARY FINANCIAL MANAGEMENT
EBK CONTEMPORARY FINANCIAL MANAGEMENT
Finance
ISBN:
9781337514835
Author:
MOYER
Publisher:
CENGAGE LEARNING - CONSIGNMENT
Corporate Fin Focused Approach
Corporate Fin Focused Approach
Finance
ISBN:
9781285660516
Author:
EHRHARDT
Publisher:
Cengage
Intermediate Financial Management (MindTap Course…
Intermediate Financial Management (MindTap Course…
Finance
ISBN:
9781337395083
Author:
Eugene F. Brigham, Phillip R. Daves
Publisher:
Cengage Learning
Financial Reporting, Financial Statement Analysis…
Financial Reporting, Financial Statement Analysis…
Finance
ISBN:
9781285190907
Author:
James M. Wahlen, Stephen P. Baginski, Mark Bradshaw
Publisher:
Cengage Learning