ajudajoao
01-21-2021, 09:50 AM
Create an availability function that accepts the following arguments
○ Material code (cell A) - the material code to be analyzed
○ Location - a Warehouse Location String (cells H, I). It can be “Porto” or
"Lisbon"
○ Quantity - an integer with the quantity to order.
The function should return one of three possible results:
● “Available for immediate delivery” if the warehouse is located
have the quantity in stock.
● “Available for delivery” if the quantity ordered is available on the
total stock of the two warehouses (i.e. quantity ordered <Stock Port0 + Stock
Lisboa)
● “Unavailable” if the quantity ordered is greater than the sum of the stock in
warehouses
Create an availability function that accepts the following arguments○ Material code (cell A) - the material code to be analyzed○ Location - a Warehouse Location String (cells H, I). It can be “Porto” or"Lisbon"○ Quantity - an integer with the quantity to order.The function should return one of three possible results:● “Available for immediate delivery” if the warehouse is locatedhave the quantity in stock.● “Available for delivery” if the quantity ordered is available on thetotal stock of the two warehouses (i.e. quantity ordered <Stock Port + StockLisbon)● “Unavailable” if the quantity ordered is greater than the sum of the stock inwarehouses
○ Material code (cell A) - the material code to be analyzed
○ Location - a Warehouse Location String (cells H, I). It can be “Porto” or
"Lisbon"
○ Quantity - an integer with the quantity to order.
The function should return one of three possible results:
● “Available for immediate delivery” if the warehouse is located
have the quantity in stock.
● “Available for delivery” if the quantity ordered is available on the
total stock of the two warehouses (i.e. quantity ordered <Stock Port0 + Stock
Lisboa)
● “Unavailable” if the quantity ordered is greater than the sum of the stock in
warehouses
Create an availability function that accepts the following arguments○ Material code (cell A) - the material code to be analyzed○ Location - a Warehouse Location String (cells H, I). It can be “Porto” or"Lisbon"○ Quantity - an integer with the quantity to order.The function should return one of three possible results:● “Available for immediate delivery” if the warehouse is locatedhave the quantity in stock.● “Available for delivery” if the quantity ordered is available on thetotal stock of the two warehouses (i.e. quantity ordered <Stock Port + StockLisbon)● “Unavailable” if the quantity ordered is greater than the sum of the stock inwarehouses