Question: Lorch Company prepares monthly cash budgets. Relevant data from operating budgets for 2021 are as follows: Sales Direct materials purchases Direct labour Manufacturing overhead Selling

 Lorch Company prepares monthly cash budgets. Relevant data from operating budgetsfor 2021 are as follows: Sales Direct materials purchases Direct labour Manufacturingoverhead Selling and administrative expenses January $347,000 121,000 85,000 59,000 75,000 February

Lorch Company prepares monthly cash budgets. Relevant data from operating budgets for 2021 are as follows: Sales Direct materials purchases Direct labour Manufacturing overhead Selling and administrative expenses January $347,000 121,000 85,000 59,000 75,000 February $403,000 111,000 111,000 75,000 80,000 All sales are on account. Lorch expects collections to be 50% in the month of sale, 40% in the first month following the sale, and 10% in the second month following the sale. It pays 30% of direct materials purchases in cash in the month of purchase and the balance due in the month following the purchase. Other data are as follows: 1. Credit sales: November 2020, $200,000; December 2020, $278,000 2. Purchases of direct materials: December 2020, $90,000 3. Other receipts: January-collection of December 31, 2020, notes receivable $5,000; February-proceeds from sale of securities $5,000 4. Other disbursements: February-payment of $20,000 for land The company expects its cash balance on January 1, 2021, to be $50,000. It wants to maintain a minimum cash balance of $40,000. Prepare a cash budget for January and February using columns for each month. LORCH COMPANY Cash Budget For the Two Months Ending February 28, 2021 Jan Feb Total Beginning cash balance $ Add: Cash receipts Collection of notes receivable

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Accounting Questions!