3

English 13 Cost of insurance (bil to wethead financial dept.) 62 Item A Shades Sales order Information 1 Mak cartons per container by weight Total quantity 5100 units 2 Max cartons per container by volume * Choose the smaler of the two abowe use IF function Product information 4 Shades per container conwert cartors in item 3 to product units) A shades 5 # of containers needed for total order Muse ROUNDUP function product height 11 in 6 Total product manufacturing cost product diameter 11 in 7 Totaltare cartoncos carton length 12 in tubtotal packaged product cost fill to production dept.) carton width 12 in 9 and transportation cost carton height 12 in 10 Sea transportation cost total carton volume 1728 cub in 11 Subtotal transportation cost bill to logistics dept.) units inside carton 1 12 Cost basis for insurance product weight 91 are weight 1 tb 14 Total costs total weight 10 lb product cost 4.00 5 B Shades are cost 0.60 $ 1 Max cartons per container by weight 2 Max cartons per container by volume Bshades Choose the smaller of the two above fuse If function carton length 12 in 4 Shades per container convert cartons in item 3 to product units) carton width 12 in 5 # of containers needed for total order (use ROUNDUP function cartonight 40 in 6 Total product manufacturing cost total carton volume 5760 bin 7 Totalare (carton.com waits inside carton 6 Subtotal packaged product costill to production dept.) 9 Land transportation cost product cost 4.50 $ 10 Sea transportation cont are cost 2.00 $ 11 Subtotal transportation cost oil to logisties dept) 12 Cost base for wrance Cshades 13. Cost of insurance to overhead accialet.) carton length 12 in 14 Total costs carton width 12 carton height an CShades total carton volume 6912 cutii 1 Max.cartons per container by w units inside carton 10 2 Mak cartons per container by volume total weight 100 3 Choose the smaller of the two above luse if function productos 5.00 $ 4 Shades per container convert cartonsinitom 3 to product unit) are con 2.25 5 5 # of containers needed for total orders ROUNDUP function 6 Total product manufacturing cost Shipping Information con factor 7 Total are carton container weight 1000 lb Subtotal packaged product cat ill to production dept) container length 12 480 in 9 Land transportation.com container width st 12 96 in 10 Sea transportation cost containerheight 85 12 102 in 11 Subtotal transportation cost to logistics dept) container volume 2720 Cub tt 1728 6700160 cub in 12 Costbus for insurance 11 cost of insurance (bill to overhead fancial dest.) rail transport 140.00 S/container 14 Total costs can transp.com B00.00 5lcontainer Insurance rate 2 of cumulative costs at Vancouver Decision The production department may be in favor of this style of shades The logistics department may be in favor of this style of shades Assumption Based on the total cost concept. I recommend this style of shades of the total volume of carton alles in the contain volume, then the cantaminencero che individual dimensions. the cartons are confian their helt A shades. What is the number of containers needed for the total order