Schedule of Expected Cash Collection

Farley Company reported the following information for 2007:
Budgeted Sales: September $ 240,000; October $310,000; November $290,000; December $360,000; and January $200,000.
Budgeted Purchases: September $ 90,000; October $120,000; November $128,000; December $ 144,000; and January $ 88,000.
-All sales are on credit.
-Customer amounts on account are collected 50% in the month sale and 50% in the following month.
-Cost of goods sold is 35% of sales.
-Farley purchases and pays for merchandise 60% in the month of acquisition and 40% in the following month.
-Accounts payable is used only for inventory acquisitions.
How much cash will Farley receive during November?

© SolutionLibrary Inc. solutionlibary.com 9836dcf9d7 https://solutionlibrary.com/statistics/descriptive-statistics/schedule-of-expected-cash-collection-7eqv

Solution Preview

...llowing month of sale (50% of Sales) 155000

Total Cash received during November =$300,000

COGS for November (35% of ...