A firm operating in perfect competition has no influence over market price. It can sell any amount at the market-clearing price. The only one major decision to make then is about what quantity should be produced. When it decides the quantity to produce, then this quantity—along with the prices prevailing in the market for output and inputs—will determine the firm’s total revenue, total costs, and ultimately, level of profits.

For the Costs and Revenue in Perfect Competition Assignment, you will submit an MS Excel spreadsheet and a paper (word document) in Waypoint.

In the Costs and Revenue in Perfect Competition Template Download Costs and Revenue in Perfect Competition Template(MS Excel), fill in the missing values in the given table.

Make sure to use the “formula” feature.(The numbers in the table change. So, if you don’t use the “formula”, your answers will be incorrect because of the changing numbers.) Please refer Excel Formulas and Functions TutorialLinks to an external site. for guidance.

• Calculate marginal cost (MC), marginal revenue (MR), average fixed cost (AFC), average variable cost (AVC), and average total cost (ATC).
• Graph all the cost curves and the MR curve.
• Find the profit-maximizing price and output.
• Calculate the profit (or loss).

In your paper, based on the readings for the week and your calculations in the worksheet, answer the following question:

• Explain if the firm should remain open or temporarily shut down when the price drops to $10.
• Discuss why firms in perfectly and monopolistically competitive markets stay in business despite having zero economic profit in the long run.

The Costs and Revenue in Perfect Competition paper

• must be two to three double-spaced pages in length (not including title and references pages and formatted according to APA StyleLinks to an external site. as outlined in the Writing Center’s APA Formatting for Microsoft WordLinks to an external site. resource.
• must include a separate title page with the following in title case:
  • title of paper in bold font
    • Space should appear between the title and the rest of the information on the title page.
  • student’s name
  • name of institution (The University of Arizona Global Campus)
  • course name and number
  • instructor’s name
  • due date
• must utilize academic voice. See the Academic VoiceLinks to an external site. resource for additional guidance.
• must include an introduction and conclusion paragraph.
• must use at least two credible sources in addition to the course text.