Question 1(b) Cash budget Timone Limited, a beer wholesaling company has the following budgeted information: Month...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
Question 1(b) Cash budget Timone Limited, a beer wholesaling company has the following budgeted information: Month Sales values Purchases Operating costs (before trade discount) GH¢ GH¢ 800,000 GH¢ May 960,000 1,020,000 115,000 110,000 120,000 130,000 125,000 June 600,000 July August September 810,000 1,200,000 1,410,000 900,000 1,100,000 700,000 Additional information: (a) 20% of sales are cash terms and cash customers enjoy a 5% trade discount based on the selling price. The remaining sales are on credit tems, 70% of which are collected in the month following sale and 30% of which are collected in the second month following sale. (b) Timone Limited sets its selling price on a uniform mark up of 50% of the cost of goods sold for both cash and credit sales. (c) All purchases are bought on credit and paid in the following month after purchase. (d) Timone Limited will buy a new meat cutting machine at a cash price of GH¢300,000 on 1 August. The old meat cutting machine, with a cost and carrying amount of GH¢210,000 and GH¢ 156,000 as at 1 August, will be traded in against the new machine at a trade-in allowance of GH¢120,000. At all times, Timone Limited has only one meat cutting machine in operation and it is the only non-current asset of the company. The operating costs include the monthly depreciation expense of the meat cutting machine. All monthly operating costs, other than the depreciation expense, are paid in the month when they are incurred. Both the old and new meat cutting machines are depreciated at 20% per annum on a straight-line basis. (f) The expected cash balance as at 30 June is GH¢ 308,000. Required: (a) Prepare a monthly cash budget for July, August and September together with a total column for the quarter. Question 1(b) Cash budget Timone Limited, a beer wholesaling company has the following budgeted information: Month Sales values Purchases Operating costs (before trade discount) GH¢ GH¢ 800,000 GH¢ May 960,000 1,020,000 115,000 110,000 120,000 130,000 125,000 June 600,000 July August September 810,000 1,200,000 1,410,000 900,000 1,100,000 700,000 Additional information: (a) 20% of sales are cash terms and cash customers enjoy a 5% trade discount based on the selling price. The remaining sales are on credit tems, 70% of which are collected in the month following sale and 30% of which are collected in the second month following sale. (b) Timone Limited sets its selling price on a uniform mark up of 50% of the cost of goods sold for both cash and credit sales. (c) All purchases are bought on credit and paid in the following month after purchase. (d) Timone Limited will buy a new meat cutting machine at a cash price of GH¢300,000 on 1 August. The old meat cutting machine, with a cost and carrying amount of GH¢210,000 and GH¢ 156,000 as at 1 August, will be traded in against the new machine at a trade-in allowance of GH¢120,000. At all times, Timone Limited has only one meat cutting machine in operation and it is the only non-current asset of the company. The operating costs include the monthly depreciation expense of the meat cutting machine. All monthly operating costs, other than the depreciation expense, are paid in the month when they are incurred. Both the old and new meat cutting machines are depreciated at 20% per annum on a straight-line basis. (f) The expected cash balance as at 30 June is GH¢ 308,000. Required: (a) Prepare a monthly cash budget for July, August and September together with a total column for the quarter.
Expert Answer:
Answer rating: 100% (QA)
Gash budget ParHeular Jily Pug Seb Opening balance Recorpt Cash Sales Collechon fuom de... View the full answer
Related Book For
Cost Accounting Foundations and Evolutions
ISBN: 978-1111626822
8th Edition
Authors: Michael R. Kinney, Cecily A. Raiborn
Posted Date:
Students also viewed these accounting questions
-
The actual variable cost of goods sold for a product was $ 70 per unit, while the planned variable cost of goods sold was $68 per unit. The volume increased by 1,200 units to 7,000 actual total...
-
A company's cost of goods sold for the year was $97,500. Ending inventory was $12,000 and $13,500 in the current and prior years, respectively. Required Calculate the company's inventory turnover...
-
The following budgeted information about Reeves Co. is available for September 2010: Sales for September ..................... $2,700,000 Gross profit on sales .................... 40% Decrease in...
-
Uniform rod AB of length l and mass m lies in a vertical plane and is acted upon by a couple M. The ends of the rod are connected to small rollers which rest against frictionless surfaces. (a)...
-
Kansas Seed Corn Supplies, a company with 100,000 shares of common stock outstanding, had the following transactions during 20X1, its first year in business: Sales ....... 1,000,000 pounds @ $5...
-
The Food Bin grocery store operates 24 hours per day, 7 days per week. Fred Bulger, the store manager, has been analyzing the efficiency and productivity of store operations recently. Bulger decided...
-
Water flows in a 2-m-diameter finished concrete pipe so that it is completely full and the pressure is constant all along the pipe. If the slope is \(S_{0}=0.005\), determine the flowrate by using...
-
The ledger of Clayton Company includes the following unadjusted balances: Prepaid Insurance $3,000, Service Revenue $58,000, and Salaries and Wages Expense $25,000. Adjusting entries are required for...
-
Contrast managerial accounting and financial accounting. Role of corporate governance in managerial accounting. Classification of costs by cost behavior. What is the distinction between direct and...
-
The S&H Construction Company expects to have total sales next year totaling $15,000,000. In addition, the firm pays taxes at 35 percent and will owe $300,000 in interest expense. Based on last years...
-
You are asked to design a control/display panel for the space station escape launch. After the initial escape, propulsion is to be used to decelerate against the earths gravitational field. The...
-
Koudran Engineering Company is a multinational company that manufactures automotive and hydraulic parts. It has manufacturing locations in Nasik, Nagar, Pondicherry, and Hyderabad. The company gives...
-
Which decision-making style is useful when our priorities are not very discrete? Force field analysis Paired comparison analysis Pros and cons method with benefits Decision trees
-
Which among the following is the correct order for Herbert Simons model of decision? Intelligence, design, choice phase Design, intelligence, choice phase Choice, design, intelligence phase None...
-
Which decision-making tool allows one to check whether or not a course of action will actually improve the situation and is worth taking? Force field analysis Grid analysis method Pros and cons...
-
When one race car passes another during a race, the passing car usually tries to pass on the inner lane of a curve in the track. Why?
-
Zero Coupon Bond Price Calculate the price of a zero coupon bond that matures in 5 years if the market interest rate is 8.50 percent. Assume semi-annual interest payments and $1,000 par value. (Round...
-
Select the correct answer for each of the following questions. 1. On December 31, 20X3, Saxe Corporation was merged into Poe Corporation. In the business combination, Poe issued 200,000 shares of its...
-
How does workplace diversity affect organizational culture? Include in your answer a discussion of both the potential benefits and the potential difficulties of having workers with diverse...
-
A list of committed and discretionary costs follows. Annual audit fees ............Internal audit salaries Annual report preparation and printing ....Marketing research Building flood insurance...
-
Calypso Canvas makes canvas window awnings. You have been asked to predict the potential effects of some proposed company changes. The following information is available: Variable cost per unit...
-
What methods can a company use to raise capital?
-
Does higher expected inflation increase, decrease, or have no effect on the required rate of return?
-
You have been asked to consult for an entrepreneur who is assembling investors for a new professional sport league. A critical decision for the league will be whether to organize under a...
Study smarter with the SolutionInn App