Question

2. National Scan, Inc., sells radio frequency inventory tags. Monthly sales for a seven-month period were as follows: Sales (
3. Compute the multifactor productivity measure for each of the weeks shown for production of chocolate bars. What do the pro
0 0
Add a comment Improve this question Transcribed image text
Answer #1

Answer 2 a: Plot monthly data SALES (000) 24 22 20 18 16 14 12 10 8 6 4 2 0 FEB MAR APR MAY JUN JUL AUGAnswer 2 b: September: Naïve forecast=20,5 month moving average forecast=19 B С 1 A Month feb Sales (000) 19 2 3 4 mar 18 15Formulas in excel A B C 1 Month Sales (000) 2 feb 19 3 mar 18 4 apr 15 5 may jun jul 20 18 6 7 22 8 aug 20 9 sep (in 000s) N

Add a comment
Know the answer?
Add Answer to:
2. National Scan, Inc., sells radio frequency inventory tags. Monthly sales for a seven-month period were...
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
  • National Scan, Inc., sells radio frequency inventory tags. Monthly sales for a seven-month period were as...

    National Scan, Inc., sells radio frequency inventory tags. Monthly sales for a seven-month period were as follows: MonthSales(000)UnitsFeb.15Mar.18Apr.12May.20Jun.23Ju1.23Aug -27b. Forecast September sales volume using each of the following: (1)A linear trend equation.(2) A five-month moving average. (3) Exponential smoothing with a smoothing constant equal to .25, assuming a March forecast of 17(000).(4) The naive approach. (5) A weighted average using.55 for August, .10 for July, and .35 for June.

  • National Scan Inc. sells radio frequency inventory tags. Monthly sales for a seven-month period were as...

    National Scan Inc. sells radio frequency inventory tags. Monthly sales for a seven-month period were as follows: Month Sales (000) Units Feb 19 Mar 18 Apr 15 May 20 Jun 18 Jul 22 Aug 20 b. Forecast September sales volume using each of the following: SHOW WORKS!!!! (1) Thenaiveapproach. (2) A five month moving average. (3) A weighted average using .60 for August, .30 for July, and .10 for June. (4) Exponential smoothing with a smoothing constant equal to .20,...

  • National Scan, Inc., sells radio frequency inventory tags. Monthly sales for a seven-month period were as...

    National Scan, Inc., sells radio frequency inventory tags. Monthly sales for a seven-month period were as follows: Month Sales (000)Units Feb. 17 Mar. 20 Apr. 14 May. 22 Jun. 21 Jul. 25 Aug. 29 b. Forecast September sales volume using each of the following: (1) A linear trend equation.(Round your intermediate calculations and final answer to 2 decimal places.)    Yt _ thousands (2) A five-month moving average. (Round your answer to 2 decimal places.)    Moving average _ thousands...

  • 1. National Scan, Inc sells radio frequency inventory tags. Monthly sales for a seven-month period were as follows:

    1. National Scan, Inc sells radio frequency inventory tags. Monthly sales for a seven-month period were as follows: Month Sales (000 units) Feb. 21 Mar. 20 Apr. 17 May 22 Jun. 20 Aug. 22 a. Plot the monthly data on a sheet of graph paper.b. Forecast September sales volume using each of the following: (1) The naive approach (2) A five month moving average (3) A weighted average using 60 for August, 30 for July, and. 10 for June (4) Exponential smoothing with a smoothing constant equal to.20, assuming a March-forecast of...

  • Problem 3-2 National Scan, Inc., sells radlo frequency Inventory tags. Monthly sales for a seven-month period...

    Problem 3-2 National Scan, Inc., sells radlo frequency Inventory tags. Monthly sales for a seven-month period were as follows: Sales Month(ee)Units Feb Mar Apr May Jun Jul Aug 2e 23 25 18 28 30 b. Forecast September sales volume using each of the folloWng: (1 A linear trend equation.(Round your Intermedlate calculatlons and final answer to 2 declmal places.) Yt thousands (2) A five-month moVing average. (Round your answer to 2 declmal places.) Moving averagehousands (3) Exponentlal smoothing with a...

  • Chapter 2 Homework 27 Problem 2-3 Compute the multifactor productivity measure for each of the weeks...

    Chapter 2 Homework 27 Problem 2-3 Compute the multifactor productivity measure for each of the weeks shown for production of chocolate bars. Assume 40-hour weeks and an hourly wage of $16. Overhead is 1.5 times weekly labor cost Material cost is $9 per pound. (Round your answers to 2 decimal places.) 10 week Output (units)WorkersMaterial (lbs) 32,900 37,800 28,800 38,8e0 470 520 480 580 (Output/ Total Cost)

  • Please answer the following question correctly please: Problem 2-3 Compute the multifactor productivity measure for each...

    Please answer the following question correctly please: Problem 2-3 Compute the multifactor productivity measure for each of the weeks shown for production of chocolate bars. Assume 40-hour weeks and an hourly wage of $16. Overhead is 1.5 times weekly labor cost. Material cost is $9 per pound. (Round your answers to 2 decimal places.) Output (units) 32,000 37,000 28,000 38,000 Week Workers Material (lbs) 470 520 480 580 3 Week MFP (output /Total Cost)

  • ASSIGNMENT: #2 a through c. NOTE: Problem 2b. (1), change toNaive with Trend 2. National Scan,...

    ASSIGNMENT: #2 a through c. NOTE: Problem 2b. (1), change toNaive with Trend 2. National Scan, Inc., sells radio frequency inventory tags. Monthly sales for a seven-month period were as follows: Month Feb. Mar. Apr. May Jun. Jul. Aug Sales (000 units) 19 18 15 20 18 22 20 a. Plot the monthly data on a sheet of graph paper. b. Forecast September sales volume using each of the following: (1) The naive approach. (2) A five month moving average....

  • A can opener manufacturer has had monthly sales for a seven-month period as follows: Month         ...

    A can opener manufacturer has had monthly sales for a seven-month period as follows: Month          Sales (000 units) Feb. 19 Mar. 18 Apr. 15 May 20 Jun. 18 Jul. 22 Aug. 20 a) Plot the data b) Forecast September's sales volume and the previous months and calculate MAD for each method using each of the following: 1)The naïve approach. 2)A four-month moving average. 3)A weighted average using .50 for the recent month, .30 for 2 months ago, and .20...

  • The monthly sales for Yazici Batteries, Inc. were as follows: Month Jan 20 Feb 21 Mar...

    The monthly sales for Yazici Batteries, Inc. were as follows: Month Jan 20 Feb 21 Mar 16 Apr May 15 13 Jun 18 Jul 15 Aug Sept Oct Nov Dec 18 19 22 202 This exercise contains only parts de b) The forecast for the next month (Jan) using the naive method = 24 sales (round your response to a whole number) The forecast for the next period (Jan) using a 3-month moving average approach = 22 sales (round your...

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