1.
Production Budget | |||||
1st Quarter | 2nd Quarter | 3rd Quarter | 4th Quarter | Annual | |
Budgeted Sales units | 2541 | 2778 | 2927 | 2276 | 10522 |
Add : Desired Ending Inventory | 556 | 586 | 456 | 519 | 519 |
Units Required | 3097 | 3364 | 3383 | 2795 | 11041 |
Less : Beginning Inventory | 508 | 556 | 586 | 456 | 508 |
Production Required | 2589 | 2808 | 2797 | 2339 | 10533 |
2.
Purchase Budget | |||||
1st Quarter | 2nd Quarter | 3rd Quarter | 4th Quarter | Annual | |
Production Required | 2589 | 2808 | 2797 | 2339 | 10533 |
Board feet per unit | 25 | 25 | 25 | 25 | |
Production Needs | 64725 | 70200 | 69925 | 58476 | 263326 |
Budgeted Ending inventory | 7020 | 6993 | 5848 | 10091 | 10091 |
Total DM Required | 71745 | 77193 | 75773 | 68567 | 273417 |
Beginning Inventory | 5555 | 7020 | 6993 | 5848 | 5555 |
Budgeted Purchases | 66190 | 70173 | 68780 | 62719 | 267862 |
Standard Price per neck | $ 5 | $ 5 | $ 5 | $ 5 | |
Budgeted Purchases Cost | $ 330,950 | $ 350,865 | $ 343,900 | $ 313,593 | $ 1,339,308 |
3.
Direct Labor Budget | |||||
1st Quarter | 2nd Quarter | 3rd Quarter | 4th Quarter | Annual | |
Production Required | 2589 | 2808 | 2797 | 2339 | 10533 |
Labor hours per unit | 12 | 12 | 12 | 12 | |
Total Direct Labor hours required | 31068 | 33696 | 33564 | 28069 | 126397 |
Cost per hour | $ 16 | $ 16 | $ 16 | $ 16 | |
Direct Labor cost | $ 497,088 | $ 539,136 | $ 537,024 | $ 449,096 | $ 2,022,344 |
4.
Direct Labor Budget | |||||
1st Quarter | 2nd Quarter | 3rd Quarter | 4th Quarter | Annual | |
Production Required | 2589 | 2808 | 2797 | 2339 | 10533 |
Labor hours per unit | 12 | 12 | 12 | 12 | |
Total Direct Labor hours required | 31068 | 33696 | 33564 | 28069 | 126397 |
Regular hours (Minimum) | 30000 | 30000 | 30000 | 30000 | |
Cost per hour | $ 16 | $ 16 | $ 16 | $ 16 | |
Direct Labor cost | $ 480,000 | $ 480,000 | $ 480,000 | $ 480,000 | $ 1,920,000 |
Additional Labor hours | 1068 | 3696 | 3564 | ||
Cost per hour | $ 24 | $ 24 | $ 24 | $ 24 | |
Additional Labor cost | $ 25,632 | $ 88,704 | $ 85,536 | $ - | $ 199,872 |
Total Labor cost | $ 505,632 | $ 568,704 | $ 565,536 | $ 480,000 | $ 2,119,872 |
Question 1 Swifty Furniture builds high-end hand-made dining tables. Attacus Simmons, the company's owner, has developed...
Waterway Furniture builds high-end hand-made dining tables. Attacus Simmons, the company’s owner, has developed the following sales forecast for 2018. Because of the time needed to create each table, Waterway maintains an ending Finished Goods Inventory of 20% of the following quarter’s budgeted sales. Waterway has been following this inventory policy for several years. The company ended 2017 with 509 tables on hand. The standard cost card for a table is as follows: Because of the time needed to create...
Exercise 5-14 Mackenzie Chemicals has developed a new window cleaner that requires two ingredients, AM972 and CA38. Based on forecasted sales, Mackenzie has d year the following budgeted production for the coming 1st Quarter 5,520 2nd Quarter 8,300 3rd Quarter 9,780 4th Quarter 13,260 1st Quarter Next Year 7,000 Forecasted production (gallons) Each gallon of window cleaner requires 150 ounces of AM972 and 25 ounces of CA38. An ounce of AM972 costs Mackenzie $0.15. An ounce of CA38 costs the...
CALCULATOR PRINTER VERSION BACK NEXT SOURCES Exercise 5-14 Marigold Chemicals has developed a new window cleaner that requires two ingredients, AM972 and CA38. Based on forecasted sales, Marigold has developed the following budgeted production for the coming year. 1st Quarter 5,030 2nd Quarter 7,910 3rd Quarter 9.000 4th Quarter 13,260 Ist Quarter Next Year 6,070 Forecasted production (gallons) Each gallon of window cleaner requires 145 ounces of AM972 and 28 ounces of CA38. An ounce of AM972 costs Marigold 50.15....
The Diesel Dynamo Company is a high-tech diesel subsystem production business that produces technology accessories for trucks and other transport. The design of Diesel Dynamo products are unique and represent a breakthrough in the industry. The units Diesel Dynamo produces claim to provide for greater dependability, quality and longevity. The company is completing its third year of operations and is preparing to create a master budget for next year, 2017. The budget will detail each quarter’s activities and the activity...
Problem 5-31 Vaughn Enterprises is a boutique guitar manufacturer. The company produces both acoustic and electric guitars for rising and established professional musicians. Vanessa Aaron, the company's sales manager, prepared the following sales forecast for 2018. The forecasted sales prices include a 5% increase in the acoustic guitar price and a 10% increase in the electric guitar price, to cover anticipated increases in raw materials prices. Acoustic guitar sales Electric guitar sales Sales Price $1,200 $2,350 1st Quarter 190 400...
Please help!!! The Diesel Dynamo Company is a high-tech diesel subsystem production business that produces technology accessories for trucks and other transport. The design of Diesel Dynamo products are unique and represent a breakthrough in the industry. The units Diesel Dynamo produces claim to provide for greater dependability, quality and longevity. The company is completing its third year of operations and is preparing to create a master budget for next year, 2017. The budget will detail each quarter’s activities and...
Question Two (40 Marks): School Days Furniture, Inc., manufactures a variety of desks, chairs, tables, and shelf units which are sold to public school systems throughout the mid-west. The controller of the company's Desk Division is currently preparing a budget for the third quarter of the year. The following sales forecast has been made by the division's sales manager. July 10,000 desk-and-chair sets August 12,000 desk-and-chair sets September 15,000 desk-and-chair sets Each desk-and-chair set requires 10 board feet of pine...
Need Help!!! The Diesel Dynamo Company is a high-tech diesel subsystem production business that produces technology accessories for trucks and other transport. The design of Diesel Dynamo products are unique and represent a breakthrough in the industry. The units Diesel Dynamo produces claim to provide for greater dependability, quality and longevity. The company is completing its third year of operations and is preparing to create a master budget for next year, 2017. The budget will detail each quarter’s activities and...
The Diesel Dynamo Company is a high-tech diesel subsystem production business that produces technology accessories for trucks and other transport. The design of Diesel Dynamo products are unique and represent a breakthrough in the industry. The units Diesel Dynamo produces claim to provide for greater dependability, quality and longevity. The company is completing its third year of operations and is preparing to create a master budget for next year, 2017. The budget will detail each quarter’s activities and the activity...
Grant Ltd Grant Ltd operates at capacity and makes glass-topped dining tables. At the end of 2018, Grant Ltd.’s management accountant gathered the following data to prepare budgets for the first six months 2019: Units sales per quarter and the selling price per unit are estimated as follows: Unit sales Price per unit January 2,500 $450 February 2,800 $450 March 2,750 $480 April 2,750 $480 May 2,800 $500 June 2,800 $500 July 3,000 $500 August 3,000 $500 Sales on...