
Problem 22-5AA Merchandising: Preparation and analysis of purchases budgets LO P4 Keggler's Supply is a merchandiser...
Keggler’s Supply is a merchandiser of three different products. The company’s February 28 inventories are footwear, 20,000 units; sports equipment, 80,000 units; and apparel, 50,000 units. Management believes each of these inventories is too high. As a result, a new policy dictates that ending inventory in any month should equal 30% of the expected unit sales for the following month. Expected sales in units for March, April, May, and June follow. Budgeted Sales in Units March April May June...
Keggler’s Supply is a merchandiser of three different products. The company’s February 28 inventories are footwear, 21,000 units; sports equipment, 81,000 units; and apparel, 49,000 units. Management believes each of these inventories is too high. As a result, a new policy dictates that ending inventory in any month should equal 30% of the expected unit sales for the following month. Expected sales in units for March, April, May, and June follow. Budgeted Sales in Units March April May June Footwear...
Keggler’s Supply is a merchandiser of three different products.
The company’s February 28 inventories are footwear, 19,500 units;
sports equipment, 80,500 units; and apparel, 49,500 units.
Management believes each of these inventories is too high. As a
result, a new policy dictates that ending inventory in any month
should equal 29% of the expected unit sales for the following
month. Expected sales in units for March, April, May, and June
follow.
Budgeted Sales in Units
March
April
May
June
Footwear...
Keggler's Supply is a merchandiser of three different products. The company's February 28 inventories are footwear 20,500 units; sports equipment. 80,000 units and apparel, 49,500 units. Management believes each of these inventories is too high. As a result, a new policy dictates that ending Inventory in any month should equal 30% of the expected unit sales for the following month. Expected sales in units for March April May, and June Follow March 14.000 69.500 42,0 April 27.00 .000 18,500 May...
Problem 22-7AA Merchandising: Preparation and analysis of cash
budgets with supporting inventory and purchases budgets LO P4
Aztec Company sells its product for $160 per unit. Its actual
and budgeted sales follow.
Units
Dollars
April (actual)
4,000
$
640,000
May (actual)
2,800
448,000
June (budgeted)
4,500
720,000
July (budgeted)
3,500
719,000
August (budgeted)
4,100
656,000
All sales are on credit. Recent experience shows that 26% of credit
sales is collected in the month of the sale, 44% in the month...
Show transcribed image text
Problem 22-7AA Merchandising: Preparation and analysis of cash budgets with supporting inventory and purchases budgets LO P4 Aztec Company sells its product for $160 per unit. Its actual and budgeted sales follow. April (actual) May (actual) June (budgeted) July (budgeted) August (budgeted) Units 4,000 1,800 5,500 4,500 4,100 Dollars $ 640,000 288,000 880,000 879,000 656,000 All sales are on credit. Recent experience shows that 26% of credit sales is collected in the month of the sale,...
Need required 4 and 5 only **********
Problem 22-7AA Merchandising: Preparation and analysis of cash budgets with supporting Inventory and purchases budgets LO P4 Aztec Company sells its product for $150 per unit. Its actual and budgeted sales follow. April (actual) May (actual) June (budgeted) July (budgeted) August (budgeted) Units 3,500 2,400 5,500 4,500 4,400 Dollars $ 525,000 360,000 825,000 824,000 660,000 : All sales are on credit. Recent experience shows that 24% of credit sales is collected in the...
QS 22-29A Merchandising: Computing purchases LO P4 Lexi Company forecasts unit sales of 1,200,000 in April, 1,290,000 in May, 350,000 in June, and 1,100,000 in July. Beginning inventory on April 1 is 380,000 units, and the company wants to have 30% of next month's sales in inventory at the end of each month. Prepare a merchandise purchases budget for the months of April, May, and June. LEXI COMPANY Merchandise Purchases Budget For April, May, and June April Next month's budgeted...
Problem 22-8AA Merchandising: Preparation of a complete master budget LO P4 Near the end of 2017, the management of Dimsdale Sports Co., a merchandising company, prepared the following estimated balance sheet for December 31, 2017 DIMSDALE SPORTS COMPANY Estimated Balance Sheet December 31, 2017 Assets $35, 500 520, 000 Accounts receivable Inventory Total current assets 100, 000 $655, 500 Equipment Less: accumulated depreciation 600, 000 75, 000 Equipment, net 525, 000 $ 1, 180, 500 Total assets Li abili ties...
Problem 07-8AA Merchandising: Preparation of a complete master budget LO P4 Near the end of 2019, the management of Dimsdale Sports Co., a merchandising company, prepared the following estimated balance sheet for December 31, 2019. DIMSDALE SPORTS COMPANY Estimated Balance Sheet December 31, 2019 $ 35,000 520,000 157.500 712,500 552,000 69,000 483,000 $1,195,500 Cash Accounts receivable Inventory Total current assets Equipment Less: Accumulated depreciation Equipment, set Total assets Liabilities and Equity Accounta payable Bank loan payable Taxes payable dae 3/15/2020...