# Homework Help: Microeconomics Homework

1. Nov 15, 2015

### Kyle Jones

https://scontent.fdtw1-1.fna.fbcdn.net/hphotos-xat1/v/t35.0-12/12238195_10208423803536754_4071850233616539605_o.jpg?oh=c60d216b6c01a308ff1ace639c0d872f&oe=564A9A62

Here's my attempt at the problem:

Here are all relevant formulas:

TC = TFC + TVC
AFC = TC - AVC
ATC = (TVC/Q) + TFC/Q
TFC = Q x Price
AVC = (TC/Q) - (AFC /Q)
TVC = (Q x ATC) – (Q x AVC)

2. Nov 15, 2015

### Ray Vickson

It makes no sense to have the total cost go down from $9.2 at Q = 2 to$6 at Q = 3. You should avoid using a spreadsheet for most of this problem; just write things out manually, so you have control over all the calculations at every step. I think getting a spreadsheet to work properly in this problem would be difficult, because you are given data items of differing natures at different output levels, so the things you need to "solve for" differ at the different output levels.

3. Nov 15, 2015

### Staff: Mentor

In future posts, please do not delete the three parts of the homework template. The template is required for homework questions.

4. Nov 15, 2015

### Kyle Jones

Honestly, I just used excel to make it look easier to read and understand. I've been having problems with tables. I know what your concern is though. I don't want to use formulas for this. I don't understand where my math is wrong. That's what is making this assignment so difficult for me.

I gave it my best effort, but I don't know what numbers I've got wrong.

5. Nov 16, 2015

### Kyle Jones

Does this work? What's really messing me up is output 3

#### Attached Files:

• ###### image.jpeg
File size:
29.2 KB
Views:
80
6. Nov 16, 2015

### Staff: Mentor

Showing an image of a spreadsheet is no help to us, as it doesn't show the formula that's being used in each cell.
I agree completely with what Ray said.

7. Nov 16, 2015

### Kyle Jones

I'm not using formulas. I'm just typing them in and solving manually. I'm doing the math "by hand" on a calculator and these are the results I'm getting.

If I knew what formulas to type in to begin with I wouldn't be on this website.

8. Nov 16, 2015

### Ray Vickson

You are not helping. We cannot just look at the formulas and tell what you have done; you need to write down the details, step-by-step if you have any hope of getting assistance. For instance, when I do the computations for output = 2 I get something totally different from what you present. You need to show how you obtained your figures, and you should do that for at least 3 or 4 output levels. It does not matter if you present the results in tabular form, as long as they are presented in a clearly-labelled way.

9. Nov 17, 2015

### Kyle Jones

Figured it out! All good now. Thank you for assistance!