This company is developing the arrangement of its materials in a warehouse where there are 3...

  

Transcribed Image Text:

This company is developing the arrangement of its materials in a warehouse where there are 3 doors and four outputs (one per product). With the information given, determine the cost of the racks, equipment quarters, average stored material cost, and material handling cost with your proposed layout. Products (Usage in lb/lot) Lbs/pallet Z Material Raw Mat A Raw Mat B Raw Mat C Raw Mat D Raw Mat E Raw Mat F Raw Mat G Raw Mat H Raw Mat I Raw Mat J Mat Pack 1 Mat Pack 2 Mat Pack 3 Mat Pack 4 Mat Pack 5 Mat Pack 6 Mat Pack 7 Mat Pack 8 Mat Pack 9 Supply Supply II Supply III Supply V Supply V 200 300 250 300 400 200 500 450 300 300 300 250 300 200 200 500 200 400 300 100 500 300 500 300 X 5 12 21 4 7 3 9 24 2 7 17326 Y 2 5 7 50 3 8 20 10 2 2 24382 6 2 78 25 10 4 2 18 21 450532 w Cost/lb. $ 25.22 3 $ 30.50 5 $ 18.90 $ 40.20 9 $ 12.00 32 $ 4.80 $ 10.00 $15.70 2 $ 23.00 $ 13.80 13.50 2.57 5.00 8.00 $ 30.00 5 $ 12.00 7$ 8.00 $ 6.00 $ 7.00 2 $ 12.00 8 $ 7.00 $ 5 $ 27 $ 10 $ 4 $ 14.00 4 $ 2 $ 21.00 11.00 Flammable Y Y The annual demand is 5,000 lots for W: 45,000 lots for Y: 55,000 lots for Zand 4,900 lots for X. Materials A have 8 rotations, B materials have 5, and C materials have 3. The Cost of Racking sound: Drive In 4 high Drive In 3 high 2 Deep Conventional 1Deep Conventional 10' Forklift 8 Forklift Ceiling Sprinkler system Rack Sprinkler system Office Space Rest Rooms Utility Room $30per floor saft $27 per floor saft $20per floor saft $12per floor saft $30,000ea $25,000ea Handling Cost Handling Cost $50 per ceiling saft $45per rack level saft $20,000 $10,000 $2,000 15' x 20¹ 10' x 8 5' x 8 $0.50 / linear foot $0.75 / linear foot 250' 180' Product WL 601 10' 84' 100' 200' 4' 4' 8' Product Z 0 0 90' 84% 30* Product Y 160' Product X 40' This company is developing the arrangement of its materials in a warehouse where there are 3 doors and four outputs (one per product). With the information given, determine the cost of the racks, equipment quarters, average stored material cost, and material handling cost with your proposed layout. Products (Usage in lb/lot) Lbs/pallet Z Material Raw Mat A Raw Mat B Raw Mat C Raw Mat D Raw Mat E Raw Mat F Raw Mat G Raw Mat H Raw Mat I Raw Mat J Mat Pack 1 Mat Pack 2 Mat Pack 3 Mat Pack 4 Mat Pack 5 Mat Pack 6 Mat Pack 7 Mat Pack 8 Mat Pack 9 Supply Supply II Supply III Supply V Supply V 200 300 250 300 400 200 500 450 300 300 300 250 300 200 200 500 200 400 300 100 500 300 500 300 X 5 12 21 4 7 3 9 24 2 7 17326 Y 2 5 7 50 3 8 20 10 2 2 24382 6 2 78 25 10 4 2 18 21 450532 w Cost/lb. $ 25.22 3 $ 30.50 5 $ 18.90 $ 40.20 9 $ 12.00 32 $ 4.80 $ 10.00 $15.70 2 $ 23.00 $ 13.80 13.50 2.57 5.00 8.00 $ 30.00 5 $ 12.00 7$ 8.00 $ 6.00 $ 7.00 2 $ 12.00 8 $ 7.00 $ 5 $ 27 $ 10 $ 4 $ 14.00 4 $ 2 $ 21.00 11.00 Flammable Y Y The annual demand is 5,000 lots for W: 45,000 lots for Y: 55,000 lots for Zand 4,900 lots for X. Materials A have 8 rotations, B materials have 5, and C materials have 3. The Cost of Racking sound: Drive In 4 high Drive In 3 high 2 Deep Conventional 1Deep Conventional 10' Forklift 8 Forklift Ceiling Sprinkler system Rack Sprinkler system Office Space Rest Rooms Utility Room $30per floor saft $27 per floor saft $20per floor saft $12per floor saft $30,000ea $25,000ea Handling Cost Handling Cost $50 per ceiling saft $45per rack level saft $20,000 $10,000 $2,000 15' x 20¹ 10' x 8 5' x 8 $0.50 / linear foot $0.75 / linear foot 250' 180' Product WL 601 10' 84' 100' 200' 4' 4' 8' Product Z 0 0 90' 84% 30* Product Y 160' Product X 40'

Answer rating: 100% (QA)

The images you provided contain a table of materials with their respective pallet weights product usage cost per pound and flammability status details ... View the full answer