SECTION B (Answer 2 Questions only from this section) Question 1 a. Past-Due Notices Gublegog International is a manufacturing company that supplies products to its client on credit. The company has a credit policy of 30days for debtors to repay their debt. Below is an activity sheet that details customer's credit behavior. The customer's consignment delivery date is listed in column A, The payment status is shown in column B, and the customer's company name is in column C. On 10/23/2019, you were asked to prepare a list of customers who have exceeded the company's credit policy limit. As the company accountant, enter a formula in column B that calculates which customers are more than 30 days past due, using your assignment date 10/23/2019 as the reference date. Note: Customers within the 30 days credit limit will have "OKAY" in their payment column and those above the 30 days limit should have Past Due in their payment column. (20 marks) Payment Status Consignment Date 1-Sep-19 22-Oct-19 19-Sep-19 30-Oct-19 5-Sep-19 30-Sep-19 7-Sep-19 8-Sep-19 26-Sep-19 10-Sep-19 Customer Balase & Co. Miky Nini Dush Enterprise Ombaba Events Olu Josh Anani & Friends Omaka Juta Ltd. Just Fresh Gifted Legs Makoma Beats SECTION B (Answer 2 Questions only from this section) Question 1 a. Past-Due Notices Gublegog International is a manufacturing company that supplies products to its client on credit. The company has a credit policy of 30days for debtors to repay their debt. Below is an activity sheet that details customer's credit behavior. The customer's consignment delivery date is listed in column A, The payment status is shown in column B, and the customer's company name is in column C. On 10/23/2019, you were asked to prepare a list of customers who have exceeded the company's credit policy limit. As the company accountant, enter a formula in column B that calculates which customers are more than 30 days past due, using your assignment date 10/23/2019 as the reference date. Note: Customers within the 30 days credit limit will have "OKAY" in their payment column and those above the 30 days limit should have Past Due in their payment column. (20 marks) Payment Status Consignment Date 1-Sep-19 22-Oct-19 19-Sep-19 30-Oct-19 5-Sep-19 30-Sep-19 7-Sep-19 8-Sep-19 26-Sep-19 10-Sep-19 Customer Balase & Co. Miky Nini Dush Enterprise Ombaba Events Olu Josh Anani & Friends Omaka Juta Ltd. Just Fresh Gifted Legs Makoma Beats