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

105 Which of the following real estate mortgage transactions is subject to the TILA-RESPA Integrated Disclosure rule (TRID)? A) Reverse mortgage B) Home equity line of credit (HELOC) C) A single-family residence loan secured by real property D) Mortgage secured by a mobile home not attached to land
The Pinto was a small subcompact car manufactured by Ford in 1971 in the face of looming competition from foreign automobile manufacturers. It was the first ‘small’ car created by Ford and was supposed to cost less than $2000 and weigh less than 2000 pounds. It was an attractive proposition for American consumers at the time when gas prices were rising (the oil crisis of 1973 was right around the corner!) and disposable incomes were constrained. The car was initially well-received in the American market, with full-page newspaper ads highlighting the distinctive design and fuel efficiency of the Pintop. But over time, it became apparent that the vehicle had a dangerous design flaw. The car’s fuel tank was located between the rear bumper and the rear axle - any low-speed rear-end collision at 25 mph would rupture the gas tank, cause fuel to leak and cause a fire or explosion. Cases of injuries and deaths trickled into Ford over time. Recall managers conducted a cost-benefit analysis…
6.10. In August 2011, the Hong Kong Stock Exchange (HKEx) suspended trading for seven stocks after its news announcement website HKExnews was hit by a distributed denial-of-service (DoS) attack. This site is the only online platform used by HKEx to make announcement of the listed companies, and for their regulatory filings. There were 1,463 listed companies, and 5,712 other types of securities, including warrants and bonds. The affected stock included HSBC, Cathay Pacific, and the Hong Kong exchange itself. These stocks have a combined market value of HK$1.5 trillion. The companies tried to make price-sensitive announcements during the lunchtime trading break but due to the attack, the announcements failed to reach the investors. The trading system was not affected but investors rely on timely financial information posted on the HKExnews website to make investment decision. After investigations, the law en- forcement department arrested a businessman for the attack. He was sentenced to…
UST 40,000 (Commerce 5,000; Medicine 15%; AB 20%; Law 5% and others)Average price per computer device Php25,000Average price per Apple device Php30,000Among them, 40% of students of commerce, 50% of AB, and 80% of Law owns at least one Appledevice.Compare the brand penetration of Apple in the above colleges.What is the penetration share of Apple in the above colleges?Given that students replace their Apple devices once every 3 years on average, what is the marketsize (units/revenues) for computer devices for these colleges until the end of 2025?What is the concentration of sales/revenue of Apple devices among the colleges (BDI)?Compare the CDI and BDI of the colleges.Insights?
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…
Q14 Which of the following is a serious problem associated with historical cost based financial statements in periods of inflation? a. Asset understatement b. Overstated Income c. Overpayment of income taxes d. All of these options given are potential problems
Richard has a specialist car dealership. He buys old cars, refurbishes them and then sells them. He also hires out cars. Richard is restoring an old jeep. It requires a special type of shock-absorber to enable it to travel over rough ground. Richard phones Shocks Are Us. He says to Emma, the manager: "I need four shock absorbers which can be used for off-road driving" Emma consults a brochure published by the shock absorber manufacturer and "Says the D200 shock absorber can be used for off-road driving.". Richard then agrees to buy four D200 shock absorbers for $ 120 each. When he installs them on the jeep and takes it for a test drive over rough country, the shock absorbers give way and the jeep crashes down, causing $ 2 000 worth of damage to its body. It turns out that when Emma gave Richard the information over the phone, she had been looking at the wrong page of the brochure. Had she looked at the correct page, she would have seen that the D200 is not suitable for off-road…
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.
DLSU 40,000 (COB 5,000; CCS 15%; CLA 20%; COL 5% and others) Average price per computer device Php25,000Average price per Apple device Php30,000 Among them, 40% of students of COB, 50% of CLA, and 80% of COL owns at least one Apple device. Compare the brand penetration of Apple in the above colleges. What is the penetration share of Apple in the above colleges. Given that students replace their Apple devices once every 3 years on average, what is the market size (units/revenues) for computer devices for these colleges until the end of 2025? What is the concentration of sales/revenue of Apple devices among the colleges (BDI)? Compare the CDI and BDI of the colleges. Insights?
A property's annual property taxes equaled $7,560. The seller owes the buyer for 20 days c prorated property taxes. Using the 360-day calendar, how much does the seller owe the buyer? $1,950 $360 $2,100 $420
In contrast, India’s Tata Motors was moving forward with a strategy focused on small inexpensive cars, even though thiswas a highly competitive market segment, dominated by Japanese auto makers. The company’s aim was to design a smallcar that would be significantly cheaper to make and buy than any other model, and thus to satisfy India’s mass marketdemand for low – cost transportation. The result was the Nano, with a sales price of 100, 000 rupees (US$2,500), whichwas half the price of its closest competitor in India. Tata Motors achieved this by designing everything from scratch, deletingfeatures that were taken for granted by other auto makers (for example air conditioning, power brakes, radios), usinglightweight steel and an aluminium engine, and building in fuel efficiency.The car’s other important feature was its modular design, enabling the Nano to be distributed across the country in kit formand assembled by local businesses. The global reaction to the Nano catapulted the Tata…
In the table below ratings data on x = the quality of the speed of execution and y = overall satisfaction with electronic trades provided the estimated regression equation ŷ = 0.3402 +0.8922x. Brokerage Speed Satisfaction Scottrade, Inc. 3.5 3.4 Charles Schwab 3.0 3.1 Fidelity Brokerage Services 3.3 3.2 TD Ameritrade 3.6 3.5 E*Trade Financial 3.4 3.7 Vanguard Brokerage Services 3.8 3.6 USAA Brokerage Services 3.3 2.9 Thinkorswim 3.1 3.6 Wells Fargo Investments 2.4 2.4 Interactive Brokers 2.6 2.2 Zecco.com 2.7 3.1 At the 0.05 level of significance, test whether speed of execution and overall satisfaction are related. Show the ANOVA table. What is your conclusion? Source Sum of Squares Degrees Mean Square F (to 2 decimals) of Variation (to 4 decimals) of Freedom (to 4 decimals) Regression Error Total P-value is - Select your answer - We Select your answer - V reject Ho : B1 = 0, we conclude that speed of execution and overall satisfaction Select your answer - V related.