Question

The budget director of Royal Furniture Company requests estimates of sales, production, and other operating data from the various administrative units every month. Selected information concerning sales and production for February is summarized as follows: Actual Units (Decrease) Units (rounded) 3. Prepare a sales budget for the year ending December 31, 2049. OB1.4 PR 22-2B Sales, production, direct materials purchases, and direct labor cost budgets ases, a. Estimated sales of King and Prince chairs for February by sales territory: 610 units at $780 per unit 750 units at $550 per unit Northern Domestic: King.. Prince Southern Domestic: King Prince International: King. Prince 340 units at $780 per unit 440 units at $550 per unit 360 units at $850 per unit 290 units at $600 per unit

Can you show me the formula or equation to get the right answers.

Answer 1

1. Sales Budget Sales Budget Unit sales Volume Unit Selling Price Total sales King: Northen Domestic Southern Domestic International Add Add 6100 $ 340 $ 360 $ 1310 780 $ 780 $ 850 $ $ 475,800 265,200 306,000 1,047,000 Total 550 S Add Add Prince: Northen Domestic Southern Domestic International Total Total revenue from sales 750 $ 440 $ 2900 $ 1480 550 $ 600 $ 412,500 242,000 174,000 828,500 1,875,500 $ 2790 $ Total Sales = Unit sales volume x Unit selling price 2. Production Budget Production Budget King Prince 1310 80 1480 Calculate above 35 given Add Expected Units to be sold Desired Inventory, Feb 28 Total Estimated Inventory, Feb 1 Total Units to be produced 1390 90 1515 25 given Less 1300 1490

3. Direct material Purchase Budget Direct material Purchase Budget Wood Fabric Filler Springs Total Add Required Units of Production King Prince Desired units of inventory, Feb 28 Total Estimated units of inventory, Feb 1 Total units to be purchased Unit Price Total Direct material to be purchased given 7800 5960 3901 141501 420 13730 12.00 $ 164,760 $ 49400 38740 650 88790 580 88210 7.00 $ 617,470 S 5460 5066 300 10826 250 10576 3.00 $ 31,728 $ 20800 17880 540 39220 660 Less given 38560 4.50 Multiply $ $ given 987,478 173,520 $ Wood Required Units of Production = units to be produced x material per unit King Prince Fabric 1300 x 6 1490 x 4 1300 x 38 1490 x 26 Filler 1300 x 4.2 1490 x 3.4 Springs 1300 x 16 1490 x 12 4.Direct Labor Cost Budget Direct Labor Cost Budget Framing Dept Cutting dept Upholstrey Dept Total 1040 Add Hours required for production: King Prince Total Hourly Rate Total direct labor cost 1560 1490 3050 12.00 $ 36,600 $ 650 596 1246 14.00 $ 17,444 $ 894 1934 15.00 29,010 $ Multiply $ $ given 83,054 Hours required for Production = units to be produced x material per unit King Prince Framing Dept 1300 x 1.2 1490 x 1.0 Cutting dept 1300 x 0.5 1490 x 0.4 Upholstrey Dept 1300 x 0.8 1490 x 0.6