Pharma Medical is a producer of medical micromotors for worldwide manufacturers of medical and healthcare equipment....
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
Pharma Medical is a producer of medical micromotors for worldwide manufacturers of medical and healthcare equipment. Basing on past 12 periods of demand in table below, Pharma would like to determine the next period's production plan. Time Period Micromotors Demand (S, Million) 1 1.7 2.3 3 3.5 2.8 5 2.7 6 3.2 7 4.6 8 3.8 9 3.5 10 4.0 11 4.8 12 5.3 With the use of spreadsheets and solver only, solve the following: (a) For the period 13, forecast with a two-period & four-period simple moving average respectively. (4 marks) (b) For the corresponding MSE values in (a), which method has a more accurate forecast? (4 marks) (c) For the period 13, forecast with a two-period and four-period weighted moving average. (6 marks) Pharma Medical is a producer of medical micromotors for worldwide manufacturers of medical and healthcare equipment. Basing on past 12 periods of demand in table below, Pharma would like to determine the next period's production plan. Time Period Micromotors Demand (S, Million) 1 1.7 2.3 3 3.5 2.8 5 2.7 6 3.2 7 4.6 8 3.8 9 3.5 10 4.0 11 4.8 12 5.3 With the use of spreadsheets and solver only, solve the following: (a) For the period 13, forecast with a two-period & four-period simple moving average respectively. (4 marks) (b) For the corresponding MSE values in (a), which method has a more accurate forecast? (4 marks) (c) For the period 13, forecast with a two-period and four-period weighted moving average. (6 marks)
Expert Answer:
Answer rating: 100% (QA)
a Forecast with twoperiod and fourperiod simple moving average method is following EXC... View the full answer
Related Book For
Essentials of Business Statistics Communicating With Numbers
ISBN: 978-0078020544
1st edition
Authors: Sanjiv Jaggia, Alison Kelly
Posted Date:
Students also viewed these marketing questions
-
The Sea Wharf Restaurant would like to determine the best way to allocate a monthly advertising budget of $1000 between newspaper advertising and radio advertising. Management decided that at least...
-
The Sea Wharf Restaurant would like to determine the best way to allocate a monthly advertising budget of $1000 between newspaper advertising and radio advertising. Management decided that at least...
-
A major electric utility would like to determine the average amount spent per household for cooling during the summer. The management believes that a survey should be conducted. You are appointed as...
-
Moore, Inc., invented a secret process to double the growth rate of hatchery trout and manufactures a variety of products related to this process. Each product is independent of the others and is...
-
The shape of the interface pictured in Fig. P.5.1 is known as a Cartesian oval after René Descartes, who studied it in the 1600s. Its the perfect configuration to carry any ray from S to...
-
The Malcolm Baidrige National Quality Award (Baldrige Award) requires applicants to demonstrate excellence in each of the following seven categories: (1) leadership; (2) strategic planning; (3)...
-
Paulette Smith and Maureen Becker are seniors in engineering and business, respectively, at State University. They have set up a company, PM Computer Services, to assemble and sell their own brand of...
-
Case 3: UP NY Diner Janice Young is the kitchen manager for UP NY Diner, maker of Jed's Grouper Pasties. UP NY Diner got its start when Jed Baker, a snowbird from upper NY, tried grilled grouper...
-
In this mini-case, you will complete the test of details on accounts receivable for the 2019 audit of EarthWear Clothiers, Inc. The principal test of detail involves sending "confirmations" or...
-
Troy Engines, Limited, manufactures a variety of engines for use in heavy equipment. The company has always produced all of the parts for its engines, including the carburetors. An outside supplier...
-
During 2020, Silver Corp. spent $12,000 to repair its mining equipment. Rather than debiting these costs to Repair and Maintenance Expense, Silver recorded the following journal entry: Dr. Equipment...
-
Question 25 (6 points) Susan's Silken Scarves Ltd. produces scarves in a variety of designer colours. 2021 Master budget data is as follows: Quarter Sales (all on account) Raw material purchases 1 2...
-
A bank has had average profits of $35,675,000 over three years. Based on the BIA approach, what would the operational risk charge be?
-
A bank has multiple lines of business, with a three-year average net income of $58,750.000, categorized as follows: retail banking, 45%; corporate finance, 5%; agency (trust) services, 15%; brokerage...
-
1.Pacific Wind and Solar pays a dividend at the end of the year of $6 per share, but over the year, its stock price falls from $100 to $98. What is the annual rate of return for a shareholder in the...
-
K You are considering how to invest part of your retirement savings. You have decided to put $600,000 into three stocks: 58% of the money in GoldFinger (currently $24/share), 15% of the money in...
-
The sales department of P. Gillen Manufacturing Company has forecast sales in March to be 20,000 units. Additional information follows: Finished goods inventory, March 1 . . . . . . . . . . . . . . ....
-
Researchers at The Wharton School of Business have found that men and women shop for different reasons. While women enjoy the shopping experience, men are on a mission to get the job done. Men do not...
-
Although founded only in 2004, Facebook has more than 500 million active users, of which 50% log on to Facebook on any given day. In a recent survey by Facebook, young users (those born after 1984)...
-
One of the theories regarding initial public offering (IPO) pricing is that the initial return y (change from offer to open price) on an IPO depends on the price revision x (change from pre-offer to...
-
In 2002, following its adoption of a new accounting standard issued by the FASB for the impairment of goodwill accounting, AMR Corporation, the parent company of American Airlines, conducted an...
-
Discuss the concepts of book value, intrinsic value, and market capitalization. Using a financial website such as YahooFinance or MSNMoney, identify the market capitalization and book value of The...
-
The chart below summarizes the U.S. exchange traded companies that issued corrections to their financial statements during the years 2001 through 2014. The data was compiled by Audit Analytics and...
Study smarter with the SolutionInn App