Question

5) ABC Company pays for raw material purchases as follows: 75% in the month of purchase;...

5)
ABC Company pays for raw material purchases as follows:
75% in the month of purchase; 25% in the subsequent month.
Budgeted purchases are as follows: June = $56,000; July = $60,000.
Budgeted cash payment to be made in the month of July is $ ?

-------

6)
ABC Company pays for raw material purchases as follows:
75% in the month of purchase; 25% in the subsequent month.
Budgeted purchases are as follows: June = $56,000; July = $60,000.
Cash disbursement forecast for the purchases budgeted for the month of June will be anticipated as follows:
June = $ ?       July = $ ?

-------

7)
ABC Company has identified the following information related to its cash budget for October:
Beginning cash balance = $20,000; Cash receipts from sales = $100,000; Cash payments for purchases = $50,000;
Proceeds from borrowings = $25,000; Payments for other manufacturing expenses = $40,000;
Payments for operating expenses = $35,000; Dividend payment = $10,000;
Ending cash balance = $ ?

----

8)
ABC Company requires a minimum cash balance of $15,000 at the end of each month and has identified the following information related to its cash budget for October:
Beginning cash balance = $20,000; Cash receipts = $125,000; Cash disbursements = $135,000;
Required short-term borrowing = $ ?      Ending cash balance = $ ?

0 0
Add a comment Improve this question Transcribed image text
Answer #1

Answer-5)- Budgeted cash payment to be made in the month of July is = $59000.

Explanation- Budgeted cash payment to be made in the month of July = June month purchase payment+ July month purchase payment

= ($56000*25%)+($60000*75%)

= $14000+$45000

= $59000

6)- Cash disbursement forecast for the purchases budgeted for the month of June will be anticipated-

June= $56000*75% =$42000

July = ($56000*25%)+($60000*75%)

= $14000+$45000

= $59000

7)- Ending cash balance = $10000.

Explanation-Ending cash balance=(Beginning cash balance+ Cash receipts from sales + Proceeds from borrowings)- Cash payments for purchases-Payments for other manufacturing expenses-Payments for operating expenses-Dividend payment

= ($20000+$100000+$25000)-$50000-$40000-$35000-$10000

= $10000

8)- Required short-term borrowing=$5000.

Ending cash balance = $15000.

Explanation- Required short-term borrowing =(Ending minimum cash balance +Cash disbursements)- (Beginning cash balance + Cash receipts)

= ($15000+$135000)-($20000+$125000)

= $150000-$145000

= $5000

Add a comment
Know the answer?
Add Answer to:
5) ABC Company pays for raw material purchases as follows: 75% in the month of purchase;...
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
  • Please show full calculations for each. Thanks! 1) ABC Company's budgeted sales are as follows: July...

    Please show full calculations for each. Thanks! 1) ABC Company's budgeted sales are as follows: July = 3,000 units;                August = 2,500 units. June ending inventory = 1,200 units. Budgeted ending inventory must equal 40% of next month's budgeted sales. Production budgeted for July would equal units = ? units ------ 2) ABC Company's budgeted production is as follows: January = 5,000 units; February = 8,000 units. Each unit produced requires 3 pounds of raw material. January beginning inventory...

  • ABC Company’s raw materials purchases for June, July, and August are budgeted at $46,000, $36,000, and...

    ABC Company’s raw materials purchases for June, July, and August are budgeted at $46,000, $36,000, and $61,000, respectively. Based on past experience, ABC expects that 40% of a month’s raw material purchases will be paid in the month of purchase and 60% in the month following the purchase. Required: Prepare an analysis of cash disbursements from raw materials purchases for ABC Company for August. June July August Budgeted raw material purchases August cash payments: Current month's purchases Prior month's purchases...

  • Shorstein Manufacturing Company purchases raw materials on account each month. Purchases are paid for according to...

    Shorstein Manufacturing Company purchases raw materials on account each month. Purchases are paid for according to the following schedule: 30% is paid in the month of the purchase 60% is paid in the month following the purchase 10% is paid in the second month following the purchase Budgeted purchases are as follows: March $75,000 April $90,000 May $85,000 How much will be reported for Accounts Payable for material purchases as of the end of May? $59,500 O $68,500 $87,000 $95,500...

  • ABC Company provided the following information for the month of October September Actual 19,500 110,500 130,000...

    ABC Company provided the following information for the month of October September Actual 19,500 110,500 130,000 Cash sales Credit sales Total sales $ October Budget 18,000 102,000 120,000 $ $ Based on past experience, the company estimates that uncollectible credit sales are: 4% of the credit sales that are collectible, the collection pattern is as follows: Month of sales 70% Second month following sales 26% October inventory purchase September inventory purchase $ $ 83,000 98,000 Payments for inventory are made...

  • Green Book Green Book International purchases raw materials on account. Budgeted purchase amounts are April, $93,000;...

    Green Book Green Book International purchases raw materials on account. Budgeted purchase amounts are April, $93,000; May, $123,000; and June, $133,000. Payments are made as follows: 75% in the month of purchase and 25% in the month after purchase. The March 31 balance of accounts payable is $35,000. Prepare a schedule of budgeted cash payments for April, May, and June April May June Jun Current month purchases Ending accounts payable Total purchases 75% 25% 0 $ GREEN BOOK INTERNATIONAL May...

  • A company budgeted the following purchases for raw materials: Month January February March April May June...

    A company budgeted the following purchases for raw materials: Month January February March April May June July Budget $10,000 $20,000 $25,000 $22,000 $27,000 $30,000 $24,000 The company has a policy of paying for 40% of the purchases in the month of purchase, 35% in the month following the purchase, and 25% in the second month following the purchase. Based on this information, what are the budgeted cash disbursements for May?

  • Widden Company, which sells electric razors, had $360,000 of cost of goods sold during the month...

    Widden Company, which sells electric razors, had $360,000 of cost of goods sold during the month of June. The company projects a 7 percent increase in cost of goods sold during July. The inventory balance as of June 30 is $23,000, and the desired ending inventory balance for July is $24,000. Widden pays cash to settle 75 percent of its purchases on account during the month of purchase and pays the remaining 25 percent in the month following the purchase....

  • Purchases and Cash Budgets On July 1, MTC Wholesalers had a cash balance of $175,000 and...

    Purchases and Cash Budgets On July 1, MTC Wholesalers had a cash balance of $175,000 and accounts payable of $99,000. Actual sales for May and June, and budgeted sales for July, August, September, and October are: Month Actual Sales Month Budgeted Sales May $150,000   July $ 90,000 June 160,000 August 80,000 September 100,000 October 120,000 All sales are on credit with 75 percent collected during the month of sale, 20 percent collected during the next month, and 5 percent collected...

  • Adams Company, which sells electric razors, had $330,000 of cost of goods sold during the month...

    Adams Company, which sells electric razors, had $330,000 of cost of goods sold during the month of June. The company projects a 9 percent increase in cost of goods sold during July. The inventory balance as of June 30 is $31,000, and the desired ending Inventory balance for July is $32,000. Adams pays cash to settle 75 percent of its purchases on account during the month of purchase and pays the remaining 25 percent in the month following the purchase....

  • Zisk Co. purchases raw materials on account. Budgeted purchase amounts are April, $80,000; May, $110,000; and...

    Zisk Co. purchases raw materials on account. Budgeted purchase amounts are April, $80,000; May, $110,000; and June, $120,000. Payments are made as follows: 70 % in the month of purchase and 30 % in the month after purchase. The March 31 balance of accounts payable is $22,000 Prepare a schedule of budgeted cash payments for April, May, and June. April May June Current month purchases 70% Ending accounts payable 30 % Total purchases ZISK CO. Schedule of Cash Payments For...

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