Question
ABC Company provided the following information for the month of October: September October Actual Budget Cash sales $19,500 $18,000 Credit sales 110,500 102,000 Total sales
ABC Company provided the following information for the month of October: September October Actual Budget Cash sales $19,500 $18,000 Credit sales 110,500 102,000 Total sales $130,000 $120,000 Based on past experience, the company estimates that uncollectible credit sales are: 4% Of the credit sales that are collectible, the collection pattern is as follows: Month of sales 70% Second month following sales 26% October inventory purchase $83,000 September inventory purchase $98,000 Payments for inventory are made as follows: Month of purchase 25% Month following purchase 75% Salaries and wages $10,440 Rent per month $3,600 Utilities per month $5,200 Amortization per month $500 Insurance per quarter to be paid in October $900 October 1 cash balance $7,680 Required: a) Compute budgeted cash receipts for October. (3 Marks) b) Compute budgeted cash disbursements for (2 Marks) purchases for October. c) Compute the cash disbursements for Administrative (2 Marks) expenses. d) Compute the ending cash balance in the cash (2 Marks) budget for the month of October.
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