1) The second year quantity sold and sale amount should be derived by multiplying the expected growth % by the first year amounts, these values should indicate growth over the first year 2) Advertising costs are based on the second year sales amount. If < the max figure (currently 100,000), multiply the sales amount by the first %, otherwise multiply by the 2nd % 3) Transportation costs are based on the second year sales amount. This time there are three possible % estimates. Multiply by the appropriate value 4) Format the numbers according to the type of data they are 5) Calculate total costs 6) Set up headings correctly 7) Using conditional formatting, highlight the five largest sales amount values in the 2nd year sales 8) Save sheet and upload to Blackboard before the deadline.

Answer rating: 100% (QA)

Setup Spreadsheet Create a spreadsheet with the following columns First Year Quantity Sold First Yea... View the full answer