Gerry Jacobs, a financial analyst for Best Value Supermarkets, has prepared the following sales and cash disbursement estimates for the period of August through December of the current year. Month Sales Cash Disbursements August P400 P300 September 500 500 October 500 700 November 600 400 December 700 500 90% of sales are for cash, the remaining 10% are collected one month later. All disbursements are on a cash basis. The firm wishes to maintain a minimum cash balance of $50. The beginning cash balance in September is $25. Prepare a cash budget for the  months of October, November, and December, noting any needed financing or excess cash available.

Cornerstones of Cost Management (Cornerstones Series)
4th Edition
ISBN:9781305970663
Author:Don R. Hansen, Maryanne M. Mowen
Publisher:Don R. Hansen, Maryanne M. Mowen
Chapter8: Budgeting For Planning And Control
Section: Chapter Questions
Problem 34E: A companys sales for the coming months are as follows: About 20 percent of sales are cash sales, and...
icon
Related questions
Question
100%

Gerry Jacobs, a financial analyst for Best Value Supermarkets, has prepared the following sales and cash disbursement estimates for the period of August through December of the current year.

Month Sales Cash Disbursements
August P400 P300
September 500 500
October 500 700
November 600 400
December 700 500

90% of sales are for cash, the remaining 10% are collected one month later. All disbursements are on a cash basis. The firm wishes to maintain a minimum cash balance of $50. The beginning cash balance in September is $25. Prepare a cash budget for the  months of October, November, and December, noting any needed financing or excess cash available.

Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 2 steps

Blurred answer
Knowledge Booster
Income Statement Analysis
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
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
Entrepreneurial Finance
Entrepreneurial Finance
Finance
ISBN:
9781337635653
Author:
Leach
Publisher:
Cengage
EBK CONTEMPORARY FINANCIAL MANAGEMENT
EBK CONTEMPORARY FINANCIAL MANAGEMENT
Finance
ISBN:
9781337514835
Author:
MOYER
Publisher:
CENGAGE LEARNING - CONSIGNMENT
Managerial Accounting
Managerial Accounting
Accounting
ISBN:
9781337912020
Author:
Carl Warren, Ph.d. Cma William B. Tayler
Publisher:
South-Western College Pub
Principles of Accounting Volume 2
Principles of Accounting Volume 2
Accounting
ISBN:
9781947172609
Author:
OpenStax
Publisher:
OpenStax College
Intermediate Financial Management (MindTap Course…
Intermediate Financial Management (MindTap Course…
Finance
ISBN:
9781337395083
Author:
Eugene F. Brigham, Phillip R. Daves
Publisher:
Cengage Learning