The Grand Bakery produces 60 special sourdough rolls every day. Any rolls that are not sold each day are given to the employees. They have collected sales data from the past week: Day Rolls sold 1 50 2 50 3 48 4 60 5 53 6 60 What is the value of F6 if they use a 3-day weighted moving average with W1 = 0.6, W2 = 0.2, and W3 = 0.2? Using the data from above, calculate the forecast for period 7 using a four-period moving average:
Q: Aqua Man Company manufactures and sells a single product. Planned and actual production in its first…
A: Given information, Actual a Production = 100,000 units Sales = 85000 units Manufacturing -…
Q: A check processing center uses exponential smoothing to forecast the number of incoming chewcks each…
A: A) Given forecast in the month of June = Sjune = 42 million Checks received in the month June =…
Q: Forecast error is medsured using the following formula. O a. Actual value = Forecast value O b.…
A: Forecast error shows the deviation of a forecast from actual demand. This is the difference between…
Q: Auniversity lecturer needs to allocate time next week to include time for office hours. He needs to…
A: Exponential smoothing is a time series forecasting method. It calculates a weighted average of past…
Q: (b) Use a - 0.1 to compute the exponential smoothing values for the time series. (Round your answers…
A: We’ll answer the first question since the exact one wasn’t specified. Please submit a new question…
Q: Omar has heard from some of his customers that they will probably cut back on order sizes in the…
A: Ans 4: Business forecasts help every stakeholder of the organization have a sensation or perception…
Q: The number of internal disk drives (in millions) made at a plant in Taiwan during the past 5 years…
A: Find the Given details below: Given Details: Year Disk Drives 1 138 2 156 3 184 4 202…
Q: A manufacturer forecasted demand for year 2014 of 40,000 units of rera products where as the actual…
A: Given: Previous years forecast (Ft-1) = 40,000 Actual years demand (At-1) = 51,000 Alpha = 0.40…
Q: b. The mean absolute deviation as of the end of week 10 is___ rentals enter your response here.…
A: Forecasting is a strategy that uses historical data to make estimates that are predictive in taking…
Q: An electrical contractor's records during the last five weeks indicate the number of job requests:…
A: Given Information:
Q: RDB Company wishes to assign a real estate brokers to one of its 6 sales districts. Based on the…
A: The assignment problem is solved to find out the maximized sales or the minimum cost that the…
Q: Flamingo Educational Services, a company located in the Tema metropolis, is a nationwide market…
A: Inventory management is keeping track of stock and monitoring it. It helps in minimizing the cost of…
Q: Lori Cook has developed the following forecasting modaly = 36 + 4.3xwhere y = demand for Kool Air…
A: Demand forecasting is described as the process through which estimations of the future are made over…
Q: Calculate the sales forecasted for the year 2021 using Exponential smoothing given a weight a of…
A: Given data is
Q: a) The simple linear regression equation that relates bar sales to number of guests (not to time) is…
A: Below is the solution:-
Q: Monthly sales in a company for a seven-period (Jan-July) were as follows: 19, 18, 16, 14, 17, 19,…
A: Forecasting is the process of prediction in which sales demand is estimated using historic…
Q: Professor Shethinks Shesverybusy needs to allocate time this week for office appointments, so she…
A: Given data: The following formula will calculate the forecast for this week or the forecast for the…
Q: The forecast for the month of November was higher than the actual demand and the forecast for the…
A:
Q: a. Draw the scatter diagram b. With a ruler, draw rend line on your scatter diagram c. Solve for the…
A: A Scatter diagram shows the relationship between two variables whether they are positively…
Q: he following table gives the number of pints of type A blood used at Damascus Hospital in the past 6…
A: 3-week moving average = (Sum of the values for the most recent weeks)/3 3-week moving average =(…
Q: The number of disk drives (in millions) made at a plant in Taiwan during the past 5 years follows:…
A: The forecast of disks to be produced next year can be computed as follows:
Q: In the Petroco Service Station problem, for the exponentially smoothed forecast with an a value of…
A: Forecasting is a technique used to predict future outcomes on the basis of past data. In businesses…
Q: Figure shows summer air visibility measurements for Denver, Colorado. The acceptable visibility…
A: There is no trend in the data. The naïve forecast method, exponential smoothing or the simple moving…
Q: The following table gives the number of pints of type A blood used at Damascus Hospital in the past…
A: C) Exponential smoothing method of forecasting; F(t+1) = Ft + Alpha*(At-Ft)
Q: A large Portland manufacturer wants to forecast demand for a piece of pollution-control equipment.…
A: Forecasting Is a technique or method used by operations, sales managers or by management to take…
Q: The Holt method (exponential smoothing with trend andwithout seasonality) is being used to forecast…
A: Compute the new base estimate: Hence, the new base estimate is 48.2.
Q: . Two servers in a restaurant predict how many guests will come for dinner in the nextfour days. The…
A: server 1 server 2 actual forecast error 1 square error 1 absolute error 1 forecast error 2 square…
Q: The number of daily calls for the repair of Speedy copy machines has been recorded as follows: a.…
A: Formula:
Q: Mike Thatcher is a sales manager for an automobile dealership in Alberta. Mike earns a bonus each…
A: 1. Yes, Mike Thatcher faces an ethical dilemma as a result of the warranty accrual decision because…
Q: he Yummy Ice Cream Company projects the demand for ice cream by using first-order exponential…
A: 1.
Q: ber of visitors
A: Exponential Growth is an example of information that shows more noteworthy increments with relaxing,…
Q: The number of heart surgeries performed at HeartvilleGeneral Hospital has increased steadily over…
A: Note: - As we can answer up to three subparts, we will answer the first three here. If answers are…
Q: Which control chart is appropriate to analyze the above data? Justify your answer
A: A control chart is a statistical tool which will helps to study whether process in control or not.…
Q: 1. Using MAD as the criterion, which of the following models would you use for the given time series…
A: The term "forecasting" describes the process of speculating on what will occur in the future based…
Q: In the Petroco Service Station problem, for the exponentially smoothed forecast with an a value of…
A: Forecasting is a technique that enables a company to ascertain future projections based on previous…
Q: South Africa Airways would like to monitor its airline’s performance. Each week for the past 20…
A: This question is related to the topic-quality control and this topic falls under business-operations…
Q: utensil. The firm has conducted significant market research and estimated the following pattern for…
A: Given, Average cost $50000 Desire cost- $3.50
Q: The number of cans of soft drinks sold in a machine each week is recorded below. Develop forecasts…
A: Formulae used: Mean Absolute Percentage Error M =1n∑t=1nAt - FtAt Where,n= is the number of fitted…
Q: Below is data of lobster sales volume from a seafood company. We are using exponential smoothing (α…
A: Forecasting is the process of estimating future demands and sales using the previous years of…
Q: The number of major plumbing repair jobs performed by Augur’s Plumbing Service in each of the last…
A: Three-point averages are calculated by taking a number in the series with the previous and next…
Q: If the demand in the current week was 102 units and we had forecast it to be 125, what would be next…
A: Exponential smoothing is a time series forecasting technique that forecasts data for a given period…
Q: A manufacturing firm has developed a skills test, the scores from which can be used to predict…
A: Find the Given details below: Given details: Worker Test Score Production Rating A 55 43 B…
Q: A retail store records customer demand during each sales period. The data has been collected in the…
A: 3 Period Moving Average Forecasting (Ft) = At-1 +At-2 +At-33 Error = Actual - Forecast Means Squared…
Q: Dave F letcher, the general manager of NorthCarolina Engineering Corporation (NCEC), thinks that his…
A: A Small Introduction about Forecasting Forecasting is done to figure out what kind of demand could…
Q: The Charbondale Hospital is considering the purchase of a new ambulance. The decision will rest…
A: Error = Actual demand - Forecast Actual of 2012 = 3700 Forecast of 2012 = 3739
Q: A restaurant wants to forecast its weekly sales. Historical data (in dollars) for 15 weeks are…
A: 1. The mean squared error (MSE) for two periods moving average forecast can be calculated as…
Q: Holiday Lodge The Holiday Lodge is a large hotel and casino in the Adirondacks. The relatively new…
A:
Q: In order to predict pancakes, John's House of Pancakes uses a weighted moveable average process. It…
A: Given that; Weight for July = 5 Weight for June = 3 Weight for May = 1 Revenue in May = 1000…
Q: Mr. Ferdinand is a well known entrepreneur who sells fresh organic beef to persons in the local…
A: The data for the numerical example is given below. Three week weights = 0.3, 0.2, and 0.1 Four week…
The Grand Bakery produces 60 special sourdough rolls every day. Any rolls that are not sold each day are given to the employees. They have collected sales data from the past week:
Day | Rolls sold |
1 | 50 |
2 | 50 |
3 | 48 |
4 | 60 |
5 | 53 |
6 | 60 |
What is the value of F6 if they use a 3-day weighted moving average with W1 = 0.6, W2 = 0.2, and W3 = 0.2?
Using the data from above, calculate the
Trending now
This is a popular solution!
Step by step
Solved in 2 steps with 2 images
- 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.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 following table gives the number of pints of type A blood used at Damascus Hospital in the past 6 weeks: Week of Pints Used August 31 360 September 7 370 September 14 412 September 21 383 September 28 371 October 5 371 a) The forecasted demand for the week of October 12 using a 3-week moving average= {__] Pints (round your response to two decimal places).
- An operation analyst is forecasting this year's demand for one of his company's products based on the following historical data: (4 year ago Quantity sold was 10842), (3 year ago Quantity sold was 11881 ), (2 year ago Quantity sold was 16064 ) and the last year Quantity sold was 19273 . The previous trend line had predicted 12250 for three years ago, 13000 for two years ago and 13750 for last year. What was the mean absolute percent error (MAPE) for these forecasts? a. 16.95 b. 2739 c. 0.17 d. 2985The following table gives the number of pints of type A blood used at Damascus Hospital in the past 6 weeks: Week Of Pints Used August 31 360 September 7 389 September 14 412 September 21 383 September 28 366 October 5 374 a) The forecasted demand for the week of October 12 using a 3-week moving average LOADING... = 374.33374.33 pints (round your response to two decimal places). b) Using a 3-week weighted moving average, with weights of 0.15, 0.35, and 0.50, using 0.50 for the most recent week, the forecasted demand for the week of October 12 = 372.55372.55 pints (round your response to two 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.) c) If the forecasted demand for the week of August 31 is 360 and α = 0.20, using exponential smoothing,…The manager of Carpet City outlet needs to make an accurate forecast of demand for Soft Shag Carpet (its biggest seller). If the manager does not order enough carpet from the carpet mill, customers will buy their carpet from one of Carpet City’s many competitors. The manager has collected the following demand data for the past 8 months: Month Demand for Soft Shag Carpet (1000 yd) 1 8 2 12 3 7 4 9 5 15 6 11 7 10 8 12 Required showing all workings: Compute a 3-month moving average forecast for months 4 through 9. Compute a weighted 3-month moving average forecast for months 4 through 9. Assign weights of 0.55, 0.33 and 0.12 to the months in sequence, starting with the most recent month.
- In a manufacturing company, a product “A” is manufactured from components “B” and “C”. Also, the component “B” is manufactured from parts “D” and “E”. Which items should be forecasted?In year 2010, a saop manufacturer forecasts that demand of 2011 will be 200 lakhs of units of saop. Whereas the actual demand was 210 lakhs of saops , now using the smoothing constant choosen by the management of alpha is 0.30 , the manufacturer wants to forecast the 2012 demand using the exponential smoothing model , calculate the same .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 410 383 368 374 a) The forecasted demand for the week of October 12 using a 3-week moving average=pints (round your response to two decimal places).
- The following table shows the three-period moving average and five-period moving average for monthly sales of Budget Furniture's during 2019. Moving averages of Budget Furniture's Time period Months Sales Three-period moving average (rounded off to Five-period moving average four decimals) R'millions 1 Jan 7 5.0000 6.2 February 5.6667 6.6 March 5 7.0000 B 4 April 8.3333 8.2 May 7 9.3333 8.4 June 8.3333 9.6 7 July 12 8.6667 9.6 August 4 A 9.2 September 10 10.6667 10 October 13 10.6667 11 November 9 12 December 10 The seasonal index for the month of February in 2019 is: LOThe 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: response to two decimal places). 106 pints (round yourTucson Machinery, Inc., manufactures numerically controlled machines (NCM), which sell for an average price of $12 million each. Sales for these NCMs for the past two years were as follows: Quantity (units) Quantity (units) Quarter Last year ||| III IV 12 18 20 24 Quarter This year | || ||| IV 20 24 28 32 Find the equation of a simple linear regression line using Excel, in the format of Y=a+bX. Keep two decimals of a and b. Forecast the first quarter sales for next year. Keep two decimals.