Question

In: Accounting

Costing Models You work for XYZ trucking and your boss has asked you to figure out...

Costing Models

You work for XYZ trucking and your boss has asked you to figure out how much the firm should charge a new customer to make a full Truckload delivery and make a 15% profit. The firm knows that it will find a backhaul customer, so you only need to worry about the cost for the move.

The shipment consist of 400 boxes weighing 100 pounds each, and measuring 4 cubic feet each. The trailers that your company uses can carry 46,000 pounds and have a volume of 3,600 cubic feet.

You calculate that it will take 4 hours to drive from your terminal to the customer’s factory, wait for the truck to be loaded and return to your terminal. The distance between your terminal and your customer’s factory is 35 miles.

Your line haul driver will then take the truck to the consignee and deliver the boxes. The total distance from your terminal to the consignee is 900 miles and will take the driver 30 hours. Once at the consignees it will take 4.5 hours to offload the truck. Then the driver will go to the XYZ trucking terminal in the same city, which is 45 miles away.

What would you recommend to your boss that the price should be set per cwt to complete this move?

(Make sure to show your calculations)

The equipment cost data is as follows:

Equipment Cost Data                                   

Equipment Purchase Price                          

Line-haul tractors     $100,000                   

Trailers           $ 38,000                    53-foot dry van

Depreciation                          

Tractors                                 4 year straight line

Trailers                                  7 year straight line

Interest                                  

Tractors                                  4% APR for 4 years

Trailers                                   4% APR for 7 years

Fuel                             

Per Gallon      $  3.60                        

Line-haul tractors                             6 miles per gallon

Labor Cost                              

Line-haul drivers      $   0.47                       per mile

PUD operation drivers         $ 21.00                       per hour

                         

Miscellaneous                                    

Insurance cost           $  0.056                      per mile

Maintenance cost      $  0.130                      per mile

Billing cost      $   3.00                       per freight bill

Administrative overhead     15%                of total cost

Equipment available for use 365 days, 24 hours per day = 8,760 hours per year.

PLEASE SHOW ALL WORK SO I CAN UNDERSTAND HOW TO DO THIS. THANK YOU SO MUCH FOR THE HELP!

Solutions

Expert Solution


Related Solutions

Imagine that you work in the accounting department of a university and your boss has asked...
Imagine that you work in the accounting department of a university and your boss has asked you to explain components of revenue, expenses, and changes in net asset that are reported on the university’s statement of revenues. Respond to the following in a minimum of 175 words: Discuss at least two unique situations or transactions that you may encounter. Describe any circumstances the entity may engage in activities that result in Unrelated Business Income Tax (UBIT).
Imagine that you work in the accounting department of a university and your boss has asked...
Imagine that you work in the accounting department of a university and your boss has asked you to explain components of revenue, expenses, and changes in net asset that are reported on the university’s statement of revenues. Respond to the following in a minimum of 175 words: Discuss at least two unique situations or transactions that you may encounter. Describe any circumstances the entity may engage in activities that result in Unrelated Business Income Tax (UBIT).
Imagine that you work in the accounting department of a university and your boss has asked...
Imagine that you work in the accounting department of a university and your boss has asked you to explain components of revenue, expenses, and changes in net asset that are reported on the university’s statement of revenues. Respond to the following in a minimum of 175 words: Discuss at least two unique situations or transactions that you may encounter. Describe any circumstances the entity may engage in activities that result in Unrelated Business Income Tax (UBIT).
QUANTITATIVE – You work for Lynn, Inc. Your boss has asked you to complete a forecast...
QUANTITATIVE – You work for Lynn, Inc. Your boss has asked you to complete a forecast for February and March using two forecasting methods and then to evaluate the two methods to identify the “best” method. You decide to try a weighted moving average of the last two months using weights of 60% (previous month) and 40% (2 months prior). You also try exponential smoothing with an alpha constant of .3Y. Complete the table by providing numbers for A, B,...
You work for a brokerage firm. Your boss asked you to analyze Eagle Manufacturing's performance for...
You work for a brokerage firm. Your boss asked you to analyze Eagle Manufacturing's performance for the past five years and to write a report that includes the benchmarking of the company’s performance. (a.) What components would be best for you to include in tour financial statement analysis? Explain your answer. (b.) Identify and explain several weaknesses or limitations of ratio analysis. (c.) Define and explain how the following four ratios are used to examine the different aspects of a...
You are an analyst at Microsoft, and your boss has asked you to complete a ratio...
You are an analyst at Microsoft, and your boss has asked you to complete a ratio analysis for the firm’s competitors. Use the following information to write a complete ratio analysis for Microsoft’s competitors. Firm’s are identified by tickers below. Ratio MSFT IBM SAP AAPL Profit Margin ROE ROA Debt to Equity Current Ratio 28.31% 39.35% 9.44% 92.79% 3.12 10.97% 50.34% 6.64% 270.60% 1.29 16.53% 15.03% 8.36% 40.44% 1.59 22.72% 46.05% 10.89% 97.32% 1.30
Your boss has asked you to analyze a potential new product, and to recommend if the...
Your boss has asked you to analyze a potential new product, and to recommend if the company should produce and sell the product. Specifically, your boss wants you to prepare a spreadsheet that shows the free cash flows the product would generate, and shows what the product’s net present value and internal rate of return are and what your recommendation is. Marketing information Your company already has spent $125,000 to conduct market research about the demand for the product, which...
Your boss has asked you to analyze a potential new product, and to recommend if the...
Your boss has asked you to analyze a potential new product, and to recommend if the company should produce and sell the product. Specifically, your boss wants you to prepare a spreadsheet that shows the free cash flows the product would generate and shows what the product's net present value and internal rate of return are and what your recommendation is. Marketing information Your company already has spent $125,000 to conduct market research about the demand for the product, which...
Your company cafeteria has become a source of employee complaints. Your boss has asked you to...
Your company cafeteria has become a source of employee complaints. Your boss has asked you to conduct a survey of the staff’s feelings of the cafeteria and write a report based on the results, including recommendations for improvements if necessary. Use your imagination to fill in the details.
you have taken a job with a local manufacturing company. Your boss has asked you to...
you have taken a job with a local manufacturing company. Your boss has asked you to analyze a potential new product, and to recommend if the company should produce and sell the product. Specifically, your boss wants you to prepare a spreadsheet that shows the free cash flows the product would generate, and shows what the product’s net present value and internal rate of return are and what your recommendation is (see Table 12.1 in the textbook). Marketing information Your...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT