Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

logistics and transportation The CDE company has been in business for over 40 years. Sales has been consistent for the last 10 years at $2.0m

logistics and transportation image text in transcribed
The CDE company has been in business for over 40 years. Sales has been consistent for the last 10 years at $2.0m annually. In addition, the Gross margin has been consistent at 60%. Costs were all consistent- Warehouse costs $250,000. Transportation $350,000, ICC, $150,000 and Other Costs $200,000, Taxes and Interest at $100,000. The Assets were: Current- $220,000, Fixed Assets $780,000 and Liabilities were Current $220,000, Long Term $440,000. Last year the company made a number of changes in the distribution of the product to their customers. This included adding a warehouse and eliminating some 3rd party warehousing. Here is the email you received from the accountant: Greetings, I'm very busy with tax season but here is some information you will need: Sales this last year were $2,250,000 and COGS were $807,500. The sale of our Cincinnati warehouse increased LT assets by $100,000 to $540,000 and new warehouse costs are $358,000. The reduction mileage and delivery times to the customers decreased our transportation costs to $100,000 per annum. Inventory carrying costs grew to $170,000. Other costs to the organization grew to $440,000. Taxes and Interest were same at $100,000. I haven't had a chance to check the profit levels. Current Assets grew to $252,000 but so did Current Liabilities to $245,000. The purchase of the asset resulted in Long Term Liabilities increasing to $530,000. Anyways very busy got to go. Saheed You have been tasked by the owner to do an analysis of this change and determine whether or not it was successful. What ratios and margins should be considered? The CDE company has been in business for over 40 years. Sales has been consistent for the last 10 years at $2.0m annually. In addition, the Gross margin has been consistent at 60%. Costs were all consistent- Warehouse costs $250,000. Transportation $350,000, ICC, $150,000 and Other Costs $200,000, Taxes and Interest at $100,000. The Assets were: Current- $220,000, Fixed Assets $780,000 and Liabilities were Current $220,000, Long Term $440,000. Last year the company made a number of changes in the distribution of the product to their customers. This included adding a warehouse and eliminating some 3rd party warehousing. Here is the email you received from the accountant: Greetings, I'm very busy with tax season but here is some information you will need: Sales this last year were $2,250,000 and COGS were $807,500. The sale of our Cincinnati warehouse increased LT assets by $100,000 to $540,000 and new warehouse costs are $358,000. The reduction mileage and delivery times to the customers decreased our transportation costs to $100,000 per annum. Inventory carrying costs grew to $170,000. Other costs to the organization grew to $440,000. Taxes and Interest were same at $100,000. I haven't had a chance to check the profit levels. Current Assets grew to $252,000 but so did Current Liabilities to $245,000. The purchase of the asset resulted in Long Term Liabilities increasing to $530,000. Anyways very busy got to go. Saheed You have been tasked by the owner to do an analysis of this change and determine whether or not it was successful. What ratios and margins should be considered

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

Empirical Techniques In Finance

Authors: Ramaprasad Bhar, Shigeyuki Hamori

1st Edition

3642064175, 978-3642064173

More Books

Students also viewed these Finance questions

Question

What is order of reaction? Explain with example?

Answered: 1 week ago

Question

Derive expressions for the rates of forward and reverse reactions?

Answered: 1 week ago