Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Calculate the budgeted cash disbursements during the month of February. Calculate the budgeted cash collection during the month of January Calculated budgeted number of units
- Calculate the budgeted cash disbursements during the month of February.
- Calculate the budgeted cash collection during the month of January
- Calculated budgeted number of units of inventory to be purchased during the month of March
Metlock State sells electronic products. The controller is responsible for preparing the master budget and has accumulated the information below for the months of January, February, and March. Balances at January 1 are expected to be as follows:
Cash | $6270 | Inventories | $352700 | |||
---|---|---|---|---|---|---|
Accounts receivable | 474400 | Accounts payable | 151700 |
The budget is to be based on the following assumptions:
1. | Each months sales are billed on the last day of the month. | |
2. | Customers are allowed a 3% discount if their payment is made within 10 days after the billing date. Receivables are booked at gross. | |
3. | The company collects 60% of the billings within the discount period, 25% by the end of the month after the date of sale, and 9% by the end of the second month after the date of sale; 6% prove uncollectible. | |
4. | It pays 54% of all materials purchases and the selling, general, and administrative expenses in the month purchased and the remainder in the following month. Each months units of ending inventory are equal to 130% of the next months units of sales. | |
5. | The cost of each unit of inventory is $20. | |
6. | Selling, general, and administrative expenses, of which $2,300 is for depreciation, are equal to 15% of the current months sales. | |
7. | Actual and projected sales are as follows: |
Month | Sales | Units | ||
---|---|---|---|---|
November | $405000 | 13500 | ||
December | 414000 | 13800 | ||
January | 408000 | 13600 | ||
February | 390000 | 13000 | ||
March | 411000 | 13700 | ||
April | 417000 | 13900 |
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