July | Sept | Oct. | |
Credit sales | 1,200 | 1,236 | 1,260 |
Credit purchases (55% of next month's sales) |
667 | 693 | 713 |
Cash receipts: | |||
Collection from cu.month(15%) | 176 | 182 | 185 |
From last month(75%) | 882 | 909 | 927 |
From 2nd last month (10%) | 114 | 120 | 121 |
Total cash receipts (A) | 1,172 | 1,211 | 1,233 |
Cash disbursements: | |||
Payment for credit purchases | 660 | 680 | 693 |
Wages and salaries | 240 | 247 | 252 |
Rent | 48 | 48 | 48 |
Other expenses | 60 | 62 | 63 |
Taxes | 70 | 73 | |
Payment for plant construction | 1,200 | ||
Total cash disbursements (B) | 1,078 | 2,237 | 1,129 |
Net cash flow (A-B) | 94 | -1,026 | 104 |
Begn. cash bal. | 154 | 426 | -600 |
Endg. cash bal. | 248 | -600 | -496 |
Target cash bal. | 200 | 200 | 200 |
Surplus (shortfall) cash | 48 | -800 | (696) |
Hansborough's total sales for each month were first calculated in the sales budget and are reflected...
Wickford Company's financial managers are meeting with the company's bank to renew their line of credit and discuss their investment needs. They have prepared the company's operating cash budget for the last six months of the year. The following budget assumptions were used to construct the budget: Wickford's total sales for each month were first calculated in the sales budget and are reflected on the first line of the cash budget. Wickford's sales are made on credit with terms of...
PLEASE HELP ME. I will rate :) Mellon Company's financial managers are meeting with the company's bank to renew their line of credit and discuss their investment needs. They have prepared the company's operating cash budget for the last six months of the year The following budget assumptions were used to construct the budget: Mellon's total sales for each month were first calculated in the sales budget and are reflected on the first line of the cash budget. * Mellon's...
Jim Corp. has requested a cash budget for July and August. The following information has been gathered: a. Cash balance as of July 1: $35,000. b. Actual and forecasted sales are as follows: May June July August Cash sales...................... $25,000 $ 30,000 $ 40,000 $ 50,000 Credit sales.................... 60,000 80,000 100,000 110,000 Total............................. $85,000 $110,000 $140,000 $160,000 c. Credit sales are collected 40% in the month of the sale, 35% in the month following the sale, and 25% in the second month following the sale. d. Inventory purchases average 55% of sales. Of these purchases,...
Cash Receipts The sales budget for Perrier Inc. is forecasted as follows: Month Sales Revenue May $140,000 June 140,000 July 180,000 August 120,000 To prepare a cash budget, the company must determine the budgeted cash collections from sales. Historically, the following trend has been established regarding cash collection of sales: 60 percent in the month of sale. 20 percent in the month following sale. 15 percent in the second month following sale. 5 percent uncollectible. The company gives a 1...
Wolfpack Company is a merchandising company that is preparing a budget for the month of July. It has provided the following information: Wolfpack Company Balance Sheet June 30 Assets Cash $ 78,400 Accounts receivable 65,800 Inventory 35,200 Buildings and equipment, net of depreciation 214,000 Total assets $ 393,400 Liabilities and Stockholders’ Equity Accounts payable $ 60,400 Common stock 100,000 Retained earnings 233,000 Total liabilities and stockholders’ equity $ 393,400 Budgeting Assumptions: All sales are on account. Thirty percent of the...
Wolfpack Company is a merchandising company that is preparing a budget for the month of July. It has provided the following information: Wolfpack Company Balance Sheet June 30 Assets Cash $ 81,600 Accounts receivable 59,600 Inventory 42,800 Buildings and equipment, net of depreciation 152,000 Total assets $ 336,000 Liabilities and Stockholders’ Equity Accounts payable $ 57,000 Common stock 100,000 Retained earnings 179,000 Total liabilities and stockholders’ equity $ 336,000 Budgeting Assumptions: All sales are on account. Thirty percent of the...
Wolfpack Company is a merchandising company that is preparing a budget for the month of July. It has provided the following information: Wolfpack Company Balance Sheet June 30 Assets Cash $ 91,400 Accounts receivable 67,200 Inventory 31,000 Buildings and equipment, net of depreciation 165,000 Total assets $ 354,600 Liabilities and Stockholders’ Equity Accounts payable $ 62,600 Common stock 100,000 Retained earnings 192,000 Total liabilities and stockholders’ equity $ 354,600 Budgeting Assumptions: All sales are on account. Thirty percent of the...
Wolfpack Company is a merchandising company that is preparing a budget for the month of July. It has provided the following information: Wolfpack Company Balance Sheet June 30 Assets Cash $ 79,200 Accounts receivable 68,600 Inventory 40,200 Buildings and equipment, net of depreciation 213,000 Total assets $ 401,000 Liabilities and Stockholders’ Equity Accounts payable $ 56,000 Common stock 100,000 Retained earnings 245,000 Total liabilities and stockholders’ equity $ 401,000 Budgeting Assumptions: All sales are on account. Thirty percent of the...
Cash Receipts The sales budget for Andrew Inc. is forecasted as follows: Month Sales Revenue May $ 150.000 June 175,000 July 160,000 August 200.000 To prepare a cash budget, the company must determine the budgeted cash collections from sales. Historically, the following trend has been established regarding cash collection of sales • 60 percent in the month of sale. • 20 percent in the month following sale. • 15 percent in the second month following sale. • 5 percent uncollectible....
1: Prepare a sales budget, including a schedule of expected cash collections. 2: prepare a merchandise purchase budget, including a schedule of expected cash disbursements for merchandise, and a selling and administrative budget. 3: prepare a cash budget. MOST LIKELY NUMBERS AND ASSUMPTIONS SALES MANAGER PRIVATE INFORMATION October Most likely sales 600,000 910,000 475,000 385,000 PURCHASING MANAGER PRIVATE INFORMATION Most likely cost of merchandise as a % of sales Desired ending inventory as a percentage of next month's cost of...