Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Maple Company prepares monthly cash budgets. Relevant data follows for 2021: April May Sales $400,000 $420,000 Direct Materials Purchases 145,000 130,000 Direct Labor 85,000 95,000
Maple Company prepares monthly cash budgets. Relevant data follows for 2021: April May Sales $400,000 $420,000 Direct Materials Purchases 145,000 130,000 Direct Labor 85,000 95,000 Manufacturing Overhead 70,000 80,000 Selling & Administrative Expenses 78,000 82,000 Sales are 40% cash and 60% credit. Credit collections are expected to be 50% in the month of the sale, 30% in the first month following the sale, and 15% in the second month following the sale. 60% of direct materials purchases are paid in cash in the month of the purchase, and the balance is paid in the month following the purchase. All other items above are paid in the month incurred except for depreciation of $6,000 in Manufacturing Overhead for both April and May, and depreciation of $3,000 in Selling and Administrative Expenses for both April and May. Other data: February 2021 credit sales of $150,000; March 2021 credit sales of $130,000. Purchases of direct materials for March of 2021 of $100,000. Other payments of $25,000 for dividends in May. The company's cash balance on April 1, 2021 is expected to be $45,000. Prepare a cash budget for April and May. (Show computations.)
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