Explore BrainMass
Share

Quantitative Excel Graphing Exercise: Drespie Corn Products

This content was COPIED from BrainMass.com - View the original, and get the already-completed solution here!

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.

© BrainMass Inc. brainmass.com March 22, 2019, 3:33 am ad1c9bdddf
https://brainmass.com/economics/managerial-economics/quantitative-excel-graphing-exercise-drespie-corn-products-621663

Attachments

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 ...

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.

$2.19