excel assignment

Step

Instructions

Points Possible

1

Start Excel. Download and open the workbook named: Chapter_13_Ad_Allocation_Problem_Start.

0

2

In cell E12, by using relative and absolute cell references, calculate the marginal benefit for the Facebook advertising assuming the level of advertising indicated in cell C12. Use cells E7, D11, and D12. Copy the formula from cell E12 down the column to cell E19.

1

3

In cell F12, by using relative and absolute cell references, calculate the marginal benefit per dollar spent on the Facebook advertising assuming the level of advertising indicated in cell C12. Use cells E9 and E12. Copy the formula from cell F12 down the column to cell F19.

1

4

In cell E24, by using relative and absolute cell references, calculate the marginal benefit for the newspaper advertising assuming the level of advertising indicated in cell C24. Use cells E7, D23, and D24. Copy the formula from cell E24 down the column to cell E27.

1

5

In cell F24, by using relative and absolute cell references, calculate the marginal benefit per dollar spent on the newspaper advertising assuming the level of advertising indicated in cell C24. Use cells E21 and E24. Copy the formula from cell F24 down the column to cell F27.

1

6

In cell E32, by using relative and absolute cell references, calculate the marginal benefit for the flyers advertising assuming the level of advertising indicated in cell C32. Use cells E7, D31, and D32. Copy the formula from cell E32 down the column to cell E38.

1

7

In cell F32, by using relative and absolute cell references, calculate the marginal benefit per dollar spent on the flyers advertising assuming the level of advertising indicated in cell C32. Use cells E29 and E32. Copy the formula from cell F32 down the column to cell F38.

1

8

In cells E40-E42, by using cell references, determine the levels of different types of advertising at which the marginal benefits per dollar between three kinds of advertising are equal. Refer to appropriate cells among C11-C19, C23-C27, and C31-C38.

1

9

In cells E44-E46, determine how the levels of different types of advertising described in part d should be changed to improve the current combination of three kinds of advertising.

3

10

In cell E48, by using cell references, calculate the cost of the Facebook advertising assuming the level of advertising indicated in cell E40. Use cells E9 and E40.

1

11

In cell E49, by using cell references, calculate the cost of the newspaper advertising assuming the level of advertising indicated in cell E41. Use cells E21 and E41.

1

12

In cell E50, by using cell references, calculate the cost of the flyers advertising assuming the level of advertising indicated in cell E42. Use cells E29 and E42.

1

13

In cell E51, by using cell references, calculate the total cost of advertising assuming the levels of advertising indicated in cells E40-E42. Use the Excel SUM function.

1

14

In cell E53, by using cell references, calculate the spending on Facebook advertising assuming the conditions described in part f. Use cell E9 and an appropriate cell among C11-C19.

1

15

In cell E54, by using cell references, calculate the spending on newspaper advertising assuming the conditions described in part f. Use cell E21 and an appropriate cell among C23-C27.

1

16

In cell E55, by using cell references, calculate the spending on flyers advertising assuming the conditions described in part f. Use cell E29 and an appropriate cell among C31-C38.

1

17

Save the workbook. Close the workbook and then exit Excel. Submit the workbook as directed.

0

Total Points

17