Question

In: Economics

1.1. Fill in the blanks in the following table using Excel formulas: Q P TR TFC...

1.1. Fill in the blanks in the following table using Excel formulas:

Q

P

TR

TFC

TVC

AVC

TC

AC

π

MR

MC

0

311,250

0.00

10,000

47.5

475000

311250

120000

12.00

431250

43.13

47.5

43.125

20,000

45

9000000

311250

230000

11.50

541250

27.06

42.5

11

30,000

42.5

1275000

311250

380100

12.67

691350

23.05

37.5

15

40,000

40

1600000

311250

570000

14.25

881250

22.03

32.5

19

50,000

37.5

1875000

311250

800000

16.00

1111250

22.23

27.5

23

60,000

35

2100000

311250

1069800

17.83

1381050

23.02

22.5

27

70,000

32.5

2275000

311250

1379700

19.71

1690950

24.16

17.5

31

P=50-0.00025Q.

1.2. Construct line charts for the Average Cost (AC), Average Variable Cost (AVC), Marginal Cost (MC), Marginal Revenue (MR) and Average Revenue (AR) on a Cartesian coordinate system.

Solutions

Expert Solution

Q P TR TFC TVC AVC TC AC π MR MC
0 311250 0 311250 -311250
10,000 47.5 475000 311250 120000 12 431250 43.13 43750 47.5 43.125 4.375
20,000 45 9000000 311250 230000 11.5 541250 27.06 358750 42.5 11 31.5
30,000 42.5 1275000 311250 380100 12.67 691350 23.05 583650 37.5 15 22.5
40,000 40 1600000 311250 570000 14.25 881250 22.03 718750 32.5 19 13.5
50,000 37.5 1875000 311250 800000 16 1111250 22.23 763750 27.5 23 4.5
60,000 35 2100000 311250 1069800 17.83 1381050 23.02 718950 22.5 27 -4.5
70,000 32.5 2275000 311250 1379700 19.71 1690950 24.16 584050 17.5 31 -13.5

1. Profit, π = TR - TC i.e. it is difference between total revenue and total cost.
2. Marginal profit, Mπ = MR - MC.

The profit maximizing level of output is 50000.

Below are excel formulae-

Below are the relevant curves -


Related Solutions

Fill in the blanks on the following table
 Fill in the blanks on the following tableE&pshareholder basisdistributiondividendreturn of capitalcapital gain20,000300,00080,000120,00010,000170,000220,000100,000170,00020,000080,000<20,000>50,000170,000
Fill in the blanks to complete the following table.
Fill in the blanks to complete the following table.SymbolIon FormedNumber of Electrons in IonNumber of Protons in IonF__________9Te_____54_____II−_______________Mg2+_____12Part AComplete the first column of the table.Express your answer as a chemical symbol.Part BComplete the second column of the table.Express your answer as ions. Enter your answers in order given in the table, from top to bottom, separated by a comma.Part CComplete the third column of the table.Express your answer as integers. Enter your answers in order given in the table, from...
Fill in the blanks in the following table using the Porphyry Copper Deposit description as an example.
Fill in the blanks in the following table using the Porphyry Copper Deposit description as an example. To enter data, just click on the cell and start typing. The cell will stretch to fit your answer. question is from introduction to mining 1MI1033 - Introduction to MiningModule #1, Unit #2 – Resources and Ore Deposit FormationDeposit TypePrincipal Ore Mineral(s)Secondary Ore Mineral(s)Name An Example of a Deposit and its LocationGrade And Tonnage Characterization DescriptionTypical Mining MethodsSize or Dimension of the DepositShape of...
Answer the following questions or fill in the blanks using information contained in the periodic table....
Answer the following questions or fill in the blanks using information contained in the periodic table. a) Boron has properties of both metals and nonmetals and is called a _____________. b) Transition metals are also known as _____-block elements when writing electron configurations. c) Certain nonmental elements like to exist as a pair (H2, F2, etc...) and are called _____________. d) Rows in the periodic table are called _____________. e) Group 18 elements are better known as_______________. f) Iced tea...
Fill-in the blanks of the following table and answer the following questions.
Fill-in the blanks of the following table and answer the following questions.                                Year                         Nominal GDP $                Real GDP $                      GDP Deflator       20052,000, 0002,000,000_____________20062,310,000___________         105Find the GDP Deflator in year 2005.Find the Real GDP in year 2006.Which GPD matters, nominal or real GDP? Why?Did the economy grow in year 2006? Why yes, why not?
Use the Fisher equation to fill in the blanks in the following table.
Inflation RateReal Interest RateNominal Interest Rate___%4%7%3%____%6%2%4%____%Use the Fisher equation to fill in the blanks in the following table.
Please fill in the blanks in the following table:          Present                Future        &n
Please fill in the blanks in the following table:          Present                Future                   Interest                   Time to          Value                   Value                      Rate                     Maturity          $20,000                                                6%                      34 years                                    $200,000                    7%                      12 years          $55,000          $111,419.91                                             18 years          $90,000          $207,408.40                 11%                           
1. suppy curve PQ=4 (1) P=4, Q=?, TR=?, the price elascity=? (2) P=3 Q=?, TR=?, the...
1. suppy curve PQ=4 (1) P=4, Q=?, TR=?, the price elascity=? (2) P=3 Q=?, TR=?, the prics elascity=? 2. suppy curve P=4/root(Q) (1) P=4, Q=?, TR=? The price elascity=? (2) P=3 Q=?, TR=? The price elascity=? I want detailed explanation, thank you very much??
Fill in the blanks: Consider the following equilibrium and fill in the blanks with either increase...
Fill in the blanks: Consider the following equilibrium and fill in the blanks with either increase or decrease. I2(s) + 5F2(g) ⇌ 2IF5(g) A decrease in volume results in a Blank 1 in pressure which will Blank 2 the amount of IF5.
Complete the following short-run cost table using the information provided. Q TC TFC TVC AVC ATC...
Complete the following short-run cost table using the information provided. Q TC TFC TVC AVC ATC MC 0 $   4 $_____ $ $ $ $ 1 7 2 9 3 10 4 11 5 13 6 17 7 22 3-      Using graphs, show the relationship between production and costs, by using marginal Product of labor (MPL), Average Product of labor (APL), Marginal cost (MC), and Average Cost (AC) curves? 4-      State the three cases of Returns to scale. Explain when...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT