OM (with OM Online, 1 term (6 months) Printed Access Card)
6th Edition
ISBN: 9781305664791
Author: David Alan Collier, James R. Evans
Publisher: Cengage Learning
expand_more
expand_more
format_list_bulleted
Videos
Question
Chapter 9, Problem 13PA
Summary Introduction
Interpretation:
Forecast of monthly cash requirement.
Concept Introduction:
Anova is used to find major difference between independent variables. ANOVA can help especially when the number of independent groups is more than two unlike t test. Unlike multiple sample t-tests, it has less risk of producing too many Type-I errors.
Expert Solution & Answer
Want to see the full answer?
Check out a sample textbook solution
Students have asked these similar questions
Canton Supplies, Inc., is a service firm that employs approximately 100 people. Because of the necessity of meeting monthly cash obligations, the chief financial officer wants to develop a forecast of monthly cash requirements. Because of a recent change in equipment and operating policy, only the past seven months of data are considered relevant. The change in operations has had a great impact on cash flow. What forecasting model do you recommend? Use the Moving Average and Exponential Smoothing Excel templates or other Excel tools to help you answer this question.
Cash Required
Cash Required
Month
($1,000)
Month
($1,000)
1
186
5
233
2
219
6
241
3
216
7
204
4
270
Find the best number of months to use in a moving average forecast based on MSE. Do not round intermediate calculations. Round your answers to two decimal places.
Number of months
MSE
2
3
4
The model is the best.
Find the best single exponential smoothing model by…
Herman Hahn is attempting to set up an integrated forecasting and inventory controlsystem for his hardware store, Hahn’s Hardware. When Herman indicates that outdoorlights are a seasonal item on the computer, he is prompted by the program to input theseasonal factors by quarter.Unfortunately, Herman has not kept any historical data, but he estimates that firstquarter demand for the lights is about 30 percent below average, the second-quarterdemand about 20 percent below average, third-quarter demand about average, andfourth-quarter demand about 50 percent above average. What should he input for theseasonal factors?
Since economic and technological forecasts are beyond the expertise of an operations manager, he should not be concerned about them anymore.
True
False
Chapter 9 Solutions
OM (with OM Online, 1 term (6 months) Printed Access Card)
Knowledge Booster
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, operations-management and related others by exploring similar questions and additional content below.Similar questions
- Scenario 3 Ben Gibson, the purchasing manager at Coastal Products, was reviewing purchasing expenditures for packaging materials with Jeff Joyner. Ben was particularly disturbed about the amount spent on corrugated boxes purchased from Southeastern Corrugated. Ben said, I dont like the salesman from that company. He comes around here acting like he owns the place. He loves to tell us about his fancy car, house, and vacations. It seems to me he must be making too much money off of us! Jeff responded that he heard Southeastern Corrugated was going to ask for a price increase to cover the rising costs of raw material paper stock. Jeff further stated that Southeastern would probably ask for more than what was justified simply from rising paper stock costs. After the meeting, Ben decided he had heard enough. After all, he prided himself on being a results-oriented manager. There was no way he was going to allow that salesman to keep taking advantage of Coastal Products. Ben called Jeff and told him it was time to rebid the corrugated contract before Southeastern came in with a price increase request. Who did Jeff know that might be interested in the business? Jeff replied he had several companies in mind to include in the bidding process. These companies would surely come in at a lower price, partly because they used lower-grade boxes that would probably work well enough in Coastal Products process. Jeff also explained that these suppliers were not serious contenders for the business. Their purpose was to create competition with the bids. Ben told Jeff to make sure that Southeastern was well aware that these new suppliers were bidding on the contract. He also said to make sure the suppliers knew that price was going to be the determining factor in this quote, because he considered corrugated boxes to be a standard industry item. Is Ben Gibson acting legally? Is he acting ethically? Why or why not?arrow_forwardScenario 3 Ben Gibson, the purchasing manager at Coastal Products, was reviewing purchasing expenditures for packaging materials with Jeff Joyner. Ben was particularly disturbed about the amount spent on corrugated boxes purchased from Southeastern Corrugated. Ben said, I dont like the salesman from that company. He comes around here acting like he owns the place. He loves to tell us about his fancy car, house, and vacations. It seems to me he must be making too much money off of us! Jeff responded that he heard Southeastern Corrugated was going to ask for a price increase to cover the rising costs of raw material paper stock. Jeff further stated that Southeastern would probably ask for more than what was justified simply from rising paper stock costs. After the meeting, Ben decided he had heard enough. After all, he prided himself on being a results-oriented manager. There was no way he was going to allow that salesman to keep taking advantage of Coastal Products. Ben called Jeff and told him it was time to rebid the corrugated contract before Southeastern came in with a price increase request. Who did Jeff know that might be interested in the business? Jeff replied he had several companies in mind to include in the bidding process. These companies would surely come in at a lower price, partly because they used lower-grade boxes that would probably work well enough in Coastal Products process. Jeff also explained that these suppliers were not serious contenders for the business. Their purpose was to create competition with the bids. Ben told Jeff to make sure that Southeastern was well aware that these new suppliers were bidding on the contract. He also said to make sure the suppliers knew that price was going to be the determining factor in this quote, because he considered corrugated boxes to be a standard industry item. As the Marketing Manager for Southeastern Corrugated, what would you do upon receiving the request for quotation from Coastal Products?arrow_forwardOmar has heard from some of his customers that they will probably cut back on order sizes in the next quarter. The company he works for has been reducing its salesforce due to falling demand, and he worries that he could be next if his sales begin to fall off. Believing that he may be able to convince his customers not to cut back on orders, he turns in an optimistic forecast of his next quarter sales to his manager. What are the pros and cons of doing that?arrow_forward
- A company director wants to employ you to forecast the monthly inventory levels for the firm, which manufactures a single product. However, he is unclear what facilities to provide you with, this being the first formal forecasting project undertaken by the firm. Discuss the kinds of decisions that need to be made, including those about what information to utilize and how much money to spend, and the implications of these decisions.arrow_forwardThe table below shows the sales of widgets (in units) over the past 5 years. Using exponential smoothing with a smoothing constant of 0.2, what is the forecast for next year? The initial forecast (for 5 years ago) was 1,200 units. Forecast: Time Sales 5 years ago 1,140 4 years ago 1,220 3 years ago 1,450 2 years ago 1,090 Last year 1,150 (Do not round intermediate calculations, round your final answer to the nearest whole number.)arrow_forwardA Dallas, TX-based manufacturer of small gasoline engines has developed monthly forecasts for a family of lawnmowers. Data for the 6-month period from January to June is presented in the table below. The firm would like to use an aggregate plan. MONTH Expected Demand Production Days Jan. 800 22 Feb. 700 18 Mar. 800 24 Apr. 1,200 25 May 1,600 26 June 1,900 26 One possible strategy for the manufacturer is to maintain a constant workforce throughout the 6-month period. The information below provides the cost information necessary for analyzing this alternative. Inventory carrying cost $3.00 Subcontracting cost per unit $15.00 Average pay rate $12.00 Daily pay rate = $96.00 Overtime pay rate $18.00 Labor-hours to produce a unit 2.2 Cost of increasing daily production rate (hiring and training) $200.00 Cost of decreasing daily production rate (layoffs) $350.00 The number of units produced per day = 45 and we have a constant workforce, no overtime or…arrow_forward
- The options Outlook has for handling the seasonality of magazine are adding workers during the peak season, subcontracting out some of the work, building up inventory during the slow months, or building up a backlog of orders that will be delivered late to customers. To determine how to best use these options through an aggregate plan, Outlook`s vice president of Marketing starts with the first task-building a demand forecast. Although Outlook could attempt to forecast this demand itself, a much more accurate forecast comes from a collaborative process used by both Outlook and its retailers to produce the forecast shown in Table (a). Outlook sells each book through retailers for Rs.40. The company has a starting inventory in January of 1000 books. At the beginning of January the company has a workforce of 80 employees. The company has a total of 20 working days in each month, and each employee earns Rs 4 per hour regular time. Each employee works eight hours per day on straight time…arrow_forwardThe options Outlook has for handling the seasonality of magazine are adding workers during the peak season, subcontracting out some of the work, building up inventory during the slow months, or building up a backlog of orders that will be delivered late to customers. To determine how to best use these options through an aggregate plan, Outlook`s vice president of Marketing starts with the first task-building a demand forecast. Although Outlook could attempt to forecast this demand itself, a much more accurate forecast comes from a collaborative process used by both Outlook and its retailers to produce the forecast shown in Table (a). Outlook sells each book through retailers for Rs.40. The company has a starting inventory in January of 1000 books. At the beginning of January the company has a workforce of 80 employees. The company has a total of 20 working days in each month, and each employee earns Rs 4 per hour regular time. Each employee works eight hours per day on straight time…arrow_forwardAnswer the following: 1. Suppose that the demand in period 1 was 7 units and the demand in period 2 was 9 units. Assume that the forecast for period 1 was for 5 units. If the firm uses exponential smoothing with an alpha value of .20, what should be the forecast for period 3? 2. Weekly sales of copy paper at Cubicle Suppliers are provided in the table below. Compute a three-period moving average and a four-period moving average for weeks 5, 6, and 7. Compute the MAD for both forecasting methods. Which model is more accurate? Forecast week 8 with the more accurate method. Week Sales (cases) 1 17 2 21 3 26 4 18 5 29 6 17 7 21 3. The last four weekly values of sales were 80, 100, 105, and 90 units, respectively. The last four forecasts (for the…arrow_forward
- 4, The accompanying dataset provides the closing prices for four stocks and the stock exchange over 12 days. Complete parts a through c. Complete the exponential smoothing forecast model for stock B. (Type integers or decimals rounded to two decimal places as needed.) Date Forecast B 09/03/2010 09/07/2010 enter your response here 09/08/2010 enter your response here 09/09/2010 enter your response here 09/10/2010 enter your response here 09/13/2010 enter your response here 09/14/2010 enter your response here 09/15/2010 enter your response here 09/16/2010 enter your response here 09/17/2010 enter your response here 09/20/2010 enter your response here 09/21/2010 enter your response here Date A B C D Stock Exchange 09/03/2010 127.07 18.54 20.84 15.44 10,536.56 09/07/2010 124.84 18.21 20.45 15.55 10,245.77 09/08/2010 125.67 17.77 20.83 15.72…arrow_forwardChoosing between the three period and the five period forecasts, which one would you use as a purchasing manager of the Whitebridge Hardware Store for the fertilizer it sells? Be sure to factor in the cumulative forecast errors in your answer. Also, make sure you include some rationale about why you are picking the method you do for this particular business, given its demand pattern. So for example, does picking one method over the other have any impact on how much inventory they will have on hand to meet customer demand when it grows and when it drops? Which method better supports these things?arrow_forwardSara manages one of the Albireds shoe lines, and is working to improve the group's forecasting capabilities so that production will more closely match actual demand (that's the goal, at least!). Work our the exponential smoothing with a smoothing constant equal to 0.2, (seed the model with a January forecast = 16,000). A weighted moving average using 0.6(t-1), 0.3(t-2) and 0.1(t-3)arrow_forward
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you
Practical Management ScienceOperations ManagementISBN:9781337406659Author:WINSTON, Wayne L.Publisher:Cengage,
Contemporary MarketingMarketingISBN:9780357033777Author:Louis E. Boone, David L. KurtzPublisher:Cengage Learning
Purchasing and Supply Chain ManagementOperations ManagementISBN:9781285869681Author:Robert M. Monczka, Robert B. Handfield, Larry C. Giunipero, James L. PattersonPublisher:Cengage Learning
Practical Management Science
Operations Management
ISBN:9781337406659
Author:WINSTON, Wayne L.
Publisher:Cengage,
Contemporary Marketing
Marketing
ISBN:9780357033777
Author:Louis E. Boone, David L. Kurtz
Publisher:Cengage Learning
Purchasing and Supply Chain Management
Operations Management
ISBN:9781285869681
Author:Robert M. Monczka, Robert B. Handfield, Larry C. Giunipero, James L. Patterson
Publisher:Cengage Learning
Forecasting 2: Forecasting Types & Qualitative methods; Author: Adapala Academy & IES GS for Exams;https://www.youtube.com/watch?v=npWni9K6Z_g;License: Standard YouTube License, CC-BY
Introduction to Forecasting - with Examples; Author: Dr. Bharatendra Rai;https://www.youtube.com/watch?v=98K7AG32qv8;License: Standard Youtube License