Royal Company Q2 Sales and Production Budget - April to June |

School: University of British Columbia - Course: ACCOUNTING CH1 - Subject: Accounting

Royal Company - Q2 Sales Budget AprilMayJuneQ2 TotalJulyAugust 5% Royal Company - Q2 Production budget(UNITS ONLY)- for Finished Goods AprilMayJuneQ2 TotalJulyAugustEnding Inventory Sales (units)20,00050,00030,000100,00025,00015,0004,000units @ 03/31 Add: desired end inv.10,0006,0005,0005,0003,00020%desired ending inventory Inventory available30,00056,00035,000105,00028,0005,000units @ 06/30 Less: Beg (Open) Inv(4,000)(10,000)(6,000)(4,000)(5,000) Production required(Units) 26,00046,00029,000101,00023,000 Apr 1 - 30May 1 - 31June 1 - 30Apr 1 - June 30 10%Closing Inv of Next Direct MaterialsAprilMayJuneQ2 TotalJuly Production required (Units)26,00046,00029,000101,000Part A23,000 Kilograms (kg) / Unit5555Part A5Kilograms (kg) / Unit5 Kilograms (kg)reqd130,000230,000145,000505,000Part A115,00010% Add: desired end inv.23,00014,50011,50011,500Part B Inventory available153,000244,500156,500516,500Part BDNTSNT Less: Beg (Open) Inv(13,000)(23,000)(14,500)(13,000)Part B Purchases (kg)140,000221,500142,000503,500Part B503,500 Cost per kg.0.40$0.40$0.40$0.40$Part C Total purchases reqd56,000$88,600$56,800$201,400$Part C