without using excel

1. Beta Precision is a company, situated in Pekan which has been more than 10 years in automotive industry. They supply automotive parts such as pinion, steering rack, and piston to their famous company like Alpha and Theta. The monthly sales for Beta Precision are presented in Table 1. Plot the data on a graph from April to September, forecast demand using a 3-month moving average and 3-month moving average with weights applied of 3 (last month), 2 (2 months ago) and 1 (3 months ago). Plot all forecasts on the same graph. As an engineer in Beta Precision, you need to compare forecasts with the original data and decide which forecast seems to give better results. Month January February March April May June July August Sales, MYR (000) 4 6 4 5 10 8 7 9 Table 1: Monthly Sales in Beta Precision