Question
Allan Corporation has a sales budget for March of $ 440,000. About 10% are cash sales and the remainder is sold on account. The company
Allan Corporation has a sales budget for March of $ 440,000. About 10% are cash sales and the remainder is sold on account.
The company expects that 60% of credit sales will be collected in the month of the sale, 25% in the next month and 10% in the following month.
Materials purchased on account are expected to be $ 250,000. Allan pays 35% in the month of the purchase, 50% in the month following the purchase and the remaining 15% in the second month after the purchase.
Salaries and wages of the workers are approximately $ 45,000 per month. The employees are paid weekly so on average 95% of their wages are paid in the month to which they relate and the remaining 5% is paid in the following month.
Utilities average $ 4,300 per month.
Rent on the building is $ 9,000 per month.
Insurance is $ 3,000 per month and advertising costs are $ 1,000 per month.
February sales were $ 320,000 and purchases of materials in February were $ 170,000; January sales were $ 200,000 and purchases of materials in January were $ 130,000.
The cash balance on March 1st is $ 5,400.
Required:
A. Prepare a schedule of cash receipts for the month of March.
B. Prepare a schedule of cash payments (Accounts payable payments) for March.
C. Prepare a cash budget for the month of March for this company.
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