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)...
-
Accounting Professionals Inc. experienced the following events in 2014, its first year of operation: 1. Performed services for $ 20,000 cash. 2. Purchased $ 4,000 of supplies on account. 3. A...
-
(a) What two assumptions must you make about the data in order for the standard error of the estimate to be accurate, and what does each mean? (b) How does heteroscedasticity lead to an inaccurate...
-
Repeat Example 15-11 for the following conditions: a. \(0.03 \mathrm{~g} \mathrm{CO}_{2} / 1000 \mathrm{~g}\) water in the drop. \(\mathrm{y}_{\text {water, bulk }}=0, \mathrm{y}_{\mathrm{CO} 2,...
-
America Online published a survey question. Among the 2,300 Internet users who responded, 20% answered "yes" and the others answered "no." For the "yes" responses, what is the value of /5? What is...
-
When a local pet groomer who traditionally services dogs decides to offer cat grooming services, this would represent which brand development strategy? Line extension Brand extension Multibrands New...
-
Part A Walmart Stores (Walmart) is the world's largest retailer. It employs an ''everyday low price'' strategy and operates stores as three business segments: Walmart Stores U.S., International, and...
-
By recognizing that your data set consists of smokers and nonsmokers, you gain tremendous power in extending conclusions beyond the data by recognizing that these events are mutually exclusive (or...
-
How many gallons are in a rectangular reservoir if the water pressure at the bottom is 5.3psi? The reservoir is 40feet long, 30 feet wide, and 20 feet high
-
Bonus: The angle of depression of the top of Billings Building from the roof of the Wolcott Building (in the same vertical plane) is 33.10, and from the 15th floor it is 21.50. If the distance...
-
A lone wire connects two well-separated conducting spheres. One sphere has a radius of 10.0cm and an electric potential of 250.0V (using a reference of the zero point at infinite distance). The other...
-
A company recently invested in information systems for efficient operations and strategic positioning in the industry. as an IT graduate with knowledge in the management of information systems, using...
-
Do process costing and job order costing both maintain perpetual invetories?
-
How can you identify WHS training needs for your team
-
Wilsons Auto Repair ended 2011 with Accounts Receivable of $85,000 and a credit balance in Allowance for Uncollectible Accounts balance of $11,000. During 2012, Wilsons Auto Repair had the following...
-
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...
-
At equilibrium suppliers of capital receive a rental price equal to the _________.
-
The quantity of funds supplied is _________ related to the interest rate.
-
At _________ interest rates, capital costs are lower.
Study smarter with the SolutionInn App