Using VBA in excel write a function and or sub that computes the following. The objective is determining how long it takes to deliver a pallet to a certain location.

Information: "Each slot (represented by boxes above) is 60" wide by 60" deep Aisles are 10' across There is one person working in this warehouse. They can either drive the forklift or push the cart. When idle, the worker sits at the In location. Pallets Inventory .The warchouse will have some starting inventory, with possibly some empty aisle locations. Each pallet delivered has 100 units of the same item, referenced by a SKU. The warchouse may have more than one location assigned to cach SKU, but only one type of SKU is in cach location. Assume that empty pallets evaporate and do not need to be discarded. "A pallet is 48" wide by 48" deep (not industry standard by convenient) Forklift operation Pallets of incoming inventory l arrive to the Ln location. If there are no empty aisle locations, the incoming inventory will wait at In until there is an empty aisle location. .The worker needs to decide which of the empty aisle locations will be assigned to the incoming pallet. The forklift starts in its storage location (FL), moves to the In location, and navigates to the assigned location. Then, it can either return to FL or pick up another pallet at In. Assume that pallets materialize magically at the In. location, in the order in which they arrive. .The forklift is 70" deep and can navigate 10' aisles Assume the following: The forklift operates at a constant rate of 7.5 mph (loaded or unloaded), and accelerates and decelerates The forklift travels exactly down the center of the aisle and stops centered at its target location Turning a corner, around an aisle or to orient to the In location or an aisle storage location, takes 3 seconds .The time to load a pallet onto or off of the forklift is 2 seconds. Orders and Order Picking Orders are comprised of one or more items of one or more SKUs. SKUs are located in aisle locations. The worker needs to know where each SKU is, and if there is more than one location holding that SKU, all the locations that hold each SKU. The worker also needs to know the inventory level of the SKUs at each location. More than one location may be visited if needed to fulfill the order. If there is not inventory sufficient to satisfy the order, the worker rejects the order. Once the order is selected, the woker needs to determine which locations to visit and in what order to fulfill the order Car t operation The cart starts in its storage location (Cart), and is navigated to cach of the locations in the order determined. The worker drops off the completed order at Out. The cart is then dropped off in the Cart location or begins to pick another order Assume the following: The worker walks at a constant rate of 1.3 miles per hour regardless of cart contents, and accelerates and The worker walks travels exactly down the center of the aisle and stops centered at the target location Turning a corner, around an aisle or to orient to the In location or an aisle storage location, takes no time .The time to pick an item from the aisle location is 1 second Using VBA in excel write a function and or sub that computes the following. The objective is determining how long it takes to deliver a pallet to a certain location. Information: "Each slot (represented by boxes above) is 60" wide by 60" deep Aisles are 10' across There is one person working in this warehouse. They can either drive the forklift or push the cart. When idle, the worker sits at the In location. Pallets Inventory .The warchouse will have some starting inventory, with possibly some empty aisle locations. Each pallet delivered has 100 units of the same item, referenced by a SKU. The warchouse may have more than one location assigned to cach SKU, but only one type of SKU is in cach location. Assume that empty pallets evaporate and do not need to be discarded. "A pallet is 48" wide by 48" deep (not industry standard by convenient) Forklift operation Pallets of incoming inventory l arrive to the Ln location. If there are no empty aisle locations, the incoming inventory will wait at In until there is an empty aisle location. .The worker needs to decide which of the empty aisle locations will be assigned to the incoming pallet. The forklift starts in its storage location (FL), moves to the In location, and navigates to the assigned location. Then, it can either return to FL or pick up another pallet at In. Assume that pallets materialize magically at the In. location, in the order in which they arrive. .The forklift is 70" deep and can navigate 10' aisles Assume the following: The forklift operates at a constant rate of 7.5 mph (loaded or unloaded), and accelerates and decelerates The forklift travels exactly down the center of the aisle and stops centered at its target location Turning a corner, around an aisle or to orient to the In location or an aisle storage location, takes 3 seconds .The time to load a pallet onto or off of the forklift is 2 seconds. Orders and Order Picking Orders are comprised of one or more items of one or more SKUs. SKUs are located in aisle locations. The worker needs to know where each SKU is, and if there is more than one location holding that SKU, all the locations that hold each SKU. The worker also needs to know the inventory level of the SKUs at each location. More than one location may be visited if needed to fulfill the order. If there is not inventory sufficient to satisfy the order, the worker rejects the order. Once the order is selected, the woker needs to determine which locations to visit and in what order to fulfill the order Car t operation The cart starts in its storage location (Cart), and is navigated to cach of the locations in the order determined. The worker drops off the completed order at Out. The cart is then dropped off in the Cart location or begins to pick another order Assume the following: The worker walks at a constant rate of 1.3 miles per hour regardless of cart contents, and accelerates and The worker walks travels exactly down the center of the aisle and stops centered at the target location Turning a corner, around an aisle or to orient to the In location or an aisle storage location, takes no time .The time to pick an item from the aisle location is 1 second Using VBA in excel write a function and or sub that computes the following. The objective is determining how long it takes to deliver a pallet to a certain location