Lenovo uses the ZX-81 chip in some of its laptop computers. The prices for the chip during the last 12 months were as follows: Price Per Chip Price Per Chip TET Month Month $1.85 $2.00 $1.85 $1.65 $1.60 January February $1.61 $1.60 $1.85 July August September March April October $1.88 $1.60 May June November $1.89 December $1.75 This exercise contains only parts a, b, and c. a) Using a 2-month moving average, the forecast for periods 11 and 12 is (round your responses to two decimal places): Month Mar Apr May Jun Jul Aug Sep Oct Nov Dec Forecast $1.73 1.61 1.73 1.87 1.89 1.95 1.93 1.75 1.63 1.60 b) Using a 3-month moving average, the forecast for periods 11 and 12 is (round your responses to two decimal places): Month Apr Мay Jun Jul Aug Sep Oct Nov Dec Forecast $1.69 1.69 1.78 1.87 1.92 1.91 1.83 1.70 1.62 c) The mean absolute deviation based on a 2-month moving average of March through December is $.15 (round your response to three decimal places).

Lenovo uses the ZX-81 chip in some of its laptop computers. The prices for the chip during the last 12 months were as follows: Price Per Chip Price Per Chip TET Month Month $1.85 $2.00 $1.85 $1.65 $1.60 January February $1.61 $1.60 $1.85 July August September March April October $1.88 $1.60 May June November $1.89 December $1.75 This exercise contains only parts a, b, and c. a) Using a 2-month moving average, the forecast for periods 11 and 12 is (round your responses to two decimal places): Month Mar Apr May Jun Jul Aug Sep Oct Nov Dec Forecast $1.73 1.61 1.73 1.87 1.89 1.95 1.93 1.75 1.63 1.60 b) Using a 3-month moving average, the forecast for periods 11 and 12 is (round your responses to two decimal places): Month Apr Мay Jun Jul Aug Sep Oct Nov Dec Forecast $1.69 1.69 1.78 1.87 1.92 1.91 1.83 1.70 1.62 c) The mean absolute deviation based on a 2-month moving average of March through December is $.15 (round your response to three decimal places).

Practical Management Science

6th Edition

ISBN:9781337406659

Author:WINSTON, Wayne L.

Publisher:WINSTON, Wayne L.

Chapter2: Introduction To Spreadsheet Modeling

Section: Chapter Questions

Problem 20P: Julie James is opening a lemonade stand. She believes the fixed cost per week of running the stand...

See similar textbooks

Similar questions

help asap
Sales of industrial vacuum cleaners at Yarena Supply CO. over the past 13 months are as follows: Sales in P1,000 Month Sales in P1,000 Month 11 January 14 August 14 February 17 September 15 March 12 October 10 April 14 November 15 May 16 December 17 June 11 January 11 July Required suing a moving average with three periods, determine the demand for vacuum cleaners for next February?
Prepare a Demand Forecast for “Year 5” using Excel. Quarterly Data for Cars Sales Yt Year Quarter Sales (1000s) Year 1 1 4.80 2 4.10 3 6.00 4 6.50 Year 2 1 5.80 2 5.20 3 6.80 4 7.40 Year 3 1 6.00 2 5.60 3 7.50 4 7.80 Year 4 1 6.30 2 5.90 3 8.00 4 8.40 Year 5 1 2 3 4
Consider the global hotel market. what is the trade-off for managerial decision when considering service standardisation and the role of service standardisation on market segmentation (i.e. hotels with different levels of service standardisation).
7
Sales of Volkswagens have grown steadily at auto dealerships in Nevada during the past 5 years (see table below). Q Year 1 2 3 4 5 a) Forecasted sales for year 6 using the trend projection (linear regression) method are Sales 455 510 518 575 590 sales (round your response to one decimal place).
Get the Fuel prices in Oman (Gasoline 95 (Super)) for 12 continuous months. You can choose any year, then find the following: a. Screenshot of the data b. Measurements of central tendency. c. Measurements of Dispersion d. Comment on data. A student must write about his observation on price of oil over period of time.
List 3-5 possible changes that Tesla could implement to improve their forecasting accuracy?
The computer manufacturer Skynet is relatively new in the industry. Their stated mission was the innovation of mobile computing for a better future. For the past 8 years they have been producing laptops, with the latest model the T-1000 released at the start of last year. Summary of Sales per model (in thousand $) 245 Skynet T-101 Skynet T-600 359 Skynet T-700 371 Skynet T-800 533 Skynet T-850 303 Skynet T-1000 218 What was the sales percentage for their latest model laptop? note: write the number with at most 2 decimal places without the unit (eg. 95.17 and NOT 95.17%)
Due to inflation in Australia in December 2019, the price for petrol increased from AUD1.35 to AUD 1.45. This caused petrol consumption to decrease from 2500 liters to2450 liters at a 7-Eleven Petrol Station in Sydney.Also, when the price for Hyundai 7.5kW Inverter Split System Air Conditioner (ReverseCycle) increased from AUD 950.00 to AUD 990.00; demand for these air conditionersfell from 2500 units to 2000 units.Following this condition, answer the questions below.i. Using the mid-point formula calculate the price elasticity of demand for petroland Hyundai 7.5kW Inverter Split System Air Conditioner (Reverse Cycle).ii. Is the price elasticity of demand: elastic, unit elastic, or inelastic for eachcommodity (petrol and Hyundai 7.5kW Inverter Split System Air Conditioner(Reverse Cycle)? iii. Suppose the government decides to increase tax for petrol and Hyundai 7.5kWInverter Split System Air Conditioner (Reverse Cycle). Use two diagrams toexplain the incidence of the tax increase for…
Long detailed answer
What elements would be important to put in setting up a CQI plan at the beginning of program implementation?