Manufacturing firm operating a given scale of plant

Assignment Help Microeconomics
Reference no: EM13676735

Consider a manufacturing firm operating a given scale of plant. Assume that the only input that the firm can change the amount of that can be used during the time period considered is labor (L).

Assume that the production function between Labor (L) and Total Product (Q) is given in the first two columns of the table below.

Labor (L) Total Product (Q) Labor (L) Total Product (Q)
1 100 10 1,234
2 250 11 1,314
3 410 12 1,384
4 560 13 1,444
5 700 14 1,494
6 830 15 1,534
7 945 16 1,564
8 1,050 17 1,584
9 1,146 18 1,594

Assume that depreciation on the plant and equipment, interest on borrowed money, property taxes, insurance, etc., i.e., Total Fixed Costs (TFC), are $220, and that the price of a unit of labor (PL) is $100.

To gain experience with a valuable piece of business software, it is strongly suggested that the student use a spreadsheet software program to perform the calculations and to construct the graphs described in parts A and B below. Any spreadsheet program may be used although students may be most familiar with MS EXCEL. It is assumed that the student is familiar with making calculations using a spreadsheet program.

As indicated on the course Syllabus, it is suggested that MS OFFICE, which includes EXCEL, be installed on external computers that are used. It is installed on all the computers located on the Gannon main campus.


A. Calculations
Instructions. Open a spreadsheet program, such as MS EXCEL. Open a new worksheet. Enter the above data for L in column 1 and the above data for Q in column 2.

For each level of output (Q) shown in the second column in the above table, calculate a value for each of the following cost measures: Total Fixed Cost (TFC), Total Variable Cost (TVC), Total Cost (TC), Average Fixed Cost (AFC), Average Variable Cost (AVC), Average Total Cost (ATC) and Marginal Cost (MC). Refer to the Lecture Notes entitled "Short Run Cost Functions" for the formulas used for calculating the cost measures. [Note: In calculating the average cost measures be sure to divide the corresponding total cost measure by Q and NOT by L.]
Ideally, MC would be calculated between each row and placed on a new row created with an amount of output (Q) equal to ½ of the two amounts of output used in the calculation. In other words, the MC calculated between 100 and 250 units of Q would be calculated using the discrete formula and placed on a newly created row corresponding to 175 units of Q. But this is not necessary. Each MC calculation may be placed on the row corresponding to the higher of the two levels of output used in the calculation. For example, the MC calculated between 100 and 250 units of Q using the discrete formula may be placed on the row corresponding to 250 units of Q.

Copy the above calculations in the EXCEL program and insert, i.e., paste, here into this document.


B. Graphs

1. Using the EXCEL chart feature, on one diagram graph the relationship between Total Product (Q) and all three of the total cost measures, i.e., TFC, TVC, and TC.

There is a tutorial on using the EXCEL chart tool available at:
https://ww2.gannon.edu/cetl/mahan/excel/chart.htm
If there are any technical questions on the use of the EXCEL chart feature, contact Tex Brieger, who is the creator of the tutorial, at (814.871.7134, [email protected])

On the graph be sure to label the axes and provide a label or legend for each curve. Be sure to place output (Q) on the horizontal axis and be sure that the scale for Q is correct.

Copy the above graph in the EXCEL program and insert, i.e., paste, here into this document.


2. Using the EXCEL chart feature, on another diagram, graph the relationship between Total Product (Q) and the average and marginal cost measures, i.e., AFC, AVC, ATC, and MC. Ideally, MC would be plotted midway between the two amounts of output (Q) used in the calculation, but this is not necessary. It may be plotted corresponding to the higher of the two levels of output used in each calculation. For example, the MC calculated between 100 and 250 units of Q may be plotted corresponding to 250 units of Q.

On the graph be sure to label the axes and provide a label or legend for each curve. Be sure to place output (Q) on the horizontal axis and be sure that the scale for Q is correct.

There is a tutorial on using the EXCEL chart tool available at:
https://ww2.gannon.edu/cetl/mahan/excel/chart.htm
If there are any technical questions on the use of the EXCEL chart feature, contact Tex Brieger, who is the creator of the tutorial, at (814.871.7134, [email protected])

Copy the above graph in the EXCEL program and insert, i.e., paste, here into this document.



C. Relationships

1. What happens to the value of each of the total cost measures, i.e., TC, TVC, and TFC, as Q increases (increases, decreases, remains constant?).

2. What happens to the value of AFC as Q increases?

3. How long does AFC decrease?

4. AVC decreases over the range of output from _____ to _____. Over this range of output what is happening to the values of AFC and ATC as output increases?

5. AVC increases over the range of output from _____ to _____. Over this range of output what is happening to the values of AFC and ATC as output increases?

6. ATC reaches a minimum at a level of output approximately equal to _____ . AVC reaches a minimum at a level of output approximately equal to _____.

7. How would you characterize the shapes of the ATC curve, AVC curve, and the MC curve?

8. Pick a level of Q for which MC < ATC. If Q were to increase, the value of ATC (increases, decreases, stays the same?)

9. Pick a level of Q for which MC > ATC. If Q were to increase, the value of ATC (increases, decreases, stays the same?)

10. The MC curve intersects the ATC at the __________ point on the ATC curve?

11. Referring to the table, over that range of labor usage throughout which MP increases as more L is used, for the corresponding range of output, as Q increases, MC (increases, decreases, remains constant?) .

12. Over that range of labor usage throughout which MP decreases as L increases, for the corresponding range of output, as Q increases, MC (increases, decreases, remains constant?) Explain.

[Hint: The best way to see the relationship between MP and MC and to answer the above two questions is to construct two diagrams, one on top of the other. In the lower diagram, graph the MP curve. In the upper diagram, on the horizontal axis plot the Q corresponding to the amount of labor on the horizontal axis of the bottom diagram, and on the vertical axis plot MC.]

Reference no: EM13676735

Questions Cloud

How could government subsidize a producer : How could government subsidize a producer?
Describe the macroeconomic factors : Describe the macroeconomic factors
Find what vector forms a triangle : Three vectors that are neither parallel nor anti parallel can be arranged to form a triangle if they sum to (0, 0). Find what vector forms a triangle with (0, 3) and (3, 0)
What price should you charge to the second group : What price should you charge to the second group?
Manufacturing firm operating a given scale of plant : Consider a manufacturing firm operating a given scale of plant
Determine the force required to pull : A thin 1.1 millimeter coating of glycerin has been located between two microscope slides of width 1 centimeter and length 4 centimeter. Determine the force required to pull one of the microscope
Find what is the magnitude of the electric potential : A solid conducting sphere (radius = 5.0 centimeter) has a charge of 0.25 nC distributed uniformly on its surface. find what is the magnitude of the electric potential difference between these two points
Obtain how far does the hamster run in one night : A hamster runs in its wheel for 3.3 hours every night. If the wheel has a 6.8 centimeter radius and its average angular velocity is 3.0 rad/s, obtain how far does the hamster run in one night
Average cost includes both fixed and variable costs : Average cost includes both fixed and variable costs

Reviews

Write a Review

 

Microeconomics Questions & Answers

  Compare and constract equilibrium for a monopolistic fir

Compare and constract equilibrium for a monopolistic fir and that of a perfectly competitive firm. clearly labelled diagrams should be included

  Why keynesian economists believe market forces do not

why do keynesian economists believe market forces do not automatically adjust for unemployment and inflation? what is

  The cause of accident is found to be due to airways

airway international inc. is a commercial passenger airline. airway includes on its tickets a clause that states the

  Determine the market equilibrium price for coffee beans

Due to the lack of profits, many growers have stopped production and the output of coffee beans has fallen from 400 tons per year to 250 tons per year.

  Can ge successfully prevent maytag from entering the market

suppose that ge is trying to prevent maytag from entering the market for high efficiency clothes dryers. even though

  For each of the following draw a diagram that illustrates

For each of the following, draw a diagram that illustrates the likely effect on the market for eggs. Indicate in each case the impact on equilibrium price and equilibrium quantity.

  Perform a white test for heteroskedasticity

Perform a White test for heteroskedasticity using auxiliary regression

  Explain a two time period budget equation

What did you end up doing? Explain using a two time period budget equation and congress must be happy with your findings. You are sitting at your desk starring at your very first bonus.

  Which of the following expressions is correct for a

which of the following expressions is correct for a competitive firm?a. profit quantity of output x price - average

  Describe the process of a money market hedge and calculate

ibm purchased computer chips from nec a japanese electronics concern and was billed yen250 million payable in three

  1 what factors can contribute to unemployment2 how can

1. what factors can contribute to unemployment?2. how can technology lead to greater unemployment or is it a benefit to

  Evaluate the validity of bobs statement in terms of absolute

Consider Bob, he washes his car by hand rather than taking it to the local car wash. When asked why he washes it by hand, Bob explains "you should never pay for something you can do yourself." Evaluate the validity of Bob's statement.

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd