production problem

Step

Instructions

Points Possible

1

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

0

2

In cells F8-G8, do the following: In cell F8, by using relative cell references, calculate the marginal product of labor when K = 3. Use cells E7 and E8. Copy the formula from cell F8 down the column to cell F16. In cell G8, by using relative cell references, calculate the average product of labor when K = 3. Use cells E8 and D8. Copy the formula from cell G8 down the column to cell G16.

4

3

In cells D19-E21, do the following: In cells D19-D21, by using cell references, enter the lowest number of workers for which marginal returns to labor are increasing, decreasing, and negative, respectively. Use appropriate cells among D8-D16. In cells E19-E21, by using cell references, enter the highest number of workers for which marginal returns to labor are increasing, decreasing, and negative, respectively. Use appropriate cells among D8-D16.

2

4

In cell F25, by using cell references, calculate the marginal product of labor when K = 4. Use cells E24 and E25. Copy the formula from cell F25 down the column to cell F33.

2

5

In cell G25, by using cell references, calculate the marginal product of the 4th unit of capital. Use cells E8 and E25. Copy the formula from cell G25 down the column to cell G33.

2

6

In cell H25, by using cell references, calculate the average product of labor when K = 4. Use cells D25 and E25. Copy the formula from cell H25 down the column to cell H33.

2

7

In cells C35-G47, insert a Line Chart for the marginal product of labor for K=3 and K=4. Inserting Chart Select the Line chart from the provided chart options in the Charts group of the Insert tab of the Ribbon. Selecting Data Series Then choose Select Data in the Design tab on the Ribbon. Delete any series created automatically using the Remove button and add new series for the marginal product of labor for K=3 using the Add button. Select the range of data using cells F8-F16. Use cell F6 as the series name. Add new series for the average product of labor for K=3. Select the range of data using cells G8-G16. Use cell G6 as the series name. Add new series for the marginal product of labor for K=4. Select the range of data using cells F25-F33. Use cell F23 as the series name. Add new series for the average product of labor for K=4. Select the range of data using cells H25-H33. Use cell H23 as the series name. Edit Chart Elements On the Ribbon, select design Style 1. Delete the chart title. Go to the Add Chart El ements dropdown list in the Design tab of the Ribbon. Add the legend and choose the Bottom option. Chart Size and Position Go to the Format tab on the Ribbon. Set the chart height to 3.5 inches and the chart width to 6 inches. Drag the chart to position the entire chart so that it fits withIn cells C35-G47.

4

8

In cell F49, determine whether the addition of another unit of capital increases, decreases, or does not change the productivity of labor.

1

9

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

0

Total Points

17