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)
To address the requirements outlined in the problem statement we need to prepare a flexible budget s... 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?
-
Travel Warehouse Ltd. distributes suitcases to retail stores. At the end of June, Travel Warehouse's inventory consisted of 60 suitcases purchased at $50 each. Travel Warehouse uses a perpetual...
-
In the past, Taylor Industries has used a fixed time period inventory system that involved taking a complete inventory count of all items each month. However, increasing labor costs are forcing...
-
Explain internal control procedures for merchandise sales. - Since sales revenues have a significant effect on a company's net income, internal control procedures must be established to ensure that...
-
A gas-phase decomposition reaction with stoichiometry 2A ? 2B + C follows a second-order rate law (see Problem 11.14): rd [mo1/(m3?s)] = kC2A where CA is the reactant concentration in moUrn3. The...
-
For each of the given functions you are asked to sketch an accurate graph, by following all steps required. a] Domain 3: Range. Calculate the limits at iota. [f4] h} Intercepts [f2] c] Symmetry [f2]...
-
Tonys Precision Computer Centre is picking up in business, so he has decided to expand his bookkeeping system to a general journal/ledger system. The balances from June have been forwarded to the...
-
Paty Ltd operating containers and it is contemplating two cost structures for its operations. A. High variable cost pu container with lower annual fixed costs B. Lower variable cost with higher fixed...
-
Problem 8-43 (LO. 2, 3, 4) On March 15, 2023, Helen purchased and placed in service a new Escalade. The purchase price of the automobile was $62,000, and the vehicle had a rating of 6,500 GVW. The...
-
List four circumstances under which the customs department may revoke a license granted to a manufacturer of excisable goods. (b) Explain the following terms as used in customs control: i) Clean...
-
A large chain amusement park sells tickets at its main gate for guests who are visiting the park for just that one day. The park also sells seasonal passes that can only be used on weekdays. What...
-
1. ethical leadership leader traits 2. ethical leadership leader values Explain briefly,
-
What is the importance of performance management systems? What are some of the strategies that organizations must consider when selecting the best performance management system. Choose three...
-
Determine if the following could be a probability distribution for a discr random variable, X. If no, state why. X 3 6 9 12 15 P(X=x) 4/9 2/9 1/9 1/9 1/9 No, the probabilities do not add up to 1....
-
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...
-
Which of the following statements about basic assumptions is incorrect? a. Basic assumptions are the same as accounting principles. b. The economic entity assumption states that there should be a...
-
Performing services on account will have the following effects on the basic accounting equation: a. increase assets and decrease stockholders' equity. b. increase assets and increase stockholders'...
-
Which of the following is not a step in the accounting process? a. identification. b. verification. c. recording. d. communication.
Study smarter with the SolutionInn App