The Costs of ProductionJoseph Farms, Inc. is a small firm in the agricultural industry. They have asked you to help them complete the limited data they have gathered in an effort to enable effective decision-making. Some work can be done using MS Excel but it must be copied to an MS Word file for the final submission of this assignment. To assist Joseph Farms, Inc., respond to the following:Using MS Excel or a table in MS Word, complete Table-1 (Joseph Farms, Inc., Cost and Revenue Data).Assume that the price is $165.Assume the fixed costs are $125, at an output level of 1.Assume that the data represents a firm in pure competition.Show your calculations.Explain theMC=MR Rule. Describe the market structures to which this rule applies.Create a chart to illustrate the data in Columns 9 and 10.Describe the profit maximizing (or loss minimizing) output for this firm. Explain why or why not there an accounting profit?Explain why a firm in pure competition is considered to be a “price taker.” (Assignment continues below Table-1.)Table-1: Joseph Farms, Inc., Cost and Revenue DataColumn 1Column 2Column 3Column 4Column 5Column 6Column 7Column 8Column 9Column 10Column 11OutputLevelPrice per unitTotal Fixed CostTotal Variable CostTotal CostAverage Fixed CostAverage Variable CostAverage Total CostMarginalCostMarginal RevenueTotal Revenue0 $ – NA1 $ 113.002 $ 213.003 $ 300.004 $ 375.005 $ 463.006 $ 563.007 $ 675.008 $ 813.009 $ 975.0010 $ 1,163.00Using the data in Table-1 (Joseph Farms, Inc., Cost and Revenue Data), complete Table-2 (Joseph Farms, Inc., Revenue/Profit/Loss Data). Show your calculations in summary form.Using the completed data in Table-2 (Joseph Farms, Inc., Revenue/Profit/Loss Data), Identify the break even output level for this firm.Table-2: Joseph Farms, Inc., Revenue/Profit/Loss DataOutputLevelPriceTotal RevenueTotal Costs from Table 1 Profit or Loss012345678910Save your MS Word file including your graphs or charts using the filenameLastnameFirstInitial_M3A2and submit it to theM3: Assignment 2 DropboxbyWednesday, February 18, 2015.Remember, quotations, paraphrases, and ideas you get from books, articles, or other sources of information should be cited usingAPA style. Help with citing sources can be found through theAcademic Resourcespage underCourse Home.Assignment 2 Grading CriteriaMaximum PointsAccurately calculated cost data (total fixed, total, average fixed, average variable, average total, and marginal) and revenue data (marginal and total) for output level ranging from 1 to 10 in Table-1. Showed calculations in summary form. Correctly assumed data represented a firm in pure competition. (40 points)Completed Table-1 as Microsoft Excel spreadsheet or Word table. (8 points)48Explained the MC=MR Rule. (12 points)Identified market structures the MC=MR Rule applies to. (8 points)Explained why MC=MR Rule applies to these market structures. (12 points)32Graphed all the data in column 9 of Table-1 (marginal cost) as curves in Microsoft Excel. (8 points)Graphed all the data in column 10 of Table-1 (marginal revenue) as curves in Microsoft Excel. (8 points)16Explained the profit maximizing (or loss minimizing) output for Joseph’s Farms, Inc. (14 points)Explained whether or not there is an economic profit for Joseph’s Farms, Inc. (14 points) 28Explained why a firm in pure competition is considered to be a “price taker.”28Accurately calculated price, total revenue, and profit or loss data for output level ranging from 0 to 10 in Table-2 using data from Table-1. Showed calculations. (10 points)Completed Table-2 as Microsoft Excel spreadsheet or Word table. (2 points)12Accurately calculated the break-even output level (break-even point) for Joseph’s Farms, Inc. using data in Table-2. Showed calculations.16Style (4 points):Tone, audience, and word choice.Usage and Mechanics (4 points): Grammar, spelling, and sentence structure.APA Elements (12 points): In text citations and references, paraphrasing, and appropriate use of quotations and other elements of style.20Total:200
You can hire someone to answer this question! Yes, essay96.com has paper writers dedicated to completing research and summaries, critical thinking tasks, essays, coursework, and other homework tasks. It's fast and safe.