Joseph 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 the MC=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 is an economic 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 Data Column 1Column 2Column 3Column 4Column 5Column 6Column 7Column 8Column 9Column 10Column 11Output LevelPrice per unitTotal Fixed CostTotal Variable CostTotal CostAverage Fixed CostAverage Variable CostAverage Total CostMarginal CostMarginal RevenueTotal Revenue0 $ – NA 1 $ 113.00 2 $ 213.00 3 $ 300.00 4 $ 375.00 5 $ 463.00 6 $ 563.00 7 $ 675.00 8 $ 813.00 9 $ 975.00 10 $ 1,163.00 Using 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 DataOutput LevelPriceTotal RevenueTotal Costs from Table 1 Profit or Loss0 1 2 3 4 5 6 7 8 9 10 Save your MS Word file including your graphs or charts using the filename Assignment 2 Grading Criteria Maximum 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
Do You Need A Similar Assignment Done For You From Scratch? We Have Qualified Writers To Help You. We Assure You An A+ Quality Paper That Is Free From Plagiarism. Order Now For An Amazing Discount!
Very professional support! Highly recommended.
Researched complicated topic and delivered report by the requested deadline. The paper is of a high standard reflecting careful research and clear assessments. I recommend iLecturers.com.com
It’s a 5 start for me. Excellent research and writing. The paper reflects a careful assessment of scientific information.
With Gib’s reflection, they wrote a really specific essay. Very well written, containing all of the languages I required and excellent references. The writer follows my instructions and writes clearly in English.
I am so grateful and I am 100% happy with your work.
A fantastic piece of work 👏. The writer demonstrated full knowledge of the topic and applying the relevant provided material. Well done.