Ram Roy's firm has developed the following supply, demand, cost, and inventory data. Supply Available Period 1 2 2 Regular Time 30 35 10 Overtime 15 15 20 Subcontract 10 10 10 Demand Forecast 40 55 60

Prepare a Demand Forecast for “Year 5” using Excel. Quarterly Data for Cars Sales     Yt Year Quarter Sales (1000s) Year 1 1 4.80   2 4.10   3 6.00   4 6.50 Year 2 1 5.80   2 5.20   3 6.80   4 7.40 Year 3 1 6.00   2 5.60   3 7.50   4 7.80 Year 4 1 6.30   2 5.90   3 8.00   4 8.40 Year 5 1     2     3     4

The consulting agency begins collecting data on actual population demand utilization. The first year s data is: Period March 2020 April 2020 May 2020 June 2020 Demand 31,550 40,125 38,243 35,311 32,207 32,125 35,700 40,620 n Period Demand September 41,482 2020 October 2020 November 2020 December 2020 January 2021 38,450 February 2021 33,330 38,348 34,722 36,190 July 2020 42,810 August 2020 44,230 What is the forecast demand for March 2021 considering trend and seasonality?

Critique the demand management and forecasting as an effective tool to avoid stock outs

Demand for stereo headphones and MP3 players for joggers has caused Nina Industries to grow almost 50 percent over the past year. The number of joggers continues to expand, so Nina expects demand for headsets to also expand, because, as yet, no safety laws have been passed to prevent joggers from wearing them. Demand for the players for last year was as follows: MONTH DEMAND (UNITS) January February 4,100 4,200 March 3,900 April 4,300 May 4,900 June 4,600 July 5,200 August 4,800 September 5,300 October 5,600 November 6,200 December 5,900

1. Katherine is a forecast manager. She used exponential smoothing to forecast her sales with alpha equals 0.25. Her forecast for this week was 161 but the actual number is 232. What is her forecast for next week?2. Blue Pad Company’s lead time L is1week and demand rate is119units per week.Holding cost is $29 per unit and ordering cost is $281. Assume 52 weeks in a year.What is the EOQ? Keep two decimal points!3.Blue Pad Company’s lead time L is3week and demand rate is123units per week.Holding cost is $70 per unit and ordering cost is $726. Assume 52 weeks in a year.What is the ROP?4. Lugini Watch’s annual demand is 107. It can produce at a rate of 19 watches per month with a $249 setup cost for the production run. Find the order quantity (EPQ) assuming carrying cost is $57 per unit a year. Keep two decimal points!5. Lugini Watch’s annual demand is 108. It can produce at a rate of 24 watches per month. Using the…

For a canteen, the actual demand for disposable cups was 500 units in January and 600 units in February. The forecast for the month of January was 400 units. The forecast for the month of March considering smoothing coefficient as 0.75 is.....

7. Nowjuice, Inc., produces Shakewell fruit juice. A planner has developed an aggregate forecast for demand (in cases) for the next six months. Month May Jun Jul Forecast 4,000 4,800 5,600 Aug Sep 7,200 Oct 6,400 5,000 Use the following information to develop aggregate plans. Regular production cost Regular production capacity Overtime production cost Subcontracting cost Holding cost Beginning inventory $10 per case 5,000 cases $16 per case $20 per case $1 per case per month 0 Develop an aggregate plan using each of the following guidelines and compute the total cost for each plan. Which plan has the lowest total cost? a. Use level production. Supplement using overtime as needed. b. Use a combination of overtime (500 cases per period maximum), inventory, and subcontracting (500 cases per period maximum) to handle variations in demand. c. Use overtime up to 750 cases per period and inventory to handle variations in demand.

Explain the differences between demand planning,demand forecasting and demand management.

Demand of Hairdryer from January to July   Month Demand January 2800 February 2870 March 2968 April 3000 May 3100 Jun 3150 July 3400   a). Calculate forecast future demand for May, June, July and August by using 3 months simple moving average.         b) Determine TWO (2) consequences if the company produce supply more than the customer demand.         c) In your opinion, provide ONE (1) perspective you will look into supplier before made a decision to select a supplier.