EBK OM
6th Edition
ISBN: 9781305888210
Author: Collier
Publisher: YUZU
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
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.
Year
Month
Actual Orders/Demands
2020
Apr
120
May
90
Jun
100
Jul
75
Aug
110
Sep
50
Oct
75
Nov
130
Dec
110
2021
Jan
90
Feb
There is an ongoing debate about the roles of quantitative and qualitative inputs in demand estimation and forecasting. Those in the qualitative camp argue that statistical analysis can only go so far. Demand estimates can be further improved by incorporating purely qualitative factors. Quantitative advocates insist that qualitative, intuitive, holistic approaches only serve to introduce errors, biases, and extraneous factors into the estimation task. Suppose the executive for the theater chain is convinced that any number of bits of qualitative information (the identity of the director, the film’s terrific script and rock-music sound track, the Hollywood “buzz” about the film during production, even the easing of his ulcer) influence the film’s ultimate box-office revenue. How might one test which approach—purely qualitative or statistical, provides better demand or revenue estimates? Are there ways to combine the two approaches? Provide concrete suggestions
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_forwardTIRES FOR YOU - Forecast & EOQ Forecast Tires for You, Inc. (TFY), founded in 1987, is an automotive repair shop specializing in replacement tires. Located in Altoona, PA, TFY has grown successfully over the past few years because of the addition of a new general manager, Katie McMullen. Since tire replacement is a major portion of TFY's business (it also performs oil changes, small mechanical repairs, etc.), Katie was surprised at the lack of forecasts for tire consumption for the company. Her senior mechanic, Skip Grenoble, told her that they usually stocked for this year what they sold last year. He readily admitted that several times throughout the season stockouts occurred and customers had to go elsewhere for tires. Although many tire replacements were for defective or destroyed tires, most tires were installed on cars whose original tires had worn out. Most often, four tires were installed at the same time. Katie was determined to get a better idea of how many tires to…arrow_forward
- The following is the forecasted demand for Olives Company over the next few months. Month Forecasted Demand Jan 9025 Feb 9000 Mar 9450 Apr 9830 May 9630 Jun 10100 Olives Company is considering using a pure chase strategy. The company has an inventory balance of 300 units and a work force capable of making 9000 units at the beginning of January. Stockout cost due to loss sale is estimated to be $800 per unit. Monthly inventory holding cost are $20 per unit. Olives estimates that adding capacity will cost $75 per unit and firing capacity will cost $50 per unit. Under this plan which of the following is true. O Olives will have inventory cost at the end of January of $5500 O Olives will spend $500 on hiring at the beginning of January O Olives will spend $13,750 on firing at the beginning of January Olives will need to use overtime in April, May and June O Olives holding cost will be be a total of $11000 for the entire plan O None of the other answers are correctarrow_forwardThe following table shows the actual demand observed over the last 11 years: Year 1 Demand 8 2 9 3 5 This exercise contains only parts b, c, and d. b) Using the 3-year moving average, provide the forecast from periods 4 through 12 (round your responses to one decimal place). Year Forecast 4 5 4 10 6 5 13 7 6 7 8 7 11 9 8 14 10 9 8 11 10 13 12 11 8arrow_forwardProblem 18-28 (Algo) The following are historical demand data: YEAR SEASON 2011 Spring Summer Fall 2012 Winter Spring Summer Fall Winter ACTUAL DEMAND 210 136 375 582 465 274 695 972 Use regression analysis on deseasonalized demand to forecast demand in summer 2013. (Do not round intermediate calculations. Round your answer to the nearest whole number.) Forecast for summer 2013arrow_forward
- 2. Fastway is a parcel delivery company based in Pretoria. It measures demand on a weekly basis in terms of the number of parcels which it is given to deliver (irrespective of the size of each parcel). The forecast for week 20 is 63. The table below shows actual demands for Fastway. Week Actual demand 20 63 21 62 22 67 23 66 24 67 25 69 26 65 27 71 28 68 29 68 30 70 31 72 32 66 33 68 34 67 Predict the forecast for week 35 using an exponential smoothing with a smoothing constant of 0.20.arrow_forwardQ2: A company has seasonal demand, with the forecast for the next 12 months as given below. The current labor force can produce 500 units per month. Each employee can produce 20 units per month, and is paid $2,000 per month. The inventory carrying cost is $50 per unit per period. It costs $100 to hire or layoff an employee. Assume 200 units of initial inventory and we would like to keep the similar level at the end of the year. Month 1 3 4 7 8 9 10 11 12 Demand 660 700 840 700 660 500 600 840 80 900 700 600 Please use level and chase strategy to calculate the total cost of two plans (please show your work).arrow_forward1. 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…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_forwardA manager would like to know the total cost of a chase strategy that matches the forecast belowusing a steady regular production rate of 200 units a month, a maximum of 20 units per month ofovertime, and subcontracting as needed to make up any shortages. The unit costs are:Regular production = $35Overtime = $70Subcontracting = $80Month 1 2 3 4 5 6Forecast 230 200 240 240 250 240arrow_forward
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you
Purchasing and Supply Chain ManagementOperations ManagementISBN:9781285869681Author:Robert M. Monczka, Robert B. Handfield, Larry C. Giunipero, James L. PattersonPublisher: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