# Excel Micro Econ

The following questions address some of the price and output decisions faced by firms other than those found in perfect competition. Some numbers may be rounded.
Table 1-a
Average Fixed cost
Average Variable Cost
Average Total Cost
Output
0
1
\$   180.00
\$ 135.00
\$    315.00
2
\$     90.00
\$ 127.50
\$    217.50
3
\$     60.00
\$ 120.00
\$    180.00
4
\$     45.00
\$ 112.50
\$    157.50
5
\$     36.00
\$ 111.00
\$    147.00
6
\$     30.00
\$ 112.50
\$    142.50
7
\$     25.71
\$ 115.70
\$    141.41
8
\$     22.50
\$ 121.90
\$    144.40
9
\$     20.00
\$ 130.00
\$    150.00
10
\$     18.00
\$ 139.50
\$    157.50
Table 1-a (continued)
Marginal Cost
Price
Total Revenue
Marginal Revenue
Output
0
\$ 345.00
1
\$ 300.00
2
\$ 249.00
3
\$ 213.00
4
\$ 189.00
5
\$ 165.00
6
\$ 144.00
7
\$ 126.00
8
\$ 111.00
9
\$   99.00
10
\$   87.00
Questions:

Complete Table 1. Summarize your calculations and use Microsoft Excel.
Using Excel, draw one graph showing average fixed costs, average variable costs, average total costs, marginal revenue, and marginal costs.
Using the data in the table and on your graph, what is the profit maximizing, or loss minimizing level of output?  Explain and justify your answers.
What is a normal profit?  What is an economic profit? Explain your answer using examples. Are normal profits being earned in this example? Are economic profits present for this firm in this example?  Explain your answers.
Given the data in the table and the graph, how could you determine or identify the optimal plant size?
What is the difference between explicit and implicit cost?  Explain your answers.
How would we determine if a cost is a fixed cost or a variable cost?

Present your analysis in Microsoft Excel format. Enter non-numerical responses in the same worksheet using textboxes. If you want to learn how to use Microsoft Excel to create curves, refer to the Microsoft Excel tutorials.
Submit your documents to the Submissions Area by the due date assigned.
“Looking for a Similar Assignment? Get Expert Help at an Amazing Discount!”

The post Excel Micro Econ appeared first on Nursing Experts Help.

## Order a similar paper and get 15% discount on your first order with us

98% Success Rate
“Hello, I deliver nursing papers on time following instructions from the client. My primary goal is customer satisfaction. Welcome for plagiarism free papers”
Stern Frea
98% Success Rate
Hi! I am an English Language and Literature graduate; I have written many academic essays, including argumentative essays, research papers, and literary analysis.
Dr. Ishid Elsa
98% Success Rate
"Hi, count on me to deliver quality papers that meet your expectations. I write well researched papers in the fields of nursing and medicine".
Dr. Paul P. Klug
99% Success Rate
"A top writer with proven reliability and experience. I have a 99% success rate, overall rating of 10. Hire me for quality custom written nursing papers. Thank you"

### How Our Essay Writing Service Works

Fill out order details and instructions, then upload any files or additional materials if needed. Then, confirm your order by clicking “Place an Order.”

Your payment is processed by a secure system. We accept Mastercard, Visa, Amex, and Discover. We don’t share any informati.on with third parties

## The Writing Process

You can communicate with your writer. Clarify or track order with our customer support team. Upload all the necessary files for the writer to use.

## Recent Questions

### Why Aren’t Smokers Switching to Juul?

Why Aren’t Smokers Switching to Juul?

### Group Presentation

Group Presentation

### Musculoskeletal and Skin/Integumentary Comprehensive Examination

Musculoskeletal and Skin/Integumentary Comprehensive Examination

### Neurologic SOAP note

Neurologic SOAP note