company is planning Month Sales Revenue Month Sales Revenue $200.000 155,000 January February $300,000 March 245,000 April All sales are on credit; 60 percent is collected during the month of sale, and 40 percent is collected during the next month. Cost of goods sold is 70 percent of sales. Payments for merchandise sold are made in the month following the month of sale. Operating expenses total $40,000 per month and are paid during the month incurred. The cash balance on February 1 is estimated to be $30,000. Prepare monthly cash budgets for February, March, and April. Jse negative signs only with beginning and ending cash balances, when appropriate. Do not use negative signs with disbursement answers. Wilson's Retail Company Cash Budgets February, March, and April February March Cash balance, beginning S Total Cash receipts Cash available Total disbursements Cash balance, ending $ $ $ April

company is planning Month Sales Revenue Month Sales Revenue $200.000 155,000 January February $300,000 March 245,000 April All sales are on credit; 60 percent is collected during the month of sale, and 40 percent is collected during the next month. Cost of goods sold is 70 percent of sales. Payments for merchandise sold are made in the month following the month of sale. Operating expenses total $40,000 per month and are paid during the month incurred. The cash balance on February 1 is estimated to be $30,000. Prepare monthly cash budgets for February, March, and April. Jse negative signs only with beginning and ending cash balances, when appropriate. Do not use negative signs with disbursement answers. Wilson's Retail Company Cash Budgets February, March, and April February March Cash balance, beginning S Total Cash receipts Cash available Total disbursements Cash balance, ending $ $ $ April

FINANCIAL ACCOUNTING

10th Edition

ISBN:9781259964947

Author:Libby

Publisher:Libby

Chapter1: Financial Statements And Business Decisions

Section: Chapter Questions

Problem 1Q

See similar textbooks

Similar questions

Assume a manufacturing company,s estimated sales for january,febuar and march are 1,00,000 , 1,20,000 , 1,10,000 respectively.the cost of goods sold is always 40 % of its sales.the company always maintains ending merchandise inventory equal to 10%of next motn cost of goods sold.it pays for 25% of its merchandise purchase in the month of the purchase and remaining 75%in the subsequent month .What is the account payable balance at the end of febuary? please proper explantion thnx
Jasper Company has 65% of its sales on credit and 35% for cash. All credit sales are collected in full in the first month following the sale. The company budgets sales of $527,000 for April, $537,000 for May, and $562,000 for June. Total sales for March are $300,100. Prepare a schedule of cash receipts from sales for April, May, and June.
A company budgets the following merchandising purchases: April: $70.000; May $90,000, June: $60,000. All purchases are on account and the company pays 25% of purchases in the month of the purchase and the remaining amount in the following month. Cash disbursements for June for merchandise is $
Memphis Company anticipates total sales for April, May, and June of $990,000 $1,090,000, and $1140,000 respectively. Cash sales are normally 20% of total sales. of the credit sales, 35% are collected in the same month as the sale, 60% are collected during the first month after the sale, and the remaining 5% are not collected. Compute the amount of cash received from credit sales during the month of May.
Eastern Auto Parts Inc. has 20 percent of its sales paid for in cash and 80 percent on credit. All credit accounts are collected in the following month. Assume the following sales: January February March April $ 82,000 72,000 117,000 62,000 Sales in December of the prior year were $92,000. Prepare a cash receipts schedule for January through April. Sales Cash receipts: Cash sales Prior month's credit sales Total cash receipts Eastern Auto Parts Inc. February January $ 80,000 $ March 81,000 $ April 106,000
Cave Hardware's forecasted sales for April, May, June, and July are $220,000, $260,000, $190,000, and $300,000, respectively. Sales are 70% cash and 30% credit with all accounts receivables collected in the month following the sale. Cost of goods sold is 75% of sales and ending inventory is maintained at $55,000 plus 20% of the following month's cost of goods sold. All inventory purchases are paid 28% in the month of purchase and 72% in the following month. What are the cash collections budgeted for June at Cave Hardware? $267,000 $133,000 $211,000 $156,000
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 $74,000 in June, $68,000 in July, and $88,000 in August? Cash collected $fill in the blank 1
Jasper Company has 56% of its sales on credit and 44% for cash. All credit sales are collected in full in the first month following the sale. The company budgets sales of $523,000 for April, $533,000 for May, and $558,000 for June. Total sales for March are $305,700. Prepare a schedule of cash receipts from sales for April, May, and June. Sales Cash receipts from: Cash sales JASPER COMPANY Schedule of Cash Receipts from Sales April May Collections of prior period sales Total cash receipts S S $ $ $ $ June
Page Company makes 30% of its sales for cash and 70% on account. 60% of the credit sales are collected in the month of sale, 25% in the month following sale, and 12% in the second month following sale. The remainder is uncollectible. The following information has been gathered for the current year: Month Total sales Total cash receipts in Month 4 will be: Multiple Choice $27,230. $47,900. 1 2 3 $ 60,000 $ 70,000 $50,000 $30,000 £36 230
ABC Company manufactures and sells lighting fixtures. Estimated sales for the next three months are; September – $350,000 October – $500,000 November – $400,000 Sales for August were $400,000. All sales are on account, ABC Company estimates that 60% of the accounts receivable are collected in the month of sale with the remaining 40% collected the following month. The units sell for $30 each. The cash balance for September 1 is $100,000. Generally, 60% of purchases are due and payable in the month of purchase with the remainder due the following month. Purchase cost per unit for materials is $18. The company maintains an end-of-the-month inventory of 1,000 units plus 10% of next month's unit sales. In addition to the information given, selling and administrative expenses paid in cash are $120,000 per month. Requirement: Prepare a monthly cash budget for September and October for ABC Company.
Ed's Waterbeds has made the following sales projections for the next six months. All sales are credit sales. March $ 12,000 June $ 14,000 April 16,000 July 17,000 May 10,000 August 18,000 Sales in January and February were $13, 500 and $13,000 respectively. Experience has shown that 10 percent of total sales are uncollectible, 30 percent are collected in the month of sale, 40 percent are collected in the following month, and 20 percent are collected two months after sale. a. Prepare a monthly cash receipts schedule for the firm for March through August. Ed's Waterbeds Cash Receipts Schedule January February March April May June July August Sales $ $ $ $ $ $ $ $ Collections of current sales Collections of prior month's sales Collections of sales 2 months earlier Total cash receipts $ $ $ $ $$b. Of the sales expected to be made during the six months from March to August, how much will still be uncollected at the end of August? How much of this is expected to be collected later? Amount…
Pardee Company makes 30% of its sales for cash and 70% on account. 60% of the account sales are collected in the month of sale, 25% in the month following sale, and 12% in the second month following sale. The remainder is uncollectible. The following information has been gathered for the current year: Month 1 2 3 4 Total sales $78,000 $80,000 $68,000 $48,000 Total cash receipts in Month 4 will be: A. 38,780 B.68,000 C.53,180 D.50,600