Question

Lakeside Components wishes to purchase parts in one month for sale in the next. On May...

Lakeside Components wishes to purchase parts in one month for sale in the next. On May 31, the company has 12,000 parts in stock, although sales for the next month (June) are estimated to total 11,600 parts. Total sales of parts are expected to be 10,600 in July and 9,800 in August. Parts are purchased at a wholesale price of $30. The supplier has a financing arrangement by which Lakeside Components pays 50 percent of the purchase price in the month when the parts are delivered and 50 percent in the following month. Lakeside purchased 16,000 parts in May.

Required:

a. Estimate purchases (in units) for June and July.

b. Estimate the cash required to make purchases in June and July.

Homework Answers

Answer #1
a. Lakeside Components
Estimated Purchases
For the Months of June and July
June July
Budgeted sales (units) 11600 10600
Budgeted ending inventory (units) 10600 9800
Total quantity required (units) 22200 20400
Beginning inventory (units) 12000 10600
Estimated purchases (units) 10200 9800
Price per unit $ $    30.00 $    30.00
Total cost of estimated purchases $ 306000 294000
b. Lakeside Components
Schedule of Estimated Cash Requirement for Purchases
For the Months of June and July
June July
Estimated purchases $ 306000 294000
Cash disbursements for:
May purchases (16000 x $30 x 50%) 240000
June purchases 153000 153000
July purchases 147000
Total estimated cash requirement for purchases $ 393000 300000
Know the answer?
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Not the answer you're looking for?
Ask your own homework help question
Similar Questions
Lakeside Components wishes to purchase parts in one month for sale in the next. On June...
Lakeside Components wishes to purchase parts in one month for sale in the next. On June 1, the company has 9,000 parts in stock, although sales for June are estimated to total 12,200 parts. Total sales of parts are expected to be 10,100 in July and 11,800 in August. Parts are purchased at a wholesale price of $25. The supplier has a financing arrangement by which Lakeside Components pays 50 percent of the purchase price in the month when the...
Lakeside Components wishes to purchase parts in one month for sale in the next. On June...
Lakeside Components wishes to purchase parts in one month for sale in the next. On June 1, the company has 12,000 parts in stock, although sales for June are estimated to total 11,000 parts. Total sales of parts are expected to be 11,000 in July and 10,500 in August. Parts are purchased at a wholesale price of $25. The supplier has a financing arrangement by which Lakeside Components pays 60 percent of the purchase price in the month when the...
Lakeside Components wishes to purchase parts in one month for sale in the next. On June...
Lakeside Components wishes to purchase parts in one month for sale in the next. On June 1, the company has 14,000 parts in stock, although sales for June are estimated to total 10,000 parts. Total sales of parts are expected to be 12,800 in July and 11,400 in August. Parts are purchased at a wholesale price of $20. The supplier has a financing arrangement by which Lakeside Components pays 60 percent of the purchase price in the month when the...
Month Sales Purchases Cash Expenses Paid May $ 94,000 $ 61,000 $ 18,000 June 116,000 90,000...
Month Sales Purchases Cash Expenses Paid May $ 94,000 $ 61,000 $ 18,000 June 116,000 90,000 26,000 July 135,000 114,000 37,750 August 134,000 70,000 30,800 The majority of Martin’s sales (65 percent) are cash, but a few of the excursion companies purchase on credit. Of the credit sales, 35 percent are collected in the month of sale and 65 percent are collected in the following month. All of Martin’s purchases are on account with 50 percent paid in the month...
Clinton Retailers expects to make inventory purchases in the next quarter as follows: April $58,400 May...
Clinton Retailers expects to make inventory purchases in the next quarter as follows: April $58,400 May 69,800 June 95,500 Prior experience has shown that 80 percent of a month’s purchases are paid in the month of purchase and 20 percent are paid in the month following purchase. March purchases were $52,300. Estimate cash disbursements related to purchases for April, May, and June. Cash disbursements for purchases April May June Payment of March purchases $ $ $ Payment of April purchases...
Croy Inc. has the following projected sales for the next five months: Month Sales in Units...
Croy Inc. has the following projected sales for the next five months: Month Sales in Units April 3,580 May 3,890 June 4,540 July 4,110 August 3,990 Croy’s finished goods inventory policy is to have 50 percent of the next month’s sales on hand at the end of each month. Direct materials costs $2.70 per pound, and each unit requires 2 pounds. Direct materials inventory policy is to have 50 percent of the next month’s production needs on hand at the...
Croy Inc. has the following projected sales for the next five months: Month Sales in Units...
Croy Inc. has the following projected sales for the next five months: Month Sales in Units April 3,430 May 3,840 June 4,550 July 4,105 August 3,950 Croy’s finished goods inventory policy is to have 50 percent of the next month’s sales on hand at the end of each month. Direct materials costs $3.20 per pound, and each unit requires 2 pounds. Direct materials inventory policy is to have 50 percent of the next month’s production needs on hand at the...
Paul’s Pool Service provides pool cleaning, chemical application, and pool repairs for residential customers. Clients are...
Paul’s Pool Service provides pool cleaning, chemical application, and pool repairs for residential customers. Clients are billed weekly for services provided and usually pay 60 percent of their fees in the month the service is provided. In the month following service, Paul collects 35 percent of service fees. The final 5 percent is collected in the second month following service. Paul purchases his supplies on credit, and pays 50 percent in the month of purchase and the remaining 50 percent...
Furry Friends Supplies Inc., a pet wholesale supplier, was organized on May 1. Projected sales for...
Furry Friends Supplies Inc., a pet wholesale supplier, was organized on May 1. Projected sales for each of the first three months of operations are as follows: May $210,000 June 250,000 July 360,000 All sales are on account. 50 percent of sales are expected to be collected in the month of the sale, 38% in the month following the sale, and the remainder in the second month following the sale. Prepare a schedule indicating cash collections from sales for May,...
Croy Inc. has the following projected sales for the next five months:    Month Sales in...
Croy Inc. has the following projected sales for the next five months:    Month Sales in Units April 3,570 May 3,890 June 4,510 July 4,110 August 4,000 Croy’s finished goods inventory policy is to have 60 percent of the next month’s sales on hand at the end of each month. Direct material costs $2.90 per pound, and each unit requires 2 pounds. Raw materials inventory policy is to have 50 percent of the next month’s production needs on hand at...