Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Question: Prepare cash budget for the months of Jan to April 2023. begin{tabular}{|l|l|l|l|l|l|l|} hline Months & Sales & Purchases & Wages & ManufacturingExpenses & Administrationexpenses
Question: Prepare cash budget for the months of Jan to April 2023. \begin{tabular}{|l|l|l|l|l|l|l|} \hline Months & Sales & Purchases & Wages & ManufacturingExpenses & Administrationexpenses & Sellingexpenses \\ \hline Nov 2022 & 30,000 & 15,000 & 3000 & 250 & 1060 & 500 \\ \hline Decernber & 35,000 & 20,000 & 3200 & 1225 & 1040 & 550 \\ \hline Jan 2023 & 25,000 & 15,000 & 2500 & 990 & 1100 & 600 \\ \hline February & 30,000 & 20,000 & 3000 & 1050 & 1150 & 620 \\ \hline March & 35,000 & 22,500 & 2400 & 1100 & 1220 & 570 \\ \hline April & 40,000 & 25,000 & 2600 & 1200 & 1180 & 710 \\ \hline \hline \end{tabular} Additional Information: 1. Customers are allowed a credit period of 2 months. 2. A dividend of $10000 is payable in April. 3. Plant purchased on 15th Jan for $5000 and a building purchased on 1st March \& payments are made in monthly instalments $2000 each and paid in the month of march \& April $2000 each. 4. Creditors are allowed a credit of 2 months. 5. Wages are paid on the 1st of the next month. 6. Lag in payment of expenses is 1 month. 7. Balance of cash in hand on 1stJan is $15000
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