Question: Please complete all work in excel. Use excel to make the calculations (cells can be clicked on to view any formulas used) and be sure

Please complete all work in excel. Use excel to make the calculations (cells can be clicked on to view any formulas used) and be sure to identify your answer, including units.

1. Travel Co. specializes in trans-American moves for businesses and individuals through the shipment of containers. For every container the company transports via rail, Travel Co. must pay the rail owners $3,000. In addition, containers are weighed and for each pound of weight, the company must pay $0.20. Harry plans to charge $0.60 per pound to his customers.

How many pounds would a container have to hold in order for the company to Break Even?
What would the total revenue be at Break Even?
The company finds out that to maintain the integrity of its containers, each container could only hold an average of 15,000 pounds. What would the company have to charge customers to make $5,000 in profit on each container?

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!

MGMT 3213 Part 1 Forecasting (30 pts) All analysis and calculations and report must be done in a single (ONE) Excel file. Put your name at the top of the worksheet Make Excel do all of the...

HW 1 Part 2- Please complete all work in excel. Use excel to make the calculations (cells can be clicked on to view any formulas used) and be sure to identify your answer, including units. Upload one...

Please complete all work in excel. Use excel to make the calculations (cells can be clicked on to view any formulas used) and be sure to identify your answer, including units. Answers with no...

Please complete all work in excel. Use excel to make the calculations (cells can be clicked on to view any formulas used) and be sure to identify your answer, including units. Upload one excel file...

HW 2 Part 2- Please complete all work in excel. Use excel to make the calculations (cells can be clicked on to view any formulas used) and be sure to identify your answer, including units. Upload one...

Please complete all work in excel. Use excel to make the calculations (cells can be clicked on to view any formulas used) and be sure to identify your answer, including units. A manager needs to buy...

Please complete all work in excel. Use excel to make the calculations (cells can be clicked on to view any formulas used) and be sure to identify your answer, including units. 1. Travel Co....

Please complete all work in excel. Use excel to make the calculations (cells can be clicked on to view any formulas used) and be sure to identify your answer, including units. The manufacturing...

Please complete all work in excel. Use excel to make the calculations (cells can be clicked on to view any formulas used) and be sure to identify your answer, including units. Savor Summer has just...

Please complete all work in excel. Use excel to make the calculations (cells can be clicked on to view any formulas used) and be sure to identify your answer, including units. A firm has 82 units of...

8. Naser's elasticity of demand for Beef is equal 0.6.When the price is $2 per Kg, he buys 10 kg How many units will he buy when the price is $1.00 per Kg ? Select one: O a. 7Kg O b. 9Kg Oc 10Kg C. O...

Construct an algorithm that can be used for inverse interpolation.

All else equal, a lower risk - free rate in a country will lead to a lower cost of equity for an MNC .

Read the articles on journaling and review the template provided. Identify what approach, to journaling, in the articles you found useful and why. Post to the discussion forum that you have reviewed...