Question

In: Accounting

Cash Budget The owner of a building supply company has requested a cash budget for June....

Cash Budget

The owner of a building supply company has requested a cash budget for June. After examining the records of the company, you find the following:

  1. Cash balance on June 1 is $1,436.
  2. Actual sales for April and May are as follows:
    April May
    Cash sales $10,000 $18,000
    Credit sales 28,900 35,000
    Total sales $38,900 $53,000
  3. Credit sales are collected over a 3-month period: 40% in the month of sale, 30% in the second month, and 20% in the third month. The sales collected in the third month are subject to a 2% late fee, which is paid by those customers in addition to what they owe. The remaining sales are uncollectible.
  4. Inventory purchases average 70% of a month's total sales. Of those purchases, 20% are paid for in the month of purchase. The remaining 80% are paid for in the following month.
  5. Salaries and wages total $11,750 per month, including a $4,500 salary paid to the owner.
  6. Rent is $4,400 per month.
  7. Taxes to be paid in June are $6,780.

The owner also tells you that he expects cash sales of $18,600 and credit sales of $54,000 for June. No minimum cash balance is required. The owner of the company doesn’t have access to short-term loans.

Required:

1. Prepare a cash budget for June. Include supporting schedules for cash collections and cash payments. Round calculations and final answers to the nearest dollar. Be sure to enter percentages as whole numbers.

Cash Budget
For June
Beginning cash balance $
Collections:
Cash sales
Credit sales:
Current month
$ ×  %
May credit sales
$ ×  %
April credit sales
Total cash available $
Less disbursements:
Inventory purchases:
Current month
$ ×  % $
Prior month
$ ×  %
Salaries and wages
Rent
Taxes
Total cash needs
Excess of cash available over needs $

Solutions

Expert Solution


Related Solutions

Transcript Company is preparing a cash budget for June. The company has $145,000 cash at the...
Transcript Company is preparing a cash budget for June. The company has $145,000 cash at the beginning of the month and anticipates having total sales of $1,222,000, consisting of 25% cash sales and 75% credit card sales. The bank charges 3 percent for credit card deposits. The firm sets its selling price at 150 percent of the cost of purchases and pays the cost of each month's sales at the end of the month. Other cash disbursements are $66,000 per...
Transcript Company is preparing a cash budget for June. The company has $125,000 cash at the...
Transcript Company is preparing a cash budget for June. The company has $125,000 cash at the beginning of the month and anticipates having total sales of $1,222,000, consisting of 25% cash sales and 75% credit card sales. The bank charges 3 percent for credit card deposits. The firm sets its selling price at 150 percent of the cost of purchases and pays the cost of each month's sales at the end of the month. Other cash disbursements are $66,000 per...
LFJ Manufacturing requested the company cost accountant to prepare a cash budget for the four months...
LFJ Manufacturing requested the company cost accountant to prepare a cash budget for the four months ending 30 April 2018. The following sales figures are for the months of November 2017 to June 2018. The figures from January 2018 onward are estimated: Actual Sales for 2017 November...............60,000 December................64,000 Sales Forecast for 2018 January.............65,000 February............70,000 March...................72,500 April..................76,250 May.................80,000 June................78,750 50% of the sales are usually paid for in the month in which they occur, while the remaining sales are paid for...
A cash budget/ Cash flow statement is requested Any useful report with the information at hand...
A cash budget/ Cash flow statement is requested Any useful report with the information at hand that can assist management one way or the other
On June 24, 20Y9, a building was sold for $225,000 cash. The building was originally purchased...
On June 24, 20Y9, a building was sold for $225,000 cash. The building was originally purchased in 20Y1 for $210,000. To date, it had accumulated depreciation of $20,000. Which of the following is true on the date of disposition? A.A gain on sale of $35,000 should be recorded. B.The building had a net book value of $205,000. C.The building had a fair market value of $190,000. D.The building had a net book value of $225,000
The owner of a private firm has requested that you estimate the value of the firm...
The owner of a private firm has requested that you estimate the value of the firm so that it can be marketed for sale. The firm creates custom, made-to-order furniture. The firm’s most recent results are shown in Appendix A. Furniture Company Income & FCF Analysis ($ in thousands ) Most Recent Year Revenue $ 20,000 Cost of Goods Sold 15,500 Gross Profit Margin 4,500 Gross Profit Margin % 22.5% General Operating Expenses 2,000 Depreciation & Amortization 500 Total Operating...
Building the Master Budget involve: The Sales Budget. The Production Budget Expected Cash Collections Budget The...
Building the Master Budget involve: The Sales Budget. The Production Budget Expected Cash Collections Budget The Direct Materials Budget Expected Cash Disbursement Budget The Direct Labor Budget Manufacturing Overhead Budget Ending Finished Goods Inventory Budget Selling and Administrative Expense Budget The Cash Budget The Budgeted Income Statement The Budgeted Balance Sheet Full Explanations
Honolua Company is preparing a cash budget for November. The company has $150,000 cash at the...
Honolua Company is preparing a cash budget for November. The company has $150,000 cash at the beginning of November and anticipates total sales of $1,000,000, consisting of 25% cash sales and 75% bank credit-card sales. The bank charges 3% for credit-card deposits. The firm sets its selling price at 160% of the cost of purchases and pays the cost of each month's sales at the end of the month. Operating expenses are $45,000 per month, of which $25,000 is depreciation...
Cash Budget Problem: Francesca’s Fragrances, Inc. Prepare Cash Budget for April, May, June 2019 Follow the...
Cash Budget Problem: Francesca’s Fragrances, Inc. Prepare Cash Budget for April, May, June 2019 Follow the following to prepare the budget: 1.         Real Sales 2019:         January                        - $200,000                                                 February                      - $400,000                                                 March                          - $350,000             Projected for 2019:     April                            - $500,000                                                 May                             - $400,000                                                 June                             - $450,000             Sales Payment History:           10% cash                                                             30% Accts. Rec. – collected n/30 days                                                             60% Accts. Rec. – collected...
Cash Budget The Williams Supply Company sells for $50 one product that it purchases for $20....
Cash Budget The Williams Supply Company sells for $50 one product that it purchases for $20. Budgeted sales in total dollars for the year are $3,000,000. The sales information needed for preparing the July budget follows: Month Sales Revenue May $ 175,000 June 240,000 July 295,000 August 320,000 Account balances at July 1 include these: Cash $ 125,000 Merchandise inventory 47,200 Accounts receivable (sales) 84,530 Accounts payable (purchases) 47,200 The company pays for one-half of its purchases in the month...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT