Yancey has $14,500 in cash on hand on January 1 and has collected the following budget data: (Click on the icon to view the budget data.) Assume direct labor costs and manufacturing overhead costs are paid in the month incurred. Additionally, assume Yancey has cash payments for selling and administrative expenses including salaries of $65,000 per month plus commissions that are 1% of sales, all paid in the month of sale. The company requires a minimum cash balance of $12,000. Prepare a cash budget for January and February. Round to the nearest dollar. Will Yancey need to borrow cash by the end of February? Begin by preparing the cash budget for January, then prepare the cash budget for February. (Complete all input fields. Enter a "0" for any zero balances. Round all amounts entered into the cash budget to the nearest whole dollar.) Yancey Company Cash Budget Two Months Ended January 31 and February 28 January Beginning cash balance Cash receipts Cash available Cash payments: Purchases of direct materials Direct labor 29,000
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.
![Data table
Sales
Cash receipts from customers
Cash payments for direct materials purchases
Direct labor costs
Manufacturing overhead costs (includes depreciation of
$1,600 per month)
Print
Done
January February
$ 534,000 $ 565,000
443,000
502,600
180,278
160,366
135,130
113,238
55,534
53,124
- X](/v2/_next/image?url=https%3A%2F%2Fcontent.bartleby.com%2Fqna-images%2Fquestion%2Fb0b68c17-0012-4355-9326-4020008027d9%2F7fca20b1-d1b2-4d88-84a5-e46d2f7bbf05%2Fgp5ce6o_processed.jpeg&w=3840&q=75)
![Yancey has $14,500 in cash on hand on January 1 and has collected the following budget data:
(Click on the icon to view the budget data.)
Assume direct labor costs and manufacturing overhead costs are paid in the month incurred. Additionally, assume
Yancey has cash payments for selling and administrative expenses including salaries of $65,000 per month plus
commissions that are 1% of sales, all paid in the month of sale. The company requires a minimum cash balance of
$12,000. Prepare a cash budget for January and February. Round to the nearest dollar. Will Yancey need to borrow
cash by the end of February?
Begin by preparing the cash budget for January, then prepare the cash budget for February. (Complete all input fields.
Enter a "0" for any zero balances. Round all amounts entered into the cash budget to the nearest whole dollar.)
Yancey Company
Cash Budget
Two Months Ended January 31 and February 28
January
Beginning cash balance
Cash receipts
Cash available
Cash payments:
Purchases of direct materials
Direct labor
29,000](/v2/_next/image?url=https%3A%2F%2Fcontent.bartleby.com%2Fqna-images%2Fquestion%2Fb0b68c17-0012-4355-9326-4020008027d9%2F7fca20b1-d1b2-4d88-84a5-e46d2f7bbf05%2F7asam1_processed.jpeg&w=3840&q=75)
![](/static/compass_v2/shared-icons/check-mark.png)
Step by step
Solved in 3 steps
![Blurred answer](/static/compass_v2/solution-images/blurred-answer.jpg)
![Managerial Accounting: The Cornerstone of Busines…](https://www.bartleby.com/isbn_cover_images/9781337115773/9781337115773_smallCoverImage.gif)
![EBK CONTEMPORARY FINANCIAL MANAGEMENT](https://www.bartleby.com/isbn_cover_images/9781337514835/9781337514835_smallCoverImage.jpg)
![Managerial Accounting: The Cornerstone of Busines…](https://www.bartleby.com/isbn_cover_images/9781337115773/9781337115773_smallCoverImage.gif)
![EBK CONTEMPORARY FINANCIAL MANAGEMENT](https://www.bartleby.com/isbn_cover_images/9781337514835/9781337514835_smallCoverImage.jpg)
![Excel Applications for Accounting Principles](https://www.bartleby.com/isbn_cover_images/9781111581565/9781111581565_smallCoverImage.gif)
![Cornerstones of Cost Management (Cornerstones Ser…](https://www.bartleby.com/isbn_cover_images/9781305970663/9781305970663_smallCoverImage.gif)
![Managerial Accounting](https://www.bartleby.com/isbn_cover_images/9781337912020/9781337912020_smallCoverImage.jpg)