Question: 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,

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, Zip Code 44135) to Research Triangle Park, NC (Zip Code 27709). Use the CzarLite website cited in this chapter to obtain rate data and enter it into Excel. Assume that your carrier has agreed to provide a discount of 46% of these rates, approximately the same as the national average discount for LTL reported by Kay and Warsing. What are the actual and estimated effective rates for a 8500-lb shipmrny 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!

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

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

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

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

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

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

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

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

Which of the following compounds are aromatic? Are any antiaromatic? NH HN: :NH Nl 1

One wheel of a pre-1916 automobile manufactured by the Buick Motor Company was made of defective wood. Buick could have discovered the defect had it made a reasonable inspection after it purchased...

Five descriptions of network terms are given below. In each case, name the network term being described. a) Hardware component (on a circuit board) or chip that allows a device to connect to a...

atch the compensation objectives with their meanings. Efficiency Efficiency drop zone empty. Fairness Fairness drop zone empty. Compliance Compliance drop zone empty. Improving performance and...