The LaPann Corporation has obtained the following sales forecast data: Cash sales Credit sales July August September $ 80,000 $70,000 $50,000 $ 240,000 $220,000 $180,000 October $60,000 $ 200,000 The regular pattern of collection of credit sales is 30% in the month of sale, 70% in the month following the month of sale. There are no bad debts. The total budgeted cash collections in August would be: Multiple Choice $366,000 $198.000 $296,000 $304,000 $268,000

The LaPann Corporation has obtained the following sales forecast data: Cash sales Credit sales July August September $ 80,000 $70,000 $50,000 $ 240,000 $220,000 $180,000 October $60,000 $ 200,000 The regular pattern of collection of credit sales is 30% in the month of sale, 70% in the month following the month of sale. There are no bad debts. The total budgeted cash collections in August would be: Multiple Choice $366,000 $198.000 $296,000 $304,000 $268,000

Principles of Accounting Volume 2

19th Edition

ISBN:9781947172609

Author:OpenStax

Publisher:OpenStax

Chapter7: Budgeting

Section: Chapter Questions

Problem 14EA: Halifax Shoes has 30% of its sales in cash and the remainder on credit. Of the credit sales, 65% is...

See similar textbooks

Similar questions

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
The sales department of Macro Manufacturing Co. has forecast sales for its single product to be 20,000 units for June, with three-quarters of the sales expected in the East region and one-fourth in the West region. The budgeted selling price is 25 per unit. The desired ending inventory on June 30 is 2,000 units, and the expected beginning inventory on June 1 is 3,000 units. Prepare the following: a. A sales budget for June. b. A production budget for June.
Carmichael Corporation is in the process of preparing next years budget. The pro forma income statement for the current year is as follows: Required: 1. What is the break-even sales revenue (rounded to the nearest dollar) for Carmichael Corporation for the current year? 2. For the coming year, the management of Carmichael Corporation anticipates an 8 percent increase in variable costs and a 60,000 increase in fixed expenses. What is the break-even point in dollars for next year? (CMA adapted)
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 Feinberg Company is gathering data to prepare the cash budget for July. He plans to develop the budget from the following information: a. Of all sales, 40% are cash sales. b. Of credit sales, 45% are collected within the month of sale. Half of the credit sales collected within the month receive a 2% cash discount (for accounts paid within 10 days). Thirty percent of credit sales are collected in the following month; remaining credit sales are collected the month thereafter. There are virtually no bad debts. c. Sales for the second two quarters of the year follow. (Note: The first 3 months are actual sales, and the last 3 months are estimated sales.) d. The company sells all that it produces each month. The cost of raw materials equals 26% of each sales dollar. The company requires a monthly ending inventory of raw materials equal to the coming months production requirements. Of raw materials purchases, 50% is paid for in the month of purchase. The remaining 50% is paid for in the following month. e. Wages total 105,000 each month and are paid in the month incurred. f. Budgeted monthly operating expenses total 376,000, of which 45,000 is depreciation and 6,000 is expiration of prepaid insurance (the annual premium of 72,000 is paid on January 1). g. Dividends of 130,000, declared on June 30, will be paid on July 15. h. Old equipment will be sold for 25,200 on July 4. i. On July 13, new equipment will be purchased for 173,000. j. The company maintains a minimum cash balance of 20,000. k. The cash balance on July 1 is 27,000. Required: Prepare a cash budget for July. Give a supporting schedule that details the cash collections from sales.
Shalimar Company manufactures and sells industrial products. For next year, Shalimar has budgeted the follow sales: In Shalimars experience, 10 percent of sales are paid in cash. Of the sales on account, 65 percent are collected in the quarter of sale, 25 percent are collected in the quarter following the sale, and 7 percent are collected in the second quarter after the sale. The remaining 3 percent are never collected. Total sales for the third quarter of the current year are 4,900,000 and for the fourth quarter of the current year are 6,850,000. Required: 1. Calculate cash sales and credit sales expected in the last two quarters of the current year, and in each quarter of next year. 2. Construct a cash receipts budget for Shalimar Company for each quarter of the next year, showing the cash sales and the cash collections from credit sales. 3. What if the recession led Shalimars top management to assume that in the next year 10 percent of credit sales would never be collected? The expected payment percentages in the quarter of sale and the quarter after sale are assumed to be the same. How would that affect cash received in each quarter? Construct a revised cash budget using the new assumption.
Cash collections for Renew Lights found that 65% of sales were collected in the month of sale, 25% was collected the month after the sale, and 10% was collected the second month after the sale. Given the sales shown, how much cash will be collected in March and April?
The data shown were obtained from the financial records of Italian Exports, Inc., for March: Sales are expected to increase each month by 10%. Prepare a budgeted income statement.
Compton Company expects the following total sales: Month Sales March $30,000 April $20,000 May $30,000 June $25,000 The company expects 60% of its sales to be credit sales and 40% for cash. Credit sales are collected as follows: 30% in the month of sale, 70% in the month following the sale. What is the budgeted accounts receivable balance on May 31?
Clay Co.'s projected sales are as follows: August $400,000 September $450,000 October $550,000 Clay estimates that it will collect 30% in the month of sale, 50% in the month after the sale, and 18% in the second month following the sale. Two percent of all sales are estimated to be bad debts. Instructions: How much are Clay Co.'s budgeted cash receipts for October?
Saathi forecast sales of P48,000 for the month of June and P55,000 for July. It has been assumed that 60% of the sales are for cash and remaining are credit sales. The customers pay in the month following the sale. Calculate budgeted cash receipts for the month of July.
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 $ 21,000 $ 27,000 $ 36,000 $ 39,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 О $30,600. ○ $22,920. $33,120. $36,000.