(b) The budgeting section of-the corporate finance department of Atlas Products Company has received the following sales estimates from the marketing department: Total Sales Credit Sales December 2019 January 2020 February 2020 March 2020 Sh. 825,000 730,000 840,000 Sh.770,000 690,000 780,000 855,000 920,000 The company has found that, on average, about 25 percent of its credit sales are collected during the month when the sale is made, and the remaining 75 percent of credit sales are collected during the month following the sale. As a result, the company uses these figures for budgeting. The company estimates its purchases at 60 percent of next month's sales, and payments for those purchases are budgeted to lag the purchases by one month. Various disbursements have been estimated as follows: Wages and salaries Rent January Sh.250,000 February Sh.260,000 27,000 March Sh.290,000 27,000 27,000 10,000 Other expenses 12,000 14,000

FINANCIAL ACCOUNTING
10th Edition
ISBN:9781259964947
Author:Libby
Publisher:Libby
Chapter1: Financial Statements And Business Decisions
Section: Chapter Questions
Problem 1Q
icon
Related questions
icon
Concept explainers
Question

The company has found that, on average, about 25 percent of its credit sales are collected during

the month when the sale is made, and the remaining 75 percent of credit sales are collected

during the month following the sale. As a result, the company uses these figures for budgeting.

The company estimates its purchases at 60 percent of next month's sales, and payments for those

purchases are budgeted to lag the purchases by one month.

 

In addition, a tax payment of Sh.105,000 is due on January 15, and Sh.40,000 in dividends will
be declared in January and paid in March. Also, the company has ordered a Sh.75,000 piece of
equipment. Delivery is scheduled for early January, and payment will be due in February.
The company’s projected cash balance at the beginning of January is Sh.100,000, and the
company desires to maintain a balance of Sh.100,000 at the end of each month.

Prepare a cash budget for Atlas Products, Company, for the first quarter of 2014, based on the

following information.

(b) The budgeting section of-the corporate finance department of Atlas Products Company
has received the following sales estimates from the marketing department:
Total Sales
Credit Sales
December 2019
January 2020
February 2020
March 2020
Sh. 825,000
Sh.770,000
730,000
840,000
920,000
690,000
780,000
855,000
The company has found that, on average, about 25 percent of its credit sales are collected during
the month when the sale is made, and the remaining 75 percent of credit sales are collected
during the month following the sale. As a result, the company uses these figures for budgeting.
The company estimates its purchases at 60 percent of next month's sales, and payments for those
purchases are budgeted to lag the purchases by one month.
Various disbursements have been estimated as follows:
January
Sh.250,000
27,000
10,000
February
Sh.260,000
March
Wages and salaries
Rent
Sh.290,000
27,000
12,000
27,000
Other expenses
14,000
Transcribed Image Text:(b) The budgeting section of-the corporate finance department of Atlas Products Company has received the following sales estimates from the marketing department: Total Sales Credit Sales December 2019 January 2020 February 2020 March 2020 Sh. 825,000 Sh.770,000 730,000 840,000 920,000 690,000 780,000 855,000 The company has found that, on average, about 25 percent of its credit sales are collected during the month when the sale is made, and the remaining 75 percent of credit sales are collected during the month following the sale. As a result, the company uses these figures for budgeting. The company estimates its purchases at 60 percent of next month's sales, and payments for those purchases are budgeted to lag the purchases by one month. Various disbursements have been estimated as follows: January Sh.250,000 27,000 10,000 February Sh.260,000 March Wages and salaries Rent Sh.290,000 27,000 12,000 27,000 Other expenses 14,000
In addition, a tax payment of Sh.105,000 is due on January 15, and Sh.40,000 in dividends will
be declared in January and paid in March. Also, the company has ordered a Sh.75,000 piece of
equipment. Delivery is scheduled for early January, and payment will be due in February.
The company's projected cash balance at the beginning of January is Sh.100,000, and the
company desires to maintain a balance of Sh.100,000 at the end of each month.
Required;
Prepare a cash budget for Atlas Products, Company, for the first quarter of 2014, based on the
following information.
Transcribed Image Text:In addition, a tax payment of Sh.105,000 is due on January 15, and Sh.40,000 in dividends will be declared in January and paid in March. Also, the company has ordered a Sh.75,000 piece of equipment. Delivery is scheduled for early January, and payment will be due in February. The company's projected cash balance at the beginning of January is Sh.100,000, and the company desires to maintain a balance of Sh.100,000 at the end of each month. Required; Prepare a cash budget for Atlas Products, Company, for the first quarter of 2014, based on the following information.
Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 2 steps

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
  • SEE MORE 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