stomers are allowed 3% discount if payment is made r the billing date. counts receivable are booked gross. ty percent of the billings are collected within the disc collected by the end of the month where discount p are collected by the end of the end second month, a collectible. ses 6 of all purchases of materials and selling, general a enses are paid at the month purchased and the rem Dwing month. ch month's unit of ending inventory is equal to 130% s of sales. e cost of each unit of inventory is P20. ling, general and administrative expenses, of which reciation are anual to ual to 15% of the current month
stomers are allowed 3% discount if payment is made r the billing date. counts receivable are booked gross. ty percent of the billings are collected within the disc collected by the end of the month where discount p are collected by the end of the end second month, a collectible. ses 6 of all purchases of materials and selling, general a enses are paid at the month purchased and the rem Dwing month. ch month's unit of ending inventory is equal to 130% s of sales. e cost of each unit of inventory is P20. ling, general and administrative expenses, of which reciation are anual to ual to 15% of the current month
Chapter1: Financial Statements And Business Decisions
Section: Chapter Questions
Problem 1Q
Related questions
Question
![Problem 6
Tomtom store seeks your assistance to develop cash and other budget information
for May, June, and July 2009. On April 30, 2009, the company had cash balance of
Php5,500.
The budget is based on the following assumptions:
A. Sales
1. Each month's sales are billed on the last day of the month
2. Customers are allowed 3% discount if payment is made within 10 days
after the billing date.
Accounts receivable are booked gross.
3. Sixty percent of the billings are collected within the discount period, 25%
are collected by the end of the month where discount period is allowed,
9% are collected by the end of the end second month, and 6% prove
uncollectible.
B. Purchases
1. 54% of all purchases of materials and selling, general and administrative
expenses are paid at the month purchased and the remainder in the
following month.
2. Each month's unit of ending inventory is equal to 130% of the month's
units of sales.
3. The cost of each unit of inventory is P20.
4. Selling, general and administrative expenses, of which P2.000 is
depreciation, are equal to 15% of the current month's sales.
Actual and projected sales are as follows:
Pesos
354,000
363,000
357,000
342,000
360,000
366,000
2009
March
Units
11,800
12,100
April
May
June
July
August
11,900
11,400
12,000
12,200
Required: Prepare each forecast for the month May, June, and July. 2009 supported
by the following
Schedules:
a. Cash receipts from receivables.
b. Purchases of inventory
c. Cash disbursement on accounts payable.
d. Cash disbursement on selling, general, and administrative expenses.](/v2/_next/image?url=https%3A%2F%2Fcontent.bartleby.com%2Fqna-images%2Fquestion%2F65d9fa37-ef9a-482c-94a5-b6d519fe74c3%2Ff3ee28bc-8c54-4fd9-bcd8-a7cb94f50602%2Fhpy9e2_processed.jpeg&w=3840&q=75)
Transcribed Image Text:Problem 6
Tomtom store seeks your assistance to develop cash and other budget information
for May, June, and July 2009. On April 30, 2009, the company had cash balance of
Php5,500.
The budget is based on the following assumptions:
A. Sales
1. Each month's sales are billed on the last day of the month
2. Customers are allowed 3% discount if payment is made within 10 days
after the billing date.
Accounts receivable are booked gross.
3. Sixty percent of the billings are collected within the discount period, 25%
are collected by the end of the month where discount period is allowed,
9% are collected by the end of the end second month, and 6% prove
uncollectible.
B. Purchases
1. 54% of all purchases of materials and selling, general and administrative
expenses are paid at the month purchased and the remainder in the
following month.
2. Each month's unit of ending inventory is equal to 130% of the month's
units of sales.
3. The cost of each unit of inventory is P20.
4. Selling, general and administrative expenses, of which P2.000 is
depreciation, are equal to 15% of the current month's sales.
Actual and projected sales are as follows:
Pesos
354,000
363,000
357,000
342,000
360,000
366,000
2009
March
Units
11,800
12,100
April
May
June
July
August
11,900
11,400
12,000
12,200
Required: Prepare each forecast for the month May, June, and July. 2009 supported
by the following
Schedules:
a. Cash receipts from receivables.
b. Purchases of inventory
c. Cash disbursement on accounts payable.
d. Cash disbursement on selling, general, and administrative expenses.
Expert Solution
![](/static/compass_v2/shared-icons/check-mark.png)
This question has been solved!
Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.
Step by step
Solved in 2 steps
![Blurred answer](/static/compass_v2/solution-images/blurred-answer.jpg)
Knowledge Booster
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.Recommended textbooks for you
![FINANCIAL ACCOUNTING](https://compass-isbn-assets.s3.amazonaws.com/isbn_cover_images/9781259964947/9781259964947_smallCoverImage.jpg)
![Accounting](https://www.bartleby.com/isbn_cover_images/9781337272094/9781337272094_smallCoverImage.gif)
Accounting
Accounting
ISBN:
9781337272094
Author:
WARREN, Carl S., Reeve, James M., Duchac, Jonathan E.
Publisher:
Cengage Learning,
![Accounting Information Systems](https://www.bartleby.com/isbn_cover_images/9781337619202/9781337619202_smallCoverImage.gif)
Accounting Information Systems
Accounting
ISBN:
9781337619202
Author:
Hall, James A.
Publisher:
Cengage Learning,
![FINANCIAL ACCOUNTING](https://compass-isbn-assets.s3.amazonaws.com/isbn_cover_images/9781259964947/9781259964947_smallCoverImage.jpg)
![Accounting](https://www.bartleby.com/isbn_cover_images/9781337272094/9781337272094_smallCoverImage.gif)
Accounting
Accounting
ISBN:
9781337272094
Author:
WARREN, Carl S., Reeve, James M., Duchac, Jonathan E.
Publisher:
Cengage Learning,
![Accounting Information Systems](https://www.bartleby.com/isbn_cover_images/9781337619202/9781337619202_smallCoverImage.gif)
Accounting Information Systems
Accounting
ISBN:
9781337619202
Author:
Hall, James A.
Publisher:
Cengage Learning,
![Horngren's Cost Accounting: A Managerial Emphasis…](https://www.bartleby.com/isbn_cover_images/9780134475585/9780134475585_smallCoverImage.gif)
Horngren's Cost Accounting: A Managerial Emphasis…
Accounting
ISBN:
9780134475585
Author:
Srikant M. Datar, Madhav V. Rajan
Publisher:
PEARSON
![Intermediate Accounting](https://www.bartleby.com/isbn_cover_images/9781259722660/9781259722660_smallCoverImage.gif)
Intermediate Accounting
Accounting
ISBN:
9781259722660
Author:
J. David Spiceland, Mark W. Nelson, Wayne M Thomas
Publisher:
McGraw-Hill Education
![Financial and Managerial Accounting](https://www.bartleby.com/isbn_cover_images/9781259726705/9781259726705_smallCoverImage.gif)
Financial and Managerial Accounting
Accounting
ISBN:
9781259726705
Author:
John J Wild, Ken W. Shaw, Barbara Chiappetta Fundamental Accounting Principles
Publisher:
McGraw-Hill Education