Question: Problem #1 - (5 POINTS) - The table below shows the actual sales of a Product X sold by Company Y from January to December

Problem #1 - (5 POINTS) - The table below shows the actual sales of a Product X sold by Company Y from January to December of 2019. Month Actual Sales Naive Forecast - Absolute Value of (# of Product x) Sales Errors (# of Product x) Jan/19 1,860 Feb/19 2,033 Mar/19 3,556 Apr/19 4,211 May/19 6,250 Jun/19 7,990 Jul/19 10,250 Aug/19 9,850 Sep/19 9,980 Oct/19 9,990 Nov/19 7,895 Dec/19 5,353 Jan/20 A)- Explain the calculation method for the Nalve Forecast model. B) If at the end of every month from January/2019 to December/2019, the Sales Manager would have applied the Nalve Model, calculate the Naive Forecast values for the months of February/2019 and all the way to January/2020. Enter those values on the table above. C) Calculate the Absolute Value of Error for every forecasted month, from February/2019 to December/2020. Enter those values on the table above. D)- Why are there months when the Absolute Value of Error is very low and months when it is much higher? E)- Calculate the Mean Absolute Deviation (MAD), the Mean Squared Error (MSE) and the Mean Absolute Percent Error (MAPE) for the Naive Forecast you created for product X from March/2019 to December/2020 (not from February/2019 to January/2020)

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!

Chap 8 & 9 HW Saved Help Save & Exit Submit Check my work mode : This shows what is correct or incorrect for the work you have completed so far. It does not indicate completion. Return to question 3...

Question 1: Define break-even analysis and contribution in total and per unit Explain the concepts of budgeting and budget control, and why budgets are important for companies Explain the need for...

The demand for Okpa, a favourite breakfast cereal of people born in the 1930s, is experiencing a decline. The company wants to monitor demand for this product closely as it nears the end of its life...

UT 5 Samuelson and Messenger (SAM) began 2021 with 360 units of its one product. These units were purchased near the end of 2020 for $20 each. During the month of January, 180 units were purchased on...

Return to question 2 5 Samuelson and Messenger (SAM) began 2021 with 220 units of its one product. These units were purchased near the end of 2020 for $22 each. During the month of January, 110 units...

waved Exit SUL Check my word Samuelson and Messenger (SAM) began 2021 with 200 units of its one product. These units were purchased near the end of 2020 for $25 each. During the month of January, 100...

Expansion and replacement 1 Capital Budgeting Problems Problem 1: 10 points You are evaluating a new project for Globex Corporation as the company is planning to launch a new and very efficient...

PROBLEM 1 (38 points) The following data for the month of January are for Bloom Company, which sells just one product. Assume the company uses the periodic inventory system. Purchases Sales Units...

Attached is Accounting assignment along side recommended readings to answer certain questions. Thank you Assignment 1 Problem 1 15 points Reading - W. L. Ferrara, Cost/Management Accounting: The 21st...

I need help with the following questions. Please see attached documents. 1.(20 points) Brunswick Corporation sells bowling balls and has developed the following information: Sales price $70 per unit...

Why does the Covid-19 pandemic significantly impact planning for capital expenditures (capital budgeting)? Describe the difficulties both for those impacted positively by the pandemic and those...

Collins Company analyzes its accounts receivable at December 31 and arrives at the age categories below along with the percentages that are estimated as uncollectible. The balance of the allowance...

As of December 31, 20X7, Secret had declared but not yet paid its fourth-quarter dividend of $10,000. Both Private and Secret use the effective interest method for the amortization of bond discount...

Case Greenbuilders Pte Lid ("GPL") is a local construction company which specialises in providing bespoke Design and Build construction services for private residential homes that are designed to be...