FINANCIAL ACCOUNTING
FINANCIAL ACCOUNTING
10th Edition
ISBN: 9781259964947
Author: Libby
Publisher: MCG
Bartleby Related Questions Icon

Related questions

bartleby

Concept explainers

Question

Create a schedule of cash collection using both pi

viii
Rent was charged at $ 20 000.00 quarterly.
expand button
Transcribed Image Text:viii Rent was charged at $ 20 000.00 quarterly.
PART A
DS Pharmacy sells a product that has a highly seasonal variation with peak sales occurring in
the third quarter. The following information was given for expected sales data for the coming
year 2020. The product of the pharmacy sells for $6.00 per unit. Budgeted sales for the next
four quarters are as follows: -
Quarters
Budgeted
Sales in Units
i.
ii.
iii.
iv.
V.
1
Sales are collected in the following pattern: 60% in the quarter the sales are made and the
remaining 40% in the following quarter.
vi.
2
On January 1, 2020, the records showed 60 000 in accounts receivables as well as the following
information.
vii.
2020
3
50 000 70 000 120 000
4
60 000
Cash balance at January first was $38 000.00. Also, in the first quarter direct
material cost $70 000.00, direct Labour cost $80 000.00, Administration expenses
$100 000.00, Taxes $10 000.00 and Advertising $15 000.00.
Equipment was purchased in the first quarter for $50 000.00. Equipment
purchases increased in the second quarter by 30%. No other equipment was
purchased.
A dividend of $16 000.00 is to be paid in the first quarter and fourth quarter only.
Administration Expenses rose by 25% in the second quarter, 20% in the third,
quarter and 10% in the fourth quarter. The increased in expenses was based on the
previous quarter figures.
For financing purposes, a loan of $85 000.00 was received in the first quarter and
$40 000.00 in the second quarter.
In the third quarter the $85 000.00 loan with interest of $3 000.00 were repaid and
in the fourth quarter the $40 000.00 loan with interest of $6 000.00 were repaid.
Direct materials and Direct labour increased each quarter by $15 000 and
10 000 respectively.
expand button
Transcribed Image Text:PART A DS Pharmacy sells a product that has a highly seasonal variation with peak sales occurring in the third quarter. The following information was given for expected sales data for the coming year 2020. The product of the pharmacy sells for $6.00 per unit. Budgeted sales for the next four quarters are as follows: - Quarters Budgeted Sales in Units i. ii. iii. iv. V. 1 Sales are collected in the following pattern: 60% in the quarter the sales are made and the remaining 40% in the following quarter. vi. 2 On January 1, 2020, the records showed 60 000 in accounts receivables as well as the following information. vii. 2020 3 50 000 70 000 120 000 4 60 000 Cash balance at January first was $38 000.00. Also, in the first quarter direct material cost $70 000.00, direct Labour cost $80 000.00, Administration expenses $100 000.00, Taxes $10 000.00 and Advertising $15 000.00. Equipment was purchased in the first quarter for $50 000.00. Equipment purchases increased in the second quarter by 30%. No other equipment was purchased. A dividend of $16 000.00 is to be paid in the first quarter and fourth quarter only. Administration Expenses rose by 25% in the second quarter, 20% in the third, quarter and 10% in the fourth quarter. The increased in expenses was based on the previous quarter figures. For financing purposes, a loan of $85 000.00 was received in the first quarter and $40 000.00 in the second quarter. In the third quarter the $85 000.00 loan with interest of $3 000.00 were repaid and in the fourth quarter the $40 000.00 loan with interest of $6 000.00 were repaid. Direct materials and Direct labour increased each quarter by $15 000 and 10 000 respectively.
Expert Solution
Check Mark
Knowledge Booster
Background pattern image
Accounting
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
Text book image
FINANCIAL ACCOUNTING
Accounting
ISBN:9781259964947
Author:Libby
Publisher:MCG
Text book image
Accounting
Accounting
ISBN:9781337272094
Author:WARREN, Carl S., Reeve, James M., Duchac, Jonathan E.
Publisher:Cengage Learning,
Text book image
Accounting Information Systems
Accounting
ISBN:9781337619202
Author:Hall, James A.
Publisher:Cengage Learning,
Text book image
Horngren's Cost Accounting: A Managerial Emphasis...
Accounting
ISBN:9780134475585
Author:Srikant M. Datar, Madhav V. Rajan
Publisher:PEARSON
Text book image
Intermediate Accounting
Accounting
ISBN:9781259722660
Author:J. David Spiceland, Mark W. Nelson, Wayne M Thomas
Publisher:McGraw-Hill Education
Text book image
Financial and Managerial Accounting
Accounting
ISBN:9781259726705
Author:John J Wild, Ken W. Shaw, Barbara Chiappetta Fundamental Accounting Principles
Publisher:McGraw-Hill Education