” Production and Planning and Control Fall 2019
Homework
Release date: 10 October 2019 14:00
Due date: 24 October 2019 14:15
I confirm that this homework is my own work and is not copied from any other persons work.
Signature: Production Planning and Control Homework
1Forecasting
The ProMotors company produces two types of Engines, which are PM-A and PM-B. ProMotors main customers are car manufacturers, but some engine components are also sold to Aircraft producers. The sales of PM-A engine have varied significantly from month to month. ProMotors has a good reputation in Delivery reliability and aims to keep it. The manager of ProMotors wants to make sure that there is enough vehicles and drivers to deliver raw materials and finished products in time. The following table shows the sales of PM-A in 2018 and 2019.
1.1 Make a forecast of PM-A for 2020 using four-month simple moving average. Show the calculation of F(Jan 2020), F(Jul 2020), and F(Dec 2020). Put the forecasted sales in Table 2. Assume that actual demand equals to the forecasted demand in 2020. Fill out the 4th column of Table
2. You are allowed to use Excel.
Note: always round up the forecast results! (5 P)
“
添加老师微信回复‘’官网 辅导‘’获取专业老师帮助，或点击联系老师1对1在线指导。
