R PROGRAMMING

Question 3: A grocery store is building a simple planning tool to assist in product management. The store sells produces 7 different types of products: Milk, Bread, Chicken, Beef, Chocolate, Olive Oil and Burgers. The tool should allow the user to enter the packaging date of the current batch of stock, as well as the shelf life (in days and hours) and the lead time for each product. Based on this information, your R script should be able to calculate the expiry date of the current batch of each product, as well as determine whether the current batch has expired or not. Based on the expiry date, a latest new order date should also be calculated taking into account the product lead time. Create and populate a dataframe in which all the user entered information as well as the expiry date, current status (i.e. Fresh or Expired), and latest new order date of the products is captured. The design and naming conventions of the dataframe columns may be defined as is logical for you. Question 3: A grocery store is building a simple planning tool to assist in product management. The store sells produces 7 different types of products: Milk, Bread, Chicken, Beef, Chocolate, Olive Oil and Burgers. The tool should allow the user to enter the packaging date of the current batch of stock, as well as the shelf life (in days and hours) and the lead time for each product. Based on this information, your R script should be able to calculate the expiry date of the current batch of each product, as well as determine whether the current batch has expired or not. Based on the expiry date, a latest new order date should also be calculated taking into account the product lead time. Create and populate a dataframe in which all the user entered information as well as the expiry date, current status (i.e. Fresh or Expired), and latest new order date of the products is captured. The design and naming conventions of the dataframe columns may be defined as is logical for you