Answered step by step
Verified Expert Solution
Question
1 Approved Answer
[Question] The following information on actual and projected costs and revenues is available for Carson Enterprize. Dates Sales Purchases $ $ Oct. 2020 80 000
[Question] The following information on actual and projected costs and revenues is available for Carson Enterprize. Dates Sales Purchases $ $ Oct. 2020 80 000 65 000 Nov. 2020 60 000 45 000 Dec. 2020 90 000 75 000 Jan. 2021 50 000 35 000 Feb. 2021 60 000 45 000 Mar. 2021 70 000 55 000 April 2021 60 000 45 000 You are given the following additional information:You are given the following additional information: i. ii. iii. iv. the and is Based on past analysis, 20% of sales tend to be for cash while the remainder is normally settled as follows: 60% in the month following sales and 40% two months after sale. Carson enterprise normally pays 50% of the cost of purchases in the month of purchase and the remainder in the following month. New equipment will be purchased for $9,000 in January and this will be paid for in equal instalments in January, February and March. Old equipment is expected to be sold for $2,500 in February. Depreciation of the new equipment will be 10% per annum and will be charged to accounts monthly. Salaries will be $3,000 per month and utilities is expected to be $7,000 in January expected to increase by 10% each month after. vi. Selling expenses of 2% of sales will be paid in the month of sale and packing expenses of 3% of purchases will be paid in the month following the purchase date. vii. The firm will obtain a loan of $40,000 in March at an interest rate of 15% per annum. Interest will be paid on an equal monthly basis commencing in March. viii. The balance of cash on January 1, 2021 was $15,000. Required: 1. Prepare a schedule of expected sales collections (Sales Budget) for January to April 2021 2. Prepare the Purchases budget for January to April 2021 a. Prepare a cash budget for January to April 2021
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