I need some help with the attachment please.
1. Production Grid, Isoquants, Short-Run Production and Costs
The following production grid shows the relationship between capital and labor inputs and the output that can be produced by a firm.
Based on this information use Excel Charts to do the following:
(a) Set up an isoquant map with isoquants representing output levels of 10, 105, and 410 units of output.
(b) Set up a diagram showing the firm’s short run production function assuming that the firm has only one unit of capital.
(c) Set up a diagram showing the firm’s marginal product schedule assuming that the firm has only one unit of capital.
(d) Assume that capital is fixed at one unit in the short run and that the costs associated with the use of fixed inputs are $30 per period, while the wage rate is $10 per unit of labor per period. Use this information to perform the calculations necessary to set up a diagram showing total cost (TC) and total variable cost (TVC) of the firm per period in the short run.
(e) Also, use the information in part c to then set up a another diagram showing the firm’s short run marginal cost (MC), average total cost (ATC), and average variable cost (AVC) in the range from 10 to 135 units of output.
2. Price Discriminating Monopoly Part I
Consider a monopolistic firm selling the same product in two completely separate markets with the following demand schedules:
The marginal cost of this firm is equal to its average total cost and is constant at $3 per unit produced (note that this also means that there are no fixed costs). Based on this information use excel to calculate marginal revenues and set up a diagram that shows the demand and the marginal revenue curves of this firm as well as the quantities and prices it should charge in each market in order to maximize overall profits from the two markets.
3. Price Discriminating Monopoly Part II
Consider a monopolistic firm selling the same product in two separate markets, A and B, which have different demand curves. The demand in market A is defined by PA = 18 – 2QA for positive prices and quantities (i.e., for all PA, QA > 0) and the demand in market B is defined by PB = 9 – QB for positive prices and quantities (i.e., for all PB, QB > 0). Assume that the marginal cost of this firm is equal to its average total cost and is constant at $4 per unit produced.
Based on this information, your task is to use excel to set up diagrams that show the demand and the marginal revenue curves of this firm, as well as the quantities and prices it charges in each market, and also calculate the firm’s total profit from selling in the two markets.