TO Industries prepares monthly cash budgets. The following budget information is available for April and May...

Free

90.2K

Verified Solution

Question

Accounting

TO Industries prepares monthly cash budgets. The followingbudget information is available for April and May 2019:

April

May

Sales

$650,000

$700,000

Direct material purchases

220,000

240,000

Direct labor

175,000

180,000

Manufacturing overhead

120,000

130,000

Selling and administrative expenses

150,000

150,000

All sales are credit sales. The company expects to collect 60%from customers in the month of the sale and the remaining 40% infirst month following the sale. The company purchases directmaterials on account. The company pays for 75% of the purchases inthe month of the purchases and the remaining 25% in the first monthfollowing the purchase. Direct labor, manufacturing overhead, andselling and administrative expenses are paid in cash in the monthincurred.

Additional information:

  • March 2019 credit sales were $600,000
  • March 2019 purchases of direct materials were $200,000
  • The company’s cash balance on April 1, 2019 is expected to be$90,000
  • The company wants to maintain a minimum cash balance of $80,000and has a line of credit in the amount of 1,000,000, with an annualinterest rate of 6%, available to borrow if the budgeted cashbalance falls below that level. Any amounts borrowed on the line ofcredit at the end of a month require a cash interest payment in thesubsequent month. If the ending cash balance in a month exceeds theminimum balance, the excess amount is used to repay any amountsborrowed on the line of credit.

Required

  1. Prepare a schedule of cash collections from credit sales forApril and May 2019.
  2. Prepare a schedule of cash disbursements for direct materialpurchases for April and May 2019.
  3. Prepare a cash budget for April and May 2019 in columnarformat.

Answer & Explanation Solved by verified expert
4.1 Ratings (846 Votes)

Particulars March April May June
Sales 600000 650000 700000
Collection in same month of sale 360000 390000 420000 -
(600000*60% (650000*60% (700000*60%
Collections in next month 240000 156000 280000
(600000*40% (650000*40% (700000*40%
Schedule of Cash collections for credit Sales from April and May 2019
Particulars April May
March Sales $        240,000.00 -
April Sales $        390,000.00 $        156,000.00
June Sales $        420,000.00
Cash collected during the period $       630,000.00 $       576,000.00
Schedule of Cash disbursements for direct material purchases for April and May 2019
Particulars March April May June
Purchases 200000 220000 240000
Collection in same month of sale 150000 165000 180000 -
(200000*75% (220000*75% (240000*75%
Collections in next month 50000 55000 60000
(200000*25%) (220000*25% (240000*25%
Particulars April May
March Purchases $          50,000.00 -
April Purchases $        165,000.00 $          55,000.00
June Purchases $        180,000.00
Cash collected during the period $       215,000.00 $       235,000.00
Cash Budhet for April and May 2019
April May
Cash Balance as on April 1 80000 80000
Receipt from Sales $        630,000.00 $        576,000.00
Less :Payments for
Direct Material $      (215,000.00) $      (235,000.00)
Direct Labor $      (175,000.00) $      (180,000.00)
Manufacturing Overhead $      (120,000.00) $      (130,000.00)
Selling and Admin Expenses $      (150,000.00) $      (150,000.00)
Interest Paid $               150.00 (30000*6%*1/12)
Closing Cash Balance $          50,000.00 $        (38,850.00)
Cash borrowed to maintain minimum balance $          30,000.00 $        118,850.00
Net Cash Balance $          80,000.00 $          80,000.00

Get Answers to Unlimited Questions

Join us to gain access to millions of questions and expert answers. Enjoy exclusive benefits tailored just for you!

Membership Benefits:
  • Unlimited Question Access with detailed Answers
  • Zin AI - 3 Million Words
  • 10 Dall-E 3 Images
  • 20 Plot Generations
  • Conversation with Dialogue Memory
  • No Ads, Ever!
  • Access to Our Best AI Platform: Flex AI - Your personal assistant for all your inquiries!
Become a Member

Other questions asked by students