Using this data, along with your answer to part (1) above, prepare a cash budget in good form for June. Clearly show any borrowing needed during the month. The company can borrow in any dollar amount, but will not pay any interest until the following month.

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
PROBLEM 7-I CASH BUDGET
The Francine Company, a merchandising firm, has planned the following sales for the next four
months:
March
April
May
June
Total budgeted sales...
50,000
70,000
90,000
60,000
Sales are made 40% for cash and 60% on account. From experience, the company has learned
that a month's sales on account are collected according to the following pattern:
Month of sale
70%
First month following month of sale
20%
Second month following month of sale
8%
Uncollectible
2%
The company requires a minimum cash balance of $4,000 to start a month.
Required:
B. Assume the following budgeted data for June:
Purchases
Р52,000
Selling and administrative expenses.....
10,000
Depreciation .....
8,000
Equipment purchases...
15,000
Cash balance, beginning of June..
6,000
Using this data, along with your answer to part (1) above, prepare a cash budget in good
form for June. Clearly show any borrowing needed during the month. The company can
borrow in any dollar amount, but will not pay any interest until the following month.
Transcribed Image Text:PROBLEM 7-I CASH BUDGET The Francine Company, a merchandising firm, has planned the following sales for the next four months: March April May June Total budgeted sales... 50,000 70,000 90,000 60,000 Sales are made 40% for cash and 60% on account. From experience, the company has learned that a month's sales on account are collected according to the following pattern: Month of sale 70% First month following month of sale 20% Second month following month of sale 8% Uncollectible 2% The company requires a minimum cash balance of $4,000 to start a month. Required: B. Assume the following budgeted data for June: Purchases Р52,000 Selling and administrative expenses..... 10,000 Depreciation ..... 8,000 Equipment purchases... 15,000 Cash balance, beginning of June.. 6,000 Using this data, along with your answer to part (1) above, prepare a cash budget in good form for June. Clearly show any borrowing needed during the month. The company can borrow in any dollar amount, but will not pay any interest until the following month.
Expert Solution
steps

Step by step

Solved in 2 steps

Blurred answer
Knowledge Booster
Cash Budget
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
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
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
Fundamentals of Financial Management (MindTap Cou…
Fundamentals of Financial Management (MindTap Cou…
Finance
ISBN:
9781285867977
Author:
Eugene F. Brigham, Joel F. Houston
Publisher:
Cengage Learning
Fundamentals of Financial Management, Concise Edi…
Fundamentals of Financial Management, Concise Edi…
Finance
ISBN:
9781285065137
Author:
Eugene F. Brigham, Joel F. Houston
Publisher:
Cengage Learning
Fundamentals of Financial Management, Concise Edi…
Fundamentals of Financial Management, Concise Edi…
Finance
ISBN:
9781305635937
Author:
Eugene F. Brigham, Joel F. Houston
Publisher:
Cengage Learning