Homework Answers
| LEXI COMPANY | |||
| Merchandise Purchases Budget | |||
| For April, May and June | |||
| Next month budgeted sales (units) | 1,290,000 | 350,000 | 1,100,000 |
| Ratio of inventory to future sales | 30% | 30% | 30% |
| Ending inventory | 1,290,000 x 30% = 387,000 | 350,000 x 30% = 105,000 | 1,100,000 x 30% = 330,000 |
| Sales units | 1,200,000 | 1,290,000 | 350,000 |
| Required units of available inventory | 1,587,000 | 1,395,000 | 680,000 |
| Beginning inventory | -380,000 | -387,000 | -105,000 |
| Units to be purchased | $1,207,000 | $1,008,000 | $575,000 |
Kindly give a positive rating if you are satisfied with this solution and please ask if you have any query.
Thanks
Add Answer to:
QS 22-29A Merchandising: Computing purchases LO P4 Lexi Company forecasts unit sales of 1,200,000 in April,...
Lexi Company forecasts unit sales of 1,680,000 in April, 1.290,000 in May. 520,000 in June, and...
Lexi Company forecasts unit sales of 1,680,000 in April, 1.290,000 in May. 520,000 in June, and 1710,000 in July. Beginning inventory on April 1is 230,000 units, and the company wants to have 40% 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 sales (units) 1.290.000 Ratio of inventory to future...
Lexi Company forecasts unit sales of 1,750,000 in April, 1,260,000 in May, 490,000 in June, and...
Lexi Company forecasts unit sales of 1,750,000 in April, 1,260,000 in May, 490,000 in June, and 1,530,000 in July. Beginning inventory on April 1 is 330,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.
QS 22-27A Merchandising: Cash payments for merchandise LO P4 Torres Co. forecasts merchandise purchases of $14,800...
QS 22-27A Merchandising: Cash payments for merchandise LO P4
Torres Co. forecasts merchandise purchases of $14,800 in
January, $17,600 in February, and $20,200 in March; 50% of
purchases are paid in the month of purchase and 50% are paid in the
following month. At December 31 of the prior year, the balance of
Accounts Payable (for December purchases) is $28,000.
Prepare a schedule of cash payments for merchandise for each of the
months of January, February, and March.
QS 22-27A...
QS 22-30A Merchandising: Purchases budget LO P4 Montel Company's July sales budget calls for sales of...
QS 22-30A Merchandising: Purchases budget LO P4 Montel Company's July sales budget calls for sales of $530,000. The store expects to begin July with $66,000 of inventory and to end the month with $37.000 of inventory. Gross margin is typically 30% of sales. Determine the budgeted cost of merchandise purchases for July MONTEL COMPANY Computation of Budgeted Cost of Purchases For Month Ended July 31 Budgeted cost of goods sold $ 530,000 Budgeted ending inventory Required available merchandise Budgeted beginning...
QS 22-27A Merchandising: Cash payments for merchandise LO P4 Torres Co. forecasts merchandise purchases of $16,800 in J...
QS 22-27A Merchandising: Cash payments for merchandise LO P4 Torres Co. forecasts merchandise purchases of $16,800 in January, $17,600 in February, and $21,200 in March; 50% of purchases are paid in the month of purchase and 50% are paid in the following month. At December 31 of the prior year, the balance of Accounts Payable (for December purchases) is $22,000. Prepare a schedule of cash payments for merchandise for each of the months of January, February, and March. TORRES CO....
Problem 22-5AA Merchandising: Preparation and analysis of purchases budgets LO P4 Keggler's Supply is a merchandiser...
Problem 22-5AA Merchandising: Preparation and analysis of purchases budgets LO P4 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...
Problem 22-7AA Merchandising: Preparation and analysis of cash budgets with supporting inventory and purchases budgets LO...
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...
Aztec Company sells its product for $190 per unit its actual and budgeted sales to low....
Aztec Company sells its product for $190 per unit its actual and budgeted sales to low. Units Dollars $950,000 Aprill (actual) May (actual) June (budgeted) July (budgeted) August (budgeted) 5.000 2,000 7,500 6,000 4,300 380,000 1.425,000 1.140,000 817,000 All sales are on credit. Recent experience shows that 20% of credit sales is collected in the month of the sale, 50% in the month after the sale, 29% in the second month after the sale, and 1% proves to be uncollectible....
QS 7-12 Manufacturing: Production budget LO P1 Champ, Inc., predicts the following sales in units for...
QS 7-12 Manufacturing: Production budget LO P1 Champ, Inc., predicts the following sales in units for the coming two months May June 200 Sales in units 280 Each month's ending inventory of finished units should be 60% of the next month's sales. The April 30 finished goods inventory is 120 units. Compute Champ's budgeted production (in units) for May CHAMP, INC. Production Budget For Month Ended May 31 Next month's budgeted sales (units) 280 Ratio of inventory to future sales...
Show transcribed image text Problem 22-7AA Merchandising: Preparation and analysis of cash budgets with supporting inventory...
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,...
Lexi Company forecasts unit sales of 1,680,000 in April, 1.290,000 in May. 520,000 in June, and 1710,000 in July. Beginning inventory on April 1is 230,000 units, and the company wants to have 40% 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 sales (units) 1.290.000 Ratio of inventory to future...
QS 22-27A Merchandising: Cash payments for merchandise LO P4
Torres Co. forecasts merchandise purchases of $14,800 in
January, $17,600 in February, and $20,200 in March; 50% of
purchases are paid in the month of purchase and 50% are paid in the
following month. At December 31 of the prior year, the balance of
Accounts Payable (for December purchases) is $28,000.
Prepare a schedule of cash payments for merchandise for each of the
months of January, February, and March.
QS 22-27A...
QS 22-30A Merchandising: Purchases budget LO P4 Montel Company's July sales budget calls for sales of $530,000. The store expects to begin July with $66,000 of inventory and to end the month with $37.000 of inventory. Gross margin is typically 30% of sales. Determine the budgeted cost of merchandise purchases for July MONTEL COMPANY Computation of Budgeted Cost of Purchases For Month Ended July 31 Budgeted cost of goods sold $ 530,000 Budgeted ending inventory Required available merchandise Budgeted beginning...
QS 22-27A Merchandising: Cash payments for merchandise LO P4 Torres Co. forecasts merchandise purchases of $16,800 in January, $17,600 in February, and $21,200 in March; 50% of purchases are paid in the month of purchase and 50% are paid in the following month. At December 31 of the prior year, the balance of Accounts Payable (for December purchases) is $22,000. Prepare a schedule of cash payments for merchandise for each of the months of January, February, and March. TORRES CO....
Problem 22-5AA Merchandising: Preparation and analysis of purchases budgets LO P4 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...
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...
Aztec Company sells its product for $190 per unit its actual and budgeted sales to low. Units Dollars $950,000 Aprill (actual) May (actual) June (budgeted) July (budgeted) August (budgeted) 5.000 2,000 7,500 6,000 4,300 380,000 1.425,000 1.140,000 817,000 All sales are on credit. Recent experience shows that 20% of credit sales is collected in the month of the sale, 50% in the month after the sale, 29% in the second month after the sale, and 1% proves to be uncollectible....
QS 7-12 Manufacturing: Production budget LO P1 Champ, Inc., predicts the following sales in units for the coming two months May June 200 Sales in units 280 Each month's ending inventory of finished units should be 60% of the next month's sales. The April 30 finished goods inventory is 120 units. Compute Champ's budgeted production (in units) for May CHAMP, INC. Production Budget For Month Ended May 31 Next month's budgeted sales (units) 280 Ratio of inventory to future sales...
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,...
Most questions answered within 3 hours.
-
You capture data by having 8 people fill in 30 small dots on a
piece of...
asked 3 hours ago -
What are the z-values such that 70% of the area lies in the
middle of the...
asked 5 hours ago -
You borrow $29,500 to purchase a brand new car. The interest
rate is 6%, and the...
asked 5 hours ago -
The amount of time it takes an asteroid, whose average distance
from the Sun is 4.70...
asked 5 hours ago -
A 0.289 kg mass slides on a frictionless floor with a speed of
1.34 m/s. The...
asked 5 hours ago -
15.A box contains five red balls, three green balls, and two
yellow balls. Suppose you select...
asked 8 hours ago -
Assume you are given the following for Stackelberg industries:
Return on Assets (ROA) = 8%
Debt...
asked 6 hours ago -
an engineer proposes to use mmWave in 5G network to
increase data rate.
What are the...
asked 6 hours ago -
Explain the idea behind using SEMIJOIN in distributed
query processing.
asked 6 hours ago -
why
is context important in selecting and applying guidelines and
principles for interface design?
illustrate your...
asked 6 hours ago -
In a certain board game, a player rolls two fair six-sided dice
until the player rolls...
asked 8 hours ago -
You are going to deposit $3,200 in an account that pays .58
percent interest compounded quarterly....
asked 6 hours ago