Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

JL is preparing its cash budget for the next three quarters. The following data have been extracted from the operational budgets: Sales revenue: 1ST Quarter

JL is preparing its cash budget for the next three quarters. The following data have been extracted from the operational budgets: Sales revenue: 1ST Quarter $500,000 2ND Quarter $450,000 3RD Quarter $480,000 Direct material purchases 1ST Quarter $138,000 2ND Quarter $151,200 3RD Quarter $115,600 Additional information is available as follows: JL sells 20% of its goods for cash. Of the remaining sales value, 70% is received within the same quarter as sale and 30% is received in the following quarter. It is estimated that trade receivables will be $125,000 at the beginning of Quarter 1. No bad debts are anticipated. 50% of payments for direct material purchases are made in the quarter of purchase, with the remaining 50% in the quarter following purchase. It is estimated that the amount owing for direct material purchases will be $60,000 at the beginning of Quarter 1. JL pays labour and overhead costs when they are incurred. It has been estimated that labour and overhead costs in total will be $303,600 per quarter. This figure includes depreciation of $19,600. JL expects to repay a loan of $100,000 in Quarter 3. The cash balance at the beginning of Quarter 1 is estimated to be $49,400 positive. Required: Prepare a cash budget for each of the THREE quarters

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

Management And Cost Accounting

Authors: Charles T. Horngren, George Foster, Srikant M. Datar

3rd Edition

0273687514, 978-0273687511

More Books

Students also viewed these Accounting questions

Question

work settings of recent graduates;

Answered: 1 week ago