A company wants to forecast demand using the weighted moving average. If the company uses two prior yearly sales values (ie., year 2016-110 and year 2017=130), and we want to weight year 2018 at 10 percent and year 2019 at 90 percent, which of the following is the weighted moving average forecast for year 2020? Multiple Choice 120 O O 138 O 142 O 128
Q: Why is it difficult for thoovercome resistance to the change management initiative?
A: Resistance to change management initiatives can be difficult to overcome for several reasons. Some…
Q: As part of their responsibilities, all managers get involved in planning, scheduling, and monitoring…
A:
Q: Consider the supply chain illustrated below: Manufacturer Distributor Wholesaler Retailer Last year…
A: Bullwhip effects starts from the retailer and goes upto manufacturer. It is variance of orders that…
Q: Palin’s Muffler Shop has one standard muffler that fits a large variety of cars. The shop wishes to…
A: 1. The optimal target inventory level is 182 mufflers.2. IncreaseExplanation:1. a. Daily Demand…
Q: From the Research Topic - "An Analysis of the factors influencing Recruitment, Selection and…
A: Statement of the ProblemIn Montserrat, hiring, choosing, and keeping public sector employees are…
Q: A’s lead time is 1 week; B’s lead time is 2 weeks; and C’s lead time is 2 weeks. This is true…
A:
Q: UA Hamburger Hamlet (UAHH) places a daily order for its high-volume items (hamburger patties, buns,…
A: Find the given details below:
Q: elect a project in Ghana, say Ghana’s National Health Insurance or planting for food and jobs, and…
A: Project management is the branch of management that deals with organizing and overseeing the…
Q: To the Internal Revenue Service (IRS), the reasonableness of total itemized deductions depends on…
A: Find the given details below:
Q: 1. What is the economic order quantity for BBE in units? In pounds? 4.What is the total cost for…
A: Annual demand (D) = 6000Case price = $96 eachInventory carrying cost = 30%Now, Holding cost (H) ==…
Q: Model A В Fabric (kg/unit) Steel (kg/unit) Profit ($/unit) 636 6 3 6 10 CSST B459 с 5 5 7 Market…
A: Let me state the given data, ModelABCFabric(Kg/Unit)645Steel (Kg/Unit)355Profit ($/Unit)6107The…
Q: A fruit juice manufacturer has recently begun negotiations with brokers in the areas where it…
A: Find the given details below:
Q: Please do part b
A: a) To calculate the upper and lower control limits for the x bar-chart and the R-chart:For x…
Q: Mueller & Associates is a urban planning firm that is designing a new public park in an Omaha…
A: (a) To find the critical path, we need to calculate the earliest start time (ES), earliest finish…
Q: Which of the following statements is incorrect about Operations Management? O Operations Management…
A: Operations management is the process of planning, organizing, and controlling processes and…
Q: What effect would the following scenario have on a company's net income? Worldwide Company imports…
A: When a company's inventory becomes obsolete, it often results in a write-down or write-off where the…
Q: Which of the following is not a separate management function A) Planning B) Directing OC)…
A: The management function is one of his or her key duties or main activities that are carried out for…
Q: Given the following history, use a three-quarter moving average to forecast the demand for the third…
A: In operations management, Forecasting serves as a navigating tool for ships traversing uncharted…
Q: How should the 4 ps of marketing be used in a medical transportation business
A: In the healthcare enterprise, get admission to to quick and reliable medical transportation…
Q: What is bottleneck in operation?
A: A bottleneck in operations refers to a point or stage in a process where the flow of work is limited…
Q: The product manager of a tide and he is planning to launch a new product. He can either launch Tide…
A: Decisions AbbrevationsTide with ZonroxTZTide with DownyTZNo launchNL…
Q: Operations Management: Inventory Control
A: Definition: Inventory control is the act of controlling and optimizing the quantities of inventory…
Q: Henry Crouch's law office has traditionally ordered ink refills 55 units at a time. The firm…
A: Formula:EOQ = sqrt((2 * Demand * Ordering Cost) / Carrying Cost)Given:Demand (D) = 240 units per…
Q: Meritor, a company that makes muffler assemblies for the automotive industry, is committed to the…
A: Meritor would need 4 kanban cards to support their operations. Explanation:Step 1:Given:Production…
Q: 4. Consider the following to illustrate a transshipment (Min) problem. Fr\To D E A $15 $20 Supply…
A: Since you have posted a question with multiple sub-parts, we will provide the solution only to the…
Q: Explain different forecasting techniques like moving averages, exponential smoothing, regression…
A: Forecasting:Forecasting is a crucial component of decision-making in various fields, along with…
Q: PMGT 300 week 3 discussion question 1 Week Three Discussion Topic One 1 The Statement of Work and…
A: Project management is the aspect of management that is concerned with managing, allocating, and…
Q: 1. Describe the main daily tasks for an Operations Manager.
A: Daily tasks for an Operations Manager:An Operations Manager manages daily company operations,…
Q: Mining Company operates two mines for the purpose of extracting gold and silver. The Saddle Mine…
A: Linear programming is a mathematical method used to find the best possible outcome or solution from…
Q: Four regional less-than-truckload (LTL) carriers handle shipments traveling from Lexington,…
A: Efficient frontier is an alternative or a set of alternatives which provide the best value for money…
Q: What is the future value of $50,000.00 invested this year @ 5%, for 15 years?
A: The objective of this question is to calculate the future value of an investment of $50,000.00 at an…
Q: 1. Production systems with standardized outputs typically: A. Have relatively high volumes of output…
A: Concept: Production systems with standardized outputs incorporate consistent…
Q: 2. Chapter 5--Assume you are hired as a consultant for Cinnabon. You are asked to consider a SWOT…
A: Cinnabon's comprehension of its present market position and the obstacles it encounters is firm, as…
Q: What are the cause and effects on a power plant frequent power outages.
A: Frequent power outages in a power plant can stem from various causes, and they can have significant…
Q: 25. What is this year's forecast using exponential smoothing with alpha = 0.4, if year 2007's…
A: Exponential smoothing is an established technique used in time series forecasting to estimate future…
Q: The desired daily output for an assembly line is 300 units. This assembly line will operate 375…
A: Find the given details below:
Q: Month Demand 1 45 2 48 3 43 4 48 5 49 6 54 7 47 8 50 9 46 10 47 Using the table above, calculate two…
A: (i). Exponential smoothing forecast :MonthForecast1 2…
Q: Vollmer Manufacturing makes three components for sale to refrigeration companies. The components are…
A: Machine Component Shaper GrinderProfit164$8245$6342$9Availability120 hours110 hours
Q: Chara has been in the United States for two years, and she loves living here. Since she was a young…
A: Yes, proficiency in both written and spoken English is required for employment as a legal assistant.…
Q: At least __units of Eiskaffee would have to be sold to guarantee the increase in multifactor…
A: Multifactor productivity is defined as the output per dollar invested. Since the addition of new…
Q: Using linear regression analysis, what would you estimate demand to be for each month next year?…
A: Regression analysis is indeed a statistical technique that actually demonstrates the relationship…
Q: A company has a lead time of 7 days for its inventory replenishment. If the average demand during…
A: Given:Lead time Average demand during lead time
Q: How can the organization and funders know that the program is successful including analysis and data…
A: The success of a program can be determined through a systematic process of monitoring, evaluation,…
Q: When working well, the issue management process. Automatically operates with little to no company…
A: Correct option is (c)continuously cycle back to the beginning and repeat.
Q: 19. Which kind of labour force is required in case of Jobbing Production? A. Highly Skilled B. Semi…
A: Jobbing Production: Customized Manufacturing for Unique RequirementsIn jobbing manufacturing, the…
Q: B. The number of disk drives (in millions) made at a plant in China during the past 5 years follows:…
A: Linear regression is used to establish the relationship between a dependent variable (Y) and one or…
Q: MONTH DEMAND 1 45 2 3 4 5 48 43 48 49 6 54 7 8 9 10 47 50 46 47 Using…
A: I would select the Weighted Moving Average forecasting procedure because it has a lower forecast…
Q: What factors should be considered when selecting the appropriate capacity cushion? How does the…
A: Capacity cushion, also known as capacity buffer, is an important concept in operations management.…
Q: The S&OP team at Kansas Furniture, has received estimates of demand requirements as shown in the…
A: Production inventory management calls for a methodical and strategic approach. Typically, producers…
Q: Mack's guitar fabrication shop produces low cost, highly durable guitars for beginners.…
A: Multifactor productivity ratio = 0.96Explanation:The multifactor productivity ratio for Mack's…
Step by step
Solved in 3 steps with 1 images
- Under what conditions might a firm use multiple forecasting methods?The Baker Company wants to develop a budget to predict how overhead costs vary with activity levels. Management is trying to decide whether direct labor hours (DLH) or units produced is the better measure of activity for the firm. Monthly data for the preceding 24 months appear in the file P13_40.xlsx. Use regression analysis to determine which measure, DLH or Units (or both), should be used for the budget. How would the regression equation be used to obtain the budget for the firms overhead costs?The file P13_42.xlsx contains monthly data on consumer revolving credit (in millions of dollars) through credit unions. a. Use these data to forecast consumer revolving credit through credit unions for the next 12 months. Do it in two ways. First, fit an exponential trend to the series. Second, use Holts method with optimized smoothing constants. b. Which of these two methods appears to provide the best forecasts? Answer by comparing their MAPE values.
- The file P13_22.xlsx contains total monthly U.S. retail sales data. While holding out the final six months of observations for validation purposes, use the method of moving averages with a carefully chosen span to forecast U.S. retail sales in the next year. Comment on the performance of your model. What makes this time series more challenging to forecast?The file P13_29.xlsx contains monthly time series data for total U.S. retail sales of building materials (which includes retail sales of building materials, hardware and garden supply stores, and mobile home dealers). a. Is seasonality present in these data? If so, characterize the seasonality pattern. b. Use Winters method to forecast this series with smoothing constants = = 0.1 and = 0.3. Does the forecast series seem to track the seasonal pattern well? What are your forecasts for the next 12 months?Play Things is developing a new Lady Gaga doll. The company has made the following assumptions: The doll will sell for a random number of years from 1 to 10. Each of these 10 possibilities is equally likely. At the beginning of year 1, the potential market for the doll is two million. The potential market grows by an average of 4% per year. The company is 95% sure that the growth in the potential market during any year will be between 2.5% and 5.5%. It uses a normal distribution to model this. The company believes its share of the potential market during year 1 will be at worst 30%, most likely 50%, and at best 60%. It uses a triangular distribution to model this. The variable cost of producing a doll during year 1 has a triangular distribution with parameters 15, 17, and 20. The current selling price is 45. Each year, the variable cost of producing the doll will increase by an amount that is triangularly distributed with parameters 2.5%, 3%, and 3.5%. You can assume that once this change is generated, it will be the same for each year. You can also assume that the company will change its selling price by the same percentage each year. The fixed cost of developing the doll (which is incurred right away, at time 0) has a triangular distribution with parameters 5 million, 7.5 million, and 12 million. Right now there is one competitor in the market. During each year that begins with four or fewer competitors, there is a 25% chance that a new competitor will enter the market. Year t sales (for t 1) are determined as follows. Suppose that at the end of year t 1, n competitors are present (including Play Things). Then during year t, a fraction 0.9 0.1n of the company's loyal customers (last year's purchasers) will buy a doll from Play Things this year, and a fraction 0.2 0.04n of customers currently in the market ho did not purchase a doll last year will purchase a doll from Play Things this year. Adding these two provides the mean sales for this year. Then the actual sales this year is normally distributed with this mean and standard deviation equal to 7.5% of the mean. a. Use @RISK to estimate the expected NPV of this project. b. Use the percentiles in @ RISKs output to find an interval such that you are 95% certain that the companys actual NPV will be within this interval.
- The file P13_02.xlsx contains five years of monthly data on sales (number of units sold) for a particular company. The company suspects that except for random noise, its sales are growing by a constant percentage each month and will continue to do so for at least the near future. a. Explain briefly whether the plot of the series visually supports the companys suspicion. b. By what percentage are sales increasing each month? c. What is the MAPE for the forecast model in part b? In words, what does it measure? Considering its magnitude, does the model seem to be doing a good job? d. In words, how does the model make forecasts for future months? Specifically, given the forecast value for the last month in the data set, what simple arithmetic could you use to obtain forecasts for the next few months?The file P13_26.xlsx contains the monthly number of airline tickets sold by the CareFree Travel Agency. a. Create a time series chart of the data. Based on what you see, which of the exponential smoothing models do you think will provide the best forecasting model? Why? b. Use simple exponential smoothing to forecast these data, using a smoothing constant of 0.1. c. Repeat part b, but search for the smoothing constant that makes RMSE as small as possible. Does it make much of an improvement over the model in part b?The file P13_28.xlsx contains monthly retail sales of U.S. liquor stores. a. Is seasonality present in these data? If so, characterize the seasonality pattern. b. Use Winters method to forecast this series with smoothing constants = = 0.1 and = 0.3. Does the forecast series seem to track the seasonal pattern well? What are your forecasts for the next 12 months?
- A company wants to forecast demand using the weighted moving average. If the company uses two prior yearly sales values (i.e., year 2015 = 110 and year 2016 = 130), and we want to weight year 2015 at 0.10 and year 2016 at 0.90, which of the following is the weighted moving average forecast for year 2017? Group of answer choices a. 120 b. 138 c. 142 d. 128 e. 133UltraPure used two different techniques (F1 and F2) to forecast demand for cases of bottled water. Actual demand and the two sets of forecasts are in the table below. PREDICTED DEMAND Period Demand F1 F2 1 68 67 60 2 75 67 67 3 70 71 70 4 74 69 72 5 69 71 77 6 72 70 77 7 80 72 75 8 78 75 83 a. Compute MAD for each set of forecasts. Given your results, which forecast appears to be more accurate? (Round your answers to 2 decimal places.) b. Compute the MSE for each set of forecasts. Given your results, which forecast appears to be more accurate? (Round your answers to 2 decimal places.) c. Compute MAPE for each data set. Which forecast appears to be more accurate? (Round your intermediate calculations to 2 decimal places and and final answers to 2 decimal places.)UltraPure used two different techniques (F1 and F2) to forecast demand for cases of bottled water. Actual demand and the two sets of forecasts are in the table below. PREDICTED DEMAND Period Demand F1 F2 1 68 67 60 2 75 67 67 3 70 71 70 4 74 69 72 5 69 71 77 6 72 70 77 7 80 72 75 8 78 75 83 a. Compute MAD for each set of forecasts. Given your results, which forecast appears to be more accurate? (Round your answers to 2 decimal places.)