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

VW Cheats on Emissions Testing Up until late 2015, Volkswagen AG (VW) was the second largest carmaker in the world, with its 590,000 employees producing nearly 41,000 vehicles per day. At that time, the company's prospects seemed bright, with many of its 12 subsidiaries, such as Audi, Bentley, Bugatti, Ducati, Lamborghini, Volkswagen Passenger Cars, and Volkswagen Commercial Vehicles, performing well. A central question of this scandal—whether VW's top management knew of the deception—remains. However, many critics claim that the multibillion dollar emissions cheating scandal shows that at the very least, the VW engineers who created and installed the software did not believe company management expected them to act with integrity. If they had, VW would not have cheated and would not be in this mess. Critical Thinking Questions 1. VW has blamed a small group of engineers for the misconduct and claims that members of its management board did not know of the decade-long deception.…
Can you either overestimate or underestimate the actual sales number for a poor forecast?
Q3) A farmers' cooperative association plans to build a new sugar mill in Southwestern Louisiana. The primary objective of the mill is to provide the farmers with a place to take their crop for processing that will reduce their transportation costs. The members of the co-op believe that the center-of-gravity method is appropriate for this objective. While there are over 200 sugar cane farms in the region, they are tightly clustered around six villages. Populate the relevant data using your group number below. Using the data below, use the center-of-gravity method to calculate the coordinates of the best location for this All mileage references use the city of Lake Charles as (0,0). Village Miles East of Lake Charles Miles North of Lake Charles Sugar Cane tonnage Arceneaux 90 10 2400*13 Boudreaux 140 60 3200*13 Cancienne 20 70 4500*13 Darbonne 50 20 1200*13 Evangeline 100 80 6000*13 Fontenot 10 120 14000*13
For Mother’s Day, the handbag buyer planned a point-of-sale promotion at 25% off for straw handbags. Here is a record of what sold during the promotion: 100 handbags with an original retail of $49.00 200 handbags with an original retail of $39.00 Calculate the following: Total markdown in dollars for the promotion. Total sales generated for the Mother’s Day event. Total markdown percentage for the Mother’s Day sale event.
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).
Compile a forecast for sales in Q1, Q2, Q3, and Q4 for 2013.
The following table contains sales data for the last eight periods. Forecast the sales for period 9 using a moving average forecast of 3 periods. Period Sales Period Sales 1 24 5 79 2 48 6 69 3 56 7 56 4 69 8 22 a. 61 b. 54 c. 49 d. 68
List 3-5 possible changes that Tesla could implement to improve their forecasting accuracy?
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…