What is the total amount that floyd bumpers spends

Assignment Help Finance Basics

Reference no: EM132178373

Question - Floyd's Bumpers pays a transportation company to ship its product to its customers. Floyd's Bumpers ships full truckloads to its customers. Therefore, the cost for shipping is a function of the distance traveled and a fuel surcharge (also on a per mile basis). The cost per mile is $2.69 and the fuel surcharge is $.56 per mile. The file Floyds May contains data for shipments for the month of May (each record is simply the customer zip code for a given truckload shipment), as well as the distance table from the distribution centers to each customer. Use the MATCH and INDEX functions to retrieve the distance traveled for each shipment and calculate the charge for each shipment. What is the total amount that Floyd's Bumpers spends on these May shipments?

Attachment:- Data File.rar

Reference no: EM132178373

Questions Cloud

Derive the circuit that implement the sequence detector : You should follow the design steps of the sequential logic design to derive the circuit that implement the sequence detector

How much do you need to save each month : The expected inflation rate for the next 40 years is 2.5%. How much do you need to save each month, starting today, to meet your goal

Solve for yield to maturity and current yield for each bond : The face value of each bond is $100. Assume interest compounds annually. Solve for yield to maturity and current yield for each bond above

What would your arbitrage profits be : The continuously compounded interest rate is 5% per year. Stocks constituting S are expected to pay $190 of dividends this year. What would arbitrage profit be

What is the total amount that floyd bumpers spends : Floyd's Bumpers pays a transportation company to ship its product to its customers. What is the total amount that Floyd's Bumpers spends

How many are palindrome : Among those, how many are palindrome? (A palindrome is a sequence that reads the same backward as forward)

What is the NPV of opening this new store : This value is the present value of all cash flows in year 16 and beyond. What is the NPV of opening this new store if the appropriate discount rate is 6.0%

Discuss role interest groups play in policy making process : Discuss the role interest groups play in the policy making process, and the methods they use to influence policy makers

Determine the financial health of this company : Determine the three ratios which best help you determine the financial health of this company. Do a trend analysis for the most recent three years

User Account

All Pages