*Exercise 10.27 Nunez Company expects to have a cash balance of $47,000 on January 1, 2020. Relevant monthly budget data for the first two months of 2020 are as follows: 1. Collections from customers: January $101,000; February $158,000 2. Payments to suppliers: January $61,000; February $82,000 3. Direct labour: January $31,000; February $45,000. Wages are paid in the month they are incurred. 4. 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. 5. Selling and administrative expenses: January $15,000; February $21,000. These costs are exclusive of depreciation. They are paid as incurred. 6. Sales of marketable securities in January are expected to realize $9,000 in cash. Nunez 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. NUNEZ COMPANY Cash Budget

FINANCIAL ACCOUNTING
10th Edition
ISBN:9781259964947
Author:Libby
Publisher:Libby
Chapter1: Financial Statements And Business Decisions
Section: Chapter Questions
Problem 1Q
icon
Related questions
icon
Concept explainers
Question
Please do not give solution in image format thanku
*Exercise 10.27
Nunez Company expects to have a cash balance of $47,000 on January 1, 2020. Relevant monthly budget data for the first two months of 2020 are as follows:
1. Collections from customers: January $101,000; February $158,000
2. Payments to suppliers: January $61,000; February $82,000
3. Direct labour: January $31,000; February $45,000. Wages are paid in the month they are incurred.
4. 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.
5. Selling and administrative expenses: January $15,000; February $21,000. These costs are exclusive of depreciation. They are paid as incurred.
6. Sales of marketable securities in January are expected to realize $9,000 in cash.
Nunez 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.
NUNEZ COMPANY
Cash Budget
For the Two Months Ending February 29, 2020
Month
$
Jan
$
Feb
Total
Transcribed Image Text:*Exercise 10.27 Nunez Company expects to have a cash balance of $47,000 on January 1, 2020. Relevant monthly budget data for the first two months of 2020 are as follows: 1. Collections from customers: January $101,000; February $158,000 2. Payments to suppliers: January $61,000; February $82,000 3. Direct labour: January $31,000; February $45,000. Wages are paid in the month they are incurred. 4. 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. 5. Selling and administrative expenses: January $15,000; February $21,000. These costs are exclusive of depreciation. They are paid as incurred. 6. Sales of marketable securities in January are expected to realize $9,000 in cash. Nunez 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. NUNEZ COMPANY Cash Budget For the Two Months Ending February 29, 2020 Month $ Jan $ Feb Total
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
FINANCIAL ACCOUNTING
FINANCIAL ACCOUNTING
Accounting
ISBN:
9781259964947
Author:
Libby
Publisher:
MCG
Accounting
Accounting
Accounting
ISBN:
9781337272094
Author:
WARREN, Carl S., Reeve, James M., Duchac, Jonathan E.
Publisher:
Cengage Learning,
Accounting Information Systems
Accounting Information Systems
Accounting
ISBN:
9781337619202
Author:
Hall, James A.
Publisher:
Cengage Learning,
Horngren's Cost Accounting: A Managerial Emphasis…
Horngren's Cost Accounting: A Managerial Emphasis…
Accounting
ISBN:
9780134475585
Author:
Srikant M. Datar, Madhav V. Rajan
Publisher:
PEARSON
Intermediate Accounting
Intermediate Accounting
Accounting
ISBN:
9781259722660
Author:
J. David Spiceland, Mark W. Nelson, Wayne M Thomas
Publisher:
McGraw-Hill Education
Financial and Managerial Accounting
Financial and Managerial Accounting
Accounting
ISBN:
9781259726705
Author:
John J Wild, Ken W. Shaw, Barbara Chiappetta Fundamental Accounting Principles
Publisher:
McGraw-Hill Education