The following information is provided to assist in the preparation of the Cash Budget for TSA...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
The following information is provided to assist in the preparation of the Cash Budget for TSA Ltd. for June, 2012: • The cash balance at 1¹ June, 2012 is $30,000 • All sales are on credit March April May June . Actual/Budgeted Sales $ • 140,000 120,000 130,000 155,000 Budgeted Purchases $ Cash collections from credit customers are: 70% in the month following the sale 20% in the second month following the sale 10% in the third month following the sale • All purchases are made on credit and payments are made as follows: 60% of purchases are paid for in the month of purchase 40% of purchases are paid for in the month following the purchase. 72,000 64,000 68,000 82,000 • Selling and administrative expenses each month are $24,000 plus 15% of sales for that month. This includes $6,000 per month for depreciation. • Equipment costing $35,000 is expected to be bought in May and paid for in June Required: (i) Prepare a schedule of cash collections for the month of June, 2012. (ii) Prepare a cash budget for the month of June, 2012. The following information is provided to assist in the preparation of the Cash Budget for TSA Ltd. for June, 2012: • The cash balance at 1¹ June, 2012 is $30,000 • All sales are on credit March April May June . Actual/Budgeted Sales $ • 140,000 120,000 130,000 155,000 Budgeted Purchases $ Cash collections from credit customers are: 70% in the month following the sale 20% in the second month following the sale 10% in the third month following the sale • All purchases are made on credit and payments are made as follows: 60% of purchases are paid for in the month of purchase 40% of purchases are paid for in the month following the purchase. 72,000 64,000 68,000 82,000 • Selling and administrative expenses each month are $24,000 plus 15% of sales for that month. This includes $6,000 per month for depreciation. • Equipment costing $35,000 is expected to be bought in May and paid for in June Required: (i) Prepare a schedule of cash collections for the month of June, 2012. (ii) Prepare a cash budget for the month of June, 2012.
Expert Answer:
Answer rating: 100% (QA)
1 Schedule of Cash Collections for June 2012 To determine the cash collections for June 2012 we need ... View the full answer
Related Book For
Managerial Accounting
ISBN: 9780073526706
12th Edition
Authors: Ray H. Garrison, Eric W. Noreen, Peter C. Brewer
Posted Date:
Students also viewed these accounting questions
-
As a new employee of Clayton Asset Management, you are assigned to evaluate the credit quality of BRT Corp. bonds. Clayton holds the bonds in its high-yield bond portfolio. The following information...
-
You were recently hired as an assistant controller at Just Tables (JT). JT sells one product, dining room tables made out of red cedar. You have been charged with preparing a cash budget for the...
-
Manny Fold owns a factory that specializes in making titanium valves for high-performance engines on a just in time basis. Thus, Manny produces what he sells in a particular month. There are no...
-
The acquisition committee of KE plc is considering making takeover bids for two competitors, Scot plc, a listed company, and Ring Ltd. Summarised financial data is given below for these companies....
-
Steam enters an adiabatic turbine at 10 MPa and 500C and leaves at 10 kPa with a quality of 90 percent. Neglecting the changes in kinetic and potential energies, determine the mass flow rate required...
-
How are the date of transition and the date of reporting determined in first-time adoption of IFRS?
-
Sony owed Estimated Warranty Payable of \($1,000\) at the end of 2009. During 2010, Sony made sales of \($100,000\) and expects product warranties to cost the company 3% of the sales. During 2010,...
-
On November, 1 of the current year, Rob Elliot invested $30,500.00 of his cash to form a corporation, GGE Enterprises Inc, in exchange for shares of common stock. No other common stock was issued...
-
How you choose to organize your people can have a dramatic affect on your organization's level of success. Like most clothing, one size does not fit all. Each organization needs to be created taking...
-
The Freemont Automobile Factory has discovered that the longer a worker has been on the job, the more parts the worker can produce. Write an application that computes and displays a workers...
-
Draw a graph that shows marginal cost, average variable cost, and average total cost. Your curves only need to have the proper shape and relationship to the other curves; you do NOT need to plot your...
-
Donald is resident and domiciled in the UK. He is not a Scottish taxpayer. He has the following income in tax year 2023-24: Donald claims only the personal allowance. Compute the amount of income tax...
-
5. Making predictions for values of the explanatory variable that are outside of the range of the data is called ____________________ . In Exercises 510, fill in each blank with the appropriate word...
-
The median is resistant because it is not affected much by_________________. In Exercises 912, fill in each blank with the appropriate word or phrase.
-
A UK resident company has 19 subsidiaries, five of which are situated abroad. In the year to 31 March 2024, the company had the following results: None of the dividends received were from any of the...
-
The mean is resistant. In Exercises 1316, determine whether the statement is true or false. If the statement is false, rewrite it as a true statement.
-
11. Find L[(t)], if 1 1- {-04-0), 15 = t> 2 f(t) 0 < t < 2;
-
Show that every group G with identity e and such that x * x = e for all x G is abelian.
-
The budgeted unit sales of Haerve Company for the upcoming fiscal year are provided below: The companys variable selling and administrative expenses per unit are $2.75. Fixed selling and...
-
The Central Area Well-Baby Clinic provides a variety of health services to newborn babies and their parents. The clinic is organized into a number of departments, one of which is the Immunization...
-
Fred Austin is employed by White Company where he assembles a component part for one of the companys products. Fred is paid $12 per hour for regular time, and he is paid time and a half (i.e., $18...
-
Consider a system of two dampers, with damping constants \(c_{1}\) and \(c_{2}\), arranged in parallel as shown in Fig. 1.104. The rigid bar to which the two dampers are connected remains horizontal...
-
Design a shock absorber (piston-cylinder-type dashpot) to obtain a damping constant of \(1.8 \times 10^{7} \mathrm{~N}\)-s \(/ \mathrm{m}\) using SAE 30 oil at \(21^{\circ} \mathrm{C}\). The diameter...
-
Develop an expression for the damping constant of the rotational damper shown in Fig. 1.105 in terms of \(D, d, l, h, \omega\), and \(\mu\), where \(\omega\) denotes the constant angular velocity of...
Study smarter with the SolutionInn App