Bonita Company expects to have a cash balance of $52,200 on January 1, 2022. Relevant monthly budget data for the first 2 months of 2022 are as follows. Collections from customers: January $98,600, February $174,000. Payments for direct materials: January $58,000, February $87,000. Direct labor: January $34,800, February $52,200. Wages are paid in the month they are incurred. Manufacturing overhead: January $24,360, February $29,000. These costs include depreciation of $1,740 per month. All other overhead costs are paid as incurred. Selling and administrative expenses: January $17,400, February $23,200. These costs are exclusive of depreciation. They are paid as incurred. Sales of marketable securities in January are expected to realize $13,920 in cash. Bonita Company has a line of credit at a local bank that enables it to borrow up to $29,000. The company wants to maintain a minimum monthly cash balance of $23,200.

Managerial Accounting
15th Edition
ISBN:9781337912020
Author:Carl Warren, Ph.d. Cma William B. Tayler
Publisher:Carl Warren, Ph.d. Cma William B. Tayler
Chapter8: Budgeting
Section: Chapter Questions
Problem 5PB: Cash budget The controller of Mercury Shoes Inc. instructs you to prepare a monthly cash budget for...
icon
Related questions
icon
Concept explainers
Question

Bonita Company expects to have a cash balance of $52,200 on January 1, 2022. Relevant monthly budget data for the first 2 months of 2022 are as follows.

Collections from customers: January $98,600, February $174,000.
Payments for direct materials: January $58,000, February $87,000.
Direct labor: January $34,800, February $52,200. Wages are paid in the month they are incurred.
Manufacturing overhead: January $24,360, February $29,000. These costs include depreciation of $1,740 per month. All other overhead costs are paid as incurred.
Selling and administrative expenses: January $17,400, February $23,200. These costs are exclusive of depreciation. They are paid as incurred.


Sales of marketable securities in January are expected to realize $13,920 in cash. Bonita Company has a line of credit at a local bank that enables it to borrow up to $29,000. The company wants to maintain a minimum monthly cash balance of $23,200.

Prepare a cash budget for January and February.

BONITA COMPANY
Cash Budget
choose the accounting period                                                           
   
January
 
February
select an opening cash budget item                                                           
 
$enter a dollar amount 
 
$enter a dollar amount 
select between addition and deduction                                                           : select an opening name for section one                                                            
       
select a cash budget item                                                           
 
enter a dollar amount
 
enter a dollar amount
select a cash budget item                                                           
  enter a dollar amount   enter a dollar amount
select a closing name for section one                                                           
  enter a total amount for section one   enter a total amount for section one
select a summarizing line for the first part                                                           
  enter a total amount for the first part   enter a total amount for the first part
select between addition and deduction                                                           : select an opening name for section two                                                            
       
select a cash budget item                                                           
 
enter a dollar amount
 
enter a dollar amount
select a cash budget item                                                           
 
enter a dollar amount
 
enter a dollar amount
select a cash budget item                                                           
 
enter a dollar amount
 
enter a dollar amount
select a cash budget item                                                           
  enter a dollar amount   enter a dollar amount
select a closing name for section two                                                           
  enter a total amount for section two   enter a total amount for section two
select a summarizing line for the second part                                                           
  enter a total amount for the second part   enter a total amount for the second part
select an opening name for section three                                                           
       
select between addition and deduction                                                           : select a cash budget item                                                            
 
enter a dollar amount
 
enter a dollar amount
select between addition and deduction                                                           : select a cash budget item                                                            
  enter a dollar amount   enter a dollar amount
select a closing cash budget item                                                           
  $enter a total amount for the cash budget    $enter a total amount for the cash budget 
 
Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 2 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
Managerial Accounting
Accounting
ISBN:
9781337912020
Author:
Carl Warren, Ph.d. Cma William B. Tayler
Publisher:
South-Western College Pub
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
Principles of Cost Accounting
Principles of Cost Accounting
Accounting
ISBN:
9781305087408
Author:
Edward J. Vanderbeck, Maria R. Mitchell
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
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