Question

In: Economics

Problem 1. Complete the table below. Please use the spreadsheet for your convenience and to submit...

Problem 1. Complete the table below. Please use the spreadsheet for your convenience and to submit your responses.

Given: total Fixed Costs = $60 (i.e., the fixed cost of $60 does not change with output).

The price of the product is $55

Production Schedule for a widget firm

Output (Q)

Total Fixed Costs (TFC)

Total Variable Cost               (VC)

Total Cost (TC)

Average Fixed Cost (AFC)

Average Variable Cost (AVC)

Average Total Costs (ATC)

Total Revenue (TR)

Profit

0

0

1

45

2

85

3

120

4

150

5

185

6

225

7

270

8

325

9

390

10

465

Question: What is the profit-maximizing output for the firm? Explain.

Solutions

Expert Solution

Complete the table below.

Q TFC VC TC AFC AVC ATC TR Profit
0 60 0 60 0 -60
1 60 45 105 60 45 105 55 -50
2 60 85 145 30 42.5 72.5 110 -35
3 60 120 180 20 40 60 165 -15
4 60 150 210 15 37.5 52.5 220 10
5 60 185 245 12 37 49 275 30
6 60 225 285 10 37.5 47.5 330 45
7 60 270 330 8.57 38.57 47.14 385 55
8 60 325 385 7.50 40.63 48.13 440 55
9 60 390 450 6.67 43.33 50.00 495 45
10 60 465 525 6 46.5 52.5 550 25

AFC=FC/QTC=TFC+TVC

AVC=VC/Q

ATC=TC/Q

TR=price*Q

Profit=TR-TC

What is the profit-maximizing output for the firm? Explain.

profit Maximising quantity: 8 unit

Explanation:

Q TFC VC TC AFC AVC ATC TR Profit MC
0 60 0 60 0 -60
1 60 45 105 60 45 105 55 -50 45
2 60 85 145 30 42.5 72.5 110 -35 40
3 60 120 180 20 40 60 165 -15 35
4 60 150 210 15 37.5 52.5 220 10 30
5 60 185 245 12 37 49 275 30 35
6 60 225 285 10 37.5 47.5 330 45 40
7 60 270 330 8.57 38.57 47.14 385 55 45
8 60 325 385 7.50 40.63 48.13 440 55 55
9 60 390 450 6.67 43.33 50.00 495 45 65
10 60 465 525 6 46.5 52.5 550 25 75

MC=change in TC/change in Q

MR=change in TR/change in Q

firm maximizes its profit where MR equals MC. in perfect competition Price=MR.so here at quantity 8, Price=MC. so that will be profit maximising quantity.


Related Solutions

Complete the questions below. Submit only an Excel spreadsheet with your name, one tab for each...
Complete the questions below. Submit only an Excel spreadsheet with your name, one tab for each question, and your Excel Solver solution; ensure that you clearly identify each answer. A local pastry shop is planning their next morning’s production. The shop has three main items that they sell: cakes, cupcakes, and cannolis. All of these are made in-house with the shop’s own ingredients. The recipes for these items are as follows: Cakes: 5 eggs, 2 cups flower, 15 g of...
Create an Excel spreadsheet to organize your answers to the following problem, and submit your Excel...
Create an Excel spreadsheet to organize your answers to the following problem, and submit your Excel file as an attachment by clicking on the appropriate button on this page. A firm that is in the 35% tax bracket forecasts that it can retain $4 million of new earnings plans to raise new capital in the following proportions: 60% from 30-year bonds with a flotation cost of 4% of face value. Their current bonds are selling at a price of 91...
create an Excel spreadsheet to organize your answers to the following problem, and submit your Excel...
create an Excel spreadsheet to organize your answers to the following problem, and submit your Excel file as an attachment by clicking on the appropriate button on this page. A company is evaluating the purchase of a machine to improve product quality and output levels. The new machine would cost $1.6 million and would be depreciated for tax purposes using the straight-line method over an estimated six-year life to its expected salvage value of $100,000. The new machine would require...
Create an Excel spreadsheet to organize your answers to the following problem, and submit your Excel...
Create an Excel spreadsheet to organize your answers to the following problem, and submit your Excel file as an attachment by clicking on the appropriate button on this page. A company with EBIT of $6,000,000 is considering two financing alternatives. The first alternative would have interest expense of $2,000,000 and 1,000,000 common shares outstanding, whereas the second would have interest expense of $3,800,000 but only 750,000 shares outstanding. The company is in the 35% tax bracket. Part 1: Construct the...
Create an Excel spreadsheet to organize your answers to the following problem, and submit your Excel...
Create an Excel spreadsheet to organize your answers to the following problem, and submit your Excel file as an attachment by clicking on the appropriate button on this page. A firm had the following abbreviated income statement for 2020 and abbreviated balance sheets at the end of 2020 and 2021. 2020 Sales $600,000 Less Cost of goods sold 320,000 Gross Profit 280,000 Less Operating expenses 190,000 Less Depreciation 30,000 Operating Income (EBIT) 60,000 Less Interest expense 20,000 Earnings Before Taxes...
Create an Excel spreadsheet to organize your answers to the following problem, and submit your Excel...
Create an Excel spreadsheet to organize your answers to the following problem, and submit your Excel file as an attachment by clicking on the appropriate button on this page. A company with EBIT of $6,000,000 is considering two financing alternatives. The first alternative would have $25 million of bonds at 8% interest and 1,000,000 common shares outstanding, whereas the second would have $47.5 million of bonds at 8% interest and only 750,000 shares outstanding. The company is in the 35%...
chapter 14 Create an Excel spreadsheet to organize your answers to the following problem, and submit...
chapter 14 Create an Excel spreadsheet to organize your answers to the following problem, and submit your Excel file as an attachment by clicking on the appropriate button on this page. A company with EBIT of $6,000,000 is considering two financing alternatives. The first alternative would have $25 million of bonds at 8% interest and 1,000,000 common shares outstanding, whereas the second would have $47.5 million of bonds at 8% interest and only 750,000 shares outstanding. The company is in...
Please use Excel to solve the assignment and submit as an excel spreadsheet. Bethesda Mining Company...
Please use Excel to solve the assignment and submit as an excel spreadsheet. Bethesda Mining Company Based on a Mini Case presented in the textbook Ross, S.A., R.W. Westerfield and J. Jaffe, Corporate Finance, McGraw Hill/Irwin. Bethesda Mining is a midsized coal mining company with 20 mines located in Ohio, Pennsylvania, West Virginia and Kentucky. The company operates deep mines as well as strip mines. Most of the coal mined is sold under contract, with excess production sold on the...
Complete problem below and submit to your instructor. Write under the generally accepted auditing standards column...
Complete problem below and submit to your instructor. Write under the generally accepted auditing standards column the specific standard that was violated and how the action of Jones resulted in a failure to comply with each standard. Organize your answer as shown below; specifically with a column for the standard that was violated and a column for the required action. The paper should be 2-3 pages. Problem: John Clinton, owner of Clinton Company, applied for a bank loan and was...
Using these results, complete the table below and then use your results to answer the questions...
Using these results, complete the table below and then use your results to answer the questions that follow. (Please remember to round all answers to two decimal places: 0.00 at each step.) (23 points) X X-M (X-M)2 1 14 -15.85 251.22 2 16 -13.85 191.82 3 18 -11.85 140.42 4 20 -9.85 97.02 5 23 -6.85 46.92 6 23 -6.85 46.92 7 25 -4.85 23.52 8 27 -2.85 8.12 9 28 -1.85 3.42 10 29 -0.85 0.72 11 30 0.15...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT