tag:blogger.com,1999:blog-7785557572354836233.post979561855946212646..comments2014-07-31T11:10:12.121-05:00Comments on The Economics Of Organizations - Fall 2013: Coordination Failures and Coordination Mechanisms - Due Wednesday 9/18Professor Arvanhttp://www.blogger.com/profile/15256000730474030475noreply@blogger.comBlogger14125tag:blogger.com,1999:blog-7785557572354836233.post-58674833626382830202013-09-18T11:34:19.883-05:002013-09-18T11:34:19.883-05:00Literally just type the cell reference number afte...Literally just type the cell reference number after the "=". Because it's protected, you can't click on it, but you can still reference the cell in the formula by typing in the cell number.Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-7785557572354836233.post-90047689554157310242013-09-18T11:33:00.355-05:002013-09-18T11:33:00.355-05:00You have to type out the cell reference in the for...You have to type out the cell reference in the formula bar. It wont let you click it. it should work then.Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-7785557572354836233.post-32347011783025607412013-09-18T11:32:29.169-05:002013-09-18T11:32:29.169-05:00You have to type out the cell reference in the for...You have to type out the cell reference in the formula bar. It wont let you click it.Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-7785557572354836233.post-50091407380549215172013-09-18T11:18:45.218-05:002013-09-18T11:18:45.218-05:00Unless there is another way to reference the prote...Unless there is another way to reference the protected cell other than using the "=" and the cell reference, we are unable to reference protected cells.Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-7785557572354836233.post-75500135642709146352013-09-18T01:56:24.776-05:002013-09-18T01:56:24.776-05:00THERE IS NO ROUNDING. YOU MUST USE CELL REFERENCE...THERE IS NO ROUNDING. YOU MUST USE CELL REFERENCES. <b>TYPE</b> THOSE INTO THE CELL WITH THE FORMULA. DON'T TRY TO COPY FROM PROTECTED CELLS. Professor Arvanhttps://www.blogger.com/profile/15256000730474030475noreply@blogger.comtag:blogger.com,1999:blog-7785557572354836233.post-56080350392863070502013-09-17T20:33:14.929-05:002013-09-17T20:33:14.929-05:00Having the same problem. Can't reference F255....Having the same problem. Can't reference F255.Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-7785557572354836233.post-53815176296553893792013-09-17T19:49:20.853-05:002013-09-17T19:49:20.853-05:00It appears that the cell F255 is protected and ref...It appears that the cell F255 is protected and referencing it is prohibited. All we can do is look what is on our screen. Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-7785557572354836233.post-85251147995489103422013-09-17T18:13:04.644-05:002013-09-17T18:13:04.644-05:00I have a question about the transfer pricing tab o...I have a question about the transfer pricing tab on the Excel homework and it's the question that involves marginal pricing and output<br /><br />"When the transfer price is set by the central office...the optimal output is where marginal benefit equals marginal cost. This output is...?"<br /><br />So I take my A, B, C, D values (which are 210, 0.24, 10.5, 0.35 respectively) and set up an equation using the marginal functions of benefit and cost.<br /><br />Then I have A - BQ = C + DQ which, using the values I have, are 210 - 0.24Q = 10.5 + 0.35Q. Thus, 199.5 = 0.59Q and Q = 338.14 (rounded to two decimal places). <br /><br />But the homework box shows that this is incorrect so I'm confused as to what or how else this "marginal benefit equals marginal cost" equation can be set up to get the proper optimal Q.<br /><br />Thank you for your help!Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-7785557572354836233.post-60715826957366756962013-09-17T17:03:33.089-05:002013-09-17T17:03:33.089-05:00Let's talk about the economics first and leave...Let's talk about the economics first and leave the calculation for a moment. The issue is when there is an outside market where a perfect substitute can be bought or sold at the market price, what should the transfer price be? The answer in that case us that the transfer price should equal the market price. This is discussed in M&R. If you are having trouble with the worksheet on conceptual grounds, I strongly encourage you to read that. (The detail starts on page 82. The topic begins on page 79.) <br /><br />Now on the calculations themselves, the first time around where the market price is below what the transfer price would be in the absence of an outside market, the market price is given in cell F255. Use the cell reference instead of the number you see on the screen (which is a truncation of the true number) and then it should be like the calculations you've already done to this point. (Use cell reference for the Marginal Benefit and Marginal Cost parameters as well.) <br /><br />I hope that helps. For the time being I'm going offline but I will be available, if not later tonight then certainly tomorrow morning. So if there are further questions, please ask. Professor Arvanhttps://www.blogger.com/profile/15256000730474030475noreply@blogger.comtag:blogger.com,1999:blog-7785557572354836233.post-88524191364411103802013-09-17T16:03:01.580-05:002013-09-17T16:03:01.580-05:00Even using a pencil and paper away from the comput...Even using a pencil and paper away from the computer, I am still not understanding the last calculation problems, regarding the upstream and downstream division quantities at market price. Any help would be much appreciated! Olivia Altmayerhttps://www.blogger.com/profile/06435412455270721703noreply@blogger.comtag:blogger.com,1999:blog-7785557572354836233.post-78181520443046187632013-09-12T17:37:23.590-05:002013-09-12T17:37:23.590-05:00Not to give away the answer, we're not close e...Not to give away the answer, we're not close enough to the deadline for that, but my suggestion now is to try to solve this with pencil and paper away from the computer and see if you can understand it that way. Only then, go back to the Excel and type in the formulas.Professor Arvanhttps://www.blogger.com/profile/15256000730474030475noreply@blogger.comtag:blogger.com,1999:blog-7785557572354836233.post-57048539500738382332013-09-12T17:07:53.013-05:002013-09-12T17:07:53.013-05:00Does anyone have any idea how to solve the last tw...Does anyone have any idea how to solve the last two calculation problems on the last page. They are the questions on Q supplied in the upstream edition and Q demanded by the downstream division. I cat seem to figure them out.Tilesha Northernhttps://www.blogger.com/profile/02575651109217082649noreply@blogger.comtag:blogger.com,1999:blog-7785557572354836233.post-4348952409683502992013-09-12T06:51:56.391-05:002013-09-12T06:51:56.391-05:00You need to use Cell References to answer the ques...You need to use Cell References to answer the question. That 42.41 price might be how Excel shows on the screen a number that really is an infinitely repeated decimal, but is shown with only two decimal places. By using that instead of the cell reference, you are creating a rounding error. This is covered in the <a href="http://econoforganizationsfall2013.blogspot.com/2013/08/tutorial-for-doing-excel-homework.html" rel="nofollow">Tutorial video</a> which I encourage you to watch (full screen) if you haven't done so already. Professor Arvanhttps://www.blogger.com/profile/15256000730474030475noreply@blogger.comtag:blogger.com,1999:blog-7785557572354836233.post-82681831968053679842013-09-11T22:14:27.338-05:002013-09-11T22:14:27.338-05:00I have question about the last page, transfer pric...I have question about the last page, transfer pricing. For the monopsony part, I cannot get the output right. I think my answer is correct because if I plugged the number into the next question, which is about the transfer price, the answer is correct. <br />The other question is for the next question, which asks about the quantity supplied by upstream and quantity demanded by downstream divisions. I am not sure about these two questions. I tried to use MC as supply and MB as demand, then calculate the quantity with the price of 42.41. But the answers were not correct. I am wondering how to do these two questions. <br />Thank youAnonymousnoreply@blogger.com