Question: Please show complete work, no excel! Use the information in the table to the right. Use the 3 - month weighted moving - average method

Please show complete work, no excel!

Use the information in the table to the right. Use the 3 - month weighted moving - average method to calculate the forecast for month 9 . The weights are 0.60 , 0.30 , and 0.10 , where 0.60 refers to the most recent demand. A. $3,396 B. $3,229 C. $3,916 D. $3,880 A sales manager wants to forecast monthly sales of the machines the company makes using the following monthly sales data

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!

Only need answers to Question E-G. Please show fourmulas from excel as well a) Create 2019 and 2020 forecasts using a 4- month weighted moving average where the weight of the most recent month is...

Please attach Excel file so I can study formulas! Thank you Demand Forecasting for the Inner-city Health Center Inner City Health Center is a federally funded health clinic that serves the needs of...

Demand Forecasting for the Inner-city Health Center Inner City Health Center is a federally funded health clinic that serves the needs of the inner-city poor. Currently the center is at the end of...

just need help with 6A please! Inner City Health Center is a federally funded health clinic that serves the needs of the inner-city poor. Currently the center is at the end of third-year operation...

Demand Forecasting for the Inner-city Health Center Inner City Health Center is a federally funded health clinic that serves the needs of the inner-city poor. Currently the center is at the end of...

(PLEASE SHOW YOUR WORK! Problem 1 (6 points): A manager wants to choose one of two forecasting alternatives: moving average and exponential smoothing. Each alternative was tested using historical...

1. The monthly sales for Telco Batteries, Inc., were as shown in the excel sheet. Please use 4-month weighted moving average method to forecast the demands from month 5 to month 19. The weight...

Can someone please solve all these questions ASAP! No need for explanation, i will give a thumbs up, and thanks. 1) OM Cafe uses a weighted moving average method to forecast cake sales. It assigns a...

You Consider a stock with a price of $50 that is expected to increase by 6% or decrease by 8% each month over the next two months. Having a risk-free rate of 3% per year with continuous compounding,...

The radius of the Moon's orbit is 385000 km. It takes 27 days for the Moon to complete one orbit. Calculate the orbital speed of the Moon. Give a suitable unit.

| x | M n = flimpilty pour evener! ! 4 8 2 [ Smet ' y pory annam ] + 3 4 5 0 7 ( Simplly your avame. ) A . E . 2 . 2 0 6

Note: This problem is for the 2018 tax year. Daniel B. Butler and Freida C. Butler, husband and wife, file a joint return. The Butlers live at 625 Oak Street in Corbin, KY 40701. Dan's Social...