Excel Problem:

Can you please provide Specific instructions to follow so I can follow along and do them?

1.) Now the managers would like to know how several output values change when sales of Competition units increase. Create a data table that shows how Sales, COGS, Distribution Expense, and Marginal Net Income change when Competition Units Sold are increased from 3,500 to 3,900 in 100-unit increments. Do the analysis in the same Swim Accessories worksheet. Appropriately label the data table to make it easy to understand.

2. The managers would also like to know how Marginal Net Income is affected by simultaneously changing Competition Units Sold and Casual Units Sold (with no change to Team Units Sold). Complete a data table that does this. Specifically, vary the Competition Units Sold from 3,500 to 3,900 and the Casual Units Sold from 3,000 to 2,600, both in 100-unit increments. Do the analysis in the same Swim Accessories worksheet, just below the analysis for #8. Appropriately label the data table to make it easy to understand.

3. Highlight the cell that shows the Marginal Net Income projected when Competition Units Sold equals 3,800 and Casual Units Sold equals 2,700.