Question

Question 1 Swifty Furniture builds high-end hand-made dining tables. Attacus Simmons, the companys owner, has developed theYour answer is partially correct. Try again. Prepare Swiftys production budget for 2018. Assume that the desired ending inveSwifty maintains inventory of American cherry wood equal to 10% of the following quarters production needs. On December 31,

Prepare Swiftys direct labor budget for 2018. (Round answers to 0 decimal places, e.g. 5,275.) Direct Labor Budget 1st QuartAssume that because of the skill level required to make the tables, Swifty cannot easily hire additional workers to handle pe

0 0
Add a comment Improve this question Transcribed image text
Answer #1

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
Add a comment
Know the answer?
Add Answer to:
Question 1 Swifty Furniture builds high-end hand-made dining tables. Attacus Simmons, the company's owner, has developed...
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Not the answer you're looking for? Ask your own homework help question. Our experts will answer your question WITHIN MINUTES for Free.
Similar Homework Help Questions
  • Waterway Furniture builds high-end hand-made dining tables. Attacus Simmons, the company’s owner, has developed the following...

    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...

    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...

    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 t...

    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...

    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...

    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...

    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...

    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...

    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...

    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...

ADVERTISEMENT
Free Homework Help App
Download From Google Play
Scan Your Homework
to Get Instant Free Answers
Need Online Homework Help?
Ask a Question
Get Answers For Free
Most questions answered within 3 hours.
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT