Question: In excel vba please The function procedure check safety Stock determines if a distributor of discrete parts (e.g., screws, bolts, nuts, etc.) must place an
The function procedure check safety Stock determines if a distributor of discrete parts (e.g., screws, bolts, nuts, etc.) must place an order to her supplier. The function procedure check safety Stock must receive three arguments: the current inventory level (in parts), the customer order size (in parts), and the safety stock level (in parts). The function procedure check safety Stock returns a result of type String. a) Write separate variable declaration statements for the variables that will store the current inventory level (in parts), the customer order size (in parts), and the safety stock level (in parts). b) Write a variable declaration statement for the variable that will store the value returned by the function procedure check safety Stock. c) Use the variable you declared in parts (a) and (b) to write the function invocation statement. d) Write the code for the function procedure check safety Stock. The function procedure must return different values according to the logic described in Table 1
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
