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

Managerial Accounting: The Cornerstone of Business Decision-Making
7th Edition
ISBN:9781337115773
Author:Maryanne M. Mowen, Don R. Hansen, Dan L. Heitger
Publisher:Maryanne M. Mowen, Don R. Hansen, Dan L. Heitger
Chapter9: Profit Planning And Flexible Budgets
Section: Chapter Questions
Problem 45BEB: Pilsner Inc. purchases raw materials on account for use in production. The direct materials...
icon
Related questions
icon
Concept explainers
Question
Please do not give image format
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
Transcribed Image Text: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
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
Transcribed Image Text: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
Expert Solution
steps

Step by step

Solved in 3 steps

Blurred answer
Knowledge Booster
Budgeting
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, accounting and related others by exploring similar questions and additional content below.
Similar questions
  • SEE MORE QUESTIONS
Recommended textbooks for you
Managerial Accounting: The Cornerstone of Busines…
Managerial Accounting: The Cornerstone of Busines…
Accounting
ISBN:
9781337115773
Author:
Maryanne M. Mowen, Don R. Hansen, Dan L. Heitger
Publisher:
Cengage Learning
EBK CONTEMPORARY FINANCIAL MANAGEMENT
EBK CONTEMPORARY FINANCIAL MANAGEMENT
Finance
ISBN:
9781337514835
Author:
MOYER
Publisher:
CENGAGE LEARNING - CONSIGNMENT
Principles of Accounting Volume 2
Principles of Accounting Volume 2
Accounting
ISBN:
9781947172609
Author:
OpenStax
Publisher:
OpenStax College
Excel Applications for Accounting Principles
Excel Applications for Accounting Principles
Accounting
ISBN:
9781111581565
Author:
Gaylord N. Smith
Publisher:
Cengage Learning
Cornerstones of Cost Management (Cornerstones Ser…
Cornerstones of Cost Management (Cornerstones Ser…
Accounting
ISBN:
9781305970663
Author:
Don R. Hansen, Maryanne M. Mowen
Publisher:
Cengage Learning
Managerial Accounting
Managerial Accounting
Accounting
ISBN:
9781337912020
Author:
Carl Warren, Ph.d. Cma William B. Tayler
Publisher:
South-Western College Pub