It is the end of December 2022 and Palace Ltd is completing the preparation of its...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
It is the end of December 2022 and Palace Ltd is completing the preparation of its short term financial plan for the three months to 31 March 2023. To complete the preparation of the cash budget for each of these months the following projections and assumptionshave been made: Month Sales £ Purchases € January 240,000 150,000 February 300,000 140,000 March 300,000140,000 1. Past experience suggests that the firm will collect 40% of its sales revenue in the month of the sale, 50% one month after the sale, and the balance in the second month following the sale.2. Sales for October, November and December were £200,000, £220,000 and £170,000 respectively:3. Purchases are made in the month of sale but paid for in the following month.4. Purchases for December were £90,000.5. Labour costs follow the shift patterns worked by the company's employees and normally represent 5% of that month's sales, with payment being made in the month that the expense is incurred.6. Administration costs of £50,000 are incurred each month. These are paid in the month they are incurred.7. A VAT payment of £40,000 is due to be paid in March.8. Year- end performance bonuses are paid in January and are estimated to be £20,000.9. The company has decided to replace the motor vehicles of three of its board members in February at a cost of £65,000 per vehicle10. The cash balance at the beginning of January was £20,000. The directors feel that a minimum cash balance of £20,000 should be maintained at all times. Required: Show a cash budget for the three months of January, February and March 2023. It is the end of December 2022 and Palace Ltd is completing the preparation of its short term financial plan for the three months to 31 March 2023. To complete the preparation of the cash budget for each of these months the following projections and assumptionshave been made: Month Sales £ Purchases € January 240,000 150,000 February 300,000 140,000 March 300,000140,000 1. Past experience suggests that the firm will collect 40% of its sales revenue in the month of the sale, 50% one month after the sale, and the balance in the second month following the sale.2. Sales for October, November and December were £200,000, £220,000 and £170,000 respectively:3. Purchases are made in the month of sale but paid for in the following month.4. Purchases for December were £90,000.5. Labour costs follow the shift patterns worked by the company's employees and normally represent 5% of that month's sales, with payment being made in the month that the expense is incurred.6. Administration costs of £50,000 are incurred each month. These are paid in the month they are incurred.7. A VAT payment of £40,000 is due to be paid in March.8. Year- end performance bonuses are paid in January and are estimated to be £20,000.9. The company has decided to replace the motor vehicles of three of its board members in February at a cost of £65,000 per vehicle10. The cash balance at the beginning of January was £20,000. The directors feel that a minimum cash balance of £20,000 should be maintained at all times. Required: Show a cash budget for the three months of January, February and March 2023.
Expert Answer:
Answer rating: 100% (QA)
To prepare the cash budget for the three months of January February and March 2023 we need to calcul... View the full answer
Related Book For
Management Accounting
ISBN: 9781760421144
7th Edition
Authors: Kim Langfield Smith, Helen Thorne, David Alan Smith, Ronald W. Hilton
Posted Date:
Students also viewed these accounting 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...
-
Case Analysis Critical thinking, creativity, and problem-solving are among some of the top skills needed by employers in the supply chain industry. This assignment will stretch your critical...
-
The Crazy Eddie fraud may appear smaller and gentler than the massive billion-dollar frauds exposed in recent times, such as Bernie Madoffs Ponzi scheme, frauds in the subprime mortgage market, the...
-
Table 2-5 Estonia Finland One Cell Phone 40 hours 16 hours Lumber (per board foot) 8 hours 4 hours Table 2-5 shows the number of labor hours required to produce a cell phone and a board foot of...
-
Bredahl Logistics, a U.S. shipping company, has just begun distributing goods across the Atlantic to Norway. The company began operations in 2010, transporting goods to South America. The companys...
-
Which statement is the most accurate? a) The South had some very substantial economic grievances against the North in the years immediately preceding the Civil War. b) The South seceded from the...
-
Refer to the information in Exercise 16-14. Prepare journal entries dated June 30 to record: (a) raw materials purchases, (b) direct materials usage, (c) indirect materials usage, (d) direct labor...
-
Tremont, Inc., sells tire rims. Its sales budget for the nine months ended September 30 follows: In the past, cost of goods sold has been 40% of total sales. The director of marketing and the...
-
Figure shows the spring-mass damper system of two degree of freedom with free vibrations. If m = m, m = 2.5m, c =C2=C3 = 2c, k = k, k = 2.5k and k3 = 3k. a) Draw the free body diagram & derive the...
-
A survey of families living in a certain city was conducted to collect information on the following variables: age of the oldest person in the family, number of family members, number of males in the...
-
Use the method of cylindrical shells to find the volume generated by rotating the region bounded by the given curves about the y -axis. y = 8 x x 2 , y = x
-
Fully explain in full sentences the meaning and origin of fractional reserve banking. List 4 characteristics of a medium of exchange and explain why gold is often preferred as a medium of exchange....
-
From the business model you've been cultivating since our first week, this week you're going to apply it to perfect competition discussed in our lesson notes and chapter. Now, your firm may not...
-
Is it a good idea to replace higher-paid workers with lower-paid workers to ensure the success of a company?
-
In this assignment, you will answer to sets of questions. Each question is worth 2 points each. Always use complete, college level sentences. Run a spell check before submitting. Save your document...
-
write one or two sentences per bullet point (there are additional questions and points to help you flesh our your ideas): Topic: Choose a topic that is realistic and one that you want to learn more...
-
Nadia Company expects to have a cash balance of $44,500 on January 1, 2020. Nadia has budgeted the following for the first two months of the year 2020: 1. Collections from customers: January $89,600;...
-
The landing gear of an aircraft with: mass of 2000 kg the spring-mass-damper system Consider that the runway surface is y(t) = 0.2 cos 157.08t stiffness of the spring is 5 x 105 N/m. What is the...
-
Suggest three activities and a possible activity driver for each activity that might be used as part of an activity-based budgeting system in each of the following industries: (a) Automated car was...
-
Review the list of activities associated with low-cost and high-cost customers in Exhibit 15.10. Select a company with which you are familiar and explain which activities would most likely apply to...
-
Suppose the variable costs of a medical practice increase. What types of costs might these be? How will this increase change the break-even point?
-
Prove that the angular momentum operator \(L_{z}\) generates rotations around the \(z\)-axis.
-
Show that for real numbers \(\alpha, \beta\), and \(\delta\) the matrices form a group under matrix multiplication. Show that the matrices \(G\) with \(\alpha=\beta=0\) form an invariant subgroup of...
-
Show that the quotient group of the 4-group \(\mathrm{D}_{2}\) defined in Problem 2.9 is \(\mathrm{C}_{2}\).
Study smarter with the SolutionInn App