Marginal Analysis of Pricing of Parcels and Packages

Notes for Writer: This same scenario is for both charts down below, just different services. In these 2 charts the data is already provided, I placed the letter A next to the numbers that were inputed in the chart. All I need is a marginal analysis between both charts including the one that you did earlier in my 1st order. Explain the analysis that you came up with to get to this conclusion for the parcel & package services. When done with these scenarios can you compare all 2 including the 1st data you concluded for me and determine whether the delivery services should charge one price or not.
Notes For Writer: You can use Excel if that’s how you get your answers but can you demonstrate it without the Excel language because I do not know how to use Excel. For example, just say what method you used to get the answer whether its dividing, subtracting adding etc. Thank you.
The Chart is down below.
Seven Years ago, you started a crosstown delivery service. The service is an environmentally friendly business and given all the traffic congestion, you are also the fastest service in the city since your entire crew are bicyclists. You have two types of service which is – a small parcel service for anything that is flat and measures less than 11 x 17. You have a package service using a 100lb. capacity bike trailer for anything weighing up to 10lbs. As a way to introduce the new package service, you charged the same price for the packages as parcels. You are now wondering if you should charge different prices for the parcel and package service.
# 5. Complete the table below for the parcels market:
Price Parcels TR MR TC MC MR – MC Profit
100 0 0 1,150 10 -1150 A.
90 50 A. 4,500 90 1,650 10 80 2,850
80 A. 100 8,000 70 2,150 10 60 5,850
70 150 10,500 50 2,650 10 40 7,850
60 200 12,000 30 3,150 10 20 8,850A.
50 250 12,500 10 3,650 10 0 8850
40A. 300 12,000 -10 4,150 10 -20 7850
30 350 10,500 -30 4,650 10 -40 5850A.
20 400A. 8,000 -50 5,150 10 -60 2850
10A. 450 4,500 -70 5,650 10 -80 -1,150
#6. Complete the table below for the packages market:
Price Packages TR MR TC MC MR – MC Profit
100 50 5,000 450 4,550
90A. 70 6,300 65 650 10 55 5,650
80 90A. 7,200 45 850 10 35 6,350
70 110 7,700 25 1,050 10 15 6650A.
60A. 130 7,800 5 1,250 10 -5 6,550
50 150A. 7,500 -15 1,450 10 -25 6,050
40 170 6,800 -35 1,650 10 -45 5,150A.
30A. 190 5,700 -55 1,850 10 -65 3,850
20 210A. 4,200 -75 -2,050 10 -85 2,150A.
10 230 2,300 -95 2,250 10 -105 50