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

Related 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
ADVERTISEMENT