Reference no: EM13123861

Redstone Clayworks, Inc a small firm located in Sedona, manufactures clay fire puts that homeowners place 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, Lowes, Front Gate and other upscale home product chains. Despite the best marketing efforts of these retailers to differentiate their individual brands of fire pits, consumers don't care much about brands: A clay fire pit, regardless of who sells it the following spreadsheet below provides data on Redstone's costs of production

(1)	(2)	(3)	(4)
Q	TC	TFC	TVC
0	5000	5000	0
100	10000	5000	5000
200	1900	5000	14000
300	27000	5000	22000
400	38000	5000	33000
500	50000	5000	45000
600	66000	5000	61000
700	84000	5000	79000
800	104000	5000	99000
900	126000	5000	121000
1000	150000	5000	145000

a. Create a spreadsheet using Excel that matches the one above entering the output and cost data given about. Then use 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 curve for clay fire pits at $ 190 per unit.

b. Use the appropriate formula to create two more columns in your spreadsheet for total revenue ( TR) marginal revenue ( MR). Computation check: AT Q=400: MR= $ 190

C. Use the appropriate formula to create two more columns in your spreadsheet for total revenue  for profit ( PROF),  average profit ( AVGPROF), and profit margin ( PROFMARG).   Computation check: AT Q=400: AVGPROG= $ 95}

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

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

c. Now triple the total fixed cost to $ 15000 in your spreadsheet, How does this change your production decision in part e? Explain briefly

d. Suppose a congressional environmental panel announces that greenhouse gasses from clay fire pits are contributing significantly to global warming. The announcement causes world -wide demand for fire pits to shrink substantially, and clay fire-pits prices fall to $ 65 per unit. How does this change your production decision in part e? Explain briefly: Note: Return total fixed cost to the original level of $5,000