Solve the following questionsQ1.A. From the following forecast determine the monthly inventory balances required to follow aplan of letting the inventory absorb all fluctuations in demand. In this case, we have a constantwork force, no idle time or overtime, no back orders, no use of subcontractors, and no capacityadjustment. Assume that the firm does not use safety stock or cushion inventory to meet thedemand.Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov DecMonthForecasteddemand90 220 210 400 612 700378220200110100 260Productiondays22 18 2120 2220 21 2220 25 19 20

Find the Given details below: Month Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec Total…

Answered: A. From the following forecast…

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

PLEASE ANSWER BOTH QUESTIONS without excel a) Using a weighted moving average with three periods, determine the demand for period 13. Use 3, 2, and 1 for the weights of the most recent, second most recent, and third most recent periods, respectively b) Find the MAD, MSE and MAPE
Two different forecasting models were used to forecastsales of a popular soda on a college campus. Actual demand andthe two sets of forecasts are shown. Use MAD to explain whichmethod provided a better forecast.
Sunrise is planning its purchases of ingredients for bread production. If bread demand had been forecast for last week at 22k loaves & only 21k loaves were actually demanded, what would Sunrise’s forecast be for this week using exponential smoothing with α = 0.10?
please answer within 30 minutes.
1. Which of the following is indicative of the season of heaviest demand when seasonality is measured on a quarterly basis? a. Seasonal index = .75 b. Seasonal index = 1.0 c. Seasonal index = 1.25 d. Seasonal index = 3.1 Answer: 2. The forecast calculated at the end of period t for period t+k is always the same for any value of k if the time series has systematic variability. A) True B) False
Whitebridge Hardware Store Whitebridge Hardware Store has a monthly demand for lawn fertilizer listed below. The gardening season starts in early spring when people want to fertilize their lawns. Period Demand Jan 59 Feb 68 March 91 April 145 May 182 June 212 July 193 Aug 174 Sept 144 Oct 89 Nov 74 Dec 55 Answer Questions 1 – 5 below. [Be sure to watch the video on how to complete your forecasting problem, in the content module.] Everything must be typed including the graph. You need to complete this assignment in Excel. For the narrative answers, you can include them in Excel in one or more of the empty cells. If you know how to add an extra worksheet, you can add your answers on a new worksheet. Or you can type them in a Word document Please include your name somewhere. In the Assignments area, a…
The actual demand of a product for six months are summarized in the table below: Month (t) Demand Dt 1 80 2 90 3 70 4 100 5 70 6 90 Find three months weighted moving averages by assuming the weights, W1 =1, W2 = 0.4 and W3 = 0.5 ii. Compute the mean forecast error iii. Compute the mean square error (MSE) iv. Compute the mean absolute deviation (MAD). v. Mean absolute percent error (MAPE)
City Sod is a small business that sells and lays sod (rolled strips of grass). The owner has devised a forecasting procedure based on demand history from previous years plus projection of demand in recent weeks. The forecast for the next six weeks, in labor hours of sod laying, is 850 870 950 910 970 870 CmTently, City Sod has a staff of sod layers consisting of five crew chiefs and 15 laborers. A crew chief lays sod along with the laborers, but also directs the crew. The owner has decided on the following staffing policies: A two-week backlog will be accmnulated before adding staff. Plans are based on a 40 hour work week; overtime is used only to absorb weather or other delays and employee absence or resignations. The ideal crew size is one crew chief and four laborers. Devise a hiring plan for the first three weeks. In your answer, assmne a current backlog of 1,480 labor hours of sod-laying orders. Does City Sod follow a chase-demand or level-capacity strategy of…
A store has the following demand figures for the last four years: Year Demand 100 1 150 3 112 4 200 Given a demand forecast for year 2 of 100, a trend forecast for year 2 of 10, an alpha of 0.3, and a beta of 0.2, what is the demand forecast for year 3 using the exponential smoothing with trend method? 128 115 Ⓒ 135 Ⓒ 145
Dart is a product of the Digby company. Digby's sales forecast for Dart is 2067 units. Digby wants to have an extra 10% of units on hand above and beyond their forecast in case sales are better than expected. (They would risk the possibility of excess inventory carrying charges rather than risk lost profits on a stock out.) Taking current inventory into account, what will Dart's Production After Adjustment have to be in order to have a 10% reserve of units available for sale? a. 2053 units b. 2274 units c. 2260 units d. 2067 units
Two independent methods of forecasting based on judgment and experience have been prepared each month for the past 10 months. The forecasts and actual sales are as follows:
If we use a simple exponential smoothing method with ??=0.3, ??11=100 and ??12=120, what is your forecast for next year? A. 120 B. 126 C. 128 D. None of the above 10. Which one is NOT part of the reasons to keep inventory? A. To allow flexibility in production scheduling B. To meet variation in product demand C. To maintain dependence of operations D. To provide a safeguard for variation in raw material delivery time

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