Academic Integrity: tutoring, explanations, and feedback — we don’t complete graded work or submit on a student’s behalf.

I would like to know how to calculate those numbers below. Thank You Jewel Servi

ID: 2526290 • Letter: I

Question

I would like to know how to calculate those numbers below. Thank You

Jewel Service anticipates the following sales revenue over a five-month period EEB (Click the icon to view the sales data.) The company's sales are 40% cash and 60% credit. Its collection history indi (Click the icon to vie How much cash will be Complete the cash budget to determine how much cash will be collected in January, February, March and for the quarter in total. (Round your answers to the nearest whole dollar.) Jewel Service Cash Collections Budget For the Months of January through March January February March Quarter Cash sales 6,240 $ 5,200 $ 5,840 S 17,280 Collection of credit sales: 2,340 3,000 1,440 13,020 $ 2,190 3,900 1.404 13,334$ 6,480 11,580 3,744 39,084 1,950 25% Month of sale 50% Month after 15% Two months after 4,680 900 12,730$ Total cash collections 1 More Into - XData Table 25% in the month of the sale 50% in the month after the sale 15% two months after the sale 10% are never collected November December January February March Sales revenue S 16,000 $10,000 15,600 $ 13,000 14,600 PrintDone Print Done

Explanation / Answer

Cash collection schedule :

Jan Feb March Total Cash sales 6240 5200 5840 17280 Collection of credit Sales 25% of month sales 2340 1950 2190 6480 50% month after 3000 4680 3900 11580 15% Two month sale 1440 900 1404 3744 Total cash collection 13020 12730 13334 39084