The second Excel homework is due this Thursday evening. If you have questions or comments about the assignment please put them as commnets to this post.

After class today some students came up to me and said they were having trouble with the homework, the part where there is transfer pricing but also an external market.

I just tried it and it is fine as is. But I also tried to replicate the error and I think I did that. The problem is that there is a price in cell F255. You see a number with two decimals, but you were instructed in the tutorial not to trust what you see but rather to use the cell reference. See if that works for you.

I am working on the third spreadsheet, trying to find the optimal output when marginal benefit equals marginal cost. I have set the two equations equal to each other yet the amount I keep getting is incorrect. Is there something arithmetically I am doing wrong?

Have you entered all the parameters via cell reference and not by typing in the number? If no, try that. If yes, then there is something conceptual going on and we should look at the way you are solving the equation.

After class today some students came up to me and said they were having trouble with the homework, the part where there is transfer pricing but also an external market.

ReplyDeleteI just tried it and it is fine as is. But I also tried to replicate the error and I think I did that. The problem is that there is a price in cell F255. You see a number with two decimals, but you were instructed in the tutorial not to trust what you see but rather to use the cell reference. See if that works for you.

I am working on the third spreadsheet, trying to find the optimal output when marginal benefit equals marginal cost. I have set the two equations equal to each other yet the amount I keep getting is incorrect. Is there something arithmetically I am doing wrong?

ReplyDeleteHave you entered all the parameters via cell reference and not by typing in the number? If no, try that. If yes, then there is something conceptual going on and we should look at the way you are solving the equation.

ReplyDeleteI was just entering the number, but changing it to cell references worked. Thank you for your help.

Delete