Determine fixed costs equal value of the last three digits

Assignment Help Econometrics

Reference no: EM13191177

Output Total Variable Cost

0 $ 0

1 $ 50

2 $ 90

3 $120

4 $160

5 $220

6 $300

7 $400

8 $520

9 $670

10 $900

1) Given the above variable cost data and assuming fixed costs equal the value of the last three digits of your MDC student ID, create a file using Excel that lists Output, Fixed Cost, Variable Cost, Total Cost, Average Fixed Cost, Average Variable Cost, Average Total Cost, and Marginal Cost. The Excel table should be constructed using formulas wherever calculations were required.

2) Using Excel, plot FC, VC, and TC in Graph A and AFC, AVC, ATC, and MC in Graph B.

Reference no: EM13191177

Questions Cloud

Use comparative advantage and specialize in calculating : Gary and Diane must prepare a presentation. As part of their presentation, they must do a series of calculations and prepare 50 PowerPoint slides. It would take Gary 10 hours to do the required calculation and 10 hours to prepare the slides.

What is the lowest grade the student : a math student has a 100 homework average and test grades of 99,100 and 97. what is the lowest grade the student can get on the final exam and still get an A (an average of 90 or better) in the class?

Find the emperical formula for the compound : Three pure compounds are formed when 1.00 g sample of elements X combine with, respectively, 0.472 g, 0.420 g, and 0.236 g of element Z. The first compound has the formula X2Z3.

How close to the ground can the ball fall before : How close to the ground can the ball fall before it is too late for a warning shout from the balcony to reach the man in time? Assume that the man requires 0.300 s to respond to the warning.

Determine fixed costs equal value of the last three digits : Given the above variable cost data and assuming fixed costs equal the value of the last three digits of your MDC student ID, create a file using Excel that lists Output, Fixed Cost, Variable Cost, Total Cost, Average Fixed Cost, Average Variable C..

How many ten-dollar bills does the cashier have : a cashier has a total of 123 bills made up of fives and tens. The total value of the money is $725. how many ten-dollar bills does the cashier have?

Compute the diameter of the ball : calculate the diameter of the ball. The density of water is ?w = 1.000 g/cm3, the density of styrofoam is ?foam = 0.0950 g/cm3 and the acceleration due to gravity is g = 9.81 m/s2.

Make a chart of the possible dimensions for a rectangle : make a chart of the possible dimensions for a rectangle withan area of 196m2. What are the optimum dimensions of the rectangle for minimizing the perimeter?

State the butane combusts completely : A feed stream containing 2.00 mol/min butane and a feed stream containing 130 mol/min of air are fed into a reactor. The butane combusts completely according to the following reaction:

User Account

All Pages