Question

Cash Payments Schedule Fein Company provided the following information relating to cash payments: Fein purchased direct...

Cash Payments Schedule

Fein Company provided the following information relating to cash payments:

  1. Fein purchased direct materials on account in the following amounts:
    June $68,000
    July 77,000
    August 73,000
  2. Fein pays 20% of accounts payable in the month of purchase and the remaining 80% in the following month.
  3. In July, direct labor cost was $32,300. August direct labor cost was $35,400. The company finds that typically 90% of direct labor cost is paid in cash during the month, with the remainder paid in the following month.
  4. August overhead amounted to $71,200, including $6,350 of depreciation.
  5. Fein had taken out a four-month loan of $15,000 on May 1. Interest, due with payment of principal, accrued at the rate of 9% per year. The loan and all interest were repaid on August 31. (Note: Use whole months to compute interest payment.)

Required:

Prepare a schedule of cash payments for Fein Company for the month of August. Be sure to enter percentages as whole numbers.

Fein Company
Schedule of Cash Payments
For August
August
Payments on accounts payable:
From July purchases
$ ×  % $
From August purchases
$ ×  %
Direct labor payments:
From July
$ ×  %
From August
$ ×  %
Overhead
Loan repayment
Cash payments $
0 0
Add a comment Improve this question Transcribed image text
Answer #1

SOLUTION

Schedule of Cash Payments

Particulars Amount ($)
Payments on accounts payable:
From July purchases 61,600
(77,000*80%)
From August purchases 14,600
(73,000*20%)
Direct labor payments:
From July 3,230
(32,300*10%)
From August 31,860
(35,400*90%)
Overhead (71,200-6,350) 64,850
Loan repayment {15,000+(15,000*9%*4/12)} 15,450
Cash payments 191,590
Add a comment
Know the answer?
Add Answer to:
Cash Payments Schedule Fein Company provided the following information relating to cash payments: Fein purchased direct...
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. Our experts will answer your question WITHIN MINUTES for Free.
Similar Homework Help Questions
  • 2 Cash Payments Schedule Fein Company provided the following information relating to cash payments: a. Fein...

    2 Cash Payments Schedule Fein Company provided the following information relating to cash payments: a. Fein purchased direct materials on account in the following amounts: June $68,000 July 77,000 August 73,000 b. Fein pays 20% of accounts payable in the month of purchase and the remaining 80% in the following month. C. In July, direct labor cost was $32,800. August direct labor cost was $35,400. The company finds that typically 90% of direct labor cost is paid in cash during...

  • Direct Materials Purchases Budget Langer Company produces plastic items, including plastic housings for humidifiers. Each housing...

    Direct Materials Purchases Budget Langer Company produces plastic items, including plastic housings for humidifiers. Each housing requires about 21 ounces of plastic costing $0.08 per ounce Langer molds the plastic into the proper shape. Langer has budgeted production of the housings for the next 4 months as follows: Units July 3,500 August 4,400 September 4,900 October 6,300 Inventory policy requires that sufficient plastic be in ending monthly inventory to satisfy 30% of the following month's production needs. The inventory of...

  • Required information Problem 22-2A Manufacturing: Cash budget LO P2 [The following information applies to the questions...

    Required information Problem 22-2A Manufacturing: Cash budget LO P2 [The following information applies to the questions displayed below.] Built-Tight is preparing its master budget for the quarter ended September 30, 2017. Budgeted sales and cash payments for product costs for the quarter follow: July August $56,500 $ 72,500 September $ 55,500 Budgeted sales Budgeted cash payments for Direct materials Direct labor Factory overhead 15,660 3,540 19,700 12,940 2,860 16,300 13,260 2,940 16,700 Sales are 20% cash and 80% on credit....

  • Requirement 1. Prepare Cooke Company's schedule of cash receipts from customers and schedule of cash payments...

    Requirement 1. Prepare Cooke Company's schedule of cash receipts from customers and schedule of cash payments for the first quarter of 2018 Begin by preparing the schedule of cash receipts from customers for the first quarter of 2018 Cash Receipts from Customers First Quarter 2018 i Data Table Total sales Cash Receipts from Customers: Accounts Receivable balance, December 31, 2017 1st Qtr-Sales Total cash receipts from customers Total sales Budgeted purchases of direct materials Budgeted direct labor cost Budgeted manufacturing...

  • Kayak Co. budgeted the following cash receipts (excluding cash receipts from loans received) and cash payments...

    Kayak Co. budgeted the following cash receipts (excluding cash receipts from loans received) and cash payments (excluding cash payments for loan principal and interest payments) for the first three months of next year. January February March Cash Receipts $518,000 404,000 464,000 Cash payments $465,900 351,900 531,000 According to a credit agreement with its bank, Kayak requires a minimum cash balance of $50,000 at each month-end. In return, the bank has agreed that the company can borrow up to $160,000 at...

  • The Samson Company is preparing its cash payments budget. The following items relate to cash payments...

    The Samson Company is preparing its cash payments budget. The following items relate to cash payments the company anticipates making during the second quarter of the upcoming year. LOADING... ​(Click the icon to view the cash payment​ information.) The company pays for 50​%of its direct materials purchases in the month of purchase and the remainder the following month. The​ company's direct material purchases for March through June are anticipated to be as​ follows: March April May June $116,000 $133,000 $124,000...

  • Schedule of Cash Collections on Accounts Receivable and Cash Budget Roybal Inc. sells all of its...

    Schedule of Cash Collections on Accounts Receivable and Cash Budget Roybal Inc. sells all of its product on account. Roybal has the following accounts receivable payment experience: Percent paid in the month of sale 20 Percent paid in the month after the sale 55 Percent paid in the second month after the sale 23 To encourage payment in the month of sale, Roybal gives a 2% cash discount. Roybal's anticipated sales for the next few months are as follows: April...

  • 8 Schedule of Cash Collections on Accounts Receivable and Cash Budget Roybal Inc. sells all of...

    8 Schedule of Cash Collections on Accounts Receivable and Cash Budget Roybal Inc. sells all of its product on account. Roybal has the following accounts receivable payment experience: Percent paid in the month of sale Percent paid in the month after the sale Percent paid in the second month after the sale To encourage payment in the month of sale, Roybal gives a 2% cash discount. Roybal's anticipated sales for the next few months are as follows: April $275,500 May...

  • Karim Corp. requires a minimum $8,300 cash balance. If necessary, loans are taken to meet this...

    Karim Corp. requires a minimum $8,300 cash balance. If necessary, loans are taken to meet this requirement at a cost of 2% interest per month (paid monthly). Any excess cash is used to repay loans at month-end. The cash balance on July 1 is $8,700 and the company has no outstanding loans. Forecasted cash receipts (other than for loans received) and forecasted cash payments (other than for loan or interest payments) follow July Cash receipts Cash payments August September $40,300...

  • Built-Tight is preparing its master budget for the quarter ended September 30. Budgeted sales and cash...

    Built-Tight is preparing its master budget for the quarter ended September 30. Budgeted sales and cash payments for product costs for the quarter follow. July August September Budgeted sales $ 58,000 $ 74,000 $ 54,000 Budgeted cash payments for Direct materials 15,960 13,240 13,560 Direct labor 3,840 3,160 3,240 Factory overhead 20,000 16,600 17,000 Sales are 25% cash and 75% on credit. All credit sales are collected in the month following the sale. The June 30 balance sheet includes balances...

ADVERTISEMENT
Free Homework Help App
Download From Google Play
Scan Your Homework
to Get Instant Free Answers
Need Online Homework Help?
Ask a Question
Get Answers For Free
Most questions answered within 3 hours.
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT