Reference no: EM133015512
Question - Red Ltd prepares monthly cash budgets. Relevant data from operating budgets for 2021 are:
|
January
|
February
|
Sales
|
$160,000
|
$195,000
|
Direct materials purchases
|
60,000
|
70,000
|
Direct labour
|
30,000
|
35,000
|
Manufacturing overheads
|
20,000
|
25,000
|
Selling and administrative expenses
|
15,000
|
18,000
|
All sales are on credit basis. Collections are expected to be 40% in the month of sale, 30% in the first month following the sale, and 25% in the second month following the sale. Direct material purchases are paid in cash in the month following the month of purchase.
All other items are paid in the month incurred.
Depreciation $12,000 has been excluded from manufacturing overhead.
Other relevant data are:
Credit sales: November 2020, $140,000; December 2020, $150,000.
Purchases of direct materials: December 2020, $ 65,000
Other receipts: Proceeds from the sale of investments $15,000 will be collected in February 2021.
Other disbursements: Payment for the purchase of office furniture $20,000 will be paid in February 2021.
The cash balance on 1 January 2021 is expected to be $30,000.
Red Ltd wishes to maintain a minimum cash balance of $60,000 and any shortage will be met by way of a bank loan. The loan will be repaid with interest at 5% per annum.
Required -
1. Prepare cash budget for January and February 2021 for Red Ltd.
2. What is the key difference between a Cash Budget and a Cash Flow Statement?