The balance sheet of PoshEdd Company Ltd at 31 December 2022 is summarized below: GHS 000...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
The balance sheet of PoshEdd Company Ltd at 31 December 2022 is summarized below: GHS 000 GHS '000 700 Non-current assets Current assets Inventory of finished goods Debtors Cash Current liabilities Net current assets Capital employed 44.8 200,0 157.6 402.4 2.4 400 1,100 Following an advertising campaign around Christmas, the firm expects sales to rise in 2022 but it is not known precisely to what level. It is anticipated that 12,000 items will be sold in the year at an average price of GHS 100, though, with the uncertainty that exists over this figure, you have been asked to produce a flexible budget showing the profit if sales are 80%, 90%, 100%, 110 % and 120% of 12,000. You have also been asked to produce a cash budget showing the balance at the end of each quarter of 2023 and a budgeted statement of financial position at 31/12/2023, both if the 12,000 sales figure is achieved. You are told that: a) The level of demand is expected to be constant during 2022 though the actual level achieved will not be confirmed until the end of the first quarter. Production will be of 1,000 items per month during the first quarter, production in the second quarter will be sufficient to bring the end of June stock levels to 2 months; and in the remaining two quarters, production will match demand. b) Although it is intended to maintain the average sales price of GHe 100 per item, if sales are to reach the 120% level, it is felt that a quantity discount of 10% will need to be given on 20% of sales made. Page 1 of 2 c) All sales are on credit, 50% of debtors pay two months after sale and 50% pay three months after sale. Sales in 2022 had been constant throughout the year. d) Materials cost are GHe 20 per item. In order to achieve this purchase price, stocks have to be bought in bulk on the first day of each quarter and payment made within thirty days. For orders in excess of GHe 50,000 this cost will fall by 5%. e) Labor costs are based on piece- work scales of GHe3 per item, though the management of Eddposh Ltd have recently been reminded of a productivity bonus of 60p per item if monthly production from the workforce of 10 reaches 1,000 items. Labor costs are paid one month after they are incurred. f) Overhead costs are partly fixed and partly variable. The variable element amounts to GH5 per item payable in the month incurred. The fixed element is expected to be GH 500,000 of which GHe100,000 is depreciation of existing non-current assets. Half of the balance is payable monthly, a quarter at the end of June and a quarter at the end of December. If sales reach 120% additional machinery costing GH240,000 will need to be purchased on 1/04/2023 and will be depreciated at 10% g) Operating stock represents 1,600 items at unit variable cost. Creditors are for wages. h) Tax and interest charges can be ignored. The balance sheet of PoshEdd Company Ltd at 31 December 2022 is summarized below: GHS 000 GHS '000 700 Non-current assets Current assets Inventory of finished goods Debtors Cash Current liabilities Net current assets Capital employed 44.8 200,0 157.6 402.4 2.4 400 1,100 Following an advertising campaign around Christmas, the firm expects sales to rise in 2022 but it is not known precisely to what level. It is anticipated that 12,000 items will be sold in the year at an average price of GHS 100, though, with the uncertainty that exists over this figure, you have been asked to produce a flexible budget showing the profit if sales are 80%, 90%, 100%, 110 % and 120% of 12,000. You have also been asked to produce a cash budget showing the balance at the end of each quarter of 2023 and a budgeted statement of financial position at 31/12/2023, both if the 12,000 sales figure is achieved. You are told that: a) The level of demand is expected to be constant during 2022 though the actual level achieved will not be confirmed until the end of the first quarter. Production will be of 1,000 items per month during the first quarter, production in the second quarter will be sufficient to bring the end of June stock levels to 2 months; and in the remaining two quarters, production will match demand. b) Although it is intended to maintain the average sales price of GHe 100 per item, if sales are to reach the 120% level, it is felt that a quantity discount of 10% will need to be given on 20% of sales made. Page 1 of 2 c) All sales are on credit, 50% of debtors pay two months after sale and 50% pay three months after sale. Sales in 2022 had been constant throughout the year. d) Materials cost are GHe 20 per item. In order to achieve this purchase price, stocks have to be bought in bulk on the first day of each quarter and payment made within thirty days. For orders in excess of GHe 50,000 this cost will fall by 5%. e) Labor costs are based on piece- work scales of GHe3 per item, though the management of Eddposh Ltd have recently been reminded of a productivity bonus of 60p per item if monthly production from the workforce of 10 reaches 1,000 items. Labor costs are paid one month after they are incurred. f) Overhead costs are partly fixed and partly variable. The variable element amounts to GH5 per item payable in the month incurred. The fixed element is expected to be GH 500,000 of which GHe100,000 is depreciation of existing non-current assets. Half of the balance is payable monthly, a quarter at the end of June and a quarter at the end of December. If sales reach 120% additional machinery costing GH240,000 will need to be purchased on 1/04/2023 and will be depreciated at 10% g) Operating stock represents 1,600 items at unit variable cost. Creditors are for wages. h) Tax and interest charges can be ignored.
Expert Answer:
Answer rating: 100% (QA)
Here are the stepbystep workings with calculations shown for each part Flexible Budget for 2023 1 Sa... View the full answer
Related Book For
Managerial Accounting Decision Making and Performance Management
ISBN: 978-0273764489
4th edition
Authors: Ray Proctor
Posted Date:
Students also viewed these general management questions
-
This case study on project evaluation is applicable for beginning courses in corporate finance or finance strategy. Two alternative investment options are available to evaluate. Challenges are...
-
The Taos Museum of Southwestern Arts and Crafts (TMSAC) presents rotating exhibits of the works of artists and artisans from the Southwestern United States. Historically, the museum has derived its...
-
master budget case camdrone as part of the continued advancement of technology, a drone camera market has emerged in recent years the drone camera market has been growing as more photography...
-
What are the two(2) products dimensions that could be used if a position Map/Perception Map were to be created for VIA instant coffee?
-
Amount of interest capitalized during construction. Nexor, a steel manufacturer, self-constructs a new manufacturing facility in Vermont. At the start of 2008, the Construction-in-Process account had...
-
Consider the following T.F. of a certain discrete system given below. Form the state space equation of canonical form I model. H(z) = 2z + 6z +9 z + 8z +7z+ 16
-
Petitioner Christy Brzonkala met respondents Antonio Morrison and James Crawford at a campus party at Virginia Polytechnic Institute (Virginia Tech), where they were all students. At the party, the...
-
Kaj Rasmussen founded Scandi Home Furnishings as a corporation during mid-2007. Sales during the first full year (2008) of operation reached $1.3 million. Sales increased by 15 percent in 2009 and...
-
Problem 4. For the 2-point BVP: -u" (x) + 4u - sin(u)=0 on 0 x 1 with u(0)=u(1)=0. i) (1 point) Write down the main procedures of the shooting method for the BVP with the unknown parameter u'(0)=a,...
-
What motivates a parent to bribe key people to get their kid admitted to a prestigious university? That is the ethical question of Operation Varsity Blues. In March 2019, the story broke of an...
-
An oil engine working on the dual combustion cycle has a compression ratio 14 and the explosion ratio obtained from an indicator card is 1.4. If the cut-off occurs at 6 per cent of stroke, find the...
-
Bigbee Inc. had $ 1 5 0 , 0 0 0 in cash on the balance sheet at the beginning of the year. At year - end, the company had $ 2 2 5 , 0 0 0 in cash. We know cash flow from operating activities totaled...
-
a. [10] Consider the variable myList as follows: myList = [8, 0, 77, 'a', 'j', 7, 34] What do the following expressions evaluate to? If the evaluation will lead to an error, then write Error myList...
-
Solve the following percent problems. 1. What is 15 out of 75 as a percent? 2. What is 2 out of 50 as a percent? 3. What is 20 out of 100 as a percent? 4. What is 28% of 100? 5. What is 95% of 20? 6....
-
Hogwarts Express LLC is a manufacturer of Train Engines. Luckily they rely on a robust quality control system for in-process product inspection and not on magic to build high quality products. As...
-
For Selling and Administrative Expense Budget do you incorporate budgeted sales numbers or production numbers? Why or why not ?Explain
-
Suppose that the probability that a passenger will miss a flight is 0.0926. Airlines do not like flights with empty seats, but it is also not desirable to have overbooked flights because passengers...
-
KD Insurance Company specializes in term life insurance contracts. Cash collection experience shows that 20 percent of billed premiums are collected in the month before they are due, 60 percent are...
-
The current annual budget for King & Co., makers of baseball caps, is summarized as follows: ...............................................................................................000 Sales...
-
Marie and Peter Bridge run a business manufacturing and selling sets of the popular French game, boules. The boules are turned from aluminium, packaged in a neat carrying case and sold for 22 a set....
-
Carbotest Corporation manufactures equipment to test for the presence of carbon monoxide in confined spaces. It has just been offered a contract to build some specialized monitoring equipment to test...
-
____________ refers to the chronic exhaustion from persistent workload, decreased motivation, and apathy toward work.
-
Can the risks and health consequences (for individuals and organizations) associated with difficult customers and coworkers be alleviated with employee education and training? What experiences have...
-
Employee ____________ is the loss or turnover of employees to other jobs and industries perceived as having healthier workplace cultures.
Study smarter with the SolutionInn App