Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Given the following information prepare the Combined Cash Budget for April and May. Description January February March April May June July Cash Collected (actual cash

Given the following information prepare the Combined Cash Budget for April and May.

Description January February March April May June July
Cash Collected (actual cash collection 30,000 33,000 26,000 32,000 27,000 25,000 30,000
Direct Material Purchases 12,000 13,000 14,000 13,000 12,000 14,000 16,000
Salaries and Wages 12,500 12,600 12,500 12,500 12,500 12,600 12,500
All Selling Costs 300 200 200 400 200 300 100
Fixed Admin. & Equipment Costs (includes $300 in depreciation) 4,800 6,100 3,000 3,100 2,800 2,000 2,700

Disbursement Timing:

Direct Materials are paid for in the month following the purchase

Salaries and Wages are paid half in the month earned and half in the following month

All other costs are paid in the month incurred

Bank Information:

Ending Cash Balance on March 31 is $3000. The company requires a minimum cash balance of $5,000. The bank requires the company to borrow in increments of $1,000 at 12% annual interest rate. The company may borrow from this operating line at any time and pay back the balance plus interest at any time. At the current time the company has no outstanding loans. The company also has no plans to pay back any borrowings or interest until the following quarter.

Required:

Prepare the Combined Cash Budget for April and May. (Note: Show each month seperately)

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Effect Of Audit Quality On The Market Value Of Listed Non Financial Companies In Nigeria

Authors: Dr. Patience Ote Ola

1st Edition

6200479496, 978-6200479495

More Books

Students also viewed these Accounting questions