Answered step by step
Verified Expert Solution
Question
1 Approved Answer
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
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
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started