Paste Av Merge & Center v D49 x fx G H . I L M B C D F 1 Accounting 1B 2 3 4 NAKE's sales budget for basketballs for the next months: 5 B Jan Feb Mar Apr 7 Units 500,000 600,000 400,000 700.000 B 9 They sell each basketball for $12 0 They want ending inventory to be 30% of the next month's sales units. 1 Beginning Finished goods inventory is 100,000 units. 2 It takes pounds of rubber to make each basketball. That is the only Direct Material 3 Beginning Direct Material inventory is 10,000 pounds of rubber 4 They want ending raw material inventory to be 10% of the next 5 month's direct material need. 6 One pound of rubber cost them $2 7 Each basketball takes 30 minutes of labor and labor cost is $12 per hour 8 9 1 Prepare the Sales Budget for Jan-Mar 21 Jan Feb Mar 2 Units 23 4 25 Revenue 26 2 Prepare the Unit Production Budget in Units for Jan-Mar Jan Feb Mar 28 29 10 31 2 13 14 15 16 2 3 Prepare the Raw Materials Budget for Jan - Feb in pounds and dollars Jan Feb 18 19 0 11 2 2 13 14 15 6 17 17 18 4 Prepare the direct labor budget for Jan, Feb and Mar Jan Feb Mar 9 19 50 1 3 Sheet1 Sheet2 Sheet3 +