Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

The company Consort Inc. (a logisics carrier) wants to use MT Freight Forwarding as their freight forwarder. Attached is a picture showing the online summary

The company Consort Inc. (a logisics carrier) wants to use MT Freight Forwarding as their freight forwarder. Attached is a picture showing the online summary of the freight forwarder industry and Consort's carrier rates.

Given that information, Propose a "should be" flat rate for each of the five zones using a cost/CWT for the MT freight fowarding (round to the nearest cent)image text in transcribed

Over $5M - Under Size by Revenue All $50M $50M $5M Cash 12.7% 11.6% 13.4% 13.0% Transportation Purchased 65.1% 64.3% 65.4% 66.1% Accounts Receivable 37.4% 39.1% 38.4% 35.4% Inventory 0.9% 0.9% 0.8% 0.9% Total Current Assets 58.4% 57.9% 60.1% 57.5% Property, Plant & Equipment 19.6% 17.9% 19.7% 20.9% Other Non-Current Assets 22.0% 24.2% 20.1% 21.6% Total Assets 100.0% 100.0% 100.0% 100.0% Accounts Payable 17.1% 16.9% 17.6% 16.9% Total Current Liabilities 35.5% 37.8% 35.2% 34.0% Total Long Term Liabilities 21.4% 17.2% 22.2% 24.2% Net Worth 43.1% 45.0% 42.7% 41.9% Total Assets to Sales 42.4% 44.8% 37.9% 44.0% EBITDA to Sales 6.6% 6.9% 6.3% 6.5% Hoover's Online Summary of the Freight Forwarder Industry Figure 4 "Use these rates to develop a negotiation strategy for us to use with MT Freight Forwarding so we can negotiate a flat rate per CWT for each zone for what we expect to pay." Zone A 56,250 Total Weight Shipped Last Year (000s lbs): 0 to 499.9 500 to 999.9 1,000 to 1,999.9 Weight 2,000 to 4,999.9 (lbs) 5,000 to 9,999.9 10,000 to 19,999.9 20,000 to 29,999.9 30,000 $ 2.40 $ 2.36 $2.32 $ 2.27 $ 2.23 $ 2.20 $ 1.85 $ 1.55 Zone B 100,850 $ 2.15 $ 2.10 $ 2.05 $ 2.00 $ 1.97 $ 1.95 $ 1.65 $ 1.30 Zone 57,800 $ 2.35 $ 2.30 $ 2.25 $ 2.21 $ 2.17 $ 2.10 $ 1.80 $ 1.49 Zone D 42,200 $ 2.50 $ 2.46 $ 2.41 $ 2.37 $ 2.33 $ 2.30 $ 1.95 $ 1.55 Zone E 28,100 $ 2.75 $ 2.70 $ 2.65 $ 2.60 $ 2.55 $ 2.45 $ 2.10 $ 1.63 + ConSort Carrier Rates Figure 5 All rate information is based on cost per CWT. Over $5M - Under Size by Revenue All $50M $50M $5M Cash 12.7% 11.6% 13.4% 13.0% Transportation Purchased 65.1% 64.3% 65.4% 66.1% Accounts Receivable 37.4% 39.1% 38.4% 35.4% Inventory 0.9% 0.9% 0.8% 0.9% Total Current Assets 58.4% 57.9% 60.1% 57.5% Property, Plant & Equipment 19.6% 17.9% 19.7% 20.9% Other Non-Current Assets 22.0% 24.2% 20.1% 21.6% Total Assets 100.0% 100.0% 100.0% 100.0% Accounts Payable 17.1% 16.9% 17.6% 16.9% Total Current Liabilities 35.5% 37.8% 35.2% 34.0% Total Long Term Liabilities 21.4% 17.2% 22.2% 24.2% Net Worth 43.1% 45.0% 42.7% 41.9% Total Assets to Sales 42.4% 44.8% 37.9% 44.0% EBITDA to Sales 6.6% 6.9% 6.3% 6.5% Hoover's Online Summary of the Freight Forwarder Industry Figure 4 "Use these rates to develop a negotiation strategy for us to use with MT Freight Forwarding so we can negotiate a flat rate per CWT for each zone for what we expect to pay." Zone A 56,250 Total Weight Shipped Last Year (000s lbs): 0 to 499.9 500 to 999.9 1,000 to 1,999.9 Weight 2,000 to 4,999.9 (lbs) 5,000 to 9,999.9 10,000 to 19,999.9 20,000 to 29,999.9 30,000 $ 2.40 $ 2.36 $2.32 $ 2.27 $ 2.23 $ 2.20 $ 1.85 $ 1.55 Zone B 100,850 $ 2.15 $ 2.10 $ 2.05 $ 2.00 $ 1.97 $ 1.95 $ 1.65 $ 1.30 Zone 57,800 $ 2.35 $ 2.30 $ 2.25 $ 2.21 $ 2.17 $ 2.10 $ 1.80 $ 1.49 Zone D 42,200 $ 2.50 $ 2.46 $ 2.41 $ 2.37 $ 2.33 $ 2.30 $ 1.95 $ 1.55 Zone E 28,100 $ 2.75 $ 2.70 $ 2.65 $ 2.60 $ 2.55 $ 2.45 $ 2.10 $ 1.63 + ConSort Carrier Rates Figure 5 All rate information is based on cost per CWT

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

The Routledge Companion To Fair Value In Accounting

Authors: Gilad Livne

1st Edition

0367656132, 9780367656133

More Books

Students also viewed these Accounting questions

Question

What should be included in a thank-you note after an interview?

Answered: 1 week ago

Question

a. What is the name of the university?

Answered: 1 week ago