Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Alaski Co is preparing its cash budget for the three months ending September 2020. The information about the sales of its product during that period
Alaski Co is preparing its cash budget for the three months ending September 2020. The information about the sales of its product during that period is given as follows:
- Sales amounted to 1,500 units in June, and are forecast to be 1,000 units in July, 2,000 units in August and 2,500 units in September.
- The current price of a unit is $90 although it is expected to rise by 20% at the beginning of August.
- All sales are on credit and 20% of customers pay in the month of sale, 40% pay one month after the date of sale and 35% pay two months after the date of sale with 5% amounting to irrecoverable debts.
- The purchases made for each month is 60% of the sales value and the purchases are made one month prior to sale. Suppliers provide a credit of two months .
- Fixed overheads are expected to remain at $40,000 for July which includes $2,000 of depreciation. The overheads other than depreciation are expected to increase by 6% from 1 September.
- Repairs and maintenance costs should be budgeted at an average of $1,100 per month.
- Salaries are currently $3,000 per month but are due to rise by 15% from 1 August.
- Purchase of a new machine of $60,000 should be budgeted for in August.
- The cash balance at 30 June 2020 was $6,600.
Required:
a.cash budget for Alaski Co for the three months ending September 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