# Question: Floyd s Bumpers pays a transportation company to ship its product

Floyd's Bumpers pays a transportation company to ship its product in 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.42, and the fuel surcharge is $0.56 per mile. The file FloydsMay 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?

**View Solution:**## Answer to relevant Questions

Use the spreadsheet model constructed to answer Problem 1 to answer this problem. a. Construct a one-way data table with production volume as the column input and profit as the output. Breakeven occurs when profit goes from ...Through a series of Web-based experiments, Eastman has created a predictive model that estimates demand as a function of price. The predictive model is demand = 4000 - 6p where p is the price of the e-book. a. Update your ...The Sea Wharf Restaurant would like to determine the best way to allocate a monthly advertising budget of $1000 between newspaper advertising and radio advertising. Management decided that at least 25 percent of the budget ...The following questions refer to a capital budgeting problem with six projects represented by binary variables x1, x2, x3, x4, x5, and x6. a. Write a constraint modeling a situation in which two of the projects 1, 3, 5, and ...Let us consider again the data from the LaRosa tool bin location problem discussed in Section 10.3. a. Suppose we know the average number of daily trips made to the tool bin from each production station. It seems as though ...Post your question