Lexi Company forecasts unit sales of 1,120,000 in April, 1,290,000 in May, 110,000 in June, and...

Transcribed Image Text:

Lexi Company forecasts unit sales of 1,120,000 in April, 1,290,000 in May, 110,000 in June, and 1,610,000 in July. Beginning inventory on April 1 is 190,000 units, and the company wants to have 20% 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 May June 1,610,000 110,000 Next month's budgeted sales (units) Ratio of inventory to future sales Budgeted ending inventory (units) 20% 20% 22,000 322,000 Budgeted units sales for month 132,000 1,932,000 Required units of available inventory 154,000 2,254,000 Beginning inventory (units) Units to be purchased 1,290,000 20% 258,000 1,548,000 1,806,000 190,000 Lexi Company forecasts unit sales of 1,120,000 in April, 1,290,000 in May, 110,000 in June, and 1,610,000 in July. Beginning inventory on April 1 is 190,000 units, and the company wants to have 20% 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 May June 1,610,000 110,000 Next month's budgeted sales (units) Ratio of inventory to future sales Budgeted ending inventory (units) 20% 20% 22,000 322,000 Budgeted units sales for month 132,000 1,932,000 Required units of available inventory 154,000 2,254,000 Beginning inventory (units) Units to be purchased 1,290,000 20% 258,000 1,548,000 1,806,000 190,000

Answer rating: 100% (QA)

LEXI COMPANY Production budget For April May and June April May June Next month B... View the full answer