Do this in excel please

10.34 Consider a warehouse illustrated by the figure below. Thirty-two bays (25' X 25') are available for storage. Four different types of products (A, B, C, and D) are to be stored. Each type of product cannot share a bay with any other type of product. Products are received from dock 1 and are shipped out in equal proportion from docks 2 and 3. The area requirement and weekly load rate for each of these four products are shown in the table below. Product Area (ft?) Weekly Load Rate A 4,375 500 B 7,500 600 1,500 700 D 6,250 400 a. Formulate the problem using the model discussed in Section 10.3. b. Determine the layout that will minimize the average distance traveled per week. Dock 2 Dock 1 Dock 3 - 25 ft