Question: Please use excel vba code to answer the following. A warehouse contains 60 different daily products. Each product is assigned a unique SKU. The data

Please use excel vba code to answer the following. A warehouse contains 60 different daily products. Each product is assigned a unique SKU. The data on WH Layout provides information on each SKUs quantity available in each slot of the warehouse in the format [SKU #] ([Quantity]). Each slot can carry up to 50 units of product. Tasks: Write a program that does the following: 1. (10 points) Allow user to look up the locations of a specific SKU #. Return the warehouse locations as #-# (Row-Column). 2. (10 points) Allow user to either receive or ship out x units of a given SKU #. 3. (10 points) The user is required to re-enter SKU # until the SKU # is valid (i.e., the number entered has to match one of the 60 SKU # provided). 4. (20 points) If the quantity entered exceeds the quantity or space available in the warehouse, the order is to be rejected. A message box with the correct reason for the reject should be displayed. No further action is necessary. 5. (30 points) If the requested amount is valid, update and consolidate the quantity available in the warehouse as necessary on both sheets. Make sure the total number of slots required for any quantity should be minimal (e.g., if the total quantity of SKU #13030 is between 51 and 100, there should be at most 2 slots assigned to this SKU. The assigned slots do not have to be next to one another.) 6. (20 points) Highlight SKU # with total quantity below 20 units red, in both sheets Inventory and WH Layout. Skills Being Assessed: Loops, Conditions (Cases and If) and other basic VBA functions.

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!