Question
Martinez Corp. prepares monthly cash budgets. Here are relevant data from operating budgets for 2022. January February Sales $360,600 $401,200 Purchases 121,500 131,600 Salaries 84,900
Martinez Corp. prepares monthly cash budgets. Here are relevant data from operating budgets for 2022.
January | February | |||
---|---|---|---|---|
Sales | $360,600 | $401,200 | ||
Purchases | 121,500 | 131,600 | ||
Salaries | 84,900 | 81,700 | ||
Administrative expenses | 72,000 | 73,700 | ||
Selling expenses | 79,500 | 86,700 |
All sales and purchases are on account. Budgeted collections and disbursement data are given below. All other expenses are paid in the month incurred. Administrative expenses include $1,200 of depreciation per month. Other data.
1. | Collections from customers: January $336,200; February $378,700. | |
2. | Payments for purchases: January $106,900; February $141,100. | |
3. | Other receipts: January: collection of December 31, 2021, notes receivable $17,900; February: proceeds from sale of securities $5,900. | |
4. | Other disbursements: February $12,200 cash dividend. |
The companys cash balance on January 1, 2022, is expected to be $47,100. The company wants to maintain a minimum cash balance of $56,070. Prepare a cash budget for January and February. (Do not leave any answer field blank. Enter 0 for amounts.)
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