The function procedure check safety Stock determines if a distributor of discret

Question

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.

Explanation / Answer

// ****DO NOT copy from here

// This is my comment section:

// Please use below code in vba script and run to get the desired output

// Steps to run the below code

// Open new exce file , go to File options, Customize Ribbons and Tick Developer option in right side

// You will get developer option enabled on menu bar

// select developr, choose Visual basic and this will open up editor window

// copy paste your code here and run to execute

// *** DO NOT copy till here

Sub Main()
Dim Amount As String
Amount = checksafetyStock(10, 20, 30)
Debug.Print Amount
' MsgBox Amount
End Sub

Function checksafetyStock(curr_inventory_level, cust_order_size, saf_stock_lock) As String
Dim cil As Integer
Dim ril As Integer
Dim til As Integer
cil = curr_inventory_level
ril = cust_order_size
til = saf_stock_lock
Debug.Print cil
Debug.Print ril
Debug.Print til
' Returns String name
checksafetyStock = "Jonathon"
End Function

Related Questions

Navigate

• Browse (All)
• Browse T
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.