Use excel formulas for answers only Do not use hand written answers Travel Solutions specializes in trans Atlantic shipments for businesses through the delivery of containers between the US and Europe For every container the company loads on its boats, Travel Solutions estimates the haul costs $2,000 In addition, containers are weighed and for each pound, there are hauling fees of $0 16 ProHaul plans to charge $0 28 per pound to his customers How many pounds would a container have to hold in order for the company to Break Even (10 pts) What would the total revenue be for this (5 pts) The company finds out that to maintain the integrity of its containers, each container could only hold an average of 60,000 pounds What would the company have to charge customers to make $10,000 in profit on each container (10 pts) Use excel formulas for answers only Do not use hand written answers

The Answer is in the image, click to view ...

Question: Use excel formulas for answers only. Do not use hand written answers. Travel Solutions specializes in trans-Atlantic shipments for businesses through the delivery of containers

Use excel formulas for answers only. Do not use hand written answers.

Travel Solutions specializes in trans-Atlantic shipments for businesses through the delivery of containers between the US and Europe. For every container the company loads on its boats, Travel Solutions estimates the haul costs $2,000. In addition, containers are weighed and for each pound, there are hauling fees of $0.16. ProHaul plans to charge $0.28 per pound to his customers.

How many pounds would a container have to hold in order for the company to Break Even? (10 pts)

What would the total revenue be for this? (5 pts)

The company finds out that to maintain the integrity of its containers, each container could only hold an average of 60,000 pounds. What would the company have to charge customers to make $10,000 in profit on each container? (10 pts)

Use excel formulas for answers only. Do not use hand written answers.

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!

FULL EXCEL FORMULAS NEEDED TO COMPARE. Travel Solutions specializes in trans-Atlantic shipments for businesses through the delivery of containers between the US and Europe. For every container the...

I have to do an accounting assignment. I have attached the instructions, the questions, and pdf's containing the information requested for the questions. Company Estimates & Opinions Sanmina Corp...

Please write the selecting tools and approaches (according to the subject R esearch Method ) for this topic SECOND LANGUAGE ACQUISITION: LEVEL OF INTEREST IN LEARNING MANDARIN CHINESE LANGUAGE AS A...

Montonya Company has the following selected data for the current year: Sales (10,000 units) $90,000 Direct materials 30,000 Direct labor costs 10,000 Variable manufacturing overhead 3,500 Fixed...

An organization'spurpose and respective strategy are influenced by its stakeholders. Use the relevant dimensions of Figure 5.2 to identify the main stakeholders for Volkwagen'selectric vehicle...

For the exclusive use of M. Omar, 2022. HKUST Thompson Center for HBP Product ID: ST96 BUSINESS SCHOOL Business Case Studies WORLD CLASS IN ASIA UST096 RONALD LAU ALBERT HA GIANNE WONG KTZ Express:...

Excused Performance When Circumstances Change I. Introduction Circumstances change. Contracts made in good times may have to be performed in bad times. The cost of the seller's raw materials may...

22 R e a d i n g t h e T e a L e a v e s a t T e a a n d M o r e : Re s o l v i n g C o m p l e x Su p p l y Ch a i n Issues 1 Abstract Tea and More is facing growing pains from its rapid expansion...

The shoe sizes and heights (in inches) of 14 men (a) x = size 11.5 (b) x = size 8.0 (c) x = size 15.5 (d) x = size 10.0 Find the equation of the regression line for the data. Then construct a scatter...

Suppose SuperWidget is the latest and greatest product that you are thinking of manufacturing. You think the SuperWidget is worth making, but your not sure just how sales will go. Your biggest...

The present value of $ 1 0 0 to be paid in two years is less than the present value of $ 1 0 0 to be paid in three years.

The new 2018 tax laws changed how taxes are affected by depreciation by O no longer allowing depreciation to be deducted as an expense to calculate taxes. by considering depreciation as income which...