help with AG econ cost formulas

Description Using the following spread sheet, find the different costs and decide what the producer in each row should do (increase production, decrease production, get out of business, or stay the same). Profit maximization or loss minimization are where marginal cost is equal to marginal revenue. Remember how the different costs are related to each other. A.F.C. M.C. Output Action $ 4.00 600 200 $ 2.00 $ 8.00 1000 1 Case # T. Revenue. T. Cost TV.C. T.F.C. Profit Price A.T.CA A.V.C. 2 3 1 $ 4.00 $ 3.00 $ 2.00 4 2 $ 8,000.00 Minimum 5 3 $ 8,000.00 $ 9,000.00 $ 9.00 6. 4 $ 16,000.00 $ 7,000.00 $ 9.00 Minimun 7 5 $ 7,000.00 $ 6.00 $ 8.00 8 6 $ 55,000.00 $ 45,000.00 $ 5.000.00 $ 90.00 9 7 $ 60,000.00 $ 10,000.00 $ 200.00 10 8 $ (1,000.00) $ 5.00 $ 6.00 11 $ 10,000.00 $ 2.000.00 $ 8.00 12 10 $ (200,00) $ 10.00 $ 12.00 $ 8.00 13 14 15 1 Complete the table 16 17 2. What action should the firm take in order to maximize profits or minimize loss in each case, and why? 18 $ 6.00 $ 120.00 $ 200,00 $ 5.00 Do 800 200 100 elp with my ag econ! ive got some formulas to he so the question and the table. Cost Formulas Total Revenue Price x Output Total Fixed Costs Sum of all foxed Costs Total Variable Costs Sum of all Variable Costs Total Costs TFC+TVC Ave Fixed Costs(AFC) TFC/Output Ave Variable Costs(AVC) TVC/Output Ave. Total Costs(ATC) TC/Output Marginal Cost ATC / Output or ATVC/"Output Short Run Rules Price > ATC, Produce make profit ATC > Price > AVC, Produce Minimize loss AVC > Price, Don't Produce Limit loss to Fixed Costs Long Run Rules Price > ATC, Produce MR = MC Price ATC, Produce MR = MC Price ATC, Produce make profit ATC > Price > AVC, Produce Minimize loss AVC > Price, Don't Produce Limit loss to Fixed Costs Long Run Rules Price > ATC, Produce MR = MC Price ATC, Produce MR = MC Price