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
-
A plane flies north at 215 km/h. A wind from the east blows at 69 km/h. What is the planes new velocity with respect to the ground in standard position?
-
Ron and Hermione formed Wizard Corporation on January 2. Ron contributed cash of $200,000 in return for 50 percent of the corporation's stock. Hermione contributed a building and land with the...
-
Identify the four common operating cycles of business activity.
-
Most firms in the apparel and footwear industries choose to outsource production to countries where labor is abundant (primarily, Southeast Asia and the Caribbean)but those firms do not integrate...
-
show R studio script and get data from link in the question/ show all steps
-
Olive Enterprises experienced the following events during 2018: 1. Acquired cash from the issue of common stock. 2. Paid cash to reduce the principal on a bank note. 3. Sold land for cash at an...
-
What was the calculation made to to find the per unity operating income for requirement 2?
-
The current stock price is selling for $64 and has a dividend growth rate of 2%. Investors require a rate of return of 12%. What would you expect the annual dividend to be? Please ensure that you are...
-
Question 1: (30 marks) (a) Loss amounts under a class of insurance policies follow an exponential distribution with mean 100. The insurance company wishes to enter into an individual excess of loss...
-
Considering the case of Van Orden v. Perry, To what extent do you think Supreme Court Justices are able to divorce their personal religious beliefs from how they see a challenge based on religious...
-
Jack asked Jill to marry him, and she has accepted under one condition: Jack must buy her a new $320,000 Rolls-Royce Phantom. Jack currently has $66,130 that he may invest. He has found a mutual fund...
-
Zhang Industries budgets production of 390 units in June and 400 units in July. Each unit requires 1.5 hours of direct labor. The direct labor rate is $15.80 per hour. The indirect labor rate is...
-
Blue-Light (BL) Plc. and Red-Switch (RS) Plc. are two firms which produce glass and electrical components for lighting manufactures. BL Plc. has 8.2m shares and currently trades at 4.52 per share. RS...
-
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.
-
Does price discrimination work when reselling is easy?
-
Why does price discrimination exist?
-
A price-discriminating monopolist will a. price where marginal revenue equals marginal cost for each different group of demanders. b. charge a higher price to those with a greater willingness to pay...
Study smarter with the SolutionInn App