Question

Janus Products, Inc. is a merchandising company that sells binders, paper, and other school supplies. The company is planningRequired: 1. Prepare a schedule of expected cash collections for July, August, and September and for the quarter in total JAN2. Prepare the following for merchandise inventory: a. A merchandise purchases budget for July, August, and September. JANUS3. Prepare a cash budget for July, August, and September and for the quarter in total. (Roundup Borrowing and Repayments

0 0
Add a comment Improve this question Transcribed image text
Answer #1
Schedule of cash collection
July August September Quarter
Cash sales 10600 16600 12600 39800
Sales on account
May 6880 6880
June 27440 7840 35280
July 4240 29680 8480 42400
August 6640 46480 53120
September 5040 5040
Total cash collections 49160 60760 72600 182520
2a) Merchandise purchase budget
July August September
Budgeted cost of goods sold 29,200 47,200 35,200
Add:ending inventory 35400 26400 24150
total needs 64,600 73,600 59,350
Deduct:Beginning inventory 24,500 35400 26400
Required invnetory purchases 40,100 38,200 32,950
b) Schedule of Cash disbursements
July August September Quarter
Accounts payable,June 30 18,200 18,200
July purchases 20050 20050 40100
August purchases 19100 19100 38200
September purchases 16475 16475
Total cash disbursements 38,250 39150 35575 112,975
c) Cash Budget
July August September Quarter
Cash balance ,beginning 9,300 9,310 10,770 9,300
Add collection from sales 49160 60760 72600 182520
Total cash available 58,460 70,070 83,370 191,820
less: disbursements
for inventory purchases 38,250 39150 35575 112,975
For selling expense 11,100 14,300 9,800 35,200
for administrative expense 3650 5850 4750 14250
for land 5,150 5,150
for dividends 1,650 1650
total disbursements 58,150 59300 51775 169,225
Excess(Deficiency) 310 10,770 31,595 22,595
financing:
Borrowings 9,000 0 0 9,000
Repayment 0 0 -9000 -9000
interest 0 0 -270 -270
total financing 9,000 0 -9270 -270
cash balance,ending 9,310 10,770 22,325 22,325
Add a comment
Answer #2
Where do you get the interest
Add a comment
Know the answer?
Add Answer to:
Janus Products, Inc. is a merchandising company that sells binders, paper, and other school supplies. The company is pl...
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
  • Janus Products, Inc. is a merchandising company that sells binders, paper, and other school supplies. The company is pl...

    Janus Products, Inc. is a merchandising company that sells binders, paper, and other school supplies. The company is planning its cash needs for the third quarter. In the past, Janus Products has had to borrow money during the third quarter to support peak sales of back-to-school materials, which occur during August. The following information has been assembled to assist in preparing a cash budget for the quarter: a. Budgeted monthly absorption costing income statements for July to October are as...

  • Janus Products, Inc. is a merchandising company that sells binders, paper, and other school supplies. The...

    Janus Products, Inc. is a merchandising company that sells binders, paper, and other school supplies. The company is planning its cash needs for the third quarter. In the past, Janus Products has had to borrow money during the third quarter to support peak sales of back-to-school materials, which occur during August. The following information has been assembled to assist in preparing a cash budget for the quarter: a. Budgeted monthly absorption costing income statements for July to October are as...

  • Janus Products, Inc. is a merchandising company that sells binders, paper, and other school supplies. The...

    Janus Products, Inc. is a merchandising company that sells binders, paper, and other school supplies. The company is planning its cash needs for the third quarter. In the past, Janus Products has had to borrow money during the third quarter to support peak sales of back-to-school materials, which occur during August. The following information has been assembled to assist in preparing a cash budget for the quarter: a. Budgeted monthly absorption costing income statements for July to October are as...

  • Janus Products, Inc. is a merchandising company that sells binders, paper, and other school supplies. The...

    Janus Products, Inc. is a merchandising company that sells binders, paper, and other school supplies. The company is planning its cash needs for the third quarter. In the past, Janus Products has had to borrow money during the third quarter to support peak sales of back-to-school materials, which occur during August. The following information has been assembled to assist in preparing a cash budget for the quarter: a. Budgeted monthly absorption costing income statements for July to October are as...

  • Scott Products Inc. is a merchandising company that sells binders, paper, and other school supplies. The...

    Scott Products Inc. is a merchandising company that sells binders, paper, and other school supplies. The company is planning its cash needs for the third quarter. In the past, Scott Products has had to borrow money during the third quarter to support peak sales of back- to-school materials, which occur during August. The following information has been assembled to assist in preparing a cash budget for the quarter: a. Budgeted monthly absorption costing income statements for for July through October...

  • Scott Products Inc. is a merchandising company that sells binders, paper, and other school supplies. The...

    Scott Products Inc. is a merchandising company that sells binders, paper, and other school supplies. The company is planning its cash needs for the third quarter. In the past, Scott Products has had to borrow money during the third quarter to support peak sales of back- to-school materials, which occur during August. The following information has been assembled to assist in preparing a cash budget for the quarter: a. Budgeted monthly absorption costing income statements for for July through October...

  • Janus Products, Inc. is a merchandising company that sells binders, paper, and other school supplies. The...

    Janus Products, Inc. is a merchandising company that sells binders, paper, and other school supplies. The company is planning its cash needs for the third quarter. In the past, Janus Products has had to borrow money during the third quarter to support peak sales of back-to-school materials, which occur during August. The following information has been assembled to assist in preparing a cash budget for the quarter: a. Budgeted monthly absorption costing income statements for July to October are as...

  • Managrial accounting Scott Products Inc. is a merchandising company that sells binders, paper, and other school supplie...

    Managrial accounting Scott Products Inc. is a merchandising company that sells binders, paper, and other school supplies. The company is planning its cash needs for the third quarter. In the past, Scott Products has had to borrow money during the third quarter to support peak sales of back- to-school materials, which occur during August. The following information has been assembled to assist in preparing a cash budget for the quarter: a. Budgeted monthly absorption costing income statements for for July...

  • solve question 1&2&3 please. as it is able, repay the loan plus accumulated interest at the...

    solve question 1&2&3 please. as it is able, repay the loan plus accumulated interest at the end of the quarter. 1. Prepare a schedule of expected cash collections for July, August, and September and for the quarter in total. (Leave no cells blank-be certain to enter "0" wherever required. Do not round intermediate calculations. Omit the "S" sign in your response.) Schedule of Expected Cash Collections Cash sales Sales on account: May June July August Total cash collections 2. Prepare...

  • Beech Corporation is a merchandising company that is preparing a master budget for the third quarter...

    Beech Corporation is a merchandising company that is preparing a master budget for the third quarter of the calendar year. The company's balance sheet as of June 30th is shown below: Beech Corporation Balance Sheet June 30 Assets Cash Accounts receivable Inventory Plant and equipment, net of depreciation Total assets Liabilities and Stockholders' Equity Accounts payable Common stock Retained earnings Total liabilities and stockholders' equity $ 72,000 128,000 60,900 218,000 $ 478,900 $ 79,000 308,000 91,900 $ 478,900 Beech's managers...

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