The table shows the values found in the error analysis. What method of forecasting would be best to use? What is the forecasted value?
Q: What type of control chart should be used to monitor the process dispersion?
A: a. p-chart:- This chart is used to control the fraction of defectives. b. range chart:- In this…
Q: Describe how MRP concepts could be used for the following service operations: a. Hotel
A: The term MRP is an acronym for Manufacturing Resource Planning. The MRP system was developed in the…
Q: hat are the top ten risks associated with IT project management?
A: 1. Technology riskThe technological part of running a project is a complex deliverable since there…
Q: Produce a detailed Maslow's motivational strategy for an organization that addresses intrinsic and…
A: The Maslow Hierarchy of Needs is related to a person's motivation. According to this idea, a person…
Q: CRISIS IT In May 2007, Frontier Airlines Holdings hired Gerry Coady as chief information officer…
A: 1. Too many projects and too few resources: The airline had accepted too many projects. As the…
Q: How long will you be standing in line before you are able to place your order?
A:
Q: Role of cGMP in the Quality Control unit in the pharmaceutical industry please define this…
A: Quality if the utmost priority in pharmaceutical products as they are directly related to health. To…
Q: Discuss the main differences between Level 4 (Predictable Organizations) and Level 5 (Optimizing…
A: Utilizing performance review technologies could help businesses increase productivity, spot problem…
Q: What is the bottleneck time per batch of this operation? Fo?
A: Production is the process in which inputs are combined to have the required output. It includes a…
Q: a. What is the expected completion time of the project? The expected completion time is 19 days.…
A: Critical path is the path that take the longest time to complete the whole project of an…
Q: If another professor pitches in just to help the second professor in the original arrangement, how…
A: The first professor completes the paper = in 3 min Parts of paper completed in 1 min by first…
Q: All possibly paths through the network diagram Duration of each of the paths identified Float of…
A: The Critical Path can be broken down into three different categories: -Critical tasks: these are…
Q: 5. Consider the transportation problem having the following parameter table: Destination 1…
A: Problem Table is D1 D2 D3 Supply S1 3 2.7 0 5 S2 2.9 2.8 0 4 Demand 3 4 2…
Q: What are the consequences of shipping and receiving errors?
A: Shipping errors are the mistakes made in the process of shipping. Receiving errors are mistakes made…
Q: Suppose that you are using the four-period weighted moving average forecasting method to forecast…
A: NOTE: We are allowed to do one question only. The weighted moving average forecast is a time…
Q: Problem 12-5 (Algo) Garden Varlety Flower Shop uses 810 clay pots a month. The pots are purchased at…
A: Given data Monthly Demand (d) = 810 clay pots Annual demand (D) = Monthly Demand× No. of months in a…
Q: Forecasting as you have read isn't an exact science. There can be many intangibles that you just…
A: Forecasting: This is a scientific process of providing an estimate of a data value in the future…
Q: How can I effectively collect the necessary information to write a comprehensive operations manual?
A: Operations Manual: Operations Manual is defined as it is a well-structured document…
Q: Answer the following 4 (four) questions. Using the Laplace criterion, which location is best? Using…
A: The Laplace Criterion of Decision Making is a rule that is used to determine the best course of…
Q: Please to use 450 as daily output desired and 560 minutes as total time available per day for…
A:
Q: Sales Cost of supply chain purchases Other production costs Fixed costs Profit 280,000 182,000…
A: Profit = Sales - Fixed costs - Other production costs - Cost of supply chain purchases Given, Profit…
Q: Discuss the role of the Literature Review in a scholarly article. What is it? Why are writing…
A: The goal of a literature review is to increase understanding of current research and conversations…
Q: Ram Roy's firm has developed the following supply, demand, cost, and inventory data. Supply…
A: The transportation method is a special kind of linear programming. It is used to determine the…
Q: Max Z = 6X1 + 18X2+20X3 Sub to X1 + X2 +X3 = 60 10X1 +15X2 +20X3 = 900 2X1 + 3X2 +3X3≤100…
A: Linear programming is a mathematical technique that is also used in operations management…
Q: A farmer is planning the crops that will be planted in the upcoming season. The farmer can get…
A: Objective Functions and Constraints: Based on the given details, the objective…
Q: A process is designed to produce 2,050 units per hour. The process has a scrap rate of 0.9% and a…
A: Given data : Scrap rate=0.9 %= 0.009Inefficiencies=14%= 0.14The actual output of the process=1550…
Q: A food manufacturer wants to locate a warehouse to serve its major The customers, annual volume, and…
A: Center of gravity method is a model which considering the annual volume and the coordinate values…
Q: Need help please show formula how to solve please. Thanks A newly formed company must decide on a…
A: Choosing the best location based on the expected profit is the most suitable solution for given…
Q: The table below shows the sales figures for a brand of shoe over the last 12 months. Months January…
A: Formulae used: 1. Simple Moving Average = (A1 + A2 + …… + An)n 2. Weightage Moving Average = (A1×W1…
Q: Determine whether the following is a feasible sales and operations plan. Assume that the company has…
A: Given data: Available labor hours during the next period = 56000 hours Total labor hours required…
Q: What is the probability that the boat dock will be idle? (b) What is the average number of boats…
A: NOTE: We are allowed to do the first three sub-parts at a time. Queueing theory is a branch of…
Q: Daniel Tracy, owner of Martin Manufacturing, must expand by building a new factory. The search for a…
A: Initial calculation:
Q: Briefly define the role of cGMP in the Quality Control (QC) unit in the pharmaceutical industry,…
A: CGMP stands for Current Good Manufacturing Practice. CGMP are a set of guidelines formed by Food and…
Q: b. A food manufacturer wants to locate a warehouse to serve its major customers. The customers,…
A: Formulae used: Center of Gravity Method Cx= ∑dix × Vi∑Vi CY= ∑diY × Vi∑Vi where, Cx = is the X…
Q: If the part fails and a spare is not available, it will take The cost for idle equipment is $500 per…
A: The optimal order quantity is the number of units a company needs to order to get the best possible…
Q: Daniel Tracy, owner of Martin Manufacturing, must expand by building a new factory. The search for a…
A: Find the Calculations methods below: Total Weighted Score = ∑ (Weights * Site Scores) Given details:…
Q: Advise the new junior salesman as to what globalisation is.
A: Globalization is basically everything carried out to arrive at business sectors with various…
Q: What do you mean by role of cGMP of manufacturing unit in pharmaceutical industries? Please write…
A: Good manufacturing practices are a set of guidelines and regulations that are used to ensure a…
Q: In 2017, Aurecon was appointed by the City of Ekurhuleni to design and construct rail line…
A: Project: Project is defined as “A project is an activity to meet the creation of a unique product or…
Q: Baton Rouge's Mt. Cedar Hospital is a large, private, 600-bed facility complete with…
A: Based on the given information, the decision variables are X1 and X2. Here, the revenue details are…
Q: Applications of Linear Programming Problem 1: Blending Problem Muscat Foods produce two types of…
A: Decision variables: Suppose-B= The amount of Blacken honey to be producedG = The amount of Golden…
Q: Suppose that a task in a project has the following time estimates: to=optimistic completion…
A: Given data: Optimistic time period (to) = 10 weeks Most likely completion period (tm) =17 weeks…
Q: describe one IT resource acquisition strategy and propose a network management system
A: A network management system (NMS) is an application or set of applications that lets network…
Q: List ways in which the critical component of the procurement cycle could be corrupted
A: Procurement: Procurement process contains the series of actions to collect the goods…
Q: What are the ways used by an organization to manage conflict in the channel of distribution in…
A: 1. Establish a minimum advertised priceSince a significant number of channel conflicts emerge due to…
Q: On a toll road, there are 2 lanes for drivers to pay their toll. Customer arrival times are…
A: A queueing node is often described and categorized using Kendall's notation (or occasionally Kendall…
Q: What is meant by motivational conflict, and what marketing managers?
A: Disclaimer: Since you have asked multiple questions, we will solve the first question for you. If…
Q: Solve the following Assignment Problem using Hungarian method. PERSON 1 3x N W TASK 2 3 8 20 15 17 X…
A: The number of rows = 4 and columns = 4 1 2 3 4 W 8 20 15 17 X 15 16 12…
Q: Which of the measure(s) of central location can be used for both numerical and categorical…
A: The value that appears the most frequently in a data collection when it is unique is known as the…
Q: Briefly elaborate the importance of Quality control department for the national and international…
A: Quality is an important factor with regards to any item or service. With the high market…
The table shows the values found in the error analysis. What method of
MSE | forecast for week 13 | |
Time Series | 1.08 | 14.76 |
3-week MA | 3.04 | 13.67 |
exp smoothing | 11.04 | 9.5 |
Step by step
Solved in 2 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_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 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_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?There is a bias towards under forecasting, though we cannot determine from the data provided whether that is severe bias or not O There is a severe bias towards under forecasting O Bias is negligible in this case Question 22 A MAD (Mean Absolute Deviation) of 17.3 suggests which of the following? O There is an over-forecasting bias of 17.3 O The standard deviation for the forecast data is 17.3 O All forecasts fall within 17.3 of the actual data O On average, the forecasts miss by 17.3 O Without knowing the average, the MAD is useless 0 日Week Sales1 27502 31003 32504 28005 29006 30507 33008 31009 295010 300011 320012 3150Develop a three-week moving average. A.What is the forecast for week 5? (Make sure no decimal place and no comma. EX: 1234) B.What is the value of MSE (mean squared error) with regard to a three-week moving average? (Make sure no decimal place and no comma. EX: 1234) C.Develop the exponential smoothing with the alpha value of 0.20. What is the forecast for week 5? (Make sure no decimal place and no comma. EX: 1234) D.What is the value of MSE (mean squared error) with regard to the exponential smoothing? (Make sure no decimal place and no comma. EX: 1234) E.Which method is more accurate? (1 for Moving average, 2 for Exponential Smoothing)
- 3)The errors in a particular forecast are as follows: 3, -3, 4, 0, -2. What is the tracking signal for each period of the forecast? (use excel to show formulas )Accuracy of forecasts. The manager of a large manufacturer of industrial pumps must choose betweentwo alternative forecasting techniques. Both techniques have been used to prepare forecasts for a sixmonth period. Using MAD as a criterion, which technique has the better performance record?FORECASTMonth Demand Technique 1 Technique 21 492 488 4952 470 484 4823 485 480 4784 493 490 4885 498 497 4926 492 493 493Plot the table and give at least three observations from the plot according to the given data Weeks Calls 3 month Weighted Moving Average Error =Abs (Actual -Forecasted) (Sum of Absolute percent error) 1 50 2 35 3 25 4 40 31.42857143 8.571428571 21.42857143 5 45 35 10 22.22222222 6 35 40.71428571 5.714285714 16.32653061 7 20 38.57142857 18.57142857 92.85714286 8 30 27.85714286 2.142857143 7.142857143 9 35 27.85714286 7.142857143 20.40816327 10 20 31.42857143 11.42857143 57.14285714 11 15 25.71428571 10.71428571 71.42857143 12 40 19.28571429 20.71428571 51.78571429 13 55 30 25 45.45454545 14 35 45 10 28.57142857 15 25 41.42857143 16.42857143 65.71428571 16 55 32.14285714 22.85714286 41.55844156 17 55 43.57142857 11.42857143 20.77922078 18 40 50.71428571…