Do my answers correct (the red ones)? Mario & Luigi own the Super brother canteen. Mario is in-charge of marketing and isdeveloping his sales forecast for next year. Because of his marketing efforts, hepredicts a 5 percent increase in his monthly guest counts. Mario is not aware of anyanticipated menu price increases and assumes, therefore, that his weighted checkaverage will remain stable. 田MonthSales Last YearGuest Count Last YearCheck Average Guest Count Forecast Weighted Check Projected Sales/ Ave Sales per Guest ForecastJanuary45,216.004,8009.425,0409.5948,333.60February48,538.005,1209.485,37651,555.84March50,009.005,0069.995,25650,405.04April4,9605,14045,979.009.275,20849,944.72May49,703.009.675,39751,757.23June48,813.005,3009.215,56553,368.35July55,142.005,6219.815,90256,600.18August59,119.006,0029.856,30260,436.18September55,257.005,7809.566,06958,201.71October50,900.005,3419.535,60853,780.72November54,054.005,4609.905,73354,979.475,67067,126December50,998.005,4009.4454,375.30Total:613,728.00(15 & 16) 63,9309.59643,738.34

While doing calculations, decimal value consideration play a key role in the final answer. Here,…

Answered: Mario & Luigi own the Super brother…

Practical Management Science

6th Edition

ISBN:9781337406659

Author:WINSTON, Wayne L.

Publisher:WINSTON, Wayne L.

Chapter2: Introduction To Spreadsheet Modeling

Section: Chapter Questions

Problem 20P: Julie James is opening a lemonade stand. She believes the fixed cost per week of running the stand...

See similar textbooks

Similar questions

V. Let's Explore / Let's Create 1. Discuss the other types of forecasting methods that financial analysts use to predict future revenues. 2. Are there any several other factors that may need to be considered that affects the sales forecast? RUBRIC Criteria Poor (3 Points) Fair (7 Points) Fair Good (10 Points) Good Deer
35. The Mr. Meadows Cookie Company can obtain accurate forecasts for 12 months based on firm orders. These forecasts and the number of workdays per month are as follows: Demand Forecast Month (in thousands of cookies) Workdays 1 850 26 2 1,260 24 3 510 20 4 980 18 770 22 850 23 7 14 1,050 1,550 1,350 1,000 970 680 21 9. 23 10 24 11 21 12 13 During a 46-day period when there were 120 workers, the firm produced 1,700,000 cookies. Assume that there are 100 workers employed at the beginning of month 1 and zero starting inventory. a. Find the minimum constant workforce needed to meet monthly demand. b. Assume cz= $0.10 per cookie per month, cH= $100, and cp = $200. Add columns that give the cumulative on-hand inventory and inventory cost. What is the total cost of the constant workforce plan? c. Solve for the optimal plan using linear programming. Compare your solution to b.
10-A forecasting method that forecasts progress upward in the organization from small units to ultimately provide an aggregate forecast of employment needs is referred to as zero-base forecasting. bottom-up approach. use of predictor variables. Delphi technique.
Question 1 ) The monthiy sales Of yamizí Battery company are asfollows:- Month Jales 2000 2100 1500 1400 1300 Calcuiate fore cost sales for June using each of the fo llowing method: - i) Naive Method 1M 3 Month Simple moving averoger Ti) Exponentral smoothing using an a =0:3 cand may forecast of 1600 units.
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 日

Part C Exponential Exponential Gasoline Demand Gasoline Month smoothed forecast smoothed forecast Exponential smoothed forecast (a = 0.25) Demand (a = 0.25) (a = 0.45) Exponential smoothed forecast (a = 0.45) Mar 900 920 920 1200 Apr May 755 915.00 911.00 1100 1000 650 875.00 840.80 g20 915.00 846 80 755 818.75 754.94 904.76 835.12 Jun 550 818.75 754.94 800 320 751.56 66272 645.74 746.83 Jul 625 751.56 662.72 650 600 550 Aug Sep 730 719.92 645.74 820 722.44 683.66 400 D Oct 1100 746.83 745.01 200 1 Nov 835.12 904.76 Mar Apr May Jun Jul Aug Sep Oct Nov 1. Make a comparative analysis out of your answers in the plotted data. (3-5 5 sentences)
b. Prepare forecasts for June through September by using an exponential smoothing model with α = 0.4. Assume that the forecast for May was 2,100 (enter your responses rounded to the nearest whole number). Month March April May June July August September March April May June Demand Demand 120 2,030 1,110 4,210 3,260 5,830 c. Prepare forecasts for June through September by using an adjusted exponential smoothing model with α = 0.4 and ß = 0.2. Assume that the unadjusted forecast for May was 2,100 and the trend factor T₁ for May was 900 (enter your responses rounded to the nearest whole number). Month 120 2,030 1,110 4,210 Forecast 2,100 1704 2707 2928 4089 2,100 1,704 Unadjusted forecast Adjusted forecast
Q1) Forecasting is both art and science. Describe the situations where we use Qualitative forecasting techniques and quantitative forecasting techniques
Naïve method versus three period Moving Average The number of major plumbing repair jobs performed by Augur’s Plumbing Service in each of the last six months is listed below. Month Jobs October 92 November 94 December 98 January 95 February 99 March 104 Use the ‘textbook’ naïve method to forecast April jobs (Ft+1 = Xt + (Xt – Xt-1). Use the three- period moving average to forecast jobs in April Based upon the MAD (mean absolute deviation), determine whether the three-period moving average or textbook naïve method is more accurate, based upon forecasts for January through March.
20- Forecasting is very important in predicting the future sales of a company. Can you identify the wrong statement about forecasting from the options below? a. Short range forecasts are less accurate than long range forecasts b. The underlying casual system will remain same in the future c. Forecast for group of items is accurate than individual item d. Forecasts are rarely perfect
17. Statistical and observational methods, where adequate data or settings are available in which to apply them, are superior to survey methods of forecasting. Select one O True O False
1. A forecaster must decide on the value of this factor before he can use the simple moving average model. * a. Actual demand for each period b. Averaging period c. Exponential smoothing constant d.Weights 2. A forecaster must decide on the value of this factor before he can use the exponential smoothing model. * a. Actual demand for each period b. Averaging period c. Exponential smoothing constant d. Weights 3. A forecaster must calculate this value to assess the accuracy of a time series forecasting model. * a. Averaging period b. Correlation coefficient c. Exponential smoothing constant d. Mean absolute deviation

SEE MORE QUESTIONS

Recommended textbooks for you

Practical Management Science

Operations Management

ISBN:

9781337406659

Author:

WINSTON, Wayne L.

Publisher:

Cengage,

Operations Management

ISBN:

9781259667473

Author:

William J Stevenson

Publisher:

McGraw-Hill Education

Operations and Supply Chain Management (Mcgraw-hi…

Operations Management

ISBN:

9781259666100

Author:

F. Robert Jacobs, Richard B Chase

Publisher:

McGraw-Hill Education

Practical Management Science

Operations Management

ISBN:

9781337406659

Author:

WINSTON, Wayne L.

Publisher:

Cengage,

Operations Management

ISBN:

9781259667473

Author:

William J Stevenson

Publisher:

McGraw-Hill Education

Operations and Supply Chain Management (Mcgraw-hi…

Operations Management

ISBN:

9781259666100

Author:

F. Robert Jacobs, Richard B Chase

Publisher:

McGraw-Hill Education

Business in Action

Operations Management

ISBN:

9780135198100

Author:

BOVEE

Publisher:

PEARSON CO

Purchasing and Supply Chain Management

Operations Management

ISBN:

9781285869681

Author:

Robert M. Monczka, Robert B. Handfield, Larry C. Giunipero, James L. Patterson

Publisher:

Cengage Learning

Production and Operations Analysis, Seventh Editi…

Operations Management

ISBN:

9781478623069

Author:

Steven Nahmias, Tava Lennon Olsen

Publisher:

Waveland Press, Inc.

SEE MORE TEXTBOOKS