Purchase Solution

Quantitative Excel Graphing Exercise: Drespie Corn Products

Not what you're looking for?

Ask Custom Question

You are the new owner of Drespie Corn Products and Refineries. You are interested in your company's cost and revenue relationships as well as its future pricing strategies. Accordingly, you have developed the following relationships, which you believe to be accurate on the basis of historical data:

P = $50 - $0.005Q

TC = $73,500 + $6Q + $0.0006Q2

MR = $50 - $0.01Q

MC = $6 - $0.0012Q

where P is the price, Q the quantity, TC the total cost, MC the marginal cost, and MR the marginal revenue.

Tasks:

Using the Microsoft Excel Template given below, complete all the data in the template.
Use the following formula to calculate the profit-maximizing point: MR - MC = 0. Explain your answer.
Using the equation for MR (given below), calculate the revenue-maximizing level of output. Explain your answer.

MR = $50 - $0.01Q = 0
What is the difference between the output level where the total profit is maximized and the output level where the total revenue (TR) is maximized? What is the significance of these two values in the decision-making process?
Using Microsoft Excel, graph the data in the completed Template given below. Using the graph, identify the point where the total profit is maximized and the point where the TR is maximized. Explain your answers.

Attachments
Purchase this Solution
Solution Summary

This solution shows how to prepare an Excel spreadsheet illustrating the revenue and cost functions of Drespie Corn Products and Refineries. The completed spreadsheet is given along with graphs of each of the functions, showing the profit-maximizing and revenue-maximizing output quantities.

Solution Preview

>Using the Microsoft Excel Template given below, complete all the data in the template.

See the attached file.

>Use the following formula to calculate the profit-maximizing point: MR - MC = 0. Explain your answer.

Profit is maximized when MR = MC
Let MR = MC
50 - 0.01Q = 6 + 0.0012Q (note that the formula for MC in the question is ...

Purchase this Solution
Free BrainMass Quizzes
Pricing Strategies

Discussion about various pricing techniques of profit-seeking firms.

Economic Issues and Concepts

This quiz provides a review of the basic microeconomic concepts. Students can test their understanding of major economic issues.

Basics of Economics

Quiz will help you to review some basics of microeconomics and macroeconomics which are often not understood.

Elementary Microeconomics

This quiz reviews the basic concept of supply and demand analysis.

Economics, Basic Concepts, Demand-Supply-Equilibrium

The quiz tests the basic concepts of demand, supply, and equilibrium in a free market.

View More Free Quizzes
Related BrainMass Solutions

  • Optimal Solution

    405167 Optimal Solution - Constraints are binding and decision variable Jake's Buy Products purchases two unprocessed corn (ConCorn and Stalkers) to produce various products.

  • Quantitative Methods - Pilot Farm Project

    181360 Quantitative Methods - Pilot Farm Project See the attached file.

  • Graphing Functions

    170553 Graphing Functions To exercise your skills, you are to perform the following using different tools available to you (e.g.

  • Linear Functions and their Graphs

    To exercise your skills, you are to perform the following using different tools available to you (e.g., Excel spreadsheet, graphing calculator, etc.) and write and explanation on your findings: The graph of: f(x)= 0 The graph of: f(x) = a0, where

  • Polynomial Functions

    Excel spreadsheet, graphing calculator, etc.) and write an explanation on your findings: When graphing a function f(x), you're drawing a picture of the infinite number of points (x, y) where x is any number

  • Polynomial, rational, exponential and logarithmic functions.

    Excel spreadsheet, graphing calculator, etc.) and write an explanation on your findings: When graphing a function f(x), you're drawing a picture of the infinite number of points (x, y) where x is any number

  • Formulating a linear programming model

    Optimal solution is obtained by using MS EXCEL.

  • DMA, Inc. Apply Standard Conversion Costs Labor Overhead

    See Excel attached for schedules to guide you and instructional notes. Click in cells to see computations. See Excel attached for schedules to guide you and instructional notes. Click in cells to see computations.

  • Linear Programming: Maximize Planting

    2 4 120 <= 120 Answer: Wheat: 20 Acres Corn : 20 Acres Total profit: $10,000 This solution uses Excel to solve this maximization problem and the Excel document is attached to this posting.

View More Related Solutions