Wildhorse Company expects to have a cash balance of $47,000 on January 1, 2022. Relevant monthly budget data for the first two months of 2022 are as follows: 1. Collections from customers: January $101,000; February $158,000 Payments to suppliers: January $61,000; February $82,000 Direct labour: January $31,000; February $45,000. Wages are paid in the month they are incurred. Manufacturing overhead: January $25,000; February $32,000. These costs include depreciation of $1,000 per month. All other overhead costs are paid as incurred. 2. 3. 4. 5. 6. Selling and administrative expenses: January $15,000; February $21,000. These costs are exclusive of depreciation. They are paid as incurred. Sales of marketable securities in January are expected to realize $9,000 in cash.
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.
6
![Wildhorse Company expects to have a cash balance of $47,000 on January 1, 2022. Relevant monthly budget data for the first two
months of 2022 are as follows:
1. Collections from customers: January $101,000; February $158,000
Payments to suppliers: January $61,000; February $82,000
Direct labour: January $31,000; February $45,000. Wages are paid in the month they are incurred.
Manufacturing overhead: January $25,000; February $32,000. These costs include depreciation of $1,000 per month. All
other overhead costs are paid as incurred.
2.
3.
4.
5.
6.
Selling and administrative expenses: January $15,000; February $21,000. These costs are exclusive of depreciation. They
are paid as incurred.
Sales of marketable securities in January are expected to realize $9,000 in cash.
Wildhorse Company has a line of credit at a local bank. It can borrow up to $26,000. The company wants to keep a minimum monthly
cash balance of $26,000.
Prepare a cash budget for January and February.
WILDHORSE COMPANY
Cash Budget
For the Two Months Ending February 28, 2022](/v2/_next/image?url=https%3A%2F%2Fcontent.bartleby.com%2Fqna-images%2Fquestion%2Ffc1d9de4-8f88-42b2-bc76-7f16a2893f7e%2Ff9ae0767-0cc2-4a64-95b1-80c1e2b97554%2F1lb4wy_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)