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(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 referfor 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 toas outlined in the Writing Center’s resource.must include a separate title page with the following in title case:title of paper in bold fontSpace should appear between the title and the rest of the information on the title page.student’s namename of institution (The University of Arizona Global Campus)course name and numberinstructor’s namedue datemust utilize academic voice. See the resource for additional guidance.must include an introduction and conclusion paragraph.Your introduction paragraph needs to end with a clear thesis statement that indicates the purpose of your paper.For assistance on writing and , refer to the Writing Center resources.must use at least two credible sources in addition to the course text.The table offers additional guidance on appropriate source types. If you have questions about whether a specific source is appropriate for this assignment, please contact your instructor. Your instructor has the final say about the appropriateness of a specific source.