Question
In: Accounting
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 the next three months are as follows:
|
January sales. . . . . . . . . . . . . . . . . . . . . . . . . . . |
$165,000 |
|
February sales. . . . . . . . . . . . . . . . . . . . . . . . . . . |
$120,000 |
|
March sales. . . . . . . . . . . . . . . . . . . . . . . . . . . |
$180,000 |
Requirement
Prepare a cash collections budget for the first quarter, 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/February/March/Quarter |
|
|
Cash sales |
|
|
Collections on credit sales: |
|
|
20% Month of sale |
|
|
40% 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 | Quarter | ||
| Cash sales | $ 33,000.00 | $ 24,000.00 | $ 36,000.00 | 93,000.00 | |
| Collections on credit sales: | |||||
| 25% Month of sale | $ 26,400.00 | $ 19,200.00 | $ 28,800.00 | 74,400.00 | |
| 50% Month after | $ 44,000.00 | $ 66,000.00 | $ 48,000.00 | 158,000.00 | |
| 24% Two months after | $ 15,360.00 | $ 21,120.00 | $ 31,680.00 | 68,160.00 | |
| Total cash collections | $ 118,760.00 | $ 130,320.00 | $ 144,480.00 | 393,560.00 | |
Working
| November | December | January | February | March | |
| Total sales | $ 80,000.00 | $ 110,000.00 | $ 165,000.00 | $ 120,000.00 | $ 180,000.00 |
| Cash sales | $ 16,000.00 | $ 22,000.00 | $ 33,000.00 | $ 24,000.00 | $ 36,000.00 |
| Credit sales | $ 64,000.00 | $ 88,000.00 | $ 132,000.00 | $ 96,000.00 | $ 144,000.00 |
ekkarill92 answered 1 year agoRelated Solutions
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...
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
$...
Suppose that the ABC Corporation has a production (and sales) capacity of $1,000,000 per month. Its...
Suppose that the ABC Corporation has a production (and sales)
capacity of $1,000,000 per month. Its fixed costs – over a
considerable range of volume – are $350,000 per month, and the
variable costs are $0.50 per dollar of sales.
What is the annual break even chart (D’)? Develop (graph) the
break even chart.
What would be the effect on D’ of decreasing the variable cost
per unit by 25% if the fixed costs thereby increased by 10%?
What would...
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...
Aurora Corporation has annual credit sales of $1,200,000 with credit terms of 45 days and an...
Aurora Corporation has annual credit sales of $1,200,000 with
credit terms of 45 days and an average collection period of 40 days
with no discount. In the current economy Aurora has fallen upon
tough times and is looking for ways improve cash flow, so the
company is considering a changing their collection policy to 1/10
net 30. They estimate 50% of customers will take advantage of the
discount and the average collection period will be 28 days. With
the change...
Troy Corporation has the following budgeted sales for the selected four-month period: Month Unit Sales October...
Troy Corporation has the following budgeted sales for the
selected four-month period:
Month
Unit Sales
October
40,000
November
70,000
December
50,000
January
60,000
There were 14,000 units of finished goods in inventory at the
beginning of October. Plans are to have an inventory of finished
product equal to 25 percent of the unit sales for the next
month.
Five pounds of a single raw material are required for each unit
produced. Each pound of material costs $10. Plans are to...
Jones Corporation has the following budgeted sales for the selected four-month period: Month Unit Sales July...
Jones Corporation has the following
budgeted sales for the selected four-month period:
Month
Unit Sales
July
35,000
August
20,000
September
30,000
October
25,000
Sales price per unit is $200
Plans are to have an inventory of finished product
equal to 30% of the unit sales for the next month. There was 10,500
units in beginning inventory on July 1st.
Five pounds of materials are required for each unit produced.
Each pound of material costs $10. Inventory levels for materials
equal...
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 thecompany'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....
ADVERTISEMENT
ADVERTISEMENT
Latest Questions
- You are tasked with assessing the health department’s intervention program in preventing recurrence of acute alcohol...
- Compare the MOSFET, JFET , and BJT and identify the reasons these devices behave differently. What...
- How would you use SAS Enterprise Miner to create a neural network model of your example?
- Explain the use of neural networking modeling in predictive analytics.
- Current Market Mix of Netflix, as detail as possible, please.
- This is all one question, thank you so much in advance! You must evaluate a proposal...
- X Company is considering the purchase of a new processor that costs $200,000. Shipping and setup...
ADVERTISEMENT