Martinez Company has budgeted sales revenue as follows for the next 4 months: February March April May $310,000 245,000 230,000 330,000 Past experience indicates that 70% of sales each month are on credit. The remainder are cash sales. Collection of credit sales occurs as follows: 60% in the month of sale, 35% in the month following the sale, and 3% in the second month following the sale. The other 2% is uncollectible. Prepare a schedule which shows expected cash receipts from sales for the month of May.

Martinez Company has budgeted sales revenue as follows for the next 4 months: February March April May $310,000 245,000 230,000 330,000 Past experience indicates that 70% of sales each month are on credit. The remainder are cash sales. Collection of credit sales occurs as follows: 60% in the month of sale, 35% in the month following the sale, and 3% in the second month following the sale. The other 2% is uncollectible. Prepare a schedule which shows expected cash receipts from sales for the month of May.

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

Gardner Company expects sales for October of $259,000. Experience suggests that 55% of sales are for cash and 45% are on credit. The company collects 50% of its credit sales in the month of sale and 50% in the month following sale. Budgeted Accounts Receivable on September 30 is $73,500. What is the amount of cash expected to be collected in October? Multiple Choice $215,950. $274,225. $142,450. $200,725. $129,500.
Primary Co. has budgeted sales of $228,000 in October and $312,000 in November. The company expects it will collect 70% of cash from sales in the month of the sale. The remaining 30% of cash will be collected the next month. What is the expected cash to be collected in November? $68,400 $286,800 $312,000 $253,200
Markham Company has completed its sales budget for the first quarter of Year 2. Projected credit sales for the first four months of the year are shown below: January February March April $ 20,000 $ 26,000 $ 35,000 $ 38,000 The company's past records show collection of credit sales as follows: 40% in the month of sale and the balance in the following month. The total cash collection from receivables in March is expected to be: Multiple Choice $29,600. $22,100. $31,850. $35,000.
Timpco, a retailer, makes both cash and credit sales (i.e., sales on open account). Information regarding budgeted sales for the last quarter of the year is as follows: October November December Cash sales $ 80,000 $ 71,000 $ 83,000 Credit sales 80,000 85,200 91,300 Total $ 160,000 $ 156,200 $ 174,300 Past experience shows that 5% of credit sales are uncollectible. Of the credit sales that are collectible, 60% are collected in the month of sale; the remaining 40% are collected in the month following the month of sale. Customers are granted a 1.5% discount for payment within 10 days of billing. Approximately 75% of collectible credit sales take advantage of the cash discount. Inventory purchases each month are 100% of the cost of the following month’s projected sales. (The gross profit rate for Timpco is approximately 30%.) All merchandise purchases are made on credit, with 20% paid in the month of purchase and the remainder paid in the following month. No cash discounts…
Hunt Company's sales, based on past experience, are 30% cash and 70% credit. Credit sales are typically collected as follows: 40% in the month of sale, 50% in the month after the sale, and 10% in the second month following month of sale. On December 31, the accounts receivable balance is $69,000, of which $24,000 is from November sales. Total sales for January and February are budgeted to be $110,000 and $130,000, respectively. What are Hunt Company's budgeted cash receipts for January? Multiple Choice $79,500. $92,500. $95,800. $112,500. $125,300.
Farm Supply Company's budgeted monthly sales are as follows: April $780,000, May $560,000, and June $900,000. Sales are 60% cash and 40% on account. Farm Supply collects all its accounts receivable in the month following the sale. Cost of goods sold is budgeted at 75% of sales and ending inventory is budgeted at 20% of the next 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 Farm Supply's budgeted cash collections for the month of May? O $336,000 O $414,000 O $648,000 O $747,000 O None of the above
Treasure Service anticipates the following sales revenue over a five-month period: Its collection history indicates that credit sales are collected as follows: E (Click the icon to view the sales data.) A (Click the icon to view the collections data.) The company's sales are 20% cash and 80% credit. How much cash will be collected in Janua More Info 25% in the month of the sale 50% in the month after the sale Complete the cash budget to determine how much cash will be collected in January, February, March and for the quarter in total. (Round your answers to the nearest whole do 20% two months after the sale Treasure Service 5% are never collected Cash Collections Budget For the Months of January through March January Data Table Print Done Cash sales Collection of credit sales: 25% Month of sale November December January February March 50% Month after Sales revenue....... 16,100 $ 10,000 $ 15,200 $ 12,000 $ 14,200 20% Two months after Total cash collections Print Done
Spana Company has the following data: Total Monthly Purchasing Budget MONTH Budgeted purchases January 220,000 february 185,000 march 240,000 april 155,000 may 180,000 Purchases are paid as follows: * 10% in the month of purchase. * 60% one month after purchase * 30% two months after purchase Required: 1. Develop a schedule of cash disbursements for purchases for March, April and May.
s
Cloudy Company had the following historical collection pattern for its credit sales: 75% collected in the month of sale 12% collected in the first month after month of sale 8% collected in the second month after month of sale 3% collected in the third month after month of sale 2% uncollectible The sales on open account (credit sales) have been budgeted for the last six months of the year as shown below: $ 81,000 $ 93,000 $ 105,000 $ 117,000 $ 129,000 $ 111,000 July August September October November December The estimated total cash collections by Cloudy Company during November from collection of accounts receivable is:
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: September October November $89,000 $109,000 $146,000 37,000 47,000 31,000 33,000 Sales Manufacturing costs Selling and administrative expenses Capital expenditures 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 $7,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 $34,000, marketable…
Please help me