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?
List main up to 10 risks and new risks that emerged from the 2020 covid 19 crisis, i.e. business disruption, and explain your choice
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.
Examine the data on unemployment and GDP rate for country A and Country B i) Identify the relationship between GPD and unemployment rate (if any positive, negative, no relationship) Use the data to justify your choice.
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
Philibert Enterprises Inc is a manufacturing and distribution company that is engaged in supplying exotic Caribbean Food products of high quality for the European and North American markets. The Product Quality and consistency of supplies of the product are two critical success factors. Philibert Enterprises Inc. has been using its website as its principal point of contact for its customers It recently won a major contract to supply the Marks& Spencer chain in the UK, where persons of Caribbean origin are a significant group in the population. This is in addition to the growing popularity of Caribbean Cuisine internationally. High productivity levels are necessary to meet the product quality and delivery time requirements. The Marketing Manager is expected to work closely with the Human Resource Manager to develop a reward system that will enable greater reliability with respect to response time and assure quality and compliance with HACCAP¹ requirements. Outline the factors that…
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).
Philibert Enterprises Inc is a manufacturing and distribution company that is engaged in supplying exotic Caribbean Food products of high quality for the European and North American markets. The Product Quality and consistency of supplies of the product are two critical success factors. Philibert Enterprises Inc. has been using its website as its principal point of contact for its customers, It recently won a major contract to supply the Marks& Spencer chain in the UK, where persons of Caribbean origin are a significant group in the population. This is in addition to the growing popularity of Caribbean Cuisine internationally. High productivity levels are necessary to meet the product quality and delivery time requirements. The Marketing Manager is expected to work closely with the Human Resource Manager to develop a reward system that will enable greater reliability with respect to response time and assure quality and compliance with HACCAP equirements. tline the factors that…