Redstone clayworks inc a small firm located in sedona

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

Reference no: EM13373867

Questions Cloud

Quadplex cinema is the only movie theater in idaho falls : quadplex cinema is the only movie theater in idaho falls. the nearest rival movie theater the cedar bluff twin is 35

Writing about the language tone content and meaning of the : writing about the language tone content and meaning of the poem childhood by frances cornfordhere is the poemi used to

Nbspsummary of the attached list of books so i can complete : nbspsummary of the attached list of books so i can complete a annotation bibliography. my argument is pro the death

Describe how you would use one common game in your : describe how you would use one common game in your classroom. do not use those listed in module 11. briefly answer the

Redstone clayworks inc a small firm located in sedona : redstone clayworks inc a small firm located in sedona manufactures clay fire puts that homeowners place their patios

A family supper by kazuo ishiguro please number the : a family supper by kazuo ishiguro . please number the answers one page1. what has the narrator done that had so gravely

Answer question about the waste land the title of this : answer question about the waste land. the title of this section is the burial of the dead. read all the poems write a

The largo publishing house uses 400 printers and 200 : the largo publishing house uses 400 printers and 200 printing press to produce book. a printers wage rate is 20 and

During the 1990s several airlines were on the brink of : during the 1990s several airlines were on the brink of bankruptcy. these same airlines were giving away millions of

User Account

All Pages