Reference no: EM13373867
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