The easiest way to do this is to copy the original data to a new sheet...

Transcribed Image Text:

The easiest way to do this is to copy the original data to a new sheet and then replace the original data parameters. To copy a sheet, click on the sheet name. Select "Move or Copy." Click on the "Create a copy" box. Click OK. Rename your new sheet to indicate the name of the new scenario. For example, you could name the sheet for (e) 'Commission.' To rename a sheet, right click on the sheet name. Select "Rename." Key in the new name. (e) Put all personnel on commission. This action would affect the sales salaries and commissions expense by eliminating the fixed portion and increasing the variable portion by $4.50 per unit. Sales would increase by 44,000 units. (f) Redesign the package for the product. This would decrease the variable direct materials cost by $1.50 per unit but would increase the fixed factory overhead by $36,000. (g) Launch a new advertising campaign. This would increase fixed advertising expense by $348,000 but would increase sales volume by 4,800 units. (h) Reduce the selling price of the product by $15.00 per unit. This would increase sales volume by 16,800 units. (i) Write a memo, explaining whether the company should use any of the suggestions. Create your memo in Word, not Excel. Use proper memo format. Word has a memo template (FILE | NEW | type in 'memo' in the 'search for online templates' box). The easiest way to do this is to copy the original data to a new sheet and then replace the original data parameters. To copy a sheet, click on the sheet name. Select "Move or Copy." Click on the "Create a copy" box. Click OK. Rename your new sheet to indicate the name of the new scenario. For example, you could name the sheet for (e) 'Commission.' To rename a sheet, right click on the sheet name. Select "Rename." Key in the new name. (e) Put all personnel on commission. This action would affect the sales salaries and commissions expense by eliminating the fixed portion and increasing the variable portion by $4.50 per unit. Sales would increase by 44,000 units. (f) Redesign the package for the product. This would decrease the variable direct materials cost by $1.50 per unit but would increase the fixed factory overhead by $36,000. (g) Launch a new advertising campaign. This would increase fixed advertising expense by $348,000 but would increase sales volume by 4,800 units. (h) Reduce the selling price of the product by $15.00 per unit. This would increase sales volume by 16,800 units. (i) Write a memo, explaining whether the company should use any of the suggestions. Create your memo in Word, not Excel. Use proper memo format. Word has a memo template (FILE | NEW | type in 'memo' in the 'search for online templates' box).