Required: Prepare the following Budgets for the coming period 2017: 1. Sales Budget 2. Cash collection budget 3. Production budget 4. Labour hours budget 5. Direct wages budget 6. Required RM budget 7. Purchase RM units budget 8. Purchase RM Cost Budget 9. Purchase payments Budget 10. M.O.H cost Budget 11. Marketing \& administrative cost budget This is all givens and requirement Comparing depends on previous quarters The recerds of Tesco Coeporation show the follorated informatioe cuecrnieg sales in units for the cumcent ycar 2016 as follour: Gizen thet 1. Selling price per unial is $120 2. The sales manager evpects the following changes for the corering year 2017 . - Na uncrease of Natin Q1 - A decrease of 15 \& in Q2. - No changeri in 03 - A decreser of 25% in 04 3. The financial policy of the corporation is to colleat 3 3ors of the (TSR) of each quarter in the sartse quarter, 40 s in the aest qaarter, and the fed in the quater after. 4. The production policy of the coeponation is to krep 20f4 of the weal sales of each cuarter as at ending invetiory for the same quarter. 5. Each unit reqaires (5) hours of Labor (X) and (4) boan of laber (Y).(X) t. abor rate per hour is ($4.5) and Y labor rate per hour is ($3.2). 6. Each unit requires (4) units of RM w and (6) units of RM x. 7. The production policy of the corporation is to keep an andieg anverary of 25\% of the required RM w foe eact quarter and an codieg imveriory of 20% of the required KMz for each quarter. Given that: Beginning RM ieventory of Q1/17 of RMw is 43000 U. Ending RM inventory of Q4/16 of RMz is 36000U. 8. Purchase price per unit of RMw is $1$ and of RMz as $1.8 9. The financial policy of the corporation is to pay the sopliers agr. of the weal purctases in the same quarter, and 405, neat quarter, and the rest in the quarter after. 10. Given that the total purchase of (03/6) is $1700000 and of (0416) is 51600000. 11. The application rale of the sariatle andireet prodation ous (MCM1) as S13. A. 12. The estimated fived indirect production cont eleness flat the asming year were as Gidons: - \$ 100000 factory machines dep/YEA - $7000 Gas and OUl MONTH - \$ $0000 factory inuuranse par MIAIF YEAR - 560000 factory mactones maintenasoe per Quakte - \$ 80000 factory tent far each 3 MONTM 13. The application rate for the varialle marketing cose elems a 516 i. 14. Estimated fived marketing and administrative cest edmomes fis the conarg year were as follaws: - \$40000 admierinative deq. per VEAR - $so000 marketing deg per VZ TAR. - 535000 adminituative expenses per Qei shilkR - 5 dobo dinglar imsarance per b MSTNTHA - \$ 10000 adminiuatione alaries per Moxill 1. Sales Beclater 2. Caik switrotien badzert 3. Frodsctiee bedzet 4. I shear heers beder! 4. Eirect naxis budpot. Required: Prepare the following Budgets for the coming period 2017: 1. Sales Budget 2. Cash collection budget 3. Production budget 4. Labour hours budget 5. Direct wages budget 6. Required RM budget 7. Purchase RM units budget 8. Purchase RM Cost Budget 9. Purchase payments Budget 10. M.O.H cost Budget 11. Marketing \& administrative cost budget This is all givens and requirement Comparing depends on previous quarters The recerds of Tesco Coeporation show the follorated informatioe cuecrnieg sales in units for the cumcent ycar 2016 as follour: Gizen thet 1. Selling price per unial is $120 2. The sales manager evpects the following changes for the corering year 2017 . - Na uncrease of Natin Q1 - A decrease of 15 \& in Q2. - No changeri in 03 - A decreser of 25% in 04 3. The financial policy of the corporation is to colleat 3 3ors of the (TSR) of each quarter in the sartse quarter, 40 s in the aest qaarter, and the fed in the quater after. 4. The production policy of the coeponation is to krep 20f4 of the weal sales of each cuarter as at ending invetiory for the same quarter. 5. Each unit reqaires (5) hours of Labor (X) and (4) boan of laber (Y).(X) t. abor rate per hour is ($4.5) and Y labor rate per hour is ($3.2). 6. Each unit requires (4) units of RM w and (6) units of RM x. 7. The production policy of the corporation is to keep an andieg anverary of 25\% of the required RM w foe eact quarter and an codieg imveriory of 20% of the required KMz for each quarter. Given that: Beginning RM ieventory of Q1/17 of RMw is 43000 U. Ending RM inventory of Q4/16 of RMz is 36000U. 8. Purchase price per unit of RMw is $1$ and of RMz as $1.8 9. The financial policy of the corporation is to pay the sopliers agr. of the weal purctases in the same quarter, and 405, neat quarter, and the rest in the quarter after. 10. Given that the total purchase of (03/6) is $1700000 and of (0416) is 51600000. 11. The application rale of the sariatle andireet prodation ous (MCM1) as S13. A. 12. The estimated fived indirect production cont eleness flat the asming year were as Gidons: - \$ 100000 factory machines dep/YEA - $7000 Gas and OUl MONTH - \$ $0000 factory inuuranse par MIAIF YEAR - 560000 factory mactones maintenasoe per Quakte - \$ 80000 factory tent far each 3 MONTM 13. The application rate for the varialle marketing cose elems a 516 i. 14. Estimated fived marketing and administrative cest edmomes fis the conarg year were as follaws: - \$40000 admierinative deq. per VEAR - $so000 marketing deg per VZ TAR. - 535000 adminituative expenses per Qei shilkR - 5 dobo dinglar imsarance per b MSTNTHA - \$ 10000 adminiuatione alaries per Moxill 1. Sales Beclater 2. Caik switrotien badzert 3. Frodsctiee bedzet 4. I shear heers beder! 4. Eirect naxis budpot