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

In excel vba please  In excel vba please The function procedure check safety Stock determines

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

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!