Questions included with picture. Table also included.

The production function for a firm is q = -0.613 + 18L'K + 10L where q is the amount of output, L is the number of labor hours per week, and K is the amount of capital. The wage is w = $100 and the rental rate is r = $800 per time period. Jsing Excel, calculate the total short-run output, q(L), for L = 0, 1, 2, ..., 20, given that capital is fixed in the short run and K = 1. Also calculate the average product of labor; APL, and the marginal product of labor, MPL. MPL = -1.812 + 36L + 10 For each quantity of labor in (a), calculate the variable cost, VC; the total cost, C; the average variable cost, AVC; the average cost , AC; and the marginal Use this cost, MC. Using excel, draw the AVC, AC, and MC curves in a diagram. definition ATC/q Hint: you will not be able to solve the total product curve for L as a function of output. So, instead construct a table, See the headings. MPL APL TVC TFC TC MC AVC AFC ATC W Start Step 0 1 6 0 0 0 V O UT A W N H O 14 15 16 17 18 19 20