4-5

Question 4 1 pts A shades. What is the subtotal for the packaged product cost for the whole order? Question 5 1 pts A shades. What is the subtotal for the transportation cost for the whole order? 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) Question 4 1 pts A shades. What is the subtotal for the packaged product cost for the whole order? Question 5 1 pts A shades. What is the subtotal for the transportation cost for the whole order? 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)