ib_e09_chapter9skillsexam

ib_e09_chapter9skillsexam - Transportation Capacity Data...

Info iconThis preview shows pages 1–4. Sign up to view the full content.

View Full Document Right Arrow Icon
Transportation Capacity Data Trailer Number Trailer Length Carton Capacity Trips per Year Total Cartons 64NE6 240 24 735 8 5,880 5W6 240 24 735 8 5,880 45S4 240 24 735 8 5,880 64NE3 240 24 735 8 5,880 30E1 240 48 1,471 8 11,768 45S3 240 48 1,471 8 11,768 64NE2 420 48 1,471 8 11,768 5W1 420 48 1,471 8 11,768 5W2 420 44 1,348 8 10,784 30E2 420 44 1,348 8 10,784 30E3 420 44 1,348 8 10,784 45S2 420 44 1,348 8 10,784 5W4 480 42 1,287 8 10,296 30E4 480 42 1,287 8 10,296 5W3 480 42 1,287 8 10,296 5W5 480 53 1,624 8 12,992 30E5 480 53 1,624 8 12,992 45S5 480 53 1,624 8 12,992 64NE1 530 22 674 8 5,392 64NE4 530 22 674 8 5,392 64NE5 530 48 1,471 8 11,768 64NE7 530 53 1,624 8 12,992 45S1 530 53 1,624 8 12,992 45S6 530 53 1,624 8 12,992 Total 192 245,120
Background image of page 1

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
Capacity Analysis Average Capacity 2636 cubic feet Number of Trucks 10 Total Trips per Year 500 Total Capacity 7 8 9 10 11 12 13 100 200 300 400 500 600 700 800 900 1000 1100 1200 Data Table Conditional Formatting
Background image of page 2
Transportation Profit Analysis Cost per Mile $0.40 Cost per Truck $40,000 Charge per Mile $2.00 Total Annual Miles Driven 20,000 Total Sales $40,000 Total Profit ($8,000) Profit Rate -20.00%
Background image of page 3

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
Store Sales Data Store Number Sales 5005 $2,204,381 841,962 60,682 3 5005 $2,319,180 811,252 70,777 2 7005 $2,347,810 259,492 17,809 2 7005 $2,393,300 264,321 19,090 1 7005 $2,514,008 273,172 20,463 0 5737 $2,515,471 273,172 89,458 2 5005 $2,515,824 273,172 82,552 1 5737 $2,516,343 273,172 97,217 1 5737 $2,571,192 273,172 82,318 3 7735 $2,610,508 764,142 90,677 1 7735 $2,618,941 736,672 92,491 1 7735 $2,636,266 721,473 94,341 1 6005 $2,708,907 70,674 3,630 1 6005 $2,711,617 72,975 3,703 1 7846 $2,819,330 403,480 36,102 0 7846 $2,843,761 392,622 36,824 0 7846 $2,870,301 386,887 37,560 0 6005 $3,008,850 76,807 3,862 0 6734 $3,047,397 113,288 15,783 2 6734 $3,191,504 119,575 16,820 1 6310 $3,395,062 369,802 78,791 2 4005 $3,411,843 607,208 60,460 3 6734 $3,420,255 109,695 16,598 1 6733 $3,443,129 481,874 57,927 1 7736 $3,589,841 818,440 59,511 1 7736 $3,594,181 831,103 60,701 1 7736 $3,617,267 803,804 67,222 0 5522 $3,638,809 238,759 18,243 2 6733 $3,658,783 482,508 62,836 1 5522 $3,673,621 238,765
Background image of page 4
This is the end of the preview. Sign up to access the rest of the document.

Page1 / 4

ib_e09_chapter9skillsexam - Transportation Capacity Data...

This preview shows document pages 1 - 4. Sign up to view the full document.

View Full Document Right Arrow Icon
Ask a homework question - tutors are online