Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Old MathJax webview Can you give me the weighted moving average, exponential smoothing, and the MAD with information provided? That's the whole question... Please answer

Old MathJax webview

image text in transcribed

image text in transcribed

image text in transcribed

image text in transcribed

Can you give me the weighted moving average, exponential smoothing, and the MAD with information provided?

That's the whole question... Please answer what you can...

3) Complete the forecasting for a 2 month moving average, a 3 month moving average, a weighted moving average and exponential smoothing. Find the MAD for all four forecasting models. Select which model is the most accurate. Actual 2 Time Period Sales 1 345 2 378 3 425 4 450 5 470 Volu 6 500 7 532 8. 548 9 590 10 625 11 650 MAD Cost "H Category Cost Rent Payment Period Monthly Monthly Quarterly Annually Per Shelf $3,000 1,100 1,200 Utilities Insurance 6,000 Property Taxes 9 Steel Per Shelf Forming 0.25 Labor Per Shelf 0.75 Price 20 Per Shelf Income Statement January 46,062 February Horizc 44,759 Total Revenues Returns & Allowances 545 685 Net Sales Cost of Goods Sold 45,517 13,841 31,676 44,074 11,583 32,491 Gross Profit 2,500 2,500 15,750 14,250 Operating Expenses Officer's Salary Salaries Payroll Taxes Rent Janitorial 3,623 2,000 3,278 2,000 150 150 512 485 500 500 Utilities Depreciation Sales Taxes Total Operating Expenses Operating Profit/Loss Interest Expense Net Profit/Loss 2,994 28,029 2,909 26,072 3,647 6,419 150 150 3,497 6,269

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Supply Chain Finance Solutions

Authors: Erik Hofmann, Oliver Belin

1st Edition

3642175651, 978-3642175657

More Books

Students also viewed these Finance questions