a) Plot the monthly sales data. b) Forecast January sales using each of the following: i) Naive method. ü) A 3-month moving average. iii) A 6-month weighted average using .1, .1, .1, .2, .2, and . with the heaviest weights applied to the most recent month iv) Exponential smoothing using an a = .3 and a Septenb-
Q: The MRP gross requirements for Item A are shown here for the next 10 weeks. Lead time for A is three...
A: Least total cost method: Item A Week 1 Week 2 Week 3 Week 4 Week 5 Week 6 Week 7 Week 8 Wee...
Q: The higher levels of the work breakdown structure (WBS) represent increasing amounts of detail while...
A: The Project Work Breakdown Structure (WBS) is a result-oriented breakdown of the assignment engaged ...
Q: nolly screws annually. a. Determine the optimal size of the orders of hex nuts and molly screws, and...
A: Economic order quantity is a company's optimal order quantity that underestimates its total costs li...
Q: at suppliers perform as per the e tuct a comprehensive Value Cha uss reasons why a business like ana...
A: Michael E Porter, a Harvard University professor, introduced the notion of the value chain. Everythi...
Q: Cutey Barber Salon Cutey Barber Salon is a trendy barber salon that is located in a densely populate...
A: Forecasting is a course of anticipating or assessing the future in view of over a wide span of time ...
Q: Santura furniture makes study tables. The weekly euro value of its output, including finished goods ...
A: Inputs= € 17,650 Outputs=€ 15,290
Q: - Calculate the variance expected activity time.
A: Expected duration and variance for an activity calculating based on the standard equation as a+4m+b/...
Q: If the annual demand of gear is 24000 units, replenishment cost is Rs 20 and the cost of holding a u...
A:
Q: The K of a proportional controller is 30 and the reference value is 50% of the output. A valve is us...
A: given proportional controller = 30 reference value =50%
Q: The chairperson of the department of management at Tech wants to forecast the number of students who...
A: Given data: Semester Students Enrolled in OM 1 270 2 310 3 250 4 290 5 370 6 410 7...
Q: What is the reorder point
A: Reorder point is the stock level that initiate new order for fill the stock level. Its about the sum...
Q: Max 3x, + lx, + 5x3 + 3x4 s.t. 3x, + lx, + 2x3 2x, + lx, + 3x, + 1x 15 2x2 = 30 I| + 3x, <25 X1, X2,...
A: Objective Function: Max Z = 3x1 + 1x2 + 5x3 + 3x4 Constraints: Subject to 3x1 + 1x2 ...
Q: Mention and describe what each of the 4 types of approaches to demand analysis discussed in class co...
A: Analysis of demand means acknowledging the demand of consumers in a given market for a product or se...
Q: Discuss any three (3) PR tools or techniques that contributed to the profitability of the American E...
A: Public relations practice is the artwork and social, technological know-how of reading trends, predi...
Q: The owner of a snack food business wants to create two nut mixes for the holiday season. The regular...
A: Decision variable: Suppose-R be the no. of regular nut mixD be the no. of delux nut mix
Q: The following jobs are waiting to be processed at Jeremy LaMontagne's machine center. Today is day 2...
A:
Q: After completing the readings for this week and discussing place marketing, the inbound method, and ...
A: Marketing and selling a product/service revolve around a simple concept, and that is marketing mix. ...
Q: What is TPS?
A: A transaction processing system often called TPS gives an implementation environment that makes sure...
Q: What is Takt time? Calculate the Takt time for an 8-hour day that has two 10-minute breaks and one 3...
A: Takt time is the amount of time available to you to create a product to meet customer demand. It is ...
Q: A superfood manufac Utilizes labor machine hours , raw materials and purchased materials . Assume fo...
A: Productivity is a ratio of the output volume and the volume of inputs. It calculates how efficiently...
Q: A manager has to decide whether to prepare a bid or not. It costs P3,000 to prepare the bid. If the ...
A: At the end of the success branch, P50000 is the return, but since there is a cost of P3000 for bid p...
Q: afford to pay for the preparation of the new design and making changes in equipment
A: The affordable pay is the preparation for upgrading the process is the difference between the old co...
Q: Make a precedence Table of the picture below.
A:
Q: 3.4-15. The Weigelt Corporation has three branch plants with ex- cess production capacity. Fortunate...
A: Profit expanding organizations utilize cost control and wide profit edges to build their profitabili...
Q: Red and White Pizza Pies, Inc. makes pizza pies in two (2) flavors, regular and white pizza. Each pi...
A:
Q: A producer has three products, A, B, and C, which are composed from many of the same raw materials a...
A: 1. Max 90X1 + 120X2 + 150X3 15X1 + 10X2 + 5X3 <= 300 5X2 + 25X3 <= 400 X1 + 2X...
Q: A time-series trend equation is 25.3 + 21x. What is your forecast for period 7? A. 32.3 B. ...
A: Forecasting is the process in which future demand is determined by estimation using previous data or...
Q: 1. How does long term capacity strategy affect the stability of business organization, give an examp...
A: Capacity strategy is an approach to increasing and decreasing business capacity to fulfill needs. Ca...
Q: eral businesses
A: When an employee or worker does the same task over and over again, a learning curve is created to sh...
Q: A manufacturer is designing a product layout for a new product productionIt plans to use a productio...
A: The cycle time is the amount of time it carries to achieve a specific task from start to finish. You...
Q: a-b) One of the possible assignment of tasks to workstations is shown correctly in Fig. 2 . The effi...
A: A project schedule network diagram shows the sequential and analytical connection between tasks in a...
Q: Mr. Barrera raises goats and pigs. He wants to raise no more than 16 animals including no more than ...
A: Linear programming is a method to gain the best outcome such as maximum profit or lowest cost in a m...
Q: 24. Each of the processes listed is non-centered with respect to the specifications for that process...
A: Given-
Q: sing data in columns A-C create a forecast using the Simple Moving Average method based on 10 weeks ...
A: Forecasting means predicting in advance the values of future sales/demand by using different methods...
Q: What is the best cost using assignment problem? Employee/ 1 2 4 3,
A:
Q: Seatwork No. 2 1. Monohan Machinery specializes in developing weed harvesting equipment that is used...
A: A network diagram refers to a diagram of project that is represented in graphical form and is compos...
Q: Cutey Barber Salon is a trendy barber salon that is located in a densely populated city called Maple...
A: Forecasting attributes to the technique for having the option to foresee what will occur from here o...
Q: 10.7. Delph Manufacturing Company is going to purchase an auto parts component from one of two compe...
A: Inventory turns COGS/average inventory value Days of supply Average inventory value *365 / COGS ...
Q: (a) Formulate a linear programming model for this problem. c (b) Solve this model by the simplex met...
A: Let us assume that x1 as the Portion of Alloy 1, whereas x2 for Portion of Alloy 2. Likewise x3, x4 ...
Q: The firm should the semiconductors because this decision has an expected cost of S
A: A decision tree indicating a graphical representation of available decisions alternative based on th...
Q: What is kaizen, and wha t is a kaizen event?
A: Quality Improvement Tool - is an organized & formal procedure to analyze training performance in...
Q: a) Labor productivity per labor hour for these tires = tires/labor hour (round your response to two ...
A: Productivity is a ratio of the output volume and the volume of inputs. It calculates how efficiently...
Q: policy or mechanism could solve any informational imbalances
A: An EVPI (expected value of perfect information) is the difference between actual highest return and ...
Q: -true&idCourse%=D108358&idUnit-0&idLessan-D1222409&page-18idWebuser 43485708edSection 15653 gives an...
A: Flex time or Flexible time is the work arrangement that allows the employees to choose the start and...
Q: (790, 900) for X, Y and Z warehouses, respectively. For each warehouse, number of A product sold per...
A:
Q: The Doan Modianos Manufacturing Company isputting out seven new electronic components. Each ofModian...
A: given,
Q: Assume that the actual sales volume were 1,800; 2,000; 1,700; 1,600; 1,900; and 2,100 for Days 1 to ...
A:
Q: 1. Power Notebooks, Inc. plans to manufacture a new line of notebook computers. Management is trying...
A: We’ll answer the first question since the exact one wasn’t specified. Please submit a new question s...
Q: Why is seniority important in scheduling servers?
A: Seniority can be stated as the privileged rand on the basis of continuous employment of employment w...
Hello, Could you help me answer the questions below?
Trending now
This is a popular solution!
Step by step
Solved in 4 steps with 5 images
- 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_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 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 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_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?
- K The following table gives the number of pints of type A blood used at Damascus Hospital in the past 6 weeks: Week Of August 31 September 7 September 14 September 21 September 28 October 5 - Pints Used 350 370 412 378 371 378 a) The forecasted demand for the week of October 12 using a 3-week moving average = 375.67 pints (round your response to two decimal places). b) Using a 3-week weighted moving average, with weights of 0.15, 0.30, and 0.55, using 0.55 for the most recent week, the forecasted demand for the week of October 12 = decimal places and remember to use the weights in appropriate order the largest weight applies to most recent period and smallest weight applies to oldest period.) pints (round your response to twoQ5) Monthly sales for a six month period are as follows: Month SalesJan 18,000Feb 22,000Mar 16,000Apr 18,000May 20,000June 24,000 Compute the sales forecast for July using the following approaches: (1) Four-month moving average; (2) Weighted three-month moving average using .50 for June, .30 for May and .20 for April;(3) Exponential smoothing with α (smoothing constant) equal to .40, assuming a February forecast of 18,0002. What is the Mean Absolute Deviation (MAD)? 3. Use the following set of data to calculate the Mean Absolute Deviation (MAD) for the following set of data. Month Actual (At) Forecast (Ft) Forecast Error Absolute (Deviation) Forecast Eror January February 45 45 42 50 March 34 45 April May 48 40 38 45 MAD =
- 4.6 The monthly sales for Telco Batteries, Inc., were as follows: Month Sales 20 January February March 21 15 14 April Мay 13 June 16 17 July August September October 18 20 20 November 21 December 23 a) Plot the monthly sales data. b) Forecast January sales using each of the following: i) Naive method. ü) A 3-month moving average. iii) A 6-month weighted average using .1, .1, .1, .2, .2, and .3, with the heaviest weights applied to the most recent months. iv) Exponential smoothing using an a = .3 and a September forecast of 18. v) A trend projection.It wouldnt let me take a screenshot of the table so I had to copy and paste it in here. My question is: How do you Calculate a moving average forecast using the last 2 and 4 dates of stay. What is the prediction for 7/1/2021 for each technique? Discussion Question 1 - 200 room hotel Forecasts MA 2 Errors MA 4 Errors ES (0.8) Errors ES (0.5) Errors Date Day of Week Rooms Sold MA 2 MA 4 ES (0.8) ES (0.5) AE APE AE APE AE APE AE APE 6/1/2021 Tuesday 123 6/2/2021 Wednesday 109 6/3/2021 Thursday 140 6/4/2021 Friday 199 6/5/2021 Saturday 179 6/6/2021 Sunday 140 6/7/2021 Monday 117 6/8/2021 Tuesday 132 6/9/2021 Wednesday 108 6/10/2021 Thursday 151…The monthly sales for Yazici Batteries, Inc., were as follows: Month Jan Feb Mar Apr May Jun Jul Aug Sept Oct Nov Dec Sales 20 21 16 15 15 16 17 19 19 20 23 22 This exercise contains only parts b and c. b) The forecast for the next month (Jan) using the naive method = 22 sales (round your response to a whole number). The forecast for the next period (Jan) using a 3-month moving average approach = 21.67 sales (round your response to two decimal places) The forecast for the next period (Jan) using a 6-month weighted average with weights of 0.10, 0.10, 0.10, 0.20, 0.20, and 0.30, where the heaviest weights are applied to the most recent month = 20.7 sales (round your response to one decimal place). Using exponential smoothing with a = 0.40 and a September forecast of 18.00, the forecast for the next period (Jan) : sales (round your response to two decimal places). Using a method of trend projection, the forecast for the next month (Jan) = sales (round your response to two decimal places).…