Question: Your next task is to estimate the July through December sales based on the marketing data and the sales volume for the second half of
Your next task is to estimate the July through December sales based on the marketing data and the sales volume for the second half of the year. The marketing group has provided a list of all car models in identical order to the original data you received with the expected sales volumes for each car model. You can find this list in the Market.xlsx workbook. The marketing group assumes that the manufacturing costs and markups will be the same for the second half of the year as they were for the first half. With the data and assumptions in mind, insert a new worksheet named 2nd Half in the MTSU Sales.xlsx workbook, identical to the 1st Half worksheet. Copy and paste the sales volumes from the Market.xlsx workbook into your new worksheet. Verify that all the calculations in the new worksheet reflect the new data
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
