Prepare schedules for (1) expected collections from customers and (2) expected payments for direct materials purchases for January and February.
Master Budget
A master budget can be defined as an estimation of the revenue earned or expenses incurred over a specified period of time in the future and it is generally prepared on a periodic basis which can be either monthly, quarterly, half-yearly, or annually. It helps a business, an organization, or even an individual to manage the money effectively. A budget also helps in monitoring the performance of the people in the organization and helps in better decision-making.
Sales Budget and Selling
A budget is a financial plan designed by an undertaking for a definite period in future which acts as a major contributor towards enhancing the financial success of the business undertaking. The budget generally takes into account both current and future income and expenses.
Please do not give solution in image format thanku
![Prepare a cash budget for January and February in columnar form.
>
LILY COMPANY
Cash Budget
$
January](/v2/_next/image?url=https%3A%2F%2Fcontent.bartleby.com%2Fqna-images%2Fquestion%2F349709f6-3e99-49ce-9384-9f2b79e0bb19%2F709047b9-b023-4ea9-9225-bd4991706e94%2Foe9oxqi_processed.png&w=3840&q=75)
![Lily Company prepares monthly cash budgets. Relevant data from operating budgets for 2022 are as follows.
Sales
Direct materials purchases
Direct labor
Manufacturing overhead
Selling and administrative expenses
Other data:
1.
2.
3.
4.
All sales are on account. Collections are expected to be 50% in the month of sale, 30% in the first month following the sale, and 20% in
the second month following the sale. Sixty percent (60%) of direct materials purchases are paid in cash in the month of purchase, and
the balance due is paid in the month following the purchase. All other items above are paid in the month incurred except for selling and
administrative expenses that include $1,100 of depreciation per month.
November
December
January
February
Credit sales: November 2021, $275,000; December 2021, $352,000.
Purchases of direct materials: December 2021, $110,000.
Other receipts: January-Collection of December 31, 2021, notes receivable $16,500;
February-Proceeds from sale of securities $6,600.
Other disbursements: February-Payment of $6,600 cash dividend.
Total collections
The company's cash balance on January 1, 2022, is expected to be $66,000. The company wants to maintain a minimum cash balance
of $55,000.
December
Prepare schedules for (1) expected collections from customers and (2) expected payments for direct materials purchases for
January and February.
January
February
Total payments
January
$396,000
$
$
132,000
99,000
77,000
$
86,900
$
January
LILY COMPANY
Schedule of Expected Collections from Customers
For the Two Months Ending February 28, 2022
January
55000
105600
February
$440,000
198000
137.500
110,000
358600
82,500
93,500
LILYCOMPANY
Schedule of Expected Payments for Direct Materials
For the Two Months Ending February 28, 2022
44000
79200
123200
$
February
$
February
70400
118800
220000
409200
52800
82500
135300](/v2/_next/image?url=https%3A%2F%2Fcontent.bartleby.com%2Fqna-images%2Fquestion%2F349709f6-3e99-49ce-9384-9f2b79e0bb19%2F709047b9-b023-4ea9-9225-bd4991706e94%2Fwex47g_processed.jpeg&w=3840&q=75)
![](/static/compass_v2/shared-icons/check-mark.png)
Trending now
This is a popular solution!
Step by step
Solved in 3 steps
![Blurred answer](/static/compass_v2/solution-images/blurred-answer.jpg)
![FINANCIAL ACCOUNTING](https://compass-isbn-assets.s3.amazonaws.com/isbn_cover_images/9781259964947/9781259964947_smallCoverImage.jpg)
![Accounting](https://www.bartleby.com/isbn_cover_images/9781337272094/9781337272094_smallCoverImage.gif)
![Accounting Information Systems](https://www.bartleby.com/isbn_cover_images/9781337619202/9781337619202_smallCoverImage.gif)
![FINANCIAL ACCOUNTING](https://compass-isbn-assets.s3.amazonaws.com/isbn_cover_images/9781259964947/9781259964947_smallCoverImage.jpg)
![Accounting](https://www.bartleby.com/isbn_cover_images/9781337272094/9781337272094_smallCoverImage.gif)
![Accounting Information Systems](https://www.bartleby.com/isbn_cover_images/9781337619202/9781337619202_smallCoverImage.gif)
![Horngren's Cost Accounting: A Managerial Emphasis…](https://www.bartleby.com/isbn_cover_images/9780134475585/9780134475585_smallCoverImage.gif)
![Intermediate Accounting](https://www.bartleby.com/isbn_cover_images/9781259722660/9781259722660_smallCoverImage.gif)
![Financial and Managerial Accounting](https://www.bartleby.com/isbn_cover_images/9781259726705/9781259726705_smallCoverImage.gif)