Question
In: Accounting
ABC Enterprises has asked for your assistance in preparing a cash budget for the month of...
ABC Enterprises has asked for your assistance in preparing a cash budget for the month of December 2020 and has provided projected sales revenue data below:
Projected sales:
October 2020
$144,000
November 2020
$205,000
December 2020
$220,000
All sales are on credit with 65% collected during the month of sale, 18% collected during the month following the sale, 15% during the second month after the sale and 2% uncollectable. Required:
a) Prepare the cash receipts section of a cash budget for ABC Enterprises for the month of December 2020.
b) Explain how ABC Enterprises would go about constructing a cash budget for the first three months of 2021. Note that ABC plans to purchase a major piece of equipment costing $500,000 in February 2021.
Solutions
Expert Solution
INFORMATION GIVEN IN QUESTION:
Credit Sales of
October 2020 = $ 144,000
November 2020 = $ 205,000
December 2020 = $ 220,000
Credit terms - 65% in same month, 18% in following month, 15% in second month following sales & non recoverable 2%
ANSWER:
A. Cash receipts section of a cash budget for ABC Enterprises for the month of December 2020.
| Sales Month | December 2020 |
| OCTOBER 2020 ( 144,000 X 15%) | $ 21,600 |
| NOVEMBER 2020 (205,000 X 18%) | $ 36,900 |
| DECEMBER 2020 (220,000 X 65%) | $ 143,000 |
| TOTAL | $201,500 |
B. How ABC Enterprises would go about constructing a cash budget for the first three months of 2021
| DETAILS | JANUARY 2021 | FEBRUARY 2021 | MARCH 2021 |
| OPENING BALANCE | XXX | XXX | XXX |
| ADD: COLLECTION FROM CUSTOMERS | XXX | XXX | XXX |
| ADD: OTHER CASH RECIEVED | XXX | XXX | XXX |
| TOTAL CASH AVAILABLE FOR PAYMENTS | XXX | XXX | XXX |
| LESS: PAYMENT TO SUPPLIERS | (XXX) | (XXX) | (XXX) |
| LESS: PAYMENT FOR EXPENSES | (XXX) | (XXX) | (XXX) |
| LESS: PURCHASE OF EQUIPMENT | - | (500,000) | - |
| LESS: ANY OTHER PAYMENTS | (XXX) | (XXX) | (XXX) |
| CLOSING BALANCE | XXX | XXX | XXX |
ekkarill92 answered 1 year agoRelated Solutions
Shanghai Enterprises has asked for your assistance in preparing a cash budget for the month of...
Shanghai Enterprises has asked for your assistance in preparing
a cash budget for the month
of December 2020 and has provided projected sales revenue data
below
Projected sales:
October 2020
$144,000
November 2020
$205,000
December 2020
$220,000
All sales are on credit with 65% collected during the month of
sale, 18% collected during the
month following the sale, 15% during the second month after the
sale and 2% uncollectable.
Required:
a) Prepare the cash receipts section of a cash budget...
Shanghai Enterprises has asked for your assistance in preparing a cash budget for the month of...
Shanghai Enterprises has asked for your assistance in preparing
a cash budget for the month of December 2020 and has provided
projected sales revenue data below:
Projected sales: October 2020 $144,000
November 2020 $205,000
December 2020 $220,000
All sales are on credit with 65% collected during the month of
sale, 18% collected during the month following the sale, 15% during
the second month after the sale and 2% uncollectable.
Required:
a) Prepare the cash receipts section of a cash budget...
5. ABC Company is preparing their master budget and is preparing a schedule of expected cash...
5. ABC Company is preparing their master budget and is preparing
a schedule of expected cash collections from sales for the first
quarter of 2019. They expect sales in January to be $400,000,
February to be $300,000, and March to be $500,000. !0% of the sales
will be paid for in cash. The remainder will be charged on account.
From past experience, the company knows their customers take 3
months to pay their bills in total, with 40% of a...
Tracy is preparing her budget for next year and needs your assistance. Now that she has...
Tracy is preparing her budget for next year and needs your
assistance. Now that she has a better idea of what to expect now
that she is in business full time, we want to begin having some of
her ingredients in stock to avoid not being able to get the
ingredients on time.
She is ready to prepare her budget for the first four months of
2021. She believes she will sell the following number of cupcakes
each month:
Month...
Tracy is preparing her budget for next year and needs your assistance. Now that she has...
Tracy is preparing her budget for next year and needs your
assistance. Now that she has a better idea of what to expect now
that she is in business full time, we want to begin having some of
her ingredients in stock to avoid not being able to get the
ingredients on time.
She is ready to prepare her budget for the first four months of
2021. She believes she will sell the following number of cupcakes
each month:
Month...
Todd Enterprises is preparing a cash budget for the second quarter of the coming year. The...
Todd Enterprises is preparing a cash budget for the
second quarter of the coming year. The following data have been
forecasted:
April
May
Sales …………………………………………………………
$150,000
$157,500
Merchandise purchases ……………………………
107,000
112,400
Operating expenses:
Payroll …………………………………………………
13,600
14,280
Advertising …………………………………………..
5,400
5,700
Rent ……………………………………………………..
2,500
2,500
Depreciation …………………………………………
7,500
7,500
End of April balances:
Cash ………………………………………………………
30,000
Bank loan payable …………………………………
26,000
Additional data:
(1) Sales are 40% cash and 60% credit. The collection
pattern for credit sales is 50%...
Papst Company is preparing its cash budget for the month of May. The following information is...
Papst Company is preparing its cash budget for the month of May.
The following information is available concerning its accounts
receivable (based on sales made to customers on open account):
Actual credit sales for March
$
130,000
Actual credit sales for April
$
160,000
Estimated credit sales for May
$
210,000
Estimated collections in the month of sale
25
%
Estimated collections in the first month after the month of
sale
60
%
Estimated collections in the second month after...
Preparing a Cash Budget La Famiglia Pizzeria provided the following information for the month of October:...
Preparing a Cash Budget
La Famiglia Pizzeria provided the following information for the
month of October:
Sales are budgeted to be $167,000. About 85% of sales is cash;
the remainder is on account.
La Famiglia expects that, on average, 70% of credit sales will
be paid in the month of sale, and 28% will be paid in the following
month.
Food and supplies purchases, all on account, are expected to be
$102,000. La Famiglia pays 25% in the month of...
Preparing a Cash Budget La Famiglia Pizzeria provided the following information for the month of October:...
Preparing a Cash Budget
La Famiglia Pizzeria provided the following information for the
month of October:
Sales are budgeted to be $161,000. About 85% of sales is cash;
the remainder is on account.
La Famiglia expects that, on average, 70% of credit sales will
be paid in the month of sale, and 28% will be paid in the following
month.
Food and supplies purchases, all on account, are expected to be
$113,000. La Famiglia pays 25% in the month of...
Preparing a Cash Budget La Famiglia Pizzeria provided the following information for the month of October:...
Preparing a Cash Budget
La Famiglia Pizzeria provided the following information for the
month of October:
Sales are budgeted to be $153,000. About 85% of sales is cash;
the remainder is on account.
La Famiglia expects that, on average, 70% of credit sales will
be paid in the month of sale, and 28% will be paid in the following
month.
Food and supplies purchases, all on account, are expected to be
$101,000. La Famiglia pays 25% in the month of...
ADVERTISEMENT
ADVERTISEMENT
Latest Questions
- 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...
- There are a large number of tasks involved in information technology and programming, and many of...
- Using one quantitative and one qualitative health policy research method described in this chapter, design a...
- What is the Rawls' solution to the age-old question of social (economic / distributive) justice?...
- St. Johns River Shipyards' welding machine is 15 years old, fully depreciated, and has no salvage...
- The following information is available for Robstown Corporation for 20Y8: Inventories January 1 December 31 Materials...
ADVERTISEMENT