Explore BrainMass

Quantitative analysis of revenue figures

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

1a. Given the (Q) and price (P) data in the following table, calculate the related total revenue (TR), marginal revenue (MR), and average revenue (AR) figures:
0 $10
1 9
2 8
3 7
4 6
5 5
6 4
7 3
8 2
9 1
10 0
b. Graph this data using "dollars" on the vertical axis and "quantity" on horizontal axis. At what output level revenue maximized?
c. Why is marginal revenue less than average revenue at each price level?
2a. Fill in the missing data for price (P), total revenue (TR), marginal revenue (MR), total cost (TC), marginal cost (MC), profit (π), and marginal profit (Mπ) in the following table:
0 $160 $0 $-- $0 $--- $0 $---
1 150 150 150 26 25 125 125
2 140 55 30 100
3 390 35 300 75
4 90 130 350
5 110 550 175
6 600 50 55 370
7 630 290 60 -30
8 80 640 355 285
9 75 -85
10 600 525
B. At what output level is profit maximize?
C. At what output level is revenue maximized?
D. Discuss any differences in your answers to parts B and C.

3. Characterize each of following statements as true or false, and explain your answer.
A. If marginal revenue is less than average revenue, the demand curve will downward sloping.
B. Profits will be maximized when total revenue equals total cost.
C. Given a downward-sloping demand curve and positive marginal costs, profit-maximizing firms will always sell less output at higher prices than will revenue-maximizing firms.
D. Marginal cost must be falling for average cost to decline as output expands.
E. Marginal profit is the difference between marginal revenue and marginal cost and will always equal zero at the profit-maximizing activity level.

4. Jessica Simpson is the regional sales representative for Dental Laboratories, Inc. Simpson sells alloy products created from gold, silver, platinum, and other precious metal to several dental laboratories in Maine, New Hampshire, and Vermont. Simpson's goal is to maximize her total monthly commission income, which is figured at 10% of gross sales. In reviewing her monthly experience over the past year, Simpson found the following relations between days spent in each state and monthly sales generated:
Maine New Hampshire Vermont
Days Gross Sales Days Gross Sales Days Gross Sales
$4,000 0 $0 0 $2,500
10,000 1 3,500 1 5,000
15,000 2 6,500 2 7,000
19,000 3 9,000 3 8,500
22,000 4 10,500 4 9,500
24,000 5 11,500 5 10,000
25,000 6 12,000 6 10,000
25,000 7 12,500 7 10,000
A. Construct a table showing Simpson's marginal sales per day in each state.
B. If administrative duties limit Simpson to only selling days per month, how should she spend them?
C. Calculate Simpson's maximum monthly commission income.
5. Climate Control Devices, Inc., estimates that sales of defective thermostats cost the firm an average of $25 each for replacement or repair. An independent engineering consultant has recommended hiring quality control inspectors so that defective thermostats can be identified and corrected before shipping. The following schedule shows the expected relation between the number of quality control inspectors and the thermostat failure rate, defined in terms of the percentage of total shipments that prove to be defective.
Number of Quality Control Inspectors Thermostat Failure Rate (percent)
0 5.0
The firm expects to ship 250,000 thermostats during the coming year, and quality control inspectors each command a salary of $30,000 per year.
A. Construct a table showing the marginal failure reduction (in units) and the dollar value of these reductions for each inspector hired.
B. How many inspectors should the firm hire?
C. How many inspectors would be hired if additional indirect costs (lost customer goodwill and so on) were to average 30% of direct replacement repair costs?

© BrainMass Inc. brainmass.com October 25, 2018, 2:45 am ad1c9bdddf


Solution Preview

For all these problems, you can use a formula to find total revenue, marginal revenue, and average revenue from price and quantity. TR = P * Q, MR is the difference between TR of the previous level and of the current level, and AR = TR/Q. See the attached Excel file for all the charts.

1. See the attached Paint file for the graph. To construct the graph, we see from the chart the dollar value of MR, AR, and TR at each output level. We then plot each point of the curves using the dolar value as the y coordinate and the output level as the X coordinate.

You can see from the graph that total revenue is maximized at output level 5. From these calculations we can see that the average value increases when MR is greater than the average value, but falls when it is less. In essence when marginal revenue is below price, it pulls the average down. This occurs because when price declines, total sales will increase, but there will be some loss in revenue from current customers because of the lower price. The net increase in revenue from added sales is ...

Solution Summary

Quantitative analysis involving marginal, average, and total revenue

See Also This Related BrainMass Solution

Loonie Corporation: Cost accounting allocation methods proposed by Revenue Canada

See the attached file.

Based on the information attached, take on the task of obtaining a cost per unit figure the would hold up to the criteria proposed by Revenue Canada. This project will entail using several allocation methods and inventory techniques, which you will need to configure in multiple perspectives before you may find a satisfactory cost figure. The proper strategy would be to divide the possible permutations among the group members, program an Excel worksheet and sift through the possibilities. Once you have found a satisfactory cost figure, draft an answer letter to Revenue Canada to, hopefully, resolve the matter. In your letter you will provide a step by step chronicling of the allocation methods and all your calculations to show the price is acceptable. If, however, you are not able to provide a cost figure that will justify the current market price, present in your paper the procedures used to calculate your cost data and market price.

You are to prepare appropriate analysis of the data and prepare a written report to support your conclusions, along with supporting schedules. I suggest that the quantitative analysis be performed with Excel, as the number of options available are quite numerous and you will need to find the best combination of methods.

View Full Posting Details