1. Kilang Rot Derhad, a matulathrer of tradional breads is Pert Dickton, is preparing monthly cesh bwojets for the monts of donuary. Fobruary and Mach 2023 . The followirg dats are avaliable trom nosonds of the company The company has the following business policies: - Colections of cash trom curiomers are expecied to be 60 Nh of the sies in the month of saie and 40% in the aonth folowing pye sale. - The compary pays cash for 76tir of the raw matarals purchaces an the month of purchase and the baiance is due in the manth toligeing the purchase. - All other teme besides these two are paid cash in the month they are incuned Dther relevant deta are as follows: - Sales December 2te2 FU1500030 - Purchanes of raw matertak: Desernber 2002: RM 55,009 - Orher recepit Janusy, 2ves: Cssi Duidend recesved. 1sMz5, 000 Pieet 11 Manch, 2023: Cash receipts from sale of vsed equpment, Pur30.000 - Orner pepments February, 2023: payment of debt: ROM 50.000 August, 2023. Cash gurchase of new equ pmert for RM70,005 - The corpary propesed la poy a cash dividend of Fck 20,000 in Mark. 2002. - Closing Cast batance as at Decenber 21, 2022 is essimated at RMss b0t. Required: USE EXCEL WORKBOOK ONLY fwith fomulas on every output with black fort colon. blue font colore for hard codod inpues s) Pregare a Cash Budget for Kiang Ros Bemad for the months of Jenuayy Feonuan and March 2023. b) Analyze the Cesh Eutget ter the evnth of March. 2 cog: 1. Kilang Rot Derhad, a matulathrer of tradional breads is Pert Dickton, is preparing monthly cesh bwojets for the monts of donuary. Fobruary and Mach 2023 . The followirg dats are avaliable trom nosonds of the company The company has the following business policies: - Colections of cash trom curiomers are expecied to be 60 Nh of the sies in the month of saie and 40% in the aonth folowing pye sale. - The compary pays cash for 76tir of the raw matarals purchaces an the month of purchase and the baiance is due in the manth toligeing the purchase. - All other teme besides these two are paid cash in the month they are incuned Dther relevant deta are as follows: - Sales December 2te2 FU1500030 - Purchanes of raw matertak: Desernber 2002: RM 55,009 - Orher recepit Janusy, 2ves: Cssi Duidend recesved. 1sMz5, 000 Pieet 11 Manch, 2023: Cash receipts from sale of vsed equpment, Pur30.000 - Orner pepments February, 2023: payment of debt: ROM 50.000 August, 2023. Cash gurchase of new equ pmert for RM70,005 - The corpary propesed la poy a cash dividend of Fck 20,000 in Mark. 2002. - Closing Cast batance as at Decenber 21, 2022 is essimated at RMss b0t. Required: USE EXCEL WORKBOOK ONLY fwith fomulas on every output with black fort colon. blue font colore for hard codod inpues s) Pregare a Cash Budget for Kiang Ros Bemad for the months of Jenuayy Feonuan and March 2023. b) Analyze the Cesh Eutget ter the evnth of March. 2 cog
