Instructions: Questions 2 to 6 should be completed in Excel….
Instructions: Questions 2 to 6 should be completed in Excel.Using the same data as in Question 2, assume that ABC Company expects a 10% increase in sales in the coming year (10% more than the $575,000 it had in the past year). Prepare its sales forecast, assuming the company breaks down its sales by month using the same percentages as the actual sales from the past year, which you calculated in the first problem.