Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Old MathJax webview 4 please answr in excel this should be good Bonita Company expects to have a cash balance of $45,500 on January 1,

Old MathJax webview

4

image text in transcribed

image text in transcribed

please answr in excel

image text in transcribed

image text in transcribed

this should be good

Bonita Company expects to have a cash balance of $45,500 on January 1, 2022. Bonita has budgeted the following for the first two months of the year 2022: 1. Collections from customers: January $89.800; February $110,900. 2. Payments to suppliers: January $40,400; February $50,500. 3. Direct labour: January $29.700; February $34,800. Wages are paid in the month they are incurred. Manufacturing overhead: January $25,000; February $30,300. Overhead costs are paid as incurred. 5. Selling and administrative expenses: January $16,200; February $22,100. These costs do not include depreciation and they are paid as incurred. Sales of investments in January are expected to realize $10,100 in cash. Bonita Company wants to keep a minimum monthly cash balance of $20,000. Ignore any interest on amounts borrowed. 6. BONITA COMPANY Cash Budget For 2022 January February Bonita Company expects to have a cash balance of $45,500 on January 1, 2022. Bonita has budgeted the following for the first two months of the year 2022: Collections from customers: January $89.800; February $110.900. 22. Payments to suppliers: January $40.400; February $50.500. 3. Direct labour: January $29.700; February $34,800. Wages are paid in the month they are incurred. 4. Manufacturing overhead: January $25.000: February $30,300. Overhead costs are paid as incurred. 5. Selling and administrative expenses: January $16.200; February $22.100. These costs do not include depreciation and they are paid as incurred. Sales of investments in January are expected to realize $10.100 in cash. Bonita Company wants to keep a minimum monthly cash balance of $20.000. Ignore any interest on amounts borrowed. 6 BONITA COMPANY Cash Budget For 2022 January February $ $

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Survey Of Accounting

Authors: Paul D. Kimmel, Jerry J. Weygandt

2nd Edition

1119594537, 978-1119594536

More Books

Students also viewed these Accounting questions