The Mr. Rifkı Çakıl Company can obtain accurate forecasts for 5 months based on firm orders. These forecasts and the number of workdays per month are as follows: Month Demand forecast Workdays (in thousands of cookies) 850 26 2 1060 22 3. 510 20 4. 980 18 770 22 During a 100-day period when were 100 workers, the firm produced 1,700,000 cookies. Assume that there are 120 workers employed at the beginning of month1. Assume inventory cost is 2$ per cookies per month and producing cost is $3 per cookies. Hiring cost and firing cost per worker is $100 and $200 per worker. Develop a constant workforce plan without backorder case.

The Mr. Rifkı Çakıl Company can obtain accurate forecasts for 5 months based on firm orders. These forecasts and the number of workdays per month are as follows: Month Demand forecast Workdays (in thousands of cookies) 850 26 2 1060 22 3. 510 20 4. 980 18 770 22 During a 100-day period when were 100 workers, the firm produced 1,700,000 cookies. Assume that there are 120 workers employed at the beginning of month1. Assume inventory cost is 2$ per cookies per month and producing cost is $3 per cookies. Hiring cost and firing cost per worker is $100 and $200 per worker. Develop a constant workforce plan without backorder case.

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 in excel Jean’s Copiers sells and repairs photocopy machines. The manager needs weekly forecasts of service calls so that she can schedule the personnel. The manager uses α = 0.3 for exponential smoothing, and the forecast for the first week was 24 calls. The manager also uses 3 weekly moving averages technique. a) Using 3 period moving averages, forecast the number of calls for week 7. b) Using exponential smoothing, forecast the number of calls for week 7. c) Compare these two forecasting techniques using Mean Squared Errors (MSE) measure. Which one is better?
The historical data for 4 perlods demand are 65, 60, B0, ond 70respectively Calculate the weighted moving verae (WMA) forecast of perlod 5 with welghts (0,4, 0,6)
Week 1 2 4 Forecast Method 1 0.90 1.05 0.97 1.22 Actual Demand 0.72 1.05 1.00 0.97 Week 1 2 3 4 Forecast Method 2 0.82 1.19 0.90 1.17 Actual Demand 0.72 1.05 1.00 0.97 0 The MAD for Method 1 = thousand gallons (round your response to three decimal places). The mean squared error (MSE) for Method 1 = thousand gallons (round your response to three decimal places). The MAD for Method 2 = thousand gallons (round your response to three decimal places). The mean squared error (MSE) for Method 2 = thousand gallons (round your response to three decimal places).
Give examples of industries that are affected by seasonality.Why would these businesses want to filter out seasonali ty?
A Dallas, TX-based manufacturer of small gasoline engines has developed monthly forecasts for a family of lawnmowers. Data for the 6-month period from January to June is presented in the table below. The firm would like to use an aggregate plan. MONTH Expected Demand Production Days Jan. 800 22 Feb. 700 18 Mar. 800 24 Apr. 1,200 25 May 1,600 26 June 1,900 26 One possible strategy for the manufacturer is to maintain a constant workforce throughout the 6-month period. The information below provides the cost information necessary for analyzing this alternative. Inventory carrying cost $3.00 Subcontracting cost per unit $15.00 Average pay rate $12.00 Daily pay rate = $96.00 Overtime pay rate $18.00 Labor-hours to produce a unit 2.2 Cost of increasing daily production rate (hiring and training) $200.00 Cost of decreasing daily production rate (layoffs) $350.00 The number of units produced per day = 45 and we have a constant workforce, no overtime or…
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.
Interpret the MAD of the most accurate among the forecasting models below. A. Naïve approach;B. 5-month SMA model;C. WMA model with weights 0.1, 0.3, and 0.6; orD. ES model with α = 0.5 and a forecast of 3,500 liters in the first month.
Time period Actual sales 1 18 2 22 If the forecasting value of period 3 is 19.6 using exponential smoothing, the smoothing constant is what?
what are the primary uses of forecasting in operations management ?
An exponential smoothing is being used to forecast demand. Which of the following alpha value (or error weight) should be used if the demand is highly sensitive to the current events and external factors? a. 0.75 b. 0.05 c. -1.5 d. 0.0 e. 1.75
Given an actual demand this period of 143, a forecast value for this period of 119, and an alpha of .6, what is the exponential smoothing forecast for next period? 123.8 118.2 O 122.2 119.8 O 117.4
The County Transportation Department needs to determine usage factors by day of the week for a popular toll bridge connecting different parts of the city. In the current study, they are considering only working days. Suppose that the numbers of cars using the bridge each working day over the past four weeks were (in thousands of cars) Find the seasonal factors corresponding to daily usage of the bridge.