Question

Meath Anl Me 2790 M 2000 2230 April 30 June 30 2110 t r y for the ball de period. Renting policy is to haven at the end of each met al to 50% of the following months ection h o s Spermat throughout the period Instructions O2), AP project unit of 19 of 10000

Answer 1

Rensing Ltd. Production Budget For second Quarter 2017 April Мay June Quarter Sales Units 2550 2675 2390 7615 Ending Inventory 2230 2200 2310 2310 4780 4875 4700 9925 Beginning Inventory -2000 -2230 -2200 -2000 Production 2645 2500 2780 7925 Raw Materials Budget For second Quarter 2017 April July Мay June Quarter Production 2645 2700 2780 2500 7925 Raw Material per unit 2 2 2. 2. 2. 5400 5560 5290 5000 15850 Ending Inventory 2645 2500 2700 2700 10987 10437 10202 26477 Beginning Inventory -2780 -2645 -2500 -2780 Raw Materials Purchased 23697 8207 7792 7702 Cost per Raw material unit 4 Total Raw Material Cost 94788 32828 31168 30808

A E 1 Rensing Ltd. 2 3 Production Budget 4 For second Quarter 2017 April May 5 June Quarter 6 Sales Units 2550 2390 -SUM(B6:D6) 2675 7 Ending Inventory 2200 2230 2310 D7 -SUM(B6:B7) =SUM(C6:C7) -SUM(D6:D7) =SUM(E6:E7) 9 Beginning Inventory -2000 --B7 -C7 B9 -SUM(B8:B9) 10 Production -SUM(C8:C9) =SUM(D8:D9) -SUM(E8:E9) 11 12 Raw Materials Budget 13 For second Quarter 2017 April May July 14 June Quarter 15 Production 2700 B10 C10 D10 -E10 16 Raw Material per unit EE16 2 2 2 2 B15*B16 C15*C16 D15*D16 -E15*E16 =F15*F16 17 18 Ending Inventory C17*0.5 =D17*0,5 =F17*0.5 D18 -SUM(B15:B18) =SUM(C15:C18) =SUM(D15:D18) -SUM(E15:E18) 19 20 Beginning Inventory -B17*0.5 C17*0.5 -D17*0.5 -B20 =SUM(B19:B20) 21 Raw Materials Purchased =SUM(C19:C20) =SUM(D19:D20) -SUM(E19:E20) 22 Cost per Raw material unit 4 4 4 23 Total Raw Material Cost B21*B22 -C21*C22 D21*D22 =E21*E22 24 L LLI