Answered step by step
Verified Expert Solution
Question
1 Approved Answer
A Company expects to have a cash balance of $100,000 on February 28, 2021. A Company wants to maintain a minimum monthly cash balance
A Company expects to have a cash balance of $100,000 on February 28, 2021. A Company wants to maintain a minimum monthly cash balance of $80,000. All costs are paid as incurred. Relevant monthly budget data for March 2021 are as follows: A Company's sales are 40% cash and 60% credit. Credit sales are collected 20% in the month of sale, 50% in the month following sale, and 26% in the second month following sale; 4% are uncollectible. The sales in January, February, March are respectively $305,000, $350,000, and $360,000. A Company's purchases are 30% cash and 70% credit. Purchases on account are paid 60% in the month following purchase, and 40% in the second month following purchase. The purchases in January, February, March are respectively $230,000, $220,000, and $210,000. Direct labor incurred in March 2021 : $95,000 Manufacturing overhead excluding the monthly depreciation of $5,000: $69,500 Selling and administrative expenses including the monthly depreciation $ 2,000: $53,600 Marketable securities of $50,000 can be sold if needed for addition cash. The cash budget for March 2021 will be: A Company Cash Budget For the month ended 31 March 2021 Beginning cash balance add Collection from customers Sales of securities Total Receipts Total Available Cash less Direct Material Direct Labor Manufacturing Overhead Selling & Administrative Expenses Total Disbursements Excess (Deficiency) of available cash over cash disbursement Financing A B C D 95,000 E F G
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