Abeng Corp, a rapidly-expanding crossbow distributor, is in the process of formulating plans for James Chambers, director of marketing, has completed his 2021 forecast and is confident that sales estimates will be met or exceeded. The following forecasted sales figures show the growth expected and will provide the planning basis for other corporate departments: Month Sales (units) Month Sales (units) January 7,200 July 12,000 February 8,000 August 11,000 March 7,200 September 12,800 April 8,800 October 13,600 May 10,000 November 12,000 June 11,200 December 14,000 Ellen Eglin, assistant controller, has been given responsibility for formulating the cash flow projections, a critical element during a period of rapid expansion. The following information will be used in preparing the cash analysis: Bows are sold at an average price of $150. Abeng has experienced an excellent record in accounts receivable collection and expects this trend to The company collects 30% of its billings in the month of sales, 50% in the first month following sale and the balance in the second month after sale. The purchase of crossbows is Abeng’s largest expenditure; the cost of these items is 55% of The company maintains an ending inventory equal to 60% of the next month’s requirements. Prior experience shows that 75% of accounts payable is paid by Abeng 1 month after purchase and 25% in the second month after Wages, including fringe benefits, are a function of sales volume and are equal to 15% of the current month’s Prepare the following for the third quarter of the year:Sales budget and the Schedule of cash collections

14th Edition

ISBN:9781337514835

Author:MOYER

Publisher:MOYER

Chapter12: The Cost Of Capital

Section: Chapter Questions

Problem 15P

Related questions

Question

100%

Abeng Corp, a rapidly-expanding crossbow distributor, is in the process of formulating plans for James Chambers, director of marketing, has completed his 2021 forecast and is confident that sales estimates will be met or exceeded. The following forecasted sales figures show the growth expected and will provide the planning basis for other corporate departments:

Ellen Eglin, assistant controller, has been given responsibility for formulating the cash flow

projections, a critical element during a period of rapid expansion. The following information will be used in preparing the cash analysis:

Bows are sold at an average price of $150.
Abeng has experienced an excellent record in accounts receivable collection and expects this trend to The company collects 30% of its billings in the month of sales, 50% in the first month following sale and the balance in the second month after sale.
The purchase of crossbows is Abeng’s largest expenditure; the cost of these items is 55% of The company maintains an ending inventory equal to 60% of the next month’s

requirements.

Prior experience shows that 75% of accounts payable is paid by Abeng 1 month after purchase and 25% in the second month after
Wages, including fringe benefits, are a function of sales volume and are equal to 15% of the current month’s