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

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…
Vishnu
Kimball Company manufactures drinking glasses. One unit is a package of eight glasses, which sells for $24. Kimball projects sales for April will be 2,500 packages, with sales increasing by 200 packages per month for May, June, and July. On April 1, Kimball has 100 packages on hand but desires to maintain an ending inventory of 20% of the next month's sales. Prepare a sales budget and a production budget for Kimball for April, May, and June. Begin by preparing a sales budget for April, May, and June. Kimball Company Sales Budget April, May, and June April May Budgeted packages to be sold Sales price per package Total sales 697 2,500 2,700 24 $ 60,000 $ 64,800 24 $ $ June 2,900 Total 8,100 24 24 $ 69,600 $ 194,400
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.…
The Company has budgeted unit sales for the next four months as follows: October 4,800 units November 5,800 units December 6,400 units January 5,200 units The ending inventory for each month should be equal to 15% of the next month's sales in units. The inventory on September 30 was below this level and contained only 600 units. What are the total units to be produced in October?
Vishnu
Dhapa
Silver Company makes a product with peak sales in May of each year. Its sales budget for the second quarter is given below: April May June Total Budgeted sales (all on account) $300,000 $500,000 $200,000 $1,000,000 The company estimates 20% of a month's sales are collected in the month of sale, another 70% are collected in the month following sale, and the remaining 10% are collected in the second month following sale. Bad debts are negligible and can be ignored. February sales totaled $230, 000, and March sales totaled $260,000. Required: Prepare a schedule of expected cash collections from sales, by month and in total, for the second quarter. What is the accounts receivable balance on June 30th?
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…