Lexi Company forecasts unit sales of 1,120,000 in April, 1,290,000 in May, 110,000 in June, and...
Fantastic news! We've Found the answer you've been seeking!
Question:
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
Expert Answer:
Answer rating: 100% (QA)
LEXI COMPANY Production budget For April May and June April May June Next month B... View the full answer
Related Book For
Fundamental accounting principle
ISBN: 978-0078025587
21st edition
Authors: John J. Wild, Ken W. Shaw, Barbara Chiappetta
Posted Date:
Students also viewed these accounting questions
-
Lexi Company forecasts unit sales of 1,040,000 in April, 1,220,000 in May, 980,000 in June, and 1,020,000 in July. Beginning inventory on April 1 is 280,000 units, and the company wants to have 30%...
-
Li Company forecasts unit sales of 640,000 in April, 720,000 in May, 780,000 in June, and 620,000 in July. Beginning inventory on April 1 is 192,000 units, and the company wants to have 30% of next...
-
July 1 Purchased merchandise from Boden Company for $6,000 under credit terms of 1/15, n/30, FOB shipping point, invoice dated July 1. 2 Sold merchandise to Creek Co. for $900 under credit terms of...
-
Explain why placing soy sauce in airtight bottles was more successful for long-distance shipping than simply placing the sauce in barrels.
-
The following information describes production activities of Mercer Manufacturing for the year: Actual raw materials used . . . . . . . . . 16,000 lbs. at $ 4.05 per lb. Actual factory payroll . . ....
-
The SAT subject tests in chemistry and physics for two groups of 15 students each electing to take these tests are given below. To use the two-sample t-test with a pooled estimate of 2, you must...
-
Using the following data for Evans \& Sons, calculate the cash paid for merchandise purchased: Cost of goods sold. Inventory, January 1. Inventory, December 31 $128,000 19,000 22,000 Accounts...
-
Phung, CPA, has been engaged to audit the financial statements of Vernon Distributors, Inc., a continuing audit client, for the year ended September 30. After obtaining an understanding of Vernons...
-
for this injection, which of the pictured syringes would be a good option?
-
Ben Hallmark, the owner of Hallmark Surveying Services, has been in business for two years. The unadjusted trial balance at December 31, regarding the month just ended, follows. The following...
-
You ran a little short on your break vacation, so you put $1,000 on your credit card. You can afford only the minimum payment of $20 per month. The credit card carries an APR of 18 percent compounded...
-
Belian Sdn Bhd developed the following standard unit costs at 100% of its normal production capacity, which is 50,000 units per year : RM Direct materials Direct labour Variable factory overhead...
-
Momo is producing earrings and other DIY products. Momo always has it's own special product every month. In February, Momo produces it's signature earrings called Bloom, the earrings only produce in...
-
1. Determine the appropriate conflict resolution style by analyzing the conflict with the questions/prompts on The Thomas-Kilmann Conflict Resolution Grid ( 500 Words).
-
4. (5 points) The S&P 500 index is currently trading at 3,000. A large proportion of stocks in this index pay dividends. You are given the following information on 1 year European options on the...
-
QUESTION 13 A project has an initial cost of $91,791, and promises to pay a fixed cash flow per year for 3 years. It has been determined that using a discount rate of 13.1 percent, its net present...
-
Problem 3- The equation of motion for the free vibration of a SDOF system is given by: X(t) A sin (wat + 0) This response has been plotted and shown in the figure below. By using the graph shown...
-
Explain the term global capital markets. This chapter primarily discusses global equity markets. What other types of financial instruments are traded in these markets? How important are global...
-
After evaluating Null Companys manufacturing process, management decides to establish standards of 3 hours of direct labor per unit of product and $ 15 per hour for the labor rate. During October,...
-
KTM aims to give its managers timely cost re-ports. In responsibility accounting, who receives timely cost reports and specific cost information? Explain.
-
On May 1, 2013, Brussels Enterprises issues bonds dated January 1, 2013, that have a $3,400,000 par value, mature in 20 years, and pay 9% interest semiannually on June 30 and December 31. The bonds...
-
Perkins Appliance & Furniture Company has two departments, appliances and furniture. Operating information for 2016 appears below. Common operating expenses of the firm were \($180,000\) . Required...
-
The cutting department of Liberty Manufacturing Company operated during September 2016 with the following manufacturing overhead cost budget based on 6,000 hours of monthly productive capacity: The...
-
The following information was obtained from the ledger of Stillwell Emporium, Inc., at the end of 2016: Stillwell analyzes its operating expenses at the end of each period in order to prepare an...
Study smarter with the SolutionInn App