60.1K

Verified Solution

Question

Accounting

v
image
image
image
image
G18 x B D E F G H 14 16 13 747 1 Month 2 Item 1 3 Item 2 15 763 18 743 553 764 17 746 633 755 662 605 528 668 539 4 item 3 5 Item 4 576 496 627 377 647 287 738 673 250 832 835 6 3. Fill in actual sales and complete model for the next 6 months. Actual demand is on Sheet3. B D E 1 2 3 Month Item 1 Item 2 Item 3 Item 4 4 1 751 250 666 287 5 2 741 268 618 352 6 3 728 289 483 416 7 4 773 314 375 313 00 8 5 718 337 303 359 9 6 752 367 242 440 10 7 736 391 210 520 11 00 8 768 409 239 391 12 9 729 433 342 449 13 10 777 459 396 550 14 11 748 481 457 650 15 12 756 500 587 489 16 17 Assignment: 1. Graph each item's sales history on the Graphs tab. Give an example of a product that might fit that pattern. Item1 Item2 Item3 ;item4 2. Forecast the next 6 months of Item 4 using exponential smoothing, alpha = .3 Forecast for next 6 months: Month13 Month14 Month15 Month16 Month17 Month18 3. Fill in actual sales and complete model for the next 6 months. Actual demand is on Sheet3. 4. Determin error and bias of forecast: MAD MAPE TS

Answer & Explanation Solved by verified expert
Get Answers to Unlimited Questions

Join us to gain access to millions of questions and expert answers. Enjoy exclusive benefits tailored just for you!

Membership Benefits:
  • Unlimited Question Access with detailed Answers
  • Zin AI - 3 Million Words
  • 10 Dall-E 3 Images
  • 20 Plot Generations
  • Conversation with Dialogue Memory
  • No Ads, Ever!
  • Access to Our Best AI Platform: Flex AI - Your personal assistant for all your inquiries!
Become a Member

Other questions asked by students