Your next task is to estimate the July through December sales based on the marketing data and the sales volume for the s
Posted: Wed Jul 06, 2022 6:43 pm
Your next task is to estimate the July through December salesbased on the marketing data and the sales volume for the secondhalf of the year. The marketing group has provided a list of allcar models in identical order to the original data you receivedwith the expected sales volumes for each car model. You can findthis list in the Market.xlsx workbook. The marketing group assumesthat the manufacturing costs and markups will be the same for thesecond half of the year as they were for the first half. With thedata and assumptions in mind, insert a new worksheet named 2nd Halfin the MTSU Sales.xlsx workbook, identical to the 1st Halfworksheet. Copy and paste the sales volumes from the Market.xlsxworkbook into your new worksheet. Verify that all the calculationsin the new worksheet reflect the new data