Question

In: Accounting

Glenny’s Glassworks prepares an annual CASH Budget by quarter and uses the following information to estimate...

  1. Glenny’s Glassworks prepares an annual CASH Budget by quarter and uses the following information to estimate the Cash Budget:

On Jan 1, 2020 the Cash Balance is expected to be $47,000.00 and they want a minimum ending balance in cash in any quarter to be $25,000.

2020 Sales are expected as follows:

1st Q                 $275,000

2nd Q                $330,000

3rd Q                 $280,000

4th Q                 $240,000As

75% of Sales are expected to be collected in the quarter they are made and the remaining 25% in the following Quarter. The 4th Q 2019 Sales were $165,000.

REQUIRED:

  1. Prepare the Cash Receipts Budget by Quarter for 2020.
  2. If Glenny spends $1,200,000 in Cash Disbursements during 2020, what would their ending Cash Balance be at Dec 31, 2020? Would they need to borrow any money to maintain their minimum cash requirement?

Solutions

Expert Solution

Answer

please comment for any clarification . Kindly upvote.


Related Solutions

The Fortunate Co. is preparing a cash budget for the 2nd quarter. The following information is...
The Fortunate Co. is preparing a cash budget for the 2nd quarter. The following information is available: Projected cash sales:   $10,000 each month Projected credit sales: $ 8,000 each month One half of the credit sales are collected in the month of sale, and the remainder collected in the following month (there are no uncollectible accounts). Accounts receivable on April 1st were $3,000. Operating expenses (paid in cash): $20,000 for April, and $13,000 for each of the following two months....
TO Industries prepares monthly cash budgets. The following budget information is available for April and May...
TO Industries prepares monthly cash budgets. The following budget information is available for April and May 2020: April May Sales $650,000 $700,000 Direct material purchases 220,000 240,000 Direct labor 175,000 180,000 Manufacturing overhead 120,000 130,000 Selling and administrative expenses 150,000 150,000 All sales are credit sales. The company expects to collect 65% from customers in the month of the sale and the remaining 35% in first month following the sale. The company purchases direct materials on account. The company pays...
TO Industries prepares monthly cash budgets. The following budget information is available for July and August...
TO Industries prepares monthly cash budgets. The following budget information is available for July and August 2017: July August Sales $700,000 $800,000 Direct material purchases 220,000 240,000 Direct labor 200,000 230,000 Manufacturing overhead 120,000 150,000 Selling and administrative expenses 150,000 160,000 All sales are credit sales. The company expects to collect 60% from customers in the month of the sale and the remaining 40% in first month following the sale. The company purchases direct materials on account. The company pays...
TO Industries prepares monthly cash budgets. The following budget information is available for April and May...
TO Industries prepares monthly cash budgets. The following budget information is available for April and May 2019: April May Sales $650,000 $700,000 Direct material purchases 220,000 240,000 Direct labor 175,000 180,000 Manufacturing overhead 120,000 130,000 Selling and administrative expenses 150,000 150,000 All sales are credit sales. The company expects to collect 60% from customers in the month of the sale and the remaining 40% in first month following the sale. The company purchases direct materials on account. The company pays...
Question: Prepare the cash disbursement for direct materials budget for the first quarter Budget information below...
Question: Prepare the cash disbursement for direct materials budget for the first quarter Budget information below Sweetums Cookies, Inc.: A Master Budget CaseIntroductionYou knew they were good, but you never thought Grandma’s old cookie recipe would bring you this far! It all started about three years ago when you began using your Grandma’s cookie recipe to bake cookies as a little side business. You bake them right in your home and sell them to friends and local stores. Response has...
Bagus Industri Bhd. is preparing a cash budget for the second quarter of 2008. The following...
Bagus Industri Bhd. is preparing a cash budget for the second quarter of 2008. The following are its sales figures: ACTUAL SALES (RM) YEAR 2008                         FORECASTED SALES (RM) YEAR 2008                                                                January                       160,000                                   April                 225,000 February                     140,000                                   May                 250,000 March                          190,000                                   June                210,000 July                   220,000 a) The company collects 30 percent of its sales in the month of the sale, 30 percent in the month following the sale, and the remaining 40 percent two months following the...
“Diamond Company” is preparing a budget for the first quarter of year 2020. The following information...
“Diamond Company” is preparing a budget for the first quarter of year 2020. The following information is available: Total expected sales for last two months of 2019 and four months of 2020 are (in 000’s LE) November December January February March April Sales 200 200 160 160 180 180 All sales are on credit and collections from sales are 60% in the month of sales, 30% in the next month, and 10% in the following month. Cost of goods sold...
“Diamond Company” is preparing a budget for the first quarter of year 2020. The following information...
“Diamond Company” is preparing a budget for the first quarter of year 2020. The following information is available: Total expected sales for last two months of 2019 and four months of 2020 are (in 000’s LE) November December January February March April Sales 200 200 160 160 180 150 All sales are on credit and collections from sales are 60% in the month of sales, 30% in the next month, and 10% in the following month. Cost of goods sold...
Your job is to create the following documents: Cash Budget (per quarter) Beginning cash balance Collections...
Your job is to create the following documents: Cash Budget (per quarter) Beginning cash balance Collections in quarter of sale Collections in quarter following sale Total cash available Payments in quarter of purchase Payments in quarter following purchase Direct labor Overhead Selling and Administrative expense Equipment purchases Dividends Total Cash Disbursements Net cash balance Minimum cash balance Excess (Deficiency) of cash Cash balance before interest on balance Interest earned on cash balance Cash balance after interest on balance Diesel Dynamo...
Problem 5-35 information used for the cash budget for second quarter Sunland Products, a rapidly growing...
Problem 5-35 information used for the cash budget for second quarter Sunland Products, a rapidly growing distributor of home gardening equipment, is formulating its plans for the coming year. Carol Jones, the firm’s marketing director, has completed the following sales forecast. Month Sales Month Sales January $909,000 July $1,506,100 February $1,006,600 August $1,506,100 March $909,000 September $1,609,500 April $1,152,600 October $1,609,500 May $1,257,100 November $1,506,100 June $1,405,000 December $1,708,200 Phillip Smith, an accountant in the Planning and Budgeting Department, is...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT