Exquisite Bedding Limited You have recently been promoted as Management Accountant of Exquisite Bedding Limited, a...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
Exquisite Bedding Limited You have recently been promoted as Management Accountant of Exquisite Bedding Limited, a small company that manufactures a specialized bed for the elderly which is sold to the public and its wholly-owned subsidiary company, Ultimate Care Ltd a retain department store. The company uses a rolling budgetary control system and is in the process of preparing the budget for the four months period from September to December 2021. During the preliminary review, you established that the company intends to sell each bed produced for $219 to Ultimate Care in addition to individual customers on the same credit terms. Exquisite Bedding Ltd secured a cash loan of 120,000 from Broughton Bank that was secured on the land and building at an interest rate of 7.5% per annum. The loan is due to be received in November 2021. The repayment of the loan will begin on March 1, 2022, however monthly interest payments will begin in December 2021. Also, machinery costing $112,000 will be received in November and paid for in December. You have been provided with the following budgeted balance sheet information as at September 1, 2021 as well as estimates and other operating data: ASSETS Exquisite Bedding Limited Budgeted Balance Sheet as at September 1, 2021 Cost Depreciation to Date S $ Non-current Asset Land and Building Machinery and equipment Motor Vehicles Current assets Closing stock: Raw materials Finished goods Receivables cash at bank Total Asset Equity 500,000 $1 ordinary shares Share premium Retained earnings 500,000 124000 42000 666,000 4320 10450 0 84500 16400 100,900 14770 9040 6790 500000 50960 40840 Net book value $ 500,000 39,500 25,600 565,100 30600 595,700 591800 Equity 500,000 $1 ordinary shares Share premium Retained earnings Current liabilities Accounts payable Total Equity and liability Other information: 500000 50960 40840 591800 3900 595700 1. Estimates sales in units for September will be 80 units. Sales units will increase by 10 units each month. 2. All sales are on account. The customer is allowed to pay 50% in the month of sale and the remainder the month following sale. 3. Sales on account for August was $18,080. 4. Stock valuation was done using FIFO method and closing stock of finished goods on August 31 will be 100 units. The company's policy is to have the next month's sales in units in stock of finished goods at the end of each month 5. It is the company's policy to maintain 50% of the materials required for the next month's production. The opening stock of raw material is 175 kgs 6. The company estimated that it will have to pay $10 per unit for raw materials. 5 kgs of raw material is required to produce one bed. 7. All purchases of raw material are on account. 60% of raw material purchases are paid for in the month of purchase and 40% the month following purchase. Accounts payable for August 31, 2021 was 3900. 8. Variable overheads are charged at a rate of $3 per labour hour. Fixed overheads were estimated at $1,200 per month. 9. The company sublets a section of the factory and the monthly rent of $3,000 is received in the month incurred. 10. Each bed takes 12 labour hours at a rate of $5 per labour hour. 11. An interim dividend of $20,000 for 30th September 2021 will be paid in November 2021. 12. The company will purchase a special tool for $70,000 in November to increase the production of specially designed headboards. 13. Depreciation for the four months, including the new machinery, was calculated to be: Machinery and equipment Motor Vehicle 14. Other monthly expenses are as follows: transportation cost $1,250 and miscellaneous expenses of $750 15. The company's policy is to maintain a minimum cash balance of $10,000 each month. $15,733 $3,500 You are required to prepare the following budgets for the four months and in total: [6 marks] [10 marks] [12.5 marks] [14.5 marks] [10 marks] [4.5 marks] [4.5 marks] [31.5 marks] Sales budget Cash collection schedule Production budget Direct material budget Cash disbursement budget Labour budget Overhead budget Cash budget Exquisite Bedding Limited You have recently been promoted as Management Accountant of Exquisite Bedding Limited, a small company that manufactures a specialized bed for the elderly which is sold to the public and its wholly-owned subsidiary company, Ultimate Care Ltd a retain department store. The company uses a rolling budgetary control system and is in the process of preparing the budget for the four months period from September to December 2021. During the preliminary review, you established that the company intends to sell each bed produced for $219 to Ultimate Care in addition to individual customers on the same credit terms. Exquisite Bedding Ltd secured a cash loan of 120,000 from Broughton Bank that was secured on the land and building at an interest rate of 7.5% per annum. The loan is due to be received in November 2021. The repayment of the loan will begin on March 1, 2022, however monthly interest payments will begin in December 2021. Also, machinery costing $112,000 will be received in November and paid for in December. You have been provided with the following budgeted balance sheet information as at September 1, 2021 as well as estimates and other operating data: ASSETS Exquisite Bedding Limited Budgeted Balance Sheet as at September 1, 2021 Cost Depreciation to Date S $ Non-current Asset Land and Building Machinery and equipment Motor Vehicles Current assets Closing stock: Raw materials Finished goods Receivables cash at bank Total Asset Equity 500,000 $1 ordinary shares Share premium Retained earnings 500,000 124000 42000 666,000 4320 10450 0 84500 16400 100,900 14770 9040 6790 500000 50960 40840 Net book value $ 500,000 39,500 25,600 565,100 30600 595,700 591800 Equity 500,000 $1 ordinary shares Share premium Retained earnings Current liabilities Accounts payable Total Equity and liability Other information: 500000 50960 40840 591800 3900 595700 1. Estimates sales in units for September will be 80 units. Sales units will increase by 10 units each month. 2. All sales are on account. The customer is allowed to pay 50% in the month of sale and the remainder the month following sale. 3. Sales on account for August was $18,080. 4. Stock valuation was done using FIFO method and closing stock of finished goods on August 31 will be 100 units. The company's policy is to have the next month's sales in units in stock of finished goods at the end of each month 5. It is the company's policy to maintain 50% of the materials required for the next month's production. The opening stock of raw material is 175 kgs 6. The company estimated that it will have to pay $10 per unit for raw materials. 5 kgs of raw material is required to produce one bed. 7. All purchases of raw material are on account. 60% of raw material purchases are paid for in the month of purchase and 40% the month following purchase. Accounts payable for August 31, 2021 was 3900. 8. Variable overheads are charged at a rate of $3 per labour hour. Fixed overheads were estimated at $1,200 per month. 9. The company sublets a section of the factory and the monthly rent of $3,000 is received in the month incurred. 10. Each bed takes 12 labour hours at a rate of $5 per labour hour. 11. An interim dividend of $20,000 for 30th September 2021 will be paid in November 2021. 12. The company will purchase a special tool for $70,000 in November to increase the production of specially designed headboards. 13. Depreciation for the four months, including the new machinery, was calculated to be: Machinery and equipment Motor Vehicle 14. Other monthly expenses are as follows: transportation cost $1,250 and miscellaneous expenses of $750 15. The company's policy is to maintain a minimum cash balance of $10,000 each month. $15,733 $3,500 You are required to prepare the following budgets for the four months and in total: [6 marks] [10 marks] [12.5 marks] [14.5 marks] [10 marks] [4.5 marks] [4.5 marks] [31.5 marks] Sales budget Cash collection schedule Production budget Direct material budget Cash disbursement budget Labour budget Overhead budget Cash budget
Expert Answer:
Answer rating: 100% (QA)
1Sales Budget Particulars Units Sales in amount 219 per unit 2 Production Budget Particulars Sales u... View the full answer
Related Book For
Accounting concepts and applications
ISBN: 978-0538745482
11th Edition
Authors: Albrecht Stice, Stice Swain
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...
-
You have recently been hired by Keafer Manufacturing to work in its newly established treasury department. Keafer Manufacturing is a small company that produces highly customized cardboard boxes in a...
-
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...
-
You are the cashier employed at Tastee Limited. On November 30, 2020, you started with a float of $6,500 and at the end of the business day your cash in the cash till were as follows: Notes Coins...
-
Explain the general requirements that must be met to obtain a deduction for moving expenses and the type of moving expenses that are deductible.
-
What is the difference between historical cost and fair value measurements?
-
Fashion Fabrics sells sewing and craft materials to specialty retail and department stores. For the year, the company's New York Division had the following performance targets: Actual information...
-
The stockholders equity accounts of Warden Corporation on January 1, 2014, were as follows. Preferred Stock (9%, $50 par cumulative, 10,000 shares authorized)......$ 200,000 Common Stock ($1 stated...
-
What is Apple's strategy concerning the use of warehouses? this is a supply class btw
-
Figure 2 shows the support structure for a suspended apparatus in a laboratory. The apparatus is hung from the 1/4" A36 plate that is welded to the 3/8" plate using E70XX electrodes. Assuming that...
-
Utilitarian philosopher J.S. Mill assumes that happiness O can't be measured, because it is a subjective phenomenon (belonging to our personal experience) which simply can't be quantified. O is a...
-
If annual total disposable income is $60,000 and your annual credit card interest is $1,500, using common-size analysis, what is the percentage of your annual credit card interest to total disposable...
-
1. This is a question about binary min-heaps. 1. Given the binary min-heap A = [1, 60, 18, 83, 97, 68, 47, 99] do the following: (a) Draw the tree representation. [3 marks] (b) Show the steps...
-
Flexible budgets can be an effective tool for the manager of advertising sales at Google to enhance performance by allowing for better decision - making based on actual performance. A flexible budget...
-
what are each of these budgeting systems and how are they different from each other Traditional Performance Budgets Program Budgets Zero-based Budget System New Performance Budgeting Participatory...
-
Akasaka Investment Company established a portfolio of warehouse properties with a total market value of THB3.60 billion. It secured mortgage financing of THB2.61 billion. The terms of the mortgage...
-
An organization\'s fulfillment process maps most directly to the _ _ _ _ _ activity in Porter\'s Value Chain. Question 4 4 options: A ) inbound logistics B ) outbound logistics C ) operations D )...
-
The age-old saying for investing is "buy low and sell high," but this is easier said than done. Investors who panic about falling prices sell their investments, which in turn lowers the price and...
-
What is the danger in focusing a financial analysis solely on the data found in the historical financial statements?
-
Which inventory method (perpetual or periodic) provides better control over a firms inventory?
-
Following are the operating data for a marketing firm for the year ended December 31, 2012. For 2012, determine: 1. Income before taxes. 2. Income taxes. 3. Net income. 4. Earnings per share (EPS),...
-
Use Kruskal's algorithm to find a minimal cost spanning tree for a graph whose vertices are labeled \(\{1,2, \ldots, 8\}\) and whose edges have the costs below: 146 51 25 321 1321 - - - - 2 - 21 -...
-
A variation on the critical path problem is the task scheduling problem. In this problem, unlike the critical path problem, explicit attention is paid to how many workers are available to do tasks,...
-
Cables are to connect several components of a sound system. The vertices in the graph below represent the components, and the edges are possible connections. The matrix above gives the lengths of...
Study smarter with the SolutionInn App