Question 6 1 pts A shades. What is the cost basis for insurance (amount to which the insurance rate will be applied to calculate the premium)? Question 7 1 pts B shades. What is the smaller of the maximum number of cartons per container by weight and by volume? 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 Eng S. Item A Shades Sales order information 1 Mas cartons per container by weight Total quantity 100 units 2 Max. cartons per container by volume Choose the smaller of the two above (use IF function Product information 4 Shades per container (convert cartes intitom 3 to product units) Ashades 5 st of contains neded for total ordet ( ROUNDUP function product beight Il in 6 Total product manufacturing cost product diameter 11 in 7 Tutal tare carton cost carton length 12 in * Subtotal packaged product coat (bill to production dept) carton width 9 Land Transportation.com carton height 12 in 10 Sea transportation cost care volume 172 cubin 11 Subtotal transportation cost bill to logistics dept) is de carton 1 12 Cost basis for insurance product weight 9 lb 13 Cost of insurance (bill to overhead (financial dept.) tare weight 1 lb 14 Total costs wotal weight 10 lb productos 400 S B Shades tare cost 0603 I Max. cartons per container by weight 2 Max. cartons per container by volume shades Choose the smaller of the two above se IF function carton length 12 in 4 Shades per container convert cartons in itom 3 to productie carton width 12 in 5 of containers needed for total order fue ROUNDUP function carton height 40 in 6 Total product manufacturing cost Rotal care volume $760 cub in 7 Total are cartons) cost tits indecarton 6 * Subtital packaged product cost (bill be production dept) total weight 10 Land transl product cost 4.50 5 10 Sea transportation cost tane cost 2005 11 Subtotal transportation cost od to logistics dept) 12 Costasis for insurance Cshades D. Cost of insurance (bill to overhead (financial dept.) Carton length 12 in 14 Total costs curton width 12 in carton brigla 4 in Shades tal carton volume 12 bin 1 Mar. cartons per container by weight units in de carton 10 2 Max. Cartons per container by volume total weight 101 b 3. Choose the smaller of the two above use IF function product cost 3.10 4 Shades per container wert carte intento product units are cost 225 5 5 or containers needed for total under une ROUNDUP Fonction] Total product manufacturing com Shipping Information Contacta 7 Total are canto cost Container weight limit 4000 D Subtotal packaged product cou(till to production top) container leth 401 12 9 Landrats container width * 12 6 in 10 Sentransportation cost containerheight 23 100 11 Subtotal transportation cost bil to logistics dept.) contact yolume 2720 cb 1728 4700100 bin 12 Cost basis for insurance 13 Cost of insurance (bill to overhead financial dept) mail transport 1400.00 Scontainer 14 Tacoste ocean post N00.00 Scene Insurance male 25 of cumulative casts at Vancouvet Decision The production department may be in awe of this style of shades The logistic department may be inform of this style of shade Assumption Harden the total cost recept. I recommend this style of shades If the total volume of cartons equal or less than the continet volume. then all the cartons toe need to check individual dimension, if all the cars are going to fit given their height) Eng Item A Shades Sales order information 1 Max. cartons per container by weight Total quantity $100 units 2 Max, cartons per container by volume 3. Choose the smaller of the two above (use IF function Product Information 4 Shades per container (cotit cartes in tem 3 to product units) A shades 5 of containers needed for total order [use ROUNDUP function] product height 11 in 6 Total product manufacturing cost product diameter 11 in 7 Total tare (cartons) cost carton length 12 in Subtotal packaged product cost bill to production dept Curion with 12 in 9 Land transportation cost carton height in 10 Sea transportation cost talan volume 172N cub in Il Subtotal transportation cost bill to logisties dept) units inside carton 1 12 Cost basis for insurance product weight ob 13 Cost of insurance (bill to overhead (financial depe>> tare weight 1 lb 14 Total costs sal weight 10 lb product cost 400 5 B Shades tare cost 0.00 $ 1 Max. cartons per container by weight 2 Max. cartons per container by volume shades 3. Choose the smaller of the two above se IF function carton length 12 in 4 Shades per container (mycit cartonsinitum 3 to product units) carton width 12 5 # of containers needed for total order fuse ROUNDUP function] carton height 40 in 6 Total product manufacturing cost Totalcar volume 5760 cubin 7 Totalare (cartons) coil it inside carton 6 * Subtital packaged product cost (bili to production dept) otal weight 62 lb Land transportation product cost 450 S 10 Sea transportation cost are con 200 $ 11 Subtotal transportation cost bill to logistics dept) 12 Cost basis for insurance Cshades 1. Cost of insurance (bill to overhead financial depe] carton length 12 in 14 Total costs carton with 12 in carton height 48 in C Shades tal carton olums 6912 cub in I Max. cartons per container by weight whats de con 10 2 Max. Cartons per container by volume total weight 101 tb 3 Choose the smaller of the two above (use IF function product cost 5.00 4 Shades per container convert carties in item 3 to product units) tare cost 2.25 5 5 of containers needed for total order luxe ROUNDUP function 6 Total product manufacturing Shipping Information con factor 7 Total are carton cost container weight limit 44000 lb Subtotal packaged product combill to productie depl.) container length 40 12 40 in 9 Landtecost container width 12 w in 10 Scarasportation cost container height 8.3 12 103 11 Subtotal transportation cost hill to logistics dept.) container volume 2720 en 1728 47001 ubin 12 Cost basis for insurance 13 Cost of urance (bill to overhead (financial dept) mailtracom 1-400.00 Scontainer 14 Total costs ocean rap cost NO.00 Scontainer Insurance 2 of cumulative costs ar 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 recept. I recommend this style of shades If the total volume of cartons is equal or less than the container volume, then all the cartofit (no need to check individual dimensions, gif all the cartons are going to fit given their belight)
