Question

In: Accounting

URGENT____ The Dennison Company has planned the following sales for the next three months: January February...

URGENT____

The Dennison Company has planned the following sales for the next three months:

January February March
Budgeted Sales $40,000 $50,000 $70,000


Sales are made 20% for cash and 80% on account. From experience, the company has learned that a month's sales on account are collected according to the following pattern:

Month of sale 60%
First month following sale 30%
Second month following sale 8%
Uncollectible 2%


The company requires a minimum cash balance of $5,000 to start a month. The beginning cash balance in March is budgeted to be $6,000.

Required
a) Calculate the budgeted cash receipts for March.
b) The following additional information has been provided for March:

Inventory purchases (all paid in March) $28,000
Operating Expenses (all paid in March) 40,000
Depreciation expense for March 5,000
Dividends paid in March 4,000


Prepare a cash budget for the month of March, using this information and the budgeted cash receipts you calculated in part a) above. The company can borrow in any dollar amount and will not pay interest until April.

Solutions

Expert Solution


Related Solutions

Radcliff Ltd. has budgeted the following sales for the next three months: January February March Budgeted...
Radcliff Ltd. has budgeted the following sales for the next three months: January February March Budgeted Sales $80,000 $100,000 $140,000 Ninety percent of sales are on account and ten percent of sales are cash sales. A month's sales on account are collected as follows: Month of sale 50% First month following sale 40% Second month following sale 9% Uncollectible 1% The company requires a minimum cash balance of $7,000 to start a month. The beginning cash balance in March is...
The Fraley Company, a merchandising firm, has planned the following sales for the next four months:...
The Fraley Company, a merchandising firm, has planned the following sales for the next four months: March April May June Total budgeted sales...... $50,500 $71,450 $93,600 $67,000 All sales at Fraley are on credit. From experience, the company has learned that a month’s sales on account are collected according to the following pattern: Month of sale....................................................... 68% First month following month of sale................. 29% Uncollectible........................................................ 3%       The company requires a minimum cash balance of $5,000 to start a month....
Barrington Bears has developed the following sales forecasts for the next few months. January 500, February...
Barrington Bears has developed the following sales forecasts for the next few months. January 500, February 600, March 720, April 800 and May 770. BB has 80 bears on hand on Dec. 31. Normal ending inventory policy is to hold 20% of next month’s sales. Each bear needs .8 yards of fabric and two pounds of stuffing. Fabric is budgeted to cost $15 per yard and stuffing $4 per pound. Direct labor is paid $18 per hour. Each bear takes...
Hook's Boat Supplies Limited has planned the following sales and inventory purchases for the next three...
Hook's Boat Supplies Limited has planned the following sales and inventory purchases for the next three months: July August September Budgeted sales un 75,000 $ 60,000 S 80,000 Inventory purchases $ 35,000 $ 28,000 $ 40,000 Sales are made 20% for cash & 80% on account. From experience the company has learned that a month's sales on account are collected according to the following: Month of sale First month following sale Second month following sale Uncollectible 60% 30% 596 5%...
Company projects the following sales for the first three months of the​ year: $14300 in January​;$...
Company projects the following sales for the first three months of the​ year: $14300 in January​;$ 10100, in February​;and $10,400 in March. The company expects 60​% of the sales to be cash and the remainder on account. Sales on account are collected in the month of the sale and​ 50% in the following month. The Accounts Receivable account has a zero balance on January 1. Round to the nearest dollar. Prepare a schedule of cash receipts for Armand for January...
Company projects the following sales for the first three months of the year: $15,800 in January;...
Company projects the following sales for the first three months of the year: $15,800 in January; $12,200 in February; and $11,100 in March. The company expects 80%of the sales to be cash and the remainder on account. Sales on account are collected 50% in the month of the sale and 50% in the following month. The Accounts Receivable account has a zero balance on January 1. Round to the nearest dollar. Prepare a revised schedule of cash receipts if receipts...
Bengal Co. provides the following sales forecast for the next three months:
Bengal Co. provides the following sales forecast for the next three months: The company wants to end each month with ending finished goods inventory equal to 25% of the next month sales. Finished goods inventory on June 30 is 1, 250 units. The budgeted production units for August are 6, 950 units. 4, 310 units. 7, 090 units. 5, 565 units. 4,135 units.  
Dax Company forecasts the following sales in units for the next three months: May     50,000 June    ...
Dax Company forecasts the following sales in units for the next three months: May     50,000 June     60,000 July      45,000 Each unit sells for $15.00 and costs $11.00 to purchase. Dax Company needs to have 40% of the next month’s sales in inventory at the end of each month and pays cash for 30% of purchases. The remainder of the purchases are paid for in the month following the purchase. The balance of Accounts Payable at the end of April is $375,000...
Simpson Glove Company has made the following sales projections for the next six months. All sales...
Simpson Glove Company has made the following sales projections for the next six months. All sales are credit sales. March $41,000 June $47,000 April 50,000 July 58,000 May 32,000 August 62,000 Sales in January and February were $41,000 and $39,000, respectively. Experience has shown that of total sales receipts 10 percent are uncollectible, 40 percent are collected in the month of sale, 30 percent are collected in the following month, and 20 percent are collected two months after sale. Prepare...
Simpson Glove Company has made the following sales projections for the next six months. All sales...
Simpson Glove Company has made the following sales projections for the next six months. All sales are credit sales.    March $52,000 June $58,000 April 61,000 July 69,000 May 43,000 August 73,000    Sales in January and February were $41,000 and $39,000, respectively. Experience has shown that of total sales receipts 10 percent are uncollectible, 35 percent are collected in the month of sale, 25 percent are collected in the following month, and 30 percent are collected two months after...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT