The Francine Company, a merchandising firm, has planned the following sales for the next four months: March April May June Total budgeted sales... 50,000 70,000 90,000 60,000 Sales are made 40% for cash and 60% on account. From experience, the company has learned that a month's sales on account are collected according to the following pattern: Month of sale 70% First month following month of sale 20% Second month following month of sale 8% Uncollectible 2% The company requires a minimum cash balance of $4,000 to start a month. Required: A. Compute the budgeted cash receipts for June. B. Assume the following budgeted data for June: Purchases.. P52,000 Selling and administrative expenses....... 10,000 Depreciation 8,000 Equipment purchases 15,000 Cash balance, beginning of June. 6,000 Using this data, along with your answer to part (1) above, prepare a cash budget in good form for June. Clearly show any borrowing needed during the month. The company can borrow in any dollar amount, but will not pay any interest until the following month.

The Francine Company, a merchandising firm, has planned the following sales for the next four months: March April May June Total budgeted sales... 50,000 70,000 90,000 60,000 Sales are made 40% for cash and 60% on account. From experience, the company has learned that a month's sales on account are collected according to the following pattern: Month of sale 70% First month following month of sale 20% Second month following month of sale 8% Uncollectible 2% The company requires a minimum cash balance of $4,000 to start a month. Required: A. Compute the budgeted cash receipts for June. B. Assume the following budgeted data for June: Purchases.. P52,000 Selling and administrative expenses....... 10,000 Depreciation 8,000 Equipment purchases 15,000 Cash balance, beginning of June. 6,000 Using this data, along with your answer to part (1) above, prepare a cash budget in good form for June. Clearly show any borrowing needed during the month. The company can borrow in any dollar amount, but will not pay any interest until the following month.

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

Need help with this
Milo Company manufactures beach umbrellas. The company is preparing budgets for the third quarter and assembled the following information: The Marketing Department estimated unit sales as follows for the remainder of the year:July 33,000 October 23,000August 76,000 November 9,500September 45,000 December 10,000The selling price of the beach umbrellas is $15 per unit. All sales are on account. Based on past experience, sales are collected in the following pattern:30% in the month of sale65% in the month following sale5% uncollectibleSales for June totaled $375,000. The company maintains finished goods inventories equal to 15% of the following month’s sales. This requirement will be met at the end of June.Each beach umbrella requires 4 feet of Gilden, a material that is sometimes hard to acquire. Therefore, the company requires ending inventory of Gilden equal to 50% of the following month’s production needs. The inventory of Gilden on hand at the…
Down Under Products, Limited, of Australla has budgeted sales of its popular boomerang for the next four months as follows: April May June July Unit Sales 58,000 75,000 98,000 84,000 The company is now in the process of preparing a production budget for the second quarter. Past experience has shown that end-of- month Inventory levels must equal 15% of the following month's unit sales. The Inventory at the end of March was 8,700 units. Required: Prepare a production budget by month and in total, for the second quarter. Budgeted unit sales Total needs Required production in units Down Under Products, Limited, Production Budget April 0 0 May 0 0 June 0 0 Quarter 0 0
Milo Company manufactures beach umbrellas. The company is preparing budgets for the third quarter and assembled the following information: The Marketing Department estimated unit sales as follows for the remainder of the year:July 33,000 October 23,000August 76,000 November 9,500September 45,000 December 10,000The selling price of the beach umbrellas is $15 per unit. All sales are on account. Based on past experience, sales are collected in the following pattern:30% in the month of sale65% in the month following sale5% uncollectibleSales for June totaled $375,000. The company maintains finished goods inventories equal to 15% of the following month’s sales. This requirement will be met at the end of June.Each beach umbrella requires 4 feet of Gilden, a material that is sometimes hard to acquire. Therefore, the company requires ending inventory of Gilden equal to 50% of the following month’s production needs. The inventory of Gilden on hand at the…
ABC produces Goods for resale at throughout America. The company is currently in the process of establishing a master budget on a quarterly basis for this coming fiscal year, which ends December 31. Prioryear quarterly sales were as follows;First quarter 14,000 unitsSecond quarter 6,000 unitsThird quarter 8,000 unitsFourth quarter 4,000 unitsUnit sales are expected to increase 20 percent, and each unit is expected to sell for $1. The management prefers to maintain ending finished goods inventory equal to 10 percent of next quarter’s sales. Assume finished goods inventory at the end of the fourth quarter budget period is estimated to be 2,000 units. The beginning inventory was 1000 units. Direct Materials Purchases Budget InformationEach unit of product requires 1.5 pounds of direct materials per unit, and the cost of direct materials is $1 per pound. Management prefers to maintain ending raw materials inventory equal to 30 percent of next quarter’s materials needed in production.…
Dhapa
Silver Company makes a product that is very popular as a Mother's Day gift. Thus, peak sales occur in May of each year, as shown in the company's sales budget for the second quarter given below: April $ 430,000 Мay $ 630,000 June Total Budgeted sales (all on account) $ 200,000 $ 1,260,000 From past experience, the company has learned that 25% of a month's sales are collected in the month of sale, another 60% are collected in the month following sale, and the remaining 15% are collected in the second month following sale. Bad debts are negligible and can be ignored. February sales totaled $360,000, and March sales totaled $390,000. Required: 1. Prepare a schedule of expected cash collections from sales, by month and in total, for the second quarter. 2. What is the accounts receivable balance on June 30th? Complete this question by entering your answers in the tabs below. Required 1 Required 2 Prepare a schedule of expected cash collections from sales, by month and in total, for the…
Beckett Manufacturing produces self-watering planters for use in upscale retail establishments. Sales projections for the first five months of the upcoming year show the estimated unit sales of the planters each month to be as follows: (Click the icon to view additional information.) Inventory at the start of the year was 850 planters. The desired inventory of planters at the end of each month should be equal to 25% of the following month's budgeted sales. Each planter requires four pounds of polypropylene (a type of plastic). The company wants to have 20% of the polypropylene required for next month's production on hand at the end of each month. The polypropylene costs $0.10 per pound. Read the requirements. Data table For the Months of January through March January February March Quarter Number of planters to be sold Units to be produced 3,425 3,400 3,525 10,350 January. 3,400 4 Multiply by: Quantity of direct materials needed per unit Quantity needed for production February 3,500…
Solve this question with steps please. The subject is Managerial Accounting.
Spacely Sprockets' sales budget shows the following expected total sales: Month January February March April Sales $31,700 $41,700 $36,700 $31,700 The company expects 80% of its sales to be on account (credit sales). Credit sales are collected as follows: 30% In the month of sale and 68% In the month following the sale, with the remainder being uncollectible and written off in the month following the sale. Required: a. Calculate budgeted accounts receivable at the end of each month from February through April. b. Calculate budgeted cash Inflows from collection of receivables for each month from February through April. Note: Round your Intermediate calculations and final answers to the nearest whole dollar amount. a. Budgeted accounts receivable Answer is not complete. b. Budgeted cash inflows from collection of receivables February March April S 17,752 S 23,352 $ 20,552
Harris Inc., has budgeted sales in units for the next five months as follows: June July August September October 9,400 units 7,800 units 7,300 units 5,400 units 4,100 units Past experience has shown that the ending inventory for each month should be equal to 20% of the next month's sales in units. The inventory on May 31 contained 1,880 units. The company needs to prepare a production budget for the next five months.
Help me please