ased on the following data, prepare a cash budget (in proper form with labels) for July and August.   Forecast sales   May     $12,000   June     15,000     July      $16,000   August $12,000   Cash sales are 30% of total sales. Credit sales are collected as follows: 60% one month after the sale and 40% 2 months after the sale   Accounts payable are paid 100% 2 months after the purchase   Expected A/P   May     $5,000     June    $6,000   July     $7,000   August $8,000   In addition to purchases, there are utility bills of $1,500 each month   Beginning cash for July is $3,800

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
icon
Concept explainers
Question
100%

Based on the following data, prepare a cash budget (in proper form with labels) for July and August.

 

Forecast sales

 

May     $12,000

 

June     15,000  

 

July      $16,000

 

August $12,000

 

Cash sales are 30% of total sales. Credit sales are collected as follows: 60% one month after the sale and 40% 2 months after the sale

 

Accounts payable are paid 100% 2 months after the purchase

 

Expected A/P

 

May     $5,000  

 

June    $6,000

 

July     $7,000

 

August $8,000

 

In addition to purchases, there are utility bills of $1,500 each month

 

Beginning cash for July is $3,800

Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 2 steps with 2 images

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
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
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
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
Financial And Managerial Accounting
Financial And Managerial Accounting
Accounting
ISBN:
9781337902663
Author:
WARREN, Carl S.
Publisher:
Cengage Learning,