Draw the layout and Design the documents required for both RECEIVING and ISSUING for this warehouse

AutoSave Search moaiad M File Home Insert Page Layout Formulas Data Review View Help Share Comments X Cut AutoSum Calibri 11AA == > Wrap Text General HA Normal Bad LI LL Good 28 O LECopy Fill Paste BIU MA $ %). Calculation Insert Delete Format Check Cell Ideas Merge & Center Sensitivity Conditional Format as Neutral Formatting Table Format Painter Clear Sort & Find & Filter Select Clipboard Font Alignment Number Styles Cells Editing Ideas Sensitivity D25 fr A B C D E F G H J K L M N 0 P 0 R S T V w Demand /day Sr.# Product Source Units /Ctn. Ctn. /Pallet Safety stock (Months) Total (Months) Max. Stock Level (Months) 2 3 Max. Stock Max. Stock Max. Stock Level Level Level (Ctn) (Units) (Pallet) Max Stacks (Pallets) Area per Stack 1 2 Units 3 2 4 16 20 1 2 A B Cyan Cyan Cyan 210 100 160 30 24 16 18 25200 12000 840 500 4 52.5 28 1 4 8 10 5 3 60 20 4 1 5 24000 400 20 6 7 6 4 D Cyan 150 40 24 2 2 4 18000 450 18.75 6 7 7 5 E 135 36 24 3 1 4 16200 450 18.75 6 7 Cyan Vendor 8 6 AA 110 40 30 4 2 6 19800 495 16.5 5 6 9 7 BB Vendor 180 50 1 4 21600 432 18 5 6 24 20 3 2 10 8 CC Vendor 160 40 2 4 19200 480 24 8 9 Size of one Pallet = 1.20M X 1.00M Maximum height of loaded pallet allowed = 2 Meters Ceiling height = Maximum 8.5 Meters Minimum clearance to ceiling and Pallet = 0.5 Meters Office space required = 12 S M Packing Space = 15 Sq M Equipment Parking Space = 18 S M Aisle Area = 50% of the Net area (Pallets + Office + Packing + Equipment parking) Cushion for Future expansion = 30% Width of the building must be = 10 Meters 11 Total 196.5 59 72 12 Office 12 13 Packing 15 14 18 Equipment Total 15 width 10 117 16 length 24 Ailse 50% 58.5 17 height 8.5 Net Area 175.5 18 Rounding 180 19 Cushion 30.00% 57 20 GROSS 237 21 Rounding 240 22 23 24 25 26 27 Sheet1 AutoSave Search moaiad M File Home Insert Page Layout Formulas Data Review View Help Share Comments X Cut AutoSum Calibri 11AA == > Wrap Text General HA Normal Bad LI LL Good 28 O LECopy Fill Paste BIU MA $ %). Calculation Insert Delete Format Check Cell Ideas Merge & Center Sensitivity Conditional Format as Neutral Formatting Table Format Painter Clear Sort & Find & Filter Select Clipboard Font Alignment Number Styles Cells Editing Ideas Sensitivity D25 fr A B C D E F G H J K L M N 0 P 0 R S T V w Demand /day Sr.# Product Source Units /Ctn. Ctn. /Pallet Safety stock (Months) Total (Months) Max. Stock Level (Months) 2 3 Max. Stock Max. Stock Max. Stock Level Level Level (Ctn) (Units) (Pallet) Max Stacks (Pallets) Area per Stack 1 2 Units 3 2 4 16 20 1 2 A B Cyan Cyan Cyan 210 100 160 30 24 16 18 25200 12000 840 500 4 52.5 28 1 4 8 10 5 3 60 20 4 1 5 24000 400 20 6 7 6 4 D Cyan 150 40 24 2 2 4 18000 450 18.75 6 7 7 5 E 135 36 24 3 1 4 16200 450 18.75 6 7 Cyan Vendor 8 6 AA 110 40 30 4 2 6 19800 495 16.5 5 6 9 7 BB Vendor 180 50 1 4 21600 432 18 5 6 24 20 3 2 10 8 CC Vendor 160 40 2 4 19200 480 24 8 9 Size of one Pallet = 1.20M X 1.00M Maximum height of loaded pallet allowed = 2 Meters Ceiling height = Maximum 8.5 Meters Minimum clearance to ceiling and Pallet = 0.5 Meters Office space required = 12 S M Packing Space = 15 Sq M Equipment Parking Space = 18 S M Aisle Area = 50% of the Net area (Pallets + Office + Packing + Equipment parking) Cushion for Future expansion = 30% Width of the building must be = 10 Meters 11 Total 196.5 59 72 12 Office 12 13 Packing 15 14 18 Equipment Total 15 width 10 117 16 length 24 Ailse 50% 58.5 17 height 8.5 Net Area 175.5 18 Rounding 180 19 Cushion 30.00% 57 20 GROSS 237 21 Rounding 240 22 23 24 25 26 27 Sheet1