Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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

image text in transcribed
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

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Students also viewed these Accounting questions

Question

What is a key factor?

Answered: 1 week ago

Question

Articulate the differences between primary and secondary research

Answered: 1 week ago