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
- 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?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 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_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_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_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?
- Suppose that a regional express delivery service company wants to estimate the cost of shipping a package (Y) as a function of cargo type, where cargo type includes the following possibilities: fragile, semifragile, and durable. Costs for 15 randomly chosen packages of approximately the same weight and same distance shipped, but of different cargo types, are provided in the file P13_16.xlsx. a. Estimate a regression equation using the given sample data, and interpret the estimated regression coefficients. b. According to the estimated regression equation, which cargo type is the most costly to ship? Which cargo type is the least costly to ship? c. How well does the estimated equation fit the given sample data? How might the fit be improved? d. Given the estimated regression equation, predict the cost of shipping a package with semifragile cargo.Do the sales prices of houses in a given community vary systematically with their sizes (as measured in square feet)? Answer this question by estimating a simple regression equation where the sales price of the house is the dependent variable, and the size of the house is the explanatory variable. Use the sample data given in P13_06.xlsx. Interpret your estimated equation, the associated R-square value, and the associated standard error of estimate.At the beginning of each week, a machine is in one of four conditions: 1 = excellent; 2 = good; 3 = average; 4 = bad. The weekly revenue earned by a machine in state 1, 2, 3, or 4 is 100, 90, 50, or 10, respectively. After observing the condition of the machine at the beginning of the week, the company has the option, for a cost of 200, of instantaneously replacing the machine with an excellent machine. The quality of the machine deteriorates over time, as shown in the file P10 41.xlsx. Four maintenance policies are under consideration: Policy 1: Never replace a machine. Policy 2: Immediately replace a bad machine. Policy 3: Immediately replace a bad or average machine. Policy 4: Immediately replace a bad, average, or good machine. Simulate each of these policies for 50 weeks (using at least 250 iterations each) to determine the policy that maximizes expected weekly profit. Assume that the machine at the beginning of week 1 is excellent.