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

Reviews

Write a Review

Finance Basics Questions & Answers

  What is the difference in the way managers will behave

What is the difference in the way managers will behave regarding their capital structure decisions in each of these theories. Explain fully.

  Franchising for the franchisee

Discuss the advantages and the disadvantage of franchising for the franchisee.

  You are the client manager of sensible essentials using the

with the assistance of sensible essentials the operations management team now understands the cost implications

  Cross-section regression of the ccapm

Suppose you find, as research indicates, that in the cross-section regression of the CCAPM, the coefficients of factor loadings on the Fama-French model are significant predictors of average return factors (in addition to consumption beta). How wo..

  Determine which method will result in higher profitability

Required: 1. Using FIFO, calculate (a) ending inventory, (b) cost of goods sold, (c) sales revenue, and (d) gross profit.

  Describe the judgmental approach for simplified preparation

Describe the judgmental approach for simplified preparation of the pro forma balance sheet.

  What will the nav of this fund be at the end of the year

If you had invested $50,000 in this fund at the start of the year, how many shares would you own at the end of the year? What will the NAV of this fund be at the end of the year? Why?

  Objective of financial reporting

1. Which of the following is NOT normally an objective of financial reporting? 2. As independent (or external) auditors, CPAs are primarily responsible for

  How far would prices need to move against the position

If the initial margin for one contract of crude oil was $1,000 and the maintenance level was $800, how far would prices need to move against the position in order to trigger a margin call?

  Describe the main goals of the federal reserve

Describe the main goals of the Federal Reserve. What happens when these goals come into conflict? Explain how the Fed would decide if lower inflation is more.

  Projected marketable securities balance

Jensen and Associates has a projected balance sheet that includes the following accounts. What is the projected marketable securities balance?

  How does size of initial investment affect the indicated irr

How does the size of the initial investment affect the indicated internal rate of return (IRR) and net present value (NPV) of a proposed investment?

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd