Sam Company is preparing its cash budget for the month of May. Given below the following information: Current month's sales Prior month's sales Sales two months prior to current month Sales three months prior to current month Doubtful accounts 14% 75% 6% 4% 1% The company allows 2% cash discount on payments made by customers during the month of sale. Credit sales are as follows: May -estimated April P 100,000 March 90,000 February P 80,000 95,000
Q: NUBD Company is preparing its cash budget for the month of May. The following information: Current…
A: Answer - Calculation of estimated accounts receivable collections for May - Particulars…
Q: Prasad & Co. wishes to prepare cash budget from January. Prepare a cash budget for the first six…
A: Cash Budget: Creating a cash budget is an estimate of a company's cash flow for a certain period of…
Q: The following budget estimates are available for Ashton Ltd., manufacturer of a single product:…
A: Cash Budget shows the budgeted cash inflow as well as cash outflow in the basis of some expected…
Q: The following budget estimates are available for Ashton Ltd., manufacturer of a single product:…
A: Given, Debtors settlement as follows- 50% of debtors pay during the month following the month of…
Q: How much is the cost of goods sold on January 8? 2.
A: The accounts receivable is the amount of goods sold on credit for which cash is yet not received…
Q: Camellia, a merchandising company, has provided the following extracts from their budget for the…
A: Credit sales for thr month of January = Total sales x (1 - cash sales %) = $400,000 - (1 - 0.25) =…
Q: Company makes all of its sales on account. Company collects its account as follows: 20% in the month…
A: Sales of January are collected in January, February and March. Sales of February are collected in…
Q: What are the estimated accounts receivable collections for May? * O NUBD Company is preparing its…
A: Cash budget means expected cash receipts and expected cash payment with opening and closing cash…
Q: NUBD Company is preparing its cash budget for the month of May. The following information: Current…
A: Estimated accounts receivable collections for May = (May sales x 14%) + (April sales x 75%) + (March…
Q: Kevin Montgomery Retail seeks your assistance to develop cash and other budget information for May,…
A: Solution... Ending inventory = 125% of next month's sales Ending inventory of April = Sales of…
Q: Old Antique Store prepared the following budget information for the month of May: • Sales are…
A: Answer) Calculation of Operating Income Operating Income = Sales – Cost of Goods sold – Selling and…
Q: The following budget estimates are available for Ashton Ltd., manufacturer of a single product:…
A: Since we only answer up to 3 sub-parts, we’ll answer the first 3. Please resubmit the question and…
Q: Browning Company's sales budget shows the following expected total sales: Month Sales $22,000…
A: The correct answer is $39,577.
Q: Montero Corporation, a merchandising company, has provided the following budget data: PurchasesSales…
A: Particulars jan feb Mar april May Purchases 42,000 48,000…
Q: Benton Company's sales budget shows the following expected total sales: Month Sales $18,000 $37,000…
A: In April, collections would be: 67% of credit sales of March 25% of credit sales of April Cash…
Q: The Ohio Company has the following historical pattern on its credit sales: 70% collected in the…
A: The correct answer for the above question is given in the following steps for your reference.
Q: Rindo Company expects to have P37,500 cash on hand on April 1st, and requires you to prepare a cash…
A: Here, Period of Credit to purchases is 2 months that means payment of Feb will be done in April and…
Q: The PDQ Company makes collections on credit sales according to the following schedule: 25% in month…
A: A cash budget plan is a spending plan or plan of expected money receipts and payment during the time…
Q: 1. The following budget estimates are available for Ashton Ltd., manufacturer of a single product:…
A: A cash budget is an important part in accounting as it defines or in simple words it indicates the…
Q: The Ohio Company has the following historical pattern on its credit sales: 70% collected in the…
A: Answer 1) Calculation of Total estimated percentage of collections Total estimated percentage of…
Q: On October 1 of the current year, Molloy Corporation prepared a cash budget for October, November,…
A: October Cash Collected from Sales of August $ 4,000 Cash Collected from Sales of…
Q: A company is preparing its budget for the upcoming fiscal year. Management has found out that 20% of…
A: Cash Budget - Budgeting is the great method of controlling expense that are not necessary in nature.…
Q: Wichita Industries' sales are 10% for cash and 90% on credit. Credit sales are collected as follows:…
A: Cash Budget: This budget gives an estimation of all the cash inflows and outflows of business for…
Q: A Scndai clothing wholesaler was preparing its sales budget for the first quarter of 20X8. Forecast…
A: We shall prepare two seperate schedules for sales and cash collection.
Q: Todd Enterprises is preparing a cash budget for the second quarter of the coming year. The following…
A: Cash Budget: This budget gives an estimation of all the cash inflows and outflows of a business for…
Q: Alpha Company makes all its sales on account. The accounts receivable payment experience is as…
A: Budgeted cash collection is the expected cash is to be collected in a particular month for the…
Q: Digregory makes all purchases on account, subject to the following payment pattern: Paid in the…
A: Cost Accounting: It is the process of collecting, recording, analyzing the cost, summarizing cost,…
Q: H ltd is preparing its budget for the second quarter. The following information is available…
A:
Q: ABC Farm is preparing a collection budget for the year. Sales are expected to be P100,000 in…
A: Budgets are the forecasts or estimates that are made for future periods. These are quantitative…
Q: ABC Farm is preparing a collection budget for the year. Sales are expected to be P100,000 in…
A: Accounts receivable is the amount not paid by customer against which goods has been delivered.…
Q: Mirbat Company prepares its budget for January-April pe od. On 1 January, the cash available is…
A: Cash budget in the business shows expected cash receipts and cash payments to be made in the…
Q: Company has the following historical pattern on its credit sales: 70% collected in the month of…
A: Cash budget is a forecast of a company's cash flows over a predetermined amount of time which might…
Q: The following budget estimates are available for Ashton Ltd., manufacturer of a single product:…
A: Cash Budget- Cash budget refers to the statement that shows all the inflows of cash from various…
Q: Benton Company's sales budget shows the following expected total sales Month Sales January $20,ee0…
A:
Q: Royal Cigar Company is preparing a budget for cash collections. Its sales for November andDecember…
A: The above question relates to the preparation of a cash budget. It involves the determination of…
Q: following table lists data from the budget of Ritewell Publishers. Half the company’s sales are for…
A: Working note
Q: MARS PAUTANG Company is preparing its cash budget for the month of June. The following information…
A: Estimated collection in June for Credit sales in June = Estimated credit sales for June x 20% =…
Q: Rivers Company purchases merchandise on account. In general, Rivers pays 50% in the month of…
A: Cash disbursements are used in the cash budget. It indicates the amount to be collected and paid in…
Q: Ewing Company is preparing a cash budget for September. The following information on accounts…
A: Account’s receivables can be defined as the payment which is yet to be received by the business in…
Q: Fiscal Company has the following sales budget for the last six months o 20X5: July August September…
A: The cash collection schedule is prepared to record the cash collected during the period.
Q: Questions 24 and 25 are based on the following information: The PAD Company has the following…
A: Given information: Sales: July = P 84,000 August = P 90,000 September = P110,000 October = P 125,000…
Q: credit sales: 70% collected in the month of sale; 15% collected in the 1st month after the sale; 10%…
A: The budget is prepared to estimate the requirements for the future period.
Q: Justin Company's budget includes the following credit sales for the current year: September,…
A: Introduction: The cash collection cycle is the number of days it measures the return accounts…
Q: Papst Company is preparing its cash budget for the month of May. The following information is…
A: Since we only answer up to 3 sub-parts, we’ll answer the first 3. Please resubmit the question and…
Q: The controller of Mercury Shoes Inc. instructs you to prepare a monthly cash budget for the next…
A: Calculations: Breakup of total sales April May June Cash sales 15% 22,500 26,250…
Q: A merchandising company's sales budget indicates the following sales: January: $25,000; February:…
A: Formula: Credit sales = Total sales x Credit sales percentage.
Q: Hess Company has $15,000 in cash on hand on January 1 and has collected the following budget data:…
A:
Q: Browning Company's sales budget shows the following expected total sales: Month Sales $17,000…
A: Calculation of cash inflows in April:
1. What are the estimated accounts receivable collections for May?
Step by step
Solved in 2 steps
- Pilsner Inc. purchases raw materials on account for use in production. The direct materials purchases budget shows the following expected purchases on account: Pilsner typically pays 25% on account in the month of billing and 75% the next month. Required: 1. How much cash is required for payments on account in May? 2. How much cash is expected for payments on account in June?Amusement tickets estimated sales are: What are the balances in accounts receivable for April, May, and June if 60% of sales are collected in the month of sale, 30% are collected the month after the sale, and 10% are collected the second month after the sale?A companys sales for the coming months are as follows: About 20 percent of sales are cash sales, and the remainder are credit sales. The company finds that typically 10 percent of a months credit sales are paid in the month of sale, 70 percent are paid the next month, and 15 percent are paid in the second month after sale. Expected cash receipts in July are budgeted at what amount? a. 114,520 b. 143,150 c. 145,720 d. 156,000
- Palmgren Company produces consumer products. The sales budget for four months of the year is presented below. Company policy requires that ending inventories for each month be 25 percent of next months sales. At the beginning of July, the beginning inventory of consumer products met that policy. Required: Prepare a production budget for the third quarter of the year. Show the number of units that should be produced each month as well as for the quarter in total.Earthies Shoes has 55% of its sales in cash and the remainder on credit. Of the credit sales, 70% is collected in the month of sale, 15% is collected the month after the sale, and 10% is collected the second month after the sale. How much cash will be collected in June if sales are estimated as $75,000 in April, $65,000 in May, and $90,000 in June?Halifax Shoes has 30% of its sales in cash and the remainder on credit. Of the credit sales, 65% is collected in the month of sale, 25% is collected the month after the sale, and 5% is collected the second month after the sale. How much cash will be collected in August if sales are estimated as $75,000 in June, $65,000 in July, and $90,000 in August?
- Cash budget The controller of Mercury Shoes Inc. instructs you to prepare a monthly cash budget for the next three months. You are presented with the following budget information: The company expects to sell about 10% of its merchandise for cash. Of sales on account, 60% are expected to be collected in the month following the sale and the remainder the following month (second month after sale). Depreciation, insurance, and property tax expense represent 12,000 of the estimated monthly manufacturing costs. The annual insurance premium is paid in February, and the annual property taxes are paid in November. Of the remainder of the manufacturing costs, 80% are expected to be paid in the month in which they are incurred and the balance in the following month. Current assets as of June 1 include cash of 42,000, marketable securities of 25,000, and accounts receivable of 198,000 (150,000 from May sales and 48,000 from April sales). Sales on account in April and May were 120,000 and 150,000, respectively. Current liabilities as of June 1 include 13,000 of accounts payable incurred in May for manufacturing costs. All selling and administrative expenses are paid in cash in the period they are incurred. An estimated income tax payment of 24,000 will be made in July. Mercury Shoes regular quarterly dividend of 15,000 is expected to be declared in July and paid in August. Management desires to maintain a minimum cash balance of 40,000. Instructions Prepare a monthly cash budget and supporting schedules for June, July, and August. On the basis of the cash budget prepared in part (1), what recommendation should be made to the controller?Drainee purchases direct materials each month. Its payment history shows that 65% is paid in the month of purchase with the remaining balance paid the month after purchase. Prepare a cash payment schedule for January using this data: in December through February, it purchased $22,000, $25,000, and $23,000 respectively.Desiccate purchases direct materials each month. Its payment history shows that 70% is paid in the month of purchase with the remaining balance pad the month after purchase. Prepare a cash payment schedule for March if in January through March, it purchased $35,000, $37,000, and $39,000, respectively.
- Nonnas Re-Appliance Store collects 55% of its accounts receivable in the month of sale and 40% in the month after the sale. Given the following sales, how much cash will be collected in February?Cash budget The controller of Bridgeport Housewares Inc. instructs you to prepare a monthly cash budget for the next three months. You are presented with the following budget information: The company expects to sell about 10% of its merchandise for cash. Of sales on account, 70% are expected to be collected in the month following the sale and the remainder the following month (second month following sale). Depreciation, insurance, and property tax expense represent 50,000 of the estimated monthly manufacturing costs. The annual insurance premium is paid in January, and the annual property taxes are paid in December. Of the remainder of the manufacturing costs, 80% are expected to be paid in the month in which they are incurred and the balance in the following month. Current assets as of September 1 include cash of 40,000, marketable securities of 75,000, and accounts receivable of 300,000 (60,000 from July sales and 240,000 from August sales). Sales on account for July and August were 200,000 and 240,000, respectively. Current liabilities as of September 1 include 40,000 of accounts payable incurred in August for manufacturing costs. All selling and administrative expenses are paid in cash in the period they are incurred. An estimated income tax payment of 55,000 will be made in October. Bridgeports regular quarterly dividend of 25,000 is expected to be declared in October and paid in November. Management desires to maintain a minimum cash balance of 50,000. Instructions Prepare a monthly cash budget and supporting schedules for September, October, and November. On the basis of the cash budget prepared in part (1), what recommendation should be made to the controller?Nizwa Company prepares its budget for January-April period. On 1 January, the cash available is 15000 OMR. The financial information is given in the table below. Sales Purchases Expenses December 72000 45000 7000 January 85000 53000 9000 February 90000 54000 6000 March 95000 65000 11000 April 105000 75000 13000 Additional Information: (a) Period of credit allowed by suppliers is one month (b) 30 % of sale is for cash and the period of credit allowed to customer for credit sale one month. (c) The period allowed in payment of expenses is one month. Which of the following is the total of cash balances at the end of February and March? Select one: a. 184100 b. 131300 c. 158300 d. 95600