MJ5 Co. had the following budgeted sales for the last half of 2021: July $ 200,000 August $ 225,000 September $ 175,000 October $ 195,000 November $ 260,000 December 420,000 The company is in the process of preparing a cash budget and must determine the expected cash collections by month. To this end, the following information has been assembled: 20% of sales are in cash Collection on credit sales: 60% in the month of sale 30% in the month following sale 10% in the second month following sale The accounts receivable balance on July 1, 2021 consisted of the following: Uncollected June sales $ 60,000 Uncollected May sales $ 15,000 Total Accounts Receivable $ 75,000

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

Hi there,

I have attached the problem I'm working on. Can you please show me, step-by-step, how to solve for:

The total budgeted cash collections for July

The budgeted accounts receivable balance on December 31, 2021

MJ5 Co. had the following budgeted sales for the last half of 2021:
July
$
200,000
August
$
225,000
September
$ 175,000
October
$ 195,000
November
$ 260,000
December
420,000
The company is in the process of preparing a cash budget and must determine the expected cash collections by
month. To this end, the following information has been assembled:
20% of sales are in cash
Collection on credit sales:
60% in the month of sale
30% in the month following sale
10% in the second month following sale
The accounts receivable balance on July 1, 2021 consisted of the following:
Uncollected June sales
$
60,000
Uncollected May sales
$
15,000
Total Accounts Receivable
$
75,000
Transcribed Image Text:MJ5 Co. had the following budgeted sales for the last half of 2021: July $ 200,000 August $ 225,000 September $ 175,000 October $ 195,000 November $ 260,000 December 420,000 The company is in the process of preparing a cash budget and must determine the expected cash collections by month. To this end, the following information has been assembled: 20% of sales are in cash Collection on credit sales: 60% in the month of sale 30% in the month following sale 10% in the second month following sale The accounts receivable balance on July 1, 2021 consisted of the following: Uncollected June sales $ 60,000 Uncollected May sales $ 15,000 Total Accounts Receivable $ 75,000
Expert Solution
steps

Step by step

Solved in 2 steps

Blurred answer
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
EBK CONTEMPORARY FINANCIAL MANAGEMENT
EBK CONTEMPORARY FINANCIAL MANAGEMENT
Finance
ISBN:
9781337514835
Author:
MOYER
Publisher:
CENGAGE LEARNING - CONSIGNMENT
Fundamentals Of Financial Management, Concise Edi…
Fundamentals Of Financial Management, Concise Edi…
Finance
ISBN:
9781337902571
Author:
Eugene F. Brigham, Joel F. Houston
Publisher:
Cengage Learning
Excel Applications for Accounting Principles
Excel Applications for Accounting Principles
Accounting
ISBN:
9781111581565
Author:
Gaylord N. Smith
Publisher:
Cengage Learning
Principles of Accounting Volume 2
Principles of Accounting Volume 2
Accounting
ISBN:
9781947172609
Author:
OpenStax
Publisher:
OpenStax College
Managerial Accounting
Managerial Accounting
Accounting
ISBN:
9781337912020
Author:
Carl Warren, Ph.d. Cma William B. Tayler
Publisher:
South-Western College Pub