Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Janus Inc. needs to prepare a cash budget. The following are actual and forecasted sales figures: Actual Forecast November December January February March April $200,000

Janus Inc. needs to prepare a cash budget. The following are actual and forecasted sales figures:

Actual

Forecast

November

December

January

February

March

April

$200,000

$220,000

$280,000

$320,000

$340,000

$330,000

Thirty percent of each months sales are in cash, 50% are paid the month after sale and 20% are paid two months after sale. Materials cost 30% of sales and are purchased one month prior to sale and paid for 30 days later. Labor expense is 40% of sales, selling and administrative expenses are 5% of sales and both are paid in the month of sale. Overhead is $28,000 per month, depreciation expense is $10,000 per month. Taxes of $8,000 will be paid in January and dividends of $2,000 will be paid on March.Cash on hand at the beginning of January is $80,000 and the desired cash balance is $75,000. Prepare the cash budget for January - March.

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

Financial Statement Fraud Prevention And Detection

Authors: Zabihollah Rezaee, Richard Riley

2nd Edition

0470543205, 9780470543207

More Books

Students also viewed these Accounting questions

Question

=+f) Are any six points in a row increasing (or decreasing)?

Answered: 1 week ago