QUESTION 16 Login Pre-Kinder Exercises Use the Excel template for your answers Answers Final Test Chap 13.xlsx 1. Based on the following production and sales data of Jackson Co. for March of the current year prepare (a) a sales budget and (b) a production budget Product ProductX Estimated inventory, March 1 26,000 units 18 000 units Desired inventory, March 31 32,000 units 15.000 units Expected sales volume Areal 320,000 units 260.000 units Area 11 190,000 units 130,000 units Unit sales price S4 $12 2. Browning Inc. production budget for Product X for the year ended December 31 is as follows Sales Plus desired ending inventory Total Less estimated beginning inventory, Jan. 1 Total production Product X 140 000 units 85.000 125.000 90.000 635.000 In Browning's production operations, Materials A B, and are required to make Product X The quantities of direct materiais expected to be used for each unit of product are as follows Product X Material A 50 pound per unit Material B 100 pound per unit Material C 1 20 pound per unit The prices of direct materials are as follows Material A $0 60 per pound Save All Sme All Answers to see all ansuers. 2. 3 un 6 $ A B Jackson Co. Sales Budget 4 For Month Ending March 31, 2017 Unit Unit Sales Selling Total 7 Product and Area Volume Price Sales 8 Product T: 9 Areal 10 Area II 11 Total 12 13 Product X: 14 Areal 15 Area II 16 Total $ 17 Total revenue from sales $ 18 19 20 (b) (10 pts) 21 Jackson Co. Production Budget 23 For Month Ending March 31, 2017 24 Product T 25 Sales 26 Plus desired ending inventory, March 31, 2017 27 Total 28 Less estimated beginning inventory, March 1, 2017 29 Total production 22 Product X 20 Exe. 1 Exe. 2 fx A D 1 2 (2) (20 pts) 2 (a) E Direct Materials Purchases Budget A C Total $ $ $ 3 4 5 6 Units required for production of Product X (Note A) 7 Unit price 8 Total direct materials purchases 9 10 Note A: (Hints) 11 Material A=635,000 * .50lb. Per unit = 317,000 lbs. 12 Material B = 13 Material C = 14 15 16 17 18 19 20 21 22 23 24 25 Exe. 1 Exe. 2