Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

The manager of Caf Leblanc is preparing their budget for the upcoming fiscal quarter, commencing 1 April. The following information is available: The following balances

The manager of Caf Leblanc is preparing their budget for the upcoming fiscal quarter, commencing 1 April. The following information is available:

The following balances are expected for the end of this fiscal quarter (31 March): cash $52,000; accounts receivable $44,000, accounts payable $28,000 and unpaid expenses $1,100. The manager expects 90% of the amount outstanding from customers at the end of this fiscal quarter to be collected in April and the remainder uncollectable.

Caf Leblanc has placed an order of a new coffee machine that will cost $20,000. The scheduled payment date is in June.

Projected balances for the next quarter are as follows:

April

May

June

Sales revenue

80,000

82,000

84,000

Purchases

43,000

44,000

44,000

Depreciation

4,000

4,000

4,000

Salaries

2,500

2,500

2,500

Other expenses

2,000

1,800

2,000

90% of monthly sales are on credit. Receipts from credit customers are normally 40% in the month of sale, 55% in the month following the sale, and the remainder is considered uncollectable.

40% of goods purchased are paid for in the month of purchase and the remaining is paid in the following month.

Salaries are paid before the end of each month. 50% of other monthly expenses are paid for in the month incurred and the remainder paid in the following month.

Required:

Prepare the cash budget for April and May.

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_2

Step: 3

blur-text-image_3

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

Strategy, Value And RiskThe Real Options Approach

Authors: J. Rogers

2nd Edition

0230577377, 9780230577374

More Books

Students also viewed these Accounting questions