Question: 4.7 Using the Excel linear regression functions, develop a power curve expression (y = C) to estimate the effective rate, in $/cwt, for a Class

4.7 Using the Excel linear regression functions, develop a power curve expression (y = C) to estimate the effective rate, in $/cwt, for a Class 85 shipment from Cleveland, OH (Hopkins International Airport area, ZIP code 44135) to Research Triangle Park, NC (ZIP code 27709). Use the CzarLite web site cited in this chapter (http://smc3apps.smc3.com/ Applications/WebCzarLite/Entry.asp) to obtain the rate data and enter it into Excel. Assume that your carrier has agreed to provide a discount of 46% from these rates (including the minimum charge), approximately the same as the estimated national average discount for LTL reported TABLE 4.10 Rate Tariff for Exercise 4.6 Weight Group Minimum Weight (lb) Freight Rate (S/cwt) 1 (L5C) 30.60 2 (M5C) 500 28.15 3 (MIM) 1,000 22.03 4 (M2M) 2,000 18.05 5 (M5M) 5,000 14.21 6 (M10M) 10,000 11.85 7 (M20M) 20,000 6.90 8 (M30M) 30,000 5.31 9 (M40M) 40,000 4.87 Minimum charge = $83.24. by Kay and Warsing (2009). What are the actual and estimated effective rates for a 8500-lb shipment on the Cleveland-RTP lane? 4.7 Using the Excel linear regression functions, develop a power curve expression (y = C) to estimate the effective rate, in $/cwt, for a Class 85 shipment from Cleveland, OH (Hopkins International Airport area, ZIP code 44135) to Research Triangle Park, NC (ZIP code 27709). Use the CzarLite web site cited in this chapter (http://smc3apps.smc3.com/ Applications/WebCzarLite/Entry.asp) to obtain the rate data and enter it into Excel. Assume that your carrier has agreed to provide a discount of 46% from these rates (including the minimum charge), approximately the same as the estimated national average discount for LTL reported TABLE 4.10 Rate Tariff for Exercise 4.6 Weight Group Minimum Weight (lb) Freight Rate (S/cwt) 1 (L5C) 30.60 2 (M5C) 500 28.15 3 (MIM) 1,000 22.03 4 (M2M) 2,000 18.05 5 (M5M) 5,000 14.21 6 (M10M) 10,000 11.85 7 (M20M) 20,000 6.90 8 (M30M) 30,000 5.31 9 (M40M) 40,000 4.87 Minimum charge = $83.24. by Kay and Warsing (2009). What are the actual and estimated effective rates for a 8500-lb shipment on the Cleveland-RTP lane

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!

Use excel please and thank you! 4.7 Using the Excel linear regression functions, develop a power curve expression (y=Cxb) to estimate the effective rate, in $/cwt, for a Class 85 shipment from...

4.6 Given the LTL rate tariff in Table 4.10, compute the effective rate of a 3000-lb shipment and a 4200-lb shipment. Do the effective rates differ? Why or why not? 4.7 Using the Excel linear...

I require the answers in excel please 4.6 Given the LTL rate tariff in Table 4.10 , compute the effective rate of a 3000-lb shipment and a 4200-lb shipment. Do the effective rates differ? Why or why...

1. Using the Excel linear regression functions, develop a power curve expression (y = Cxb) to estimate the effective rate, in $/cwt, for a Class 85 shipment from Cleveland, OH (Hopkins International...

According to the Kay and Warsing (2009) paper cited in this chapter, the average density of a Class 85 shipment is 12.72lb/ft 3 . Using this value and the r LTL (s,q,d) expression of Kay and Warsing...

Question 5 20 pts General Electric has just received an order for 2500 double oven single-fan electric range from a company located in Detroit, Michigan (zip code: 48127) GE would like to ship this...

Using the Excel linear regression functions, develop a power curve expression (y = Cxb) to estimate the effective rate, in $/cwt, for a Class 85 shipment from Cleveland, OH (Hopkins International...

Using the Excel Linear Regression functions, develop a power curve expression to estimate the effective rate in $/cwt, for a Class 85 shipment from Cleveland, OH (Hopkins International Airport Area,...

need answers for these questions, solve it in Excel Given the LTL rate tariff in Table 4.10, compute the effective rate of 3000-lb shipment and a 4200-lb shipment. Do the effective rates diffe Why or...

113``` IST 461 - Business Analysis Assignment 3 Due by midnight on Sunday of the week it has been assigned. Consider the following scenario: "Take Me Away", a nation-wide Vacation Rental Company, is...

Refer to the data on the weight of wolves in Table D.9 of the Data Bank. A computer analysis produces the output (a) What is the conclusion to testing the equality of mean weights at level...

A diffraction pattern of a cubic crystal of lattice parameter a = 3.16 is obtained with a monochromatic x-ray beam of wavelength 1.54 . The first four lines on this pattern were observed to have the...

Prepare the stockholders' equity section of the balance sheet for Marin Corporation at December 3 1 , 2 0 2 0 . MARIN CORPORATION Balance Sheet ( Partial ) December 3 1 , 2 0 2 0 $ Journalize the...

As the manager of Smith Construction, you need to make a decision on the number of homes to build in a new residential area where you are the only builder. Unfortunately, you must build the homes...