Clinic administrator Marc Schniederjans wants you to forecast patient demand at the clinic for week 7 by using this data. You decide to use a weighted moving average method to find this fore- cast. Your method uses four actual demand levels, with weights of 0.333 on the present period, 0.25 one period ago, 0.25 two peri- ods ago, and 0.167 three periods ago. a) What is the value of your forecast? PX b) If instead the weights were 20, 15, 15, and 10, respectively, how would the forecast change? Explain why. =) What if the weights were 0.40, 0.30, 0.20. and 0.10. respec- tively? Now what is the forecast for week 72

Clinic administrator Marc Schniederjans wants you to forecast patient demand at the clinic for week 7 by using this data. You decide to use a weighted moving average method to find this fore- cast. Your method uses four actual demand levels, with weights of 0.333 on the present period, 0.25 one period ago, 0.25 two peri- ods ago, and 0.167 three periods ago. a) What is the value of your forecast? PX b) If instead the weights were 20, 15, 15, and 10, respectively, how would the forecast change? Explain why. =) What if the weights were 0.40, 0.30, 0.20. and 0.10. respec- tively? Now what is the forecast for week 72

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

1. With examples and necessary figures, define the Key Inventory Terms ? 2. Suppose, you are newly appointed as a Sales Manager in Unilever Company and after joining your first assignment is to do the sales forecast for the next quarter. Therefore, explain what would be your approach to do a good sales forecast for the next quarter.
41. What is revenue management? A. The use of pricing to increase profits generated from a limited supply of supply chainassetsB. Reinvesting earned profits in the supply chainC. Aggregate planningD. Effective management of a supply chain resources
Table: Factors causing the decline in salesFactors % ContributionDelayed deliveries 15%Lack of delivery personnel 8%Inaccurate sales orders 25%Wrong deliveries 32%Delayed invoicing 6%Pilferage 7%Expired items 7% a. Following the Pareto Principle, what are the vital factors or main contributors to the decline in sales? Show your Pareto Chart and indicate or label the vital factors or contributors to the problem.Hint: know the vital few % b. What are the vital factors or vital contributors to the problem? c. If the sales and marketing manager wants to reduce the impact of vital factors or contributors by 70%, what will be a good GOAL Statement to improve his sales problem?
15.________ is financial capacity of an individual to buy what he/she wants. a. Wants. b. Needs. c. None of these options. d. Demands.
26- Which among the following is the correct feature for staple merchandise categories? a. Short selling of goods b. Involves continuous replenishment c. Forecasting is challenging d. Demand for a short period of time
As with other products, Fisher-Price faces the decision of how many Weather Teddy units to order for the comingholiday season. Members of the management team suggested order quantities of 15,000, 18,000, 24,000, or28,000 units. The wide range of order quantities suggested indicates considerable disagreement concerning themarket potential. The product management team asks you for an analysis of the stock-out probabilities forvarious order quantities, an estimate of the profit potential, and to help make an order quantity recommendation.Fisher-Price expects to sell Weather Teddy for $24 based on a cost of $16 per unit. If inventory remains afterthe holiday season, Fisher-Price will sell all surplus inventory for $5 per unit. After reviewing the sales historyof similar products, Fisher-Price’s senior sales forecaster predicted an expected demand of 20,000 units with a.95 probability that demand would be between 10,000 units and 30,000 units. Compute the probability of a stock-out for the…
As with other products, Fisher-Price faces the decision of how many Weather Teddy units to order for the comingholiday season. Members of the management team suggested order quantities of 15,000, 18,000, 24,000, or28,000 units. The wide range of order quantities suggested indicates considerable disagreement concerning themarket potential. The product management team asks you for an analysis of the stock-out probabilities forvarious order quantities, an estimate of the profit potential, and to help make an order quantity recommendation.Fisher-Price expects to sell Weather Teddy for $24 based on a cost of $16 per unit. If inventory remains afterthe holiday season, Fisher-Price will sell all surplus inventory for $5 per unit. After reviewing the sales historyof similar products, Fisher-Price’s senior sales forecaster predicted an expected demand of 20,000 units with a.95 probability that demand would be between 10,000 units and 30,000 units. Question: One of Fisher-Price’s managers felt…
1. This refers to measure of how well customer expectation from a purchased product or service have been met. a Consumer goods c. Marketing b.Satisfaction d. Brand equity 2. This is the appreciation in a brand’s value from the point of view of customers. a. Brand equity c.Marketing b.Satisfaction d. Consumer goods 3. These are products whose physical characteristics are so identical, that it would be difficult, it not impossible, to distinguish one purchased from one vendor or another. a. Brand equity c. Marketing b. Consumer goods d. Primary Demand 4. It is a form of communicating or promoting the value of a product, service, or brand to the consumers. a. Durable c.Marketing b. Primary demand d. Consumer goods
Waldo sells pre-packaged lunches to construction workers at a Peachtree Street construction site near the Georgia Tech campus. The pre-packed lunches include hand crafted sandwiches (made by Waldo's significant other), chips, and a piece of fruit. In total, product costs for Waldo are $3.50/lunch and he sells the product for $10.00 to his construction worker clientele. Ignore sales tax, Waldo doesn’t pay it anyway. When Waldo runs out of product, he simply takes orders from his remaining customers, walks two blocks to the Varsity Drive In, and buys the exact amount of product needed to fill the orders. Waldo charges each customer exactly $2.00 more per product than his costs, which will be variable based on the exact food orders placed by the individual workers. Waldo only provides this "courier" service if he runs out of his own product and performs the service to maintain goodwill with his customers. If instead of being under, Waldo is over on product, he sells his unsold lunches to…
1. Katherine is a forecast manager. She used exponential smoothing to forecast her sales with alpha equals 0.25. Her forecast for this week was 161 but the actual number is 232. What is her forecast for next week?2. Blue Pad Companyâ€™s lead time L is1week and demand rate is119units per week.Holding cost is $29 per unit and ordering cost is $281. Assume 52 weeks in a year.What is the EOQ? Keep two decimal points!3.Blue Pad Companyâ€™s lead time L is3week and demand rate is123units per week.Holding cost is $70 per unit and ordering cost is $726. Assume 52 weeks in a year.What is the ROP?4. Lugini Watchâ€™s annual demand is 107. It can produce at a rate of 19 watches per month with a $249 setup cost for the production run. Find the order quantity (EPQ) assuming carrying cost is $57 per unit a year. Keep two decimal points!5. Lugini Watchâ€™s annual demand is 108. It can produce at a rate of 24 watches per month. Using the…
D&R A3 3 - 2 Question 3. FRA Pricing, Valuation, Payoff, and Hedging Today is June 1. Sustainable Corporation has an obligation of $25 million coming due on August 1. The company is planning to borrow this amount on August 1 to fulfill its obligation, and plans to pay back the loan on December 1. The company’s borrowing rate is LIBOR + 125 basis points. The company’s bank presents it with the following LIBOR term structure: # days LIBOR 30 0.90% 60 1.00% 90 1.05% 120 1.10% 150 1.15% 180 1.18% 210 1.20% 240 1.21% For the calculation of interest, the bank assumes 30 days in a month, and 360 days in a year. Ms. Devro, the VP Finance of Sustainable, is worried that LIBOR will increase between June and August, thus increasing the company’s borrowing cost. She advises that the company enters into a forward rate agreement (FRA) with its bank to hedge its interest rate risk. She has asked you, the treasurer of the company, to…
Specialty Toys, Inc., sells a variety of new and innovative children’s toys. Management learned that thepreholiday season is the best time to introduce a new toy, because many families use this time to look fornew ideas for December holiday gifts. When Specialty discovers a new toy with good market potential, itchooses an October market entry date.In order to get toys in its stores by October, Specialty places one-time orders with itsmanufacturers in June or July of each year. Demand for children’s toys can be highly volatile. If a newtoy catches on, a sense of shortage in the marketplace often increases the demand to high levels and largeprofits can be realized. However, new toys can also flop, leaving Specialty stuck with high levels ofinventory that must be sold at reduced prices. The most important question the company faces is decidinghow many units of a new toy should be purchased to meet anticipated sales demand. If too few arepurchased, sales will be lost; if too many are…