Hi. Can you please help me solve this problem in excel file? Can you provide me screenshot of excel file the calculations and tabs I can add?

An Office-products Wholesaler receives orders until early evening and then picks and ships in the night so that the product is at the customer's site at the start of business the next day. Because response time is critical, this DC set up a fast-pick area.

Most items are relatively small (staplers, toner cartridges, pens, etc.) and are stored in bin-shelving. Use thissmall subset of SKUs.

Download small subset of SKUs.(This data is courtesy ofwarehouse-science.com.)

The data fields are as follows:

• SKU ID: The unique identifier for this SKU
• Length of the storage unit, in inches
• Width of the storage unit, in inches
• Height of the storage unit, in inches
• Pieces per case (that is, the standard number of pieces in each storage unit)
• Pieces sold during the recent reporting period
• Picks (number of times this SKU was requested by a customer) during the recent reporting period
• Maximum number of storage units likely to be held in the warehouse

Questions

Use the fluid model to answer the following questions. All computations can be done on a spreadsheet.

• Rank the SKUs by the strength of their claim to forward storage if slotting to minimize restocks.
• Assume you have decided to store 10 SKUs in a forward pick location and will give each one the same amount of space. Which SKUs should you choose to minimize total labor costs (picking plus restocking)?
• Suppose five sections of static shelving are available, with 5 shelves to a section. Each shelf opening is 12-3/4 inches high x 18 inches deep x 41.25 inches wide. What SKUs would you store here and in what amounts if you want to minimize total labor? Assume picks from the shelving are estimated to average 0.5 minutes each, compared with 2 minutes each if picking from bulk storage. Restocks are estimated to average 2.75 minutes each.

ID	L	W	H	PiecesPerCase	PiecesSold	Picks	MaxOnHandCases
11038	6.4	2	12.3	25	1193	88	16
12990	4.6	3.1	1.2	1	32	16	10
12991	4.6	3.1	1.2	1	48	14	17
12992	5.5	3.3	1.1	1	240	35	83
12993	5.5	3.2	1	1	248	62	81
12994	4.1	2.9	1.7	1	41	6	20
12995	2.7	1.1	16.8	1	61	22	22
15004	10.4	2.2	12.2	10	1216	56	58
15006	10.5	2.2	12.2	10	1742	48	64
15014	10.4	2.2	12.2	10	666	39	30
15016	10.4	2.2	12.1	10	2588	58	86
15024	10.4	2.5	12.2	10	4880	142	156
15026	10.5	2.6	12.2	10	5342	210	179
15034	10.6	2.4	12.2	10	5158	144	190
15036	10.6	2.4	12.2	10	3670	132	151
15038	10.5	3.2	12.2	10	1324	71	52
15044	10.5	2.3	12.2	10	4502	126	139
15046	10.6	2.2	12.2	10	3426	154	147
15048	10.4	3.4	12.2	10	3320	126	99
15054	10.5	2.1	12.2	10	1368	46	50
15056	10.5	2.1	12.2	10	2112	82	82
15663	10.7	2.1	12.2	10	979	52	50
15665	10.5	2.2	12.2	10	1278	48	38
15669	10.5	2.1	12.2	10	556	33	30
16004	10.4	2.5	15.2	10	1094	34	48
16006	10.4	2.2	15.2	10	616	35	27
16014	10.4	2.2	15.2	10	363	24	16
16016	10.4	2.2	15.2	10	334	28	11
16024	10.5	2.5	15.2	10	1318	58	59
16026	10.5	2.5	15.2	10	1966	92	71
16034	10.5	2.1	15.2	10	1868	64	82
16036	10.5	2.1	15.2	10	1988	82	69
16038	10.5	3.3	15.1	10	965	44	36
16044	10.4	2.2	15.2	10	1428	58	43
16046	10.4	2.2	15.2	10	1898	74	100
16048	10.5	3.3	15.2	10	783	34	28
16054	10.5	2	15.2	10	1455	43	60
16056	10.5	2.1	15.2	10	1102	58	42
16665	10.4	2.5	15.2	10	360	33	22
16669	10.3	2.3	15.2	10	162	6	9
17021	9.5	2.3	15.4	25	2766	108	52
17022	9.4	1.9	15.3	25	2780	126	39
17023	9.5	2.2	15.4	25	3184	170	38
17025	9.5	1.9	15.4	25	2418	110	32
17028	9.5	1.9	15.4	25	4062	172	51
17041	9.6	2	15.4	25	634	34	10
17042	9.6	2	15.4	25	960	50	20
17048	9.6	2	15.4	25	1472	94	23
17921	9.3	1.9	15.3	25	1132	58	17
17922	9.8	1.9	15.5	25	305	25	4
17923	9.4	2.2	15.3	25	673	47	9
17928	9.4	2.4	15.3	25	1132	66	13
18099	9.8	2.5	11	4	63	21	5
19021	9.2	2	17.5	25	820	50	11
19022	9.2	2	17.5	25	564	36	9
19023	9.3	1.9	17.6	25	756	58	10
19028	9.2	2	17.7	25	1593	74	25
19041	9.5	2	17.4	25	355	15	7
19048	9.4	2.1	17.6	25	448	34	8
19921	9.3	2.2	17.6	25	528	36	9
19922	9.3	2.2	17.6	25	224	22	5
19923	9.3	2.2	17.6	25	144	20	3
19928	9.3	2.2	17.6	25	567	31	12
25070	12	2.2	12	25	2032	94	28
25071	12	2.2	12	25	2300	130	31
25072	12	2.2	12	25	1980	124	26
25073	12	2.2	12	25	4818	214	62
25074	12	2.2	12	25	1680	66	25
25075	12	2.2	12	25	700	64	13
25076	12	2.2	12	25	1654	100	27
25077	12	2.2	12	25	1034	66	14
25078	12	2.2	12.1	25	4958	202	63
25079	12	2.2	12	25	2814	138	36
25970	11.9	2.2	12.2	25	1398	116	20
25971	11.9	2.2	12.2	25	3732	146	61
25972	11.9	2.2	12.2	25	6192	202	77
25973	11.9	2.2	12.2	25	5438	222	72
25974	11.9	2.2	12.2	25	922	80	13
25975	11.9	2.2	12.2	25	1172	66	19
25976	11.9	2.2	12.2	25	1404	120	19
25977	11.9	2.2	12.2	25	708	68	14
25978	11.9	2.2	12.2	25	3108	144	41
25979	11.9	2.2	12.2	25	3270	168	50
26012	15.3	14.1	0.5	1	98	14	53
30071	14.8	12.5	1.8	25	816	58	14
30078	14.8	12.5	1.8	25	1104	68	16
32038	11.5	9.2	2	25	1606	104	25
33038	9.2	2	12.9	25	1444	82	19
35072	12.6	9.1	0.6	1	134	49	41
35073	11.4	0.9	8.9	1	173	55	72
35079	11.6	8.9	1	1	236	64	86
38048	7.6	2.1	12.5	25	2928	136	40
38600	12.1	10.3	12.1	20	221	58	4
38601	11.7	10.2	12.3	20	269	45	5
38602	11.7	10.2	12.3	20	380	33	6
38603	11.7	10.2	12.3	20	1126	92	24
38604	11.7	10.2	12.3	20	80	19	2
38606	11.7	10.2	12.3	20	236	30	5
38607	11.7	10.3	12.3	20	224	25	5
38609	11.7	10.3	12.3	20	906	42	17