Solution-Develop a linear trend equation

Develop a linear trend equation

Reference no: EM133117868

Question - The following time series shows the sales of supermarket chain over the last six months.

Month	Sales ($ 000)
August 2021	250
Sep 2021	280
Oct 2021	295
Nov 2021	320
Dec 2021	380
Jan 2022	360

Required -

(a) Develop a linear trend equation that can be used to forecast sales in Feb 2022?

(b) Forecast the sales in Feb 2021 using a three-period weighted moving average designed with the following weights: Nov 2021 weight 0.6, Dec 2021 weight 0.3 and Jan 2022 weight 0.1. Which method (A or B) is the best? Explain why.

Reference no: EM133117868

Questions Cloud

Calculate the amount of fixed overhead volume variance : The estimate for total budgeted overhead is $4492,000. Calculate and enter the amount of fixed overhead volume variance

What is the annual Interest Payment : The Accounting Department requested your assistance to resolve the following; Net Income = $23,750,000. What is the annual Interest Payment

What is the probability that it is overdue : One account is randomly selected. If the account is new, what is the probability that it is overdue? If the account is overdue, what is the probability

Innovation at IKEA : Which type (or types) of organizational culture do you think are dominant at IKEA?

Develop a linear trend equation : The following time series shows the sales of supermarket chain over the last six months. Develop a linear trend equation

What is marketing management : What Is Marketing Management? What Importance Do You Attach To Market Research In Your Profession?

What amount should be reported for cash : If the balance sheet were prepared for Creative Design Co. on August 31, what amount should be reported for cash

Identify what constitutes vulnerability in population group : Identify what constitutes vulnerability in a population group - Research and critically analyse the key concepts essential for successful health promotional

Improved as result of your internship : Describe specific skills that have improved as a result of your internship. Set specific goals to overcome your weaknesses.

User Account

All Pages

Develop a linear trend equation

Reference no: EM133117868

Reference no: EM133117868

Questions Cloud

Reviews

Write a Review

Accounting Basics Questions & Answers

Prepare the necessary adjusting entries at may

How much is the total assets as of December

The president of the retailer prime products has just

Calculate the firms operating income

Prepare a comparative balance sheet

During december western solvent completed 41800 units at

Discuss the options and determine the best choice

Prepare a journal entry to properly dispose of any balance

By how much is the manufacturing overhead underapplied or

The chief cost accountant for dr cinnamon beverage co

Compute the after tax cost of debt

Prepare the balance sheet as of december

Assured A++ Grade

Academics

Major Subjects

Majors

Get In Touch

TERMS & POLICIES

HELP & SUPPORT