Using the given data, fill in the rest of the table (using formulas)


  Q	   FC	   VC	   TC 	 AFC	 AVC 	 ATC 	 MC 	 TR    Profit  
 ----	 ------	  -----	  ----	----	----	----	----	----  -------				
    0	 $1,000 	
 1000	 $1,000    $500 
 2000	 $1,000    $850 
 3000	 $1,000  $1,100 
 4000	 $1,000  $1,360 
 5000	 $1,000  $1,660 
 6000	 $1,000  $2,010 
 7000	 $1,000  $2,410 
 8000	 $1,000  $2,860 
 9000	 $1,000  $3,360 
10000	 $1,000  $3,910 
11000	 $1,000  $4,500 
12000	 $1,000  $5,200 
13000	 $1,000  $6,000 
14000	 $1,000  $7,000 

Q   quantity produced and sold
FC  fixed cost
VC  variable cost
TC  total cost  =VC+FC
AFC average fixed cost  =FC/Q
AVC average variable cost  =VC/Q
ATC average total cost  =AFC+AVC =TC/Q
MC  marginal cost  =?TC/?Q =change in TC/change in Q
TR  total revenue  =P*Q
Profit  =TR-TC

P price (=marginal revenue MR) use an absolute address cell 0.55

Make a line chart with Q on horizontal axis; curves of: FC,VC,TC,TR,Profit.

Make a line chart with Q on horizontal axis; curves of: AVC,ATC,MC.