Please help me to solve these problems.

In the excel file below There are two problems (in two tabs):

• Question 1 is about using moving average and exponential smoothing methods to forecast Global Bike on-time delivery % based on historical data.
• Question 2 is about using trendline and regression analysis to analyze Global overhead expenses % based on historical data.

In the Excel file and use Excel Data Analysis and Trendline tools to answer the questions

Question 1

Global Bike has tracked on-time delivery percentages The yellow area or cells are for you to during the past 12 months for all purchase order complete. Only work in these areas will shipments to their customers. be graded Answer: Graph here: itips://www.youtube.com/watch-vGRZebAOkrgThe yellow area or cells are for you to complete. Only work in these areas will Paste Graph here: be graded. Global Bike has been working deligently over recent years to decrease their overhead expenses. The following data shows their overhead expenses as a percentage of production costs over the past seven years: Paste Graph here