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

FINANCIAL ACCOUNTING
10th Edition
ISBN:9781259964947
Author:Libby
Publisher:Libby
Chapter1: Financial Statements And Business Decisions
Section: Chapter Questions
Problem 1Q
icon
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.
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
steps

Step by step

Solved in 2 steps

Blurred answer
Knowledge Booster
Managing Debt
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