Question

Question 1 4 pts The actual demand for your sales merchandise is provided in the table below. The weights for June, July, andQuestion 6 4 pts Assuming no safety stock, what is the reorder point (R) given an average daily demand of 50 units, a lead tiQuestion 8 4 pts Given the data below, forecast demand for the 2017 demand for the product using the simple moving average me

0 0
Add a comment Improve this question Transcribed image text
Answer #1

data : 1) Using given The weighted moving average given forecast is as :- Futi 11 DUSCDP) + 0-3 (0:)+ 0.2 (0+) 0.45+0.35+0.2

Add a comment
Know the answer?
Add Answer to:
Question 1 4 pts The actual demand for your sales merchandise is provided in the table...
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Not the answer you're looking for? Ask your own homework help question. Our experts will answer your question WITHIN MINUTES for Free.
Similar Homework Help Questions
  • Assume that your stock of sales merchandise is maintained based on the forecast demand. If the...

    Assume that your stock of sales merchandise is maintained based on the forecast demand. If the distributor's sales personnel call on the first day of each month, compute your forecast sales by each of the three methods requested here. ACTUAL June 154 July 194 August 225 a. Using a simple three-month moving average, what is the forecast for September? (Round your answer to 2 decimal places.) b. Using a weighted moving average, what is the forecast for September with weights...

  • Forecasts and actual sales of MP3 players at Just Say Musicare as follows: Month                   Forecast    Actual Sales March &nb

    Forecasts and actual sales of MP3 players at Just Say Musicare as follows: Month                   Forecast    Actual Sales March                    150            170 April                      220            229 May                       205            192 June                       256            241 July                       250            238 August                  260            210 September             270            225 October                 280            179 a. Plot the data and show the plot using Excel, Word or PowerPoint.   b. Provide insights about the time series c. What is the forecast for November, using a two-period moving average? Note also that the forecast values provided are irrelevant to computing these moving average forecasts. d. What is the forecast for November, using a three-period...

  • Forecasts and actual sales of MP3 players at Just Say Music are as follows: Month Forecast...

    Forecasts and actual sales of MP3 players at Just Say Music are as follows: Month Forecast Actual Sales March 150 170 April 220 229 May 205 192 June 256 241 July 250 238 August 260 210 September 270 225 October 280 179 Answer the following questions. a. Plot the data and provide through insights about the time series. (Use Microsoft Excel and attach the time series graph.) b. What is the forecast for November, using a two-period moving average? c....

  • The Actual demands in the last 4 periods are given. Which of the following statement is...

    The Actual demands in the last 4 periods are given. Which of the following statement is not true? Period Ai Weight 1 10 2 20 0.3 3 30 0.3 4 20 0.4 A. F5=23.33 using Moving Average and n=3 B. F5=20 using Naive Approach C. When the business environment is more dynamic, we tend to choose smaller smoothing constant value. D. F5=23 using Weighted Moving Average when n=3 and the weight is 0.4, 0.3, and 0.3 for period 4, 3,...

  • QUESTION 32 A company's demand forecast for the next 6 months is shown in the table...

    QUESTION 32 A company's demand forecast for the next 6 months is shown in the table below as daily demand (units/day). Their average daily demand over the all 6 months is 41 units/day. If the company decides to use subcontractor to help with the production, answer the following two questions. May June July August September October 43 46 37 34 30 51 The number of units produced in house The number of units subcontracted = QUESTION 31 4 points A...

  • Answer All the Question(s) a) The following information is available for XYZ Company Period                        1    &nbsp

    Answer All the Question(s) a) The following information is available for XYZ Company Period                        1      2    3 4    5 6 Units sold (000) 150 120 180 150 140 160 Units produced (000) 150 150 150 150 170 140 Budgeted activity is expected to average 150,000 units per period and there is no opening stock for period 1. Unit selling price is Ksh 10, Unit variable cost is Ksh 6, fixed costs per period is Ksh 300,000 while non manufacturing...

  • Question 29 3 pts Annual demand for an item is 13,000 units with the cost per...

    Question 29 3 pts Annual demand for an item is 13,000 units with the cost per unit at $243. The holding rate is 10% and the order cost is $12.00 per order. The standard deviation of daily demand is 3 units. Assume 260 days in the year and a lead-time of 2 days. If a service level of 97% is desired during the reorder interval, what is the safety stock required? (Note: Due to rounding and your exact choice of...

  • This is a table to show how to calculate a three-month moving average. Please use this...

    This is a table to show how to calculate a three-month moving average. Please use this same data to calculate a four-month moving average. ACTUAL SHED SALES 10 12 13 16 19 23 26 30 28 18 16 MONTH 3-MONTH MOVING AVERAGE January March (10+ 12 + 13)3 -11.67 (12 13+ 16/3-13.67 (13 + 16 + 19)/3# 16.00 (16 + 19 +23Y3- 19.33 19 +23 + 26V3-22.67 (23+26 +30/3-26.33 (26+30 +28)V3-28.00 (30 +28 + 18/3-25.33 (28 + 18 + 163-20.67...

  • she e A O AoCE A Cd Aaßbo AabCc T H Rp E Question 4 (20%)...

    she e A O AoCE A Cd Aaßbo AabCc T H Rp E Question 4 (20%) Historical demand for a product is Demand January February 11 March 12 15 April May June 12 16 15 a) Using a weighted moving average with weights of 0.60, 0.30 and 0.10, find the July forecast b) Using a simple three-month moving average, find the July forecast. c) Using single exponential smoothing with a 0.2 and a June forecast 13, find the July forecast....

  • 23 and 24 DI Question 23 4 pts Which of the following is the least useful sales forecasting model to use when sales...

    23 and 24 DI Question 23 4 pts Which of the following is the least useful sales forecasting model to use when sales are increasing? O Simple moving average O Simple average O Naive O Weighted moving average D Question 24 4 pts Student tultion at Eagle University is $500 per semester credit hour. The state supplements school revenue by matching student tuition dollar for dollar. Average class size for a typical three-credit course is 50 students. Labor costs are...

ADVERTISEMENT
Free Homework Help App
Download From Google Play
Scan Your Homework
to Get Instant Free Answers
Need Online Homework Help?
Ask a Question
Get Answers For Free
Most questions answered within 3 hours.
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT