(i) (ii) Hunt Chemicals is preparing a cash budget for June and July 2019. At the...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
(i) (ii) Hunt Chemicals is preparing a cash budget for June and July 2019. At the end of July 2019, the company has undertaken to repay a £100,000 loan to their bank which had been borrowed in February 2019 to enable the business to survive during the seasonal peak in the second quarter of the calendar year, April to June. The bank balance at 1 June 2019 is expected to be £17,500. Budgeted sales revenues are as follows: April 2019 May 2019 June 2019 July 2019 August 2019 £360,000 £500,000 £600,000 £300,000 £240,000 Additional information: 70% of sales revenue is expected in the month of sales, subject to a 2% prompt payment discount. 20% of sales revenue is expected in the month following sales. 7% of sales revenue is expected to be received two months after sale and the remainder of sales revenue is expected to be uncollectable. The average selling price per unit is £100 and the average cost price is £75. 50% of the purchase price of goods is expected to be paid in the month of purchase and 50% in the following month. (iii) Target closing inventory is equal to the cost of goods sold in the following month plus 25%. (iv) Budgeted annual overheads are £800,000 which includes £300,000 of fixed costs of which £60,000 is depreciation. The remainder of the overheads are variable costs which vary with sales revenue and are paid in the month in which they occurred. The budgeted sales revenue for 2019 is £3 million. (v) A dividend of £40,000 will be paid and non-current assets costing £50,000 will be purchased and paid for in June while corporation tax of £75,000 will be paid in July. Required: (a) Produce a cash budget for each of the months June and July 2019, in columnar form. (15 marks) (i) (ii) Hunt Chemicals is preparing a cash budget for June and July 2019. At the end of July 2019, the company has undertaken to repay a £100,000 loan to their bank which had been borrowed in February 2019 to enable the business to survive during the seasonal peak in the second quarter of the calendar year, April to June. The bank balance at 1 June 2019 is expected to be £17,500. Budgeted sales revenues are as follows: April 2019 May 2019 June 2019 July 2019 August 2019 £360,000 £500,000 £600,000 £300,000 £240,000 Additional information: 70% of sales revenue is expected in the month of sales, subject to a 2% prompt payment discount. 20% of sales revenue is expected in the month following sales. 7% of sales revenue is expected to be received two months after sale and the remainder of sales revenue is expected to be uncollectable. The average selling price per unit is £100 and the average cost price is £75. 50% of the purchase price of goods is expected to be paid in the month of purchase and 50% in the following month. (iii) Target closing inventory is equal to the cost of goods sold in the following month plus 25%. (iv) Budgeted annual overheads are £800,000 which includes £300,000 of fixed costs of which £60,000 is depreciation. The remainder of the overheads are variable costs which vary with sales revenue and are paid in the month in which they occurred. The budgeted sales revenue for 2019 is £3 million. (v) A dividend of £40,000 will be paid and non-current assets costing £50,000 will be purchased and paid for in June while corporation tax of £75,000 will be paid in July. Required: (a) Produce a cash budget for each of the months June and July 2019, in columnar form. (15 marks)
Expert Answer:
Answer rating: 100% (QA)
Certainly Ill provide you with a simplified cash budget For the sake of brevity Ill outline the main ... View the full answer
Related Book For
Posted Date:
Students also viewed these finance questions
-
Managing Scope Changes Case Study Scope changes on a project can occur regardless of how well the project is planned or executed. Scope changes can be the result of something that was omitted during...
-
Planning is one of the most important management functions in any business. A front office managers first step in planning should involve determine the departments goals. Planning also includes...
-
The following were selected from among the transactions completed during the current year by Danix Co., an appliance wholesale company: Jan. 21. Sold merchandise on account to Black Tie Co., $28,000....
-
Ron Howard recently took over as the controller of Johnson Brothers Manufacturing. Last month, the previous controller left the company with little notice and left the accounting records in disarray....
-
What is the difference between autoassociative and heteroassociative types of memory? What is the bidirectional associative memory (BAM)? How does the BAM work?
-
The maximum blade efficiency of impulse turbine is (a) \(\frac{\cos ^{2} \alpha_{1}}{2}(1+K C)\) (b) \(\cos ^{2} \alpha_{1}(1+K C)\) (c) \(\cos \alpha_{1}(1+K C)\) (d) \(\frac{\cos \alpha_{1}}{2}(1+K...
-
Maria Lorenzi owns an ice cream stand that she operates during the summer months in West Yellowstone, Montana. Her store caters primarily to tourists passing through town on their way to Yellowstone...
-
Assume that you are the leadership team of a convenience store chain that has more than 300 outlets. The company is facing an inventory shrinkage problem, and store managers report that the main...
-
1. The clear majority of compute nodes in modern enterprise environments are networked. Can you think of any circumstances where a compute node would NOT be networked? Describe. 2. Many commercial...
-
A candle is 17 centimeters tall before it's lit. Let x represent the number of inches burned from the candle. Let y represent the number of inches of candle remaining. original length fixed a) What...
-
A company produces one product and uses process costing. In February, they calculate the following costs per equivalent unit for their two cost categories, materials and conversion costs:Materials...
-
What are you supposed to do? 1. Watch the first episode of the first season of this tv show "The Office" 2. There are five main characters in the episode: a. Michael Scott, regional manager of the...
-
Consider the downward from force of air on a horizontal piece of cardboard 1 m 2 . If the downward force is 1 . 0 *1 0 5 Pa 1 m 2 = 1 . 0 *1 0 5 N , what is the total mass of the air above the piece...
-
Niantic reported the following financial information ( amounts in millions ) . Current assets $ 1 2 , 9 6 0 Total assets 1 3 , 2 7 7 Current liabilities 1 , 0 8 0 Net sales 6 , 2 0 0 Net Income 2 6 6...
-
How does Google Chat Technology help increase communication when working in Virtual Teams? What are some limitations with using Information and Communication Technology ( Google GroupsLinks to an...
-
Carlberg Company has two manufacturing departments, Assembly and Painting. The Assembly department started 10,900 units during November. The following production activity in both units and costs...
-
A researcher reports a significant two-way between-subjects ANOVA, F(3, 40) = 2.96. State the decision to retain or reject the null hypothesis for this test.
-
Your friend is proposing to make a bid for a manufacturing business that has come onto the market. The business makes white plastic patio chairs. The purchase price for this business is 240,000. This...
-
Chillers plc manufactures fridges and freezers. The company is considering the production of a new deluxe fridge-freezer. The fridge-freezer will sell for 600 and the companys marketing department...
-
Applokia Limited is a manufacturer of smart phones. The company has the following costs for the month of September: * These costs remain the same no matter how many or how few smart phones are...
-
Colors of fabrics at a clothing store. Determine whether the data are qualitative or quantitative. Explain your reasoning.
-
Weights of bricks at a construction site. Determine whether the data are qualitative or quantitative. Explain your reasoning.
-
Marital statuses mentioned in an employment form. Determine whether the data are qualitative or quantitative. Explain your reasoning.
Study smarter with the SolutionInn App