A local car center is experiencing this problem,

Decrease in sales due to unpaid customers

Since the majority of the customers of the Car Center are from the area where it is operating and many customers have connections and is friends with the owner, some customers got the privilege of owing debt to the business for their services and allowed them to pay after several days, weeks or even months.

One main reason for this is the fact that customers are also affected by the Pandemic resulting in a low budget for them to pay on time.

Below are the sales of the Car Center for months January to June of 2021.

Month	Sales
January	1,434,034.34
February	1,452,780.45
March	1,508,944.80
April	1,498,550.50
May	1,206,740.19
June	1,121,409.67

What possible solutions can be done by the car center in order to increase their sales/prevent it from going down further considering the given situation?

Provide answers using computations or Excel. (dont just explain with words)