a. Compute MAD for the fifth period, then update it period by period using exponential smoothing with a = .10. (Round your intermediate calculations and final answers to 3 decimal places.) A Demand 123 183 143 78 73 Period 1 2 MADT 3 4 5 6 118 7 113 8 142 107 10 162 11 117 12 102 13 137 14 147
Q: Figure below shows a partially completed MPS record for ball bearings.a. Develop the MPS for ball…
A: Given information Order Quantity Week Desired 1 500 4 2 400 5 3 300 1 4 300 7
Q: You have $500,000 to donate to your college. The college's dncount rate is 4%. You donate the money…
A: Amount = $500,000 Discount Rate = 4% Time = 10 years
Q: Solve the provided model please. Max 00.10x + 00.15y + 00.20z s.t. .87x + .89y+.91z = 0
A: Linear programming is a mathematical technique that is also used in operations management…
Q: c. Calculate the net absorption of office space and describe how the total demand for offices in…
A: Net absorption:The amount of owned space at the close of a period is shorter than the number of…
Q: Mr.Tariq is an expert in processing packaged water bottles. The standard time given is 16 hours to…
A: Rowan plan is a method for calculating the wages and bonus invented by James Rowan. Here, we can…
Q: Martinez Company's relevant range of production is 7,500 units to 12,500 units. When it produces and…
A: To calculate the incremental manufacturing cost Martinez will incur, If it increases from 10000 to…
Q: Minimize z=5.15x1+4.5x2+4.36x3 (hundreds of dollars) s.t ?x1 + ?x2 + ?x3 > 140 (production capacity:…
A: Objective function: Minimize Z =5.15X1 + 4.5X2 + 4.36X3
Q: A steel workshop of PT Mental Baja produces leaf springs for cars. they have a demand forecast for…
A: Find the Given details below: Month Jan Feb Mar Apr May Jun Total Forecast 446 600 700 900 650…
Q: Q/1 An industrialist that operates four machines to produce two types of products. The production…
A: Let, Machine 1 = x1 Machine 2 = x2 Machine 3 = x3 Machine 4 = x4 Objective function…
Q: A company wants to develop a level production plan for a family of products. Theopening inventory is…
A: Formula:
Q: Agarwal Technologies was founded 10 years ago. It has been profitable for the last 5 years, but it…
A:
Q: Determine the board measure (BF) and the cost 2x4 = $1700 MBM MBM or FBM = Thousand Board Measure…
A: The board measures/board foot and the cost are computed as follows:
Q: Grouping revenue by different classifications is an effective method for managers to use the…
A: For any organization, it is extremely important to generate adequate revenue in order to remain…
Q: Directions: Fill-in the missing items on the table. Consider the estimates below. HAKDOG CORPORATION…
A: The filled answers are-
Q: B). If the cost of manufacturing (direct material and direct labour) is 60% of sales and profit is…
A: C) From the above given information, Cost of manufacturing with direct material and direct labor=…
Q: Co.PL Manufacturing makes many components for print machines and copy machines. The company makes 20…
A: The process to predict the future by analyzing the trend is known as the forecasting technique. The…
Q: What is the difference between 99.9% uptime per month and 99.9% uptime per year?
A: Uptime is the measure of reliance on a system. It is defined as the duration of time for which the…
Q: A company has the following actual and forecasted demand history for eight periods: Period Actual 26…
A: Solution Tracking signal is calculated as the ratio of cumulative error divided by the mean absolute…
Q: The following table shows the amounts of additional satisfaction (marginal utility) that Ross would…
A: Given that, Price of goods A = $6, price of goods B = $4 In the case of two commodities, a…
Q: One of the planning objectives is to increase competition Select one: O a. False O b. True
A: Planning is the first function of management, which is the beginning step for every business,…
Q: Semans is a manufacturer that produces bracket assemblies. Demand for bracket assemblies (X) is 128…
A: Following information is given: BOM tree -
Q: CASE 2: CASH RECEIPTS ABC Company is preparing its cash budget for the next month. The accounts…
A: In the given question, the amount for a budgeted sales receipts from customers for next month is to…
Q: Dwayne Cole, owner of Florida firm that manufactures display cabinets, develops an 8-month aggregate…
A: Find the Given details below: Month Jan Feb Mar Apr May June Jul Aug Total Demand (Unit) 255…
Q: 14.26. Calculate the available-to-promise row in the following matrix: Period On Hand = 100 %3D 2 3…
A: Available to promise (ATP) is a difference between the market production schedule and all actual…
Q: The production manager at Zam Tech has developed following aggregate forecast of its products:…
A: Find the Given details below: Period 1 2 3 4 5 6 7 Total Forecast 50 44 55 60 50 40 51 350
Q: The major inputs to the master production schedule are: Select one: a. Forecast of demand and…
A: Master Production Scheduling (MPS) is the process that helps manufacturers plan which products and…
Q: 12:17 PM ...0.1KB/s © 94 = bartleby Search for textbooks, step-by-step explanations to homew. Ask an…
A: Project Scope Management is a process that contains planning and which ensures that a project…
Q: 8 a) Explain how seasonality can impact both manufacturing and service organisations giving examples…
A: 8 a) Seasonality is defined as the characteristic where a particular product or service happens to…
Q: In exponential smoothing method, which one of the following statements is true? O a. Alpha is…
A: Exponential smoothing is a predictable method of time series that can be extended to support data…
Q: 1. The Wicked Witch Whisk Company manufactures a line of broomsticks. The mostpopular is the 36-inch…
A: Projected available balance is given by PAB for the first period = Opening inventory + MPS Receipts…
Q: Q 6. A production line is to run at 1200 units per month. Sales are forecast as shown in the…
A: Inventory primarily describes the assets like raw materials, work-in-process of products,…
Q: A. restaurant is opening in Laie and is going to cater to the rich and the famous. It is a 35 seat…
A: GIVEN,
Q: Ouesten 25 Question 18 A company faces the aggregate planning problem shown in the table below Cost…
A: Since it is given that the plant operates 7 days a week means it works all days. The number of units…
Q: Maybe I'm missing something obvious but where are you getting the numbers for 150 pounds of…
A: Kindly ignore the previous calculations since the wrong values are used. Find the below-updated…
Q: Given this information on planned and actual inputs and outputs for a service center, determinethe…
A:
Q: If the time series data has a significant downward trend, the weighted moving average method tends…
A: The correct answer is under-estimate.
Q: Baker Manufacturing Company forecasts the following demand for a product (in thousands of units)…
A: Year 1 2 3 4 5 Forecast Demand 131 150 151 154 153
Q: 01 14 D2 13 Ds 11 The Expected values for the payoff table as follows: 5.72 11.45 EDs 9.14 What…
A: Given data is
Q: Calculate the available to promise using the following data. There are 90 units onhand.
A: Available to promise (ATP) for first period = On hand inventory + MPS - (Total customer orders till…
Q: the following are come accounts pertaining to the rooms division od XYZ Inn. salaries and wages…
A: Since you have posted a question with multiple sub-parts, we will solve first three subparts for…
Q: a. Develop the MPS for ball bearings. (Enter your responses as integers. A response of "0" is…
A: MPS is the master production scheduling for manufacturing the products. It helps in production…
Q: From Operations and Supply Chain Management 10th edition by ROBERTA S. RUSSELL BERNARD W. TAYLOR…
A: A Small Introduction about Supply Chain Management Supply chain management (SCM) is the discipline…
Q: 10:13 ndcpanabo.schoology.com/ ED GROUPS MORE DAVAO COLLEGES COURSES RESOURCES Skill Generator 1 of…
A: Given data is Available rooms = 20 Total rooms = 35 Cost of room = P1500 per night
Q: sing the same data above, compute for the WMA using the below weights. Compute for the MAD, MSE and…
A: Forecasting can be done by many methods. Some of them are a simple moving average method, weighted…
Q: SLO-3.3. The manager of a McDonald's restaurant is an example of a(n) manager. Otop or top level…
A: Employees are the main resource of any organization. Managing the workforce will be a difficult task…
Q: Table B: Chase production plan Моnth Demand Production Plan # Workers # Workers Hired # Workers…
A: Chase production plan refers to the plan in which the production is planned according to the demand…
Solve a parts
Trending now
This is a popular solution!
Step by step
Solved in 3 steps with 3 images
- Under what conditions might a firm use multiple forecasting methods?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 owner of a restaurant in Bloomington, Indiana, has recorded sales data for the past 19 years. He has also recorded data on potentially relevant variables. The data are listed in the file P13_17.xlsx. a. Estimate a simple regression equation involving annual sales (the dependent variable) and the size of the population residing within 10 miles of the restaurant (the explanatory variable). Interpret R-square for this regression. b. Add another explanatory variableannual advertising expendituresto the regression equation in part a. Estimate and interpret this expanded equation. How does the R-square value for this multiple regression equation compare to that of the simple regression equation estimated in part a? Explain any difference between the two R-square values. How can you use the adjusted R-squares for a comparison of the two equations? c. Add one more explanatory variable to the multiple regression equation estimated in part b. In particular, estimate and interpret the coefficients of a multiple regression equation that includes the previous years advertising expenditure. How does the inclusion of this third explanatory variable affect the R-square, compared to the corresponding values for the equation of part b? Explain any changes in this value. What does the adjusted R-square for the new equation tell you?
- 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_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?
- 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?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?
- 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. As the Marketing Manager for Southeastern Corrugated, what would you do upon receiving the request for quotation from Coastal Products?Month Demand Forecast Error 1 20 2 18 3 21 4 25 5 24 6 27 7 22 8 30 9 23 10 20 11 29 12 22 Mean Abs Error Problem 6: The demand manager of Maverick Jeans is responsible for ensuring sufficient warehouse space for the finished jeans that come from the production plants. It has occasionally been necessary to rent public warehouse space, something that Maverick would like to avoid. In order to estimate the space requirements the demand manager is evaluating moving-average forecasts. The demand (in 1,000 case units) for the last fiscal year is shown below. Bias MAD (mean error) Month 1 2 3 4 5 6 7 8 9 10 11 12 Demand 20 18 21 25 24 27 22 30 23 20 29 22 Use a three-month moving average to estimate the month-in- advance forecast of demand for months 4-12. Calculate the Bias and MAD. (Note: Adjust all cell values to two decimal points.)The following are monthly actual and forecast demand levels for May through December for units of a product manufactured by the Deborah Bishop Company in Des Moines: Month May Actual Demand Forecast Demand 105 102 June 78 104 July 108 97 August 112 98 September 105 104 October 114 106 November 120 102 December 125 111 For the given forecast, the tracking signal = MADS (round your response to two decimal places).