Arising out of a meeting with the budget committee, it was decided that a new industrial...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
Arising out of a meeting with the budget committee, it was decided that a new industrial sander and polisher equipment would be purchased on 1st January 2020. It is expected to take most of the year to train the personnel and reorganize the production process to take full advantage of the new equipment. In response to the issue about financing the acquisition of new equipment, George stated that the sander and polisher equipment will cost $3,000,000 with an additional cost of $100,000 for ancillary equipment The total acquisition will be financed with a one-year loan from XIM Bank and Trust Company on 1 January 2020. The agreement of the 16% loan is that repayment of principal and interest will be paid on 31" December 2020. Woodland's Company Limited is a manufacturer of wooden tables with glass tops: large and small. The firm's two products are designated as L (large table, 60 x 24 inches) and S (small table, 36 x 18 inches). The primary raw materials are lumber and glass sheets 60x30 inches. Large table requires thirteen square feet of lumber while S small wooden table requires nine square feet of lumber. Allowing for normal breakage and scrap glass, the company can get either two Small table-tops or one Large table top out of a glass sheet. Other raw materials, such as cardboard backing, are insignificant in cost and are treated as indirect materials. has gathered the following information: 1. Sales, principal budget factor, in the fourth quarter 2019 are expected to be 5,000 Large tables and 7,000 Small tables. Based on improved economic outlook, the sales manager predicts that for the next two years 2020 and 2021, sales for Small and large tables will grow by 10% each quarter over the previous quarter. 2. Woodland Company Limited sales history indicates that 70 percent of all sales are on credit, with the remainder of the sales in cash. The company's collection experience shows that 60 percent of the credit sales are collected during the quarter in which the sale is made and the remainder is collected in the following quarter! 3. Currently, the Large table sells for $1,100 each, and the Small table sells for $850 each. It is expected that prices will hold firm throughout 2020. 4. Nathaneal Samuels the production manager attempts to end each quarter with enough finished goods inventory in each product line to cover 20 percent of the following quarter's sales. Moreover, an attempt is made to end each quarter with 25 percent of the glass sheets needed for the following quarter's production. Assume an ending inventory of 2,400 glass sheets for the fourth quarter of 2019. Lumber is purchased locally, the company buys them on a just-in-time basis, inventory is negligible. 5. All direct-material purchases are made on account, and 80 percent of each quarter's purchases are paid in cash during the same quarter as the purchase. The remainder is paid in the next quarter. 6. Indirect materials are purchased with cash as needed. Work-in-process is insignificant. 7. Projected manufacturing costs for 2020 are as follows: Direct material Lumber: Large: 13sq. ft. @ $20 per sq. foot Small 9sq.ft. @ $20 per sq. foot Glass sheets. Large: Isheet @ $60 per sheet Small: sheet @ $60 per sheet Direct labour Large: 5 hours @ $40 per hour Small: 3 hours @ $40 per hour Manufacture overhead Carchite Gond to ng Large table 0.5 direct-labour hour x $10 per hour $260 60 200 Small table $180 11 30 120 Focu Manufacture overhead 0.5 direct-labour hour x $10 per hour Total product cost per unit 8. The following production overheads are budgeted for 2020. Indirect material Indirect labour Other overhead Depreciation Total overhead costs 408,000 310,000 240,000 5 $525 1st Quarter 2nd Quarter 3rd Quarter 4th Quarter 102,000 112,000 122,000 132,000 $1,060,000 448,000 360,000 240,000 488,000 410,000 240,000 5 $335 $1,160,000 $1,260,000 528,000 460,000 240,000 $1,360,000 9. Administration and Selling overhead uses the following quarterly cost function: y-577,316+64.66X) NOTE: Round off numbers to the nearest whole number. 10. Mark anticipates for each quarter dividend of $200,000 will be declared and paid in cash 11. Woodland's Company Limited projected balance sheet as of December 31, 2019, follows: $ 10,000,000 731,828 3,404,500 Plant Property and Equipment (net book value) Cash Accounts receivable Inventory: Raw material Finished goods Total assets Common stock @ $1 Retained earnings Accounts payable Total liabilities and shareholders' equity 242,000 2,031,600 16,409,928 (b) Schedule of cash collected from customers. 9,000,000 6,149,633 1,260,295 16,409,928 Required: Prepare Woodland Company Limited master budget for each quarter of 2020 and in total for the year by completing the following schedules and statements: (a) Sales budget (prepare 4th quarter of 2019 as well as well as) (c) Production budget (prepare 4 quarter of 2019 as well as 1 quarter of 2021). (d) Direct-material budget (prepare 4th quarter of 2019 as well) (8 marks) (20 marks) (58 marks) (84 marks) (e) Schedule of cash disbursement to suppliers for direct material. (f) Direct labour budget. (g) Production overhead budget. (1) Cash budget (15 marks) TOTAL (28 marks) (h) Selling and administrative budget. (Round off variable cost to 2 decimal places and fixed cost to the nearest whole number). Show regression computation. (10 marks) (30 marks) (52 marks) (305 marks) Arising out of a meeting with the budget committee, it was decided that a new industrial sander and polisher equipment would be purchased on 1st January 2020. It is expected to take most of the year to train the personnel and reorganize the production process to take full advantage of the new equipment. In response to the issue about financing the acquisition of new equipment, George stated that the sander and polisher equipment will cost $3,000,000 with an additional cost of $100,000 for ancillary equipment The total acquisition will be financed with a one-year loan from XIM Bank and Trust Company on 1 January 2020. The agreement of the 16% loan is that repayment of principal and interest will be paid on 31" December 2020. Woodland's Company Limited is a manufacturer of wooden tables with glass tops: large and small. The firm's two products are designated as L (large table, 60 x 24 inches) and S (small table, 36 x 18 inches). The primary raw materials are lumber and glass sheets 60x30 inches. Large table requires thirteen square feet of lumber while S small wooden table requires nine square feet of lumber. Allowing for normal breakage and scrap glass, the company can get either two Small table-tops or one Large table top out of a glass sheet. Other raw materials, such as cardboard backing, are insignificant in cost and are treated as indirect materials. has gathered the following information: 1. Sales, principal budget factor, in the fourth quarter 2019 are expected to be 5,000 Large tables and 7,000 Small tables. Based on improved economic outlook, the sales manager predicts that for the next two years 2020 and 2021, sales for Small and large tables will grow by 10% each quarter over the previous quarter. 2. Woodland Company Limited sales history indicates that 70 percent of all sales are on credit, with the remainder of the sales in cash. The company's collection experience shows that 60 percent of the credit sales are collected during the quarter in which the sale is made and the remainder is collected in the following quarter! 3. Currently, the Large table sells for $1,100 each, and the Small table sells for $850 each. It is expected that prices will hold firm throughout 2020. 4. Nathaneal Samuels the production manager attempts to end each quarter with enough finished goods inventory in each product line to cover 20 percent of the following quarter's sales. Moreover, an attempt is made to end each quarter with 25 percent of the glass sheets needed for the following quarter's production. Assume an ending inventory of 2,400 glass sheets for the fourth quarter of 2019. Lumber is purchased locally, the company buys them on a just-in-time basis, inventory is negligible. 5. All direct-material purchases are made on account, and 80 percent of each quarter's purchases are paid in cash during the same quarter as the purchase. The remainder is paid in the next quarter. 6. Indirect materials are purchased with cash as needed. Work-in-process is insignificant. 7. Projected manufacturing costs for 2020 are as follows: Direct material Lumber: Large: 13sq. ft. @ $20 per sq. foot Small 9sq.ft. @ $20 per sq. foot Glass sheets. Large: Isheet @ $60 per sheet Small: sheet @ $60 per sheet Direct labour Large: 5 hours @ $40 per hour Small: 3 hours @ $40 per hour Manufacture overhead Carchite Gond to ng Large table 0.5 direct-labour hour x $10 per hour $260 60 200 Small table $180 11 30 120 Focu Manufacture overhead 0.5 direct-labour hour x $10 per hour Total product cost per unit 8. The following production overheads are budgeted for 2020. Indirect material Indirect labour Other overhead Depreciation Total overhead costs 408,000 310,000 240,000 5 $525 1st Quarter 2nd Quarter 3rd Quarter 4th Quarter 102,000 112,000 122,000 132,000 $1,060,000 448,000 360,000 240,000 488,000 410,000 240,000 5 $335 $1,160,000 $1,260,000 528,000 460,000 240,000 $1,360,000 9. Administration and Selling overhead uses the following quarterly cost function: y-577,316+64.66X) NOTE: Round off numbers to the nearest whole number. 10. Mark anticipates for each quarter dividend of $200,000 will be declared and paid in cash 11. Woodland's Company Limited projected balance sheet as of December 31, 2019, follows: $ 10,000,000 731,828 3,404,500 Plant Property and Equipment (net book value) Cash Accounts receivable Inventory: Raw material Finished goods Total assets Common stock @ $1 Retained earnings Accounts payable Total liabilities and shareholders' equity 242,000 2,031,600 16,409,928 (b) Schedule of cash collected from customers. 9,000,000 6,149,633 1,260,295 16,409,928 Required: Prepare Woodland Company Limited master budget for each quarter of 2020 and in total for the year by completing the following schedules and statements: (a) Sales budget (prepare 4th quarter of 2019 as well as well as) (c) Production budget (prepare 4 quarter of 2019 as well as 1 quarter of 2021). (d) Direct-material budget (prepare 4th quarter of 2019 as well) (8 marks) (20 marks) (58 marks) (84 marks) (e) Schedule of cash disbursement to suppliers for direct material. (f) Direct labour budget. (g) Production overhead budget. (1) Cash budget (15 marks) TOTAL (28 marks) (h) Selling and administrative budget. (Round off variable cost to 2 decimal places and fixed cost to the nearest whole number). Show regression computation. (10 marks) (30 marks) (52 marks) (305 marks)
Expert Answer:
Answer rating: 100% (QA)
Question The Woodland Company Limited Master Budget for 2020 is as follows A Sales budget prepare 4th quarter of 2019 as well as 1st quarter of 2020 4th Quarter 2019 Large tables 5000 Small tables 700... View the full answer
Related Book For
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...
-
How does HCA's financial strategy affect its product-market strategy? How important is finance to HCA and in what ways? (Please no plagiarism) Hospital Corporation of America (A) In January of 1982...
-
Jay Rexford, president of Photo Artistry Company, was just concluding a budget meeting with his senior staff. It was November of 20x4, and the group was discussing preparation of the firms master...
-
In Exercises verify the identity. coshx = 1 + cosh 2x 2
-
Financial accounting information can often be found at financial websites. These websites are useful for collecting information about a companys stock price, analysts forecasts, dividend history,...
-
Expansion Capital Group (ECG), a Delaware company, worked out of Sioux Falls, South Dakota. Matt Patterson invested $100,000 in ECG. ECG provides small business financing through business loans and...
-
The vertical motion of a machine is measured by using the arrangement shown in Fig. 10.43. The motion of the mass \(m\) relative to the machine body is recorded on a drum. If the damping constant...
-
Harris Furniture Company manufactures living room furniture through two departments: Framing and Upholstering. Materials are entered at the beginning of each process. For May, the following cost data...
-
Consider a RAID level 4 organization comprising five disks, with the parity for sets of four blocks on four disks stored on the fifth disk. How many block I / O operations will occur to perform the...
-
Bright Sparks Electrical - Bank Register Report: Now that you have completed the journals for the month, you need to prepare the Bank Register Report in the template below. Not all general journals...
-
Solve the system of nonlinear equations using elimination. x 2 + y 2 = 25 x 2 - y 2 = 1
-
Write a program that reads all lines from a file and, using a Stream , prints how many of them contain the word the.
-
What happens if you try to save an object that is not serializable in an object output stream? Try it out and report your results.
-
Consider a stack that is implemented as a linked list, as in Section 16.3.1. Describe two different scenarios in which race conditions can corrupt the data structure.
-
Design an XML document that describes a bank account.
-
How do you move the file pointer to the first byte of a file? To the last byte? To the exact middle of the file?
-
please show the step by step helping me understand how this ansappear Wildhorse Co, compiled the following financial information as of December 31, 2022: Wildhorse's retained earnings on December 31,...
-
Vince, Inc. has developed and patented a new laser disc reading device that will be marketed internationally. Which of the following factors should Vince consider in pricing the device? I. Quality of...
-
Why might advance notice be required before a strike or lockout begins?
-
Distinguish between industrial relations and human resource management.
-
Explain why most provincial labour codes require a minimum level of support among workers for a certification application to be filed.
-
Which are qualitative and which are quantitative? a. The number of patients admitted to a hospital on a given day b. The model of car last sold by a particular car dealer c. The name of your favorite...
-
Is the color of a smartphone nominal or ordinal?
-
A pollster wants to estimate the proportion of voters in a certain town who are Democrats. He goes to a large shopping mall and approaches people to ask whether they are Democrats. Is this a simple...
Study smarter with the SolutionInn App