Homework Help is Here – Start Your Trial Now!
Business
Accounting
Exercise 9-45 Cash Budget The owner of a building supply company has requested a cash budget for June. After examining the records of the company, you find the following: Cash balance on June 1 is R7,360. a. b. Actual sales for April and May are as follows: April May Cash sales R100,000 R180,000 Credit sales 350,000 R530,000 Total sales R389,000 Credit sales are collected over a three-month period: c. 40% in the month of sale, 30% in the second month, and 20% in the third month. The sales collected in the third month are subject to a 2% late fee, which is paid by those customers in addition to what they owe. The remaining sales are uncollectible. d. Inventory purchases average 64% of a month's total sales. Of those purchases, 20% are paid for in the month of purchase. The remaining 80% are paid for in the following month. Salaries and wages total R117,500 per month, including a R45,000 salary paid to the owner. Rent is R41,000 per month. Taxes to be paid in June are R67,800. The owner also tells you that he expects cash sales of R186,000 and credit sales of R540,000 for June. No minimum cash balance is required. The owner of the company doesn't have access to short-term loans. e. Required: 1. Prepare a cash budget for June. Include supporting schedules for cash collections and cash payments.

Exercise 9-45 Cash Budget The owner of a building supply company has requested a cash budget for June. After examining the records of the company, you find the following: Cash balance on June 1 is R7,360. a. b. Actual sales for April and May are as follows: April May Cash sales R100,000 R180,000 Credit sales 350,000 R530,000 Total sales R389,000 Credit sales are collected over a three-month period: c. 40% in the month of sale, 30% in the second month, and 20% in the third month. The sales collected in the third month are subject to a 2% late fee, which is paid by those customers in addition to what they owe. The remaining sales are uncollectible. d. Inventory purchases average 64% of a month's total sales. Of those purchases, 20% are paid for in the month of purchase. The remaining 80% are paid for in the following month. Salaries and wages total R117,500 per month, including a R45,000 salary paid to the owner. Rent is R41,000 per month. Taxes to be paid in June are R67,800. The owner also tells you that he expects cash sales of R186,000 and credit sales of R540,000 for June. No minimum cash balance is required. The owner of the company doesn't have access to short-term loans. e. Required: 1. Prepare a cash budget for June. Include supporting schedules for cash collections and cash payments.

FINANCIAL ACCOUNTING
FINANCIAL ACCOUNTING
10th Edition
ISBN:9781259964947
Author:Libby
Publisher:Libby
Chapter1: Financial Statements And Business Decisions
Section: Chapter Questions
Problem 1Q
See similar textbooks
icon
Related questions
Topic Video
Question
b. a. Prepare a schedule of cash payments for Fein Company for the month of August. OBJECTIVE 3 C. Exercise 9-45 Cash Budget The owner of a building supply company has requested a cash budget for June. After examining the records of the company, you find the following: Cash balance on June 1 is R7,360. b. Actual sales for April and May are as follows: d. F. a. April May Cash sales R180,000 Credit sales to 00 R530,000 Total sales R389,000 c. Credit sales are collected over a three-month period: R 40% in the month of sale, 30% in the second month, and 20% in the third month. The sales collected in the third month are subject to a 2% late fee, which is paid by those customers in addition to what they owe. The remaining sales are uncollectible. d. Inventory purchases average 64% of a month's total B sales. Of those purchases, 20% are paid for in the month of purchase. The remaining 80% are paid for in the following month. Salaries and wages total R117,500 per month, including a R45,000 salary paid to the owner. Rent is R41,000 per month. g. Taxes to be paid in June are R67,800. The owner also tells you that he expects cash sales of R186,000 and credit sales of R540,000 for June. No minimum cash balance is required. The owner of the company doesn't have access to short-term loans. e. Required: 1. Prepare a cash budget for June. Include supporting schedules for cash collections and cash payments.
Transcribed Image Text:b. a. Prepare a schedule of cash payments for Fein Company for the month of August. OBJECTIVE 3 C. Exercise 9-45 Cash Budget The owner of a building supply company has requested a cash budget for June. After examining the records of the company, you find the following: Cash balance on June 1 is R7,360. b. Actual sales for April and May are as follows: d. F. a. April May Cash sales R180,000 Credit sales to 00 R530,000 Total sales R389,000 c. Credit sales are collected over a three-month period: R 40% in the month of sale, 30% in the second month, and 20% in the third month. The sales collected in the third month are subject to a 2% late fee, which is paid by those customers in addition to what they owe. The remaining sales are uncollectible. d. Inventory purchases average 64% of a month's total B sales. Of those purchases, 20% are paid for in the month of purchase. The remaining 80% are paid for in the following month. Salaries and wages total R117,500 per month, including a R45,000 salary paid to the owner. Rent is R41,000 per month. g. Taxes to be paid in June are R67,800. The owner also tells you that he expects cash sales of R186,000 and credit sales of R540,000 for June. No minimum cash balance is required. The owner of the company doesn't have access to short-term loans. e. Required: 1. Prepare a cash budget for June. Include supporting schedules for cash collections and cash payments.
Expert Solution
steps

Step by step

Solved in 2 steps

SEE SOLUTIONCheck out a sample Q&A here
Blurred answer
Knowledge Booster
Performance measurements
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
FINANCIAL ACCOUNTING
FINANCIAL ACCOUNTING
Accounting
ISBN:
9781259964947
Author:
Libby
Publisher:
MCG
Accounting
Accounting
Accounting
ISBN:
9781337272094
Author:
WARREN, Carl S., Reeve, James M., Duchac, Jonathan E.
Publisher:
Cengage Learning,
Accounting Information Systems
Accounting Information Systems
Accounting
ISBN:
9781337619202
Author:
Hall, James A.
Publisher:
Cengage Learning,
Horngren's Cost Accounting: A Managerial Emphasis…
Horngren's Cost Accounting: A Managerial Emphasis…
Accounting
ISBN:
9780134475585
Author:
Srikant M. Datar, Madhav V. Rajan
Publisher:
PEARSON
Intermediate Accounting
Intermediate Accounting
Accounting
ISBN:
9781259722660
Author:
J. David Spiceland, Mark W. Nelson, Wayne M Thomas
Publisher:
McGraw-Hill Education
Financial and Managerial Accounting
Financial and Managerial Accounting
Accounting
ISBN:
9781259726705
Author:
John J Wild, Ken W. Shaw, Barbara Chiappetta Fundamental Accounting Principles
Publisher:
McGraw-Hill Education
SEE MORE TEXTBOOKS