Answered step by step
Verified Expert Solution
Question
1 Approved Answer
3. Ukraine steel company is in the process of preparing the Cash Budget for the last four months of 2020 that is September to December.
3.
Ukraine steel company is in the process of preparing the Cash Budget for the last four months of 2020 that is September to December. The following information has been made available.
Sept.Oct.Nov.Dec.
(i) Projected Sales (Units)12,00013,00013,00014,000
(ii) Selling Price is GHS5 per unit but it is expected to drop by 5% from 1st November.
(iii) Receipt for goods sold is as follows; 20% in the month of sales, 60% the following month after sales and the balance in the second month after sales. Bad debt is estimated at 5% of sales values.
(iv) Purchases of goods at GHS3.00 per unit per month are as follows: September 14,000 units, October 14,000 units, November 14,400 units and December 13,000 units.
(v) Goods purchased are paid one month in arrears.
(vi) Monthly expenses estimated at 24% on sales revenue are paid in the month in which the expense is incurred.
(vii) The company plans to buy a delivery van at a cost of GHS54,000.00. 40% of the cost is to be paid in October and balance in January 2018.
(viii) The Director withdraws GHS6,000.00 monthly for personal expenses.
(ix) Extracts from August figures are as follows:
Trade receivable of GHS92,000.00 out of which GHS20,000.00 is part of July sales before the bad debt.
Creditors for goods GHS20,000.00
Cash GHS7,000.00.
Required:
(a) Prepare the monthly CASH BUDGET for the four months ending December, 2020.
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