Question

In: Accounting

LaChutCorporation has found that 80​% of its sales in any given month are credit​ sales, while...

LaChutCorporation has found that 80​% of its sales in any given month are credit​ sales, while the remainder are cash sales. Of the credit​ sales, LaChut Corporation has experienced the following collection​ pattern:

25% received in the month of the sale

50% received in the month after the sale

24% received two months after the sale

1% of the credit sales are never received

November sales for last year were $90,000​,

while December sales were $125,000.

Projected sales for the next three months are as​ follows:

January sales. . . . . . . . . . . . . . . . . . . . . . . . . . .

$155,000

February sales. . . . . . . . . . . . . . . . . . . . . . . .

$135,000

March sales. . . . . . . . . . . . . . . . . . . . . . . . . . .

$180,000

Requirement

Prepare a cash collections budget for the first​ quarter, January-March, with a column for each month and for the quarter. ​(Round your answers to the nearest whole​ dollar.)

LaChut Corporation

Cash Collections Budget

For the Months of January through March

January

Cash sales

Collections on credit sales:

25% Month of sale

50% Month after

24% Two months after

Total cash collections

Solutions

Expert Solution

Solution

LaChut Corporation
Cash Collections Budget
For the Months of January through March
January February March
Cash sales $        31,000.00 $    27,000.00 $                   36,000.00
Collections on credit sales:
25% Month of sale $        31,000.00 $    27,000.00 $                   36,000.00
50% Month after $        50,000.00 $    62,000.00 $                   54,000.00
24% Two months after $        17,280.00 $    24,000.00 $                   29,760.00
Total cash collections $      129,280.00 $ 140,000.00 $                 155,760.00

Working

.

November December January February March
Total sales $        90,000.00 $      125,000.00 $ 155,000.00 $                 135,000.00 $ 180,000.00
Cash sales $        18,000.00 $        25,000.00 $    31,000.00 $                   27,000.00 $     36,000.00
Credit sales $        72,000.00 $      100,000.00 $ 124,000.00 $                 108,000.00 $ 144,000.00

Related Solutions

LaChut Corporation has found that 80​% of its sales in any given month are credit​ sales,...
LaChut Corporation has found that 80​% of its sales in any given month are credit​ sales, while the remainder are cash sales. Of the credit​ sales, LaChut Corporation has experienced the following collection​ pattern: 20% received in the month of the sale 40% received in the month after the sale 24% received two months after the sale 16% of the credit sales are never received November sales for last year were $80,000​, while December sales were $110,000. Projected sales for...
Sesnie Corporation has found that 60​% of its sales in any given month are credit​ sales,...
Sesnie Corporation has found that 60​% of its sales in any given month are credit​ sales, while the remainder are cash sales. Of the credit​ sales, Sesnie Corporation has experienced the following collection​ pattern: 25% received in the month of the sale 50% received in the month after the sale 18% received two months after the sale 7% of the credit sales are never received November sales for last year were $ 80,000​, while December sales were $ 110,000. Projected...
MonetteMonette Corporation has found that 6060?% of its sales in any given month are credit? sales,...
MonetteMonette Corporation has found that 6060?% of its sales in any given month are credit? sales, while the remainder are cash sales. Of the credit? sales, MonetteMonette Corporation has experienced the following collection? pattern: 25% received in the month of the sale 50% received in the month after the sale 18% received two months after the sale 7% of the credit sales are never received November sales for last year were $ 85 comma 000$85,000?, while December sales were $...
Jupiter Ltd has annual credit sales of $80 million and 2 percent of the value of...
Jupiter Ltd has annual credit sales of $80 million and 2 percent of the value of these sales have to be written off as bad debt. Currently Jupiter’s credit terms are 4/15 net 30; and 50 percent of the non-defaulting credit customers take advantage of the discount. A further 40 percent of non-defaulters pay on time and the remaining 10 percent of non-defaulters pay 15 days late. Jupiter Ltd is considering changing its credit terms to 2/10, net 30. It...
OfficeMart Inc. has "cash and carry" customers and credit customers. OfficeMart estimates that 30% of monthly sales are to cash customers, while the remaining sales are to credit customers.
  Schedule of Cash Collections of Accounts Receivable OfficeMart Inc. has "cash and carry" customers and credit customers. OfficeMart estimates that 30% of monthly sales are to cash customers, while the remaining sales are to credit customers. Of the credit customers, 20% pay their accounts in the month of sale, while the remaining 80% pay their accounts in the month following the month of sale. Projected sales for the next three months are as follows: October $114,000 November 143,000 December...
1)In one month, Andrea can produce 80 apples or 80 bananas, while Tom can produce 60...
1)In one month, Andrea can produce 80 apples or 80 bananas, while Tom can produce 60 apples or 100 bananas. Currently, Andrea is producing 40 apples and 40 bananas per month while Tom is making 30 apples and 50 bananas. If from now on, Andrea starts making nothing but apples and Tom makes nothing but bananas, and the two trade 35 apples for 45 bananas every month, what will be each person’s gain from trade? a. 10 bananas and 10...
ALei Industries has credit sales of $151 million a year. ​ ALei's management reviewed its credit...
ALei Industries has credit sales of $151 million a year. ​ ALei's management reviewed its credit policy and decided that it wants to maintain an average collection period of 40 days. a.  What is the maximum level of accounts receivable that ALei can carry and have 40​-day average collection​ period? b.  If​ ALei's current accounts receivable collection period is 50 ​days, how much would it have to reduce its level of accounts receivable in order to achieve its goal of...
A company had credit sales $30,000 and cash sales of $23,000 during the month of May....
A company had credit sales $30,000 and cash sales of $23,000 during the month of May. Also during​ May, the company paid wages of $24,000 and utilities of $9,000. It also received payments from customers on account totaling $4,400. What was the​company's net income for the​ month? A. 53,000 B. 20,000 C. 86,000 D. 23,000 Which accounts are increased by​ debits? A. Accounts Receivable and Utilities Expense. B. Accounts Payable and Service Revenue. C. Salaries Expense and Common Stock. D....
During the month of June, Sweet Boutique had cash sales of $219,420 and credit sales of...
During the month of June, Sweet Boutique had cash sales of $219,420 and credit sales of $153,382, both of which include the 6% sales tax that must be remitted to the state by July 15. Prepare the adjusting entry that should be recorded to fairly present the June 30 financial statements. (If no entry is required, select "No Entry" for the account titles and enter 0 for the amounts. Credit account titles are automatically indented when amount is entered. Do...
ALei Industries has credit sales of $154 million a year. ALei's management reviewed its credit policy...
ALei Industries has credit sales of $154 million a year. ALei's management reviewed its credit policy and decided that it wants to maintain an average collection period of 40 days. a. What is the maximum level of accounts receivable that ALei can carry and have a 40 -day average collection period? b. If ALei's current accounts receivable collection period is 50 days, how much would it have to reduce its level of accounts receivable in order to achieve its goal...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT