Redstone Clayworks, Inc., a small firm located in Sedona, manufactures clay fire pits that homeowners place on their patios for decoration and light-duty heating. Redstone is one of 53 firms worldwide supplying clay fire pits to retailers such as Home Depot, Lowe's, Front Gate, and other upscale home product chains. Despite the best marketing efforts o these retailers to differentiate their individual brands of fire pits, consumers don't care much about brands: A clay fire pit is a clay fire pit, regardless of who sells it. The following spreadsheet below provides data on Redstone's costs of production.

(1)

Q

(2)

TC

(3)

TFC

(4)

TVC

05,0005,000010010,0005,0005,00020019,0005,00014,00030027,0005,00022,00040038,0005,00033,00050050,0005,00045,00060066,0005,00061,00070084,0005,00079,000800104,0005,00099,000900126,0005,000121,0001,000150,0005,000145,000

a. Create a spreadsheet using Microsoft Excel (or any other spreadsheet software) that matches the one above by entering the output and cost data given above. Then use the appropriate formulas to create four new columns in your spreadsheet for average fixed cost (AFC), average variable cost (AVC), average total cost (ATC), and short-run marginal cost (SMC). [Computation check: At Q = 400: SMC = $110].

The world demand and supply curves for clay fire pits intersect at $190 per unit.

b. Use the appropriate formulas to create two more columns in your spreadsheet for total revenue (TR) and marginal (MR). [At Q = 400: MR = $190].

c. Use the appropriate formulas to create three more columns in your spreadsheet for profit (PROF), average profit (AVGPROF), and profit margin (PROFMARG). [ Computation check: At Q = 400: AVGPROF = $95].

d. If Redstone's manager wishes to minimize average total cost, how many clay fire pits should be produced? How many to maximize profit margin?

e. Redstone's manager is fired, and you are now the manager of Redstone Clayworks. How many fire pits would you choose to produce? Why?

f. Now triple the total fixed costs to $15,000 in your spreadsheet. How does this change your production decision in parte? Explain briefly.

g. Suppose a Congressional environmental panel announces that greenhouse gases from clay fire pits are contributing significantly to global warming. The announcement causes worldwide demand for fire pits to shrink substantially, and clay fire pit prices fall to $65 per unit. How does this change your production decision in parte? Explain briefly. [Note: Return total fixed cost to the original level of $5,000].