Prepare a graph showing average fixed costs

Reference no: EM13730904

For this assignment you will do a significant portion of work in MS Excel and import it into an MS Word document for submission.

You will use the data below to address Price and Output decisions faced by firms that are not in pure competition. Some numbers may be rounded.

Table 1
Output	Average Fixed cost	Average Variable Cost	Average Total Cost	Marginal Cost	Price	Total Revenue	Marginal Revenue
0					$ 345.00
1	$ 180.00	$ 135.00	$ 315.00		$ 300.00
2	$ 90.00	$ 127.50	$ 217.50		$ 249.00
3	$ 60.00	$ 120.00	$ 180.00		$ 213.00
4	$ 45.00	$ 112.50	$ 157.50		$ 189.00
5	$ 36.00	$ 111.00	$ 147.00		$ 165.00
6	$ 30.00	$ 112.50	$ 142.50		$ 144.00
7	$ 25.71	$ 115.70	$ 141.41		$ 126.00
8	$ 22.50	$ 121.90	$ 144.40		$ 111.00
9	$ 20.00	$ 130.00	$ 150.00		$ 99.00
10	$ 18.00	$ 139.50	$ 157.50		$ 87.00

Address the following:

Complete Table-1. Summarize your calculations.
Prepare a graph showing:
- Average Fixed Costs
- Average Variable Costs
- Average Total Costs
- Marginal Revenue
- Marginal Costs

Reference no: EM13730904

Questions Cloud

International commerce has rapidly increased : International commerce has rapidly increased as the Internet has provided a new and more transparent marketplace for individuals and entities alike to conduct international business and trading activities. Significant changes in the international eco..

Drug revolution and grace pharmaceuticals joint venture : A question in July 2013 about Drug Revolution and Grace Pharmaceuticals Joint venture with an excel spreadsheet uploaded. ON the free cash flow sheet line 14, why didn't you take out the 3 years of capital spending that is presented in the case stud..

Evaluation of corporate performance : The Final Project will involve applying the concepts learned in class to an analysis of a company using data from its annual report. Using the concepts from this course, you will analyze the strengths and weaknesses of the company and write a report ..

A nationally renowned photography business : Janice Cullen, owner of a nationally renowned photography business, files a registration statement and prospectus with the SEC. Five days after she files the registration statement, she has a meeting with her top 10 clients (primarily business owners..

Prepare a graph showing average fixed costs : Prepare a graph showing Average Fixed Costs and Average Variable Costs.

Explain the power of going viral : Explain the Power of "Going Viral"/ Examine advertising and social media

A 120-employee family-owned manufacturing firm : Mike is the Director of Human Resources for a 120-employee family-owned manufacturing firm. Mike has been quite busy the last year reforming the benefit offerings to comply with recent changes in healthcare laws. Given the many changes, Mike took the..

Describe what effective leadership means to you : Describe what effective leadership means to you. Who determines a leaders effectiveness? Provide details and examples to support your thoughts.

Personal distribution of income by percentile group : In what primary way is the current Distribution of Income a BENEFIT to our economy and to our society and what primary way is the current Distribution of Income a BENEFIT to our economy and to our society ? Why do you think so?

User Account

All Pages