's payment terms with e as follows: 10% of ediately goods are the remaining, 6 0% nth 3500

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
Cash budget question
Sir John Ltd, a wooden furniture business is preparing
its cash budget for the three months ending March
2021. It has the following information.
January
February
March
April
GHC
GHC
GHC
GBC
Sales
300,000
400,000
$50,000
550,000
The company's payment terms with
customers are as follows: 10% of
sales immediately goods are
delivered. Of the remaining. 60%
after one month
40% after two months
However, 2% of credit customers never pay in the
wooden furniture industry. This affects cash
received from credit customers who pay after two
months.
Sales for November and December 2020 are
GHS220,000 and GHS290,000 respectively.
3 Labour cost equals 20% of sales, paid weekly
one week in arrears. One week will be
outstanding from December 2020.
Material cost equals 25% of sales. Half of the
materials required for production are purchased
and paid for in the month prior to sale. Suppliers
of materials do not allow credit purchases.
s.Overhead cost equals 15% of sales. Overhead is
paid for in the month in which it is incurred.
The business has planned to purchase a motor
vehicle for GHS15,000 in January and pay over
the three months in three equal instalments.
Depreciation charge for each month is GHS1,000.
At the start of January, the metal box company
have GHS150,000 cash in the current account.
Note: There are four weeks in both January and
February and five weeks in March.
Required:
Prepare the cash budget for the three months period
ending 31 March, 2021.
Transcribed Image Text:Cash budget question Sir John Ltd, a wooden furniture business is preparing its cash budget for the three months ending March 2021. It has the following information. January February March April GHC GHC GHC GBC Sales 300,000 400,000 $50,000 550,000 The company's payment terms with customers are as follows: 10% of sales immediately goods are delivered. Of the remaining. 60% after one month 40% after two months However, 2% of credit customers never pay in the wooden furniture industry. This affects cash received from credit customers who pay after two months. Sales for November and December 2020 are GHS220,000 and GHS290,000 respectively. 3 Labour cost equals 20% of sales, paid weekly one week in arrears. One week will be outstanding from December 2020. Material cost equals 25% of sales. Half of the materials required for production are purchased and paid for in the month prior to sale. Suppliers of materials do not allow credit purchases. s.Overhead cost equals 15% of sales. Overhead is paid for in the month in which it is incurred. The business has planned to purchase a motor vehicle for GHS15,000 in January and pay over the three months in three equal instalments. Depreciation charge for each month is GHS1,000. At the start of January, the metal box company have GHS150,000 cash in the current account. Note: There are four weeks in both January and February and five weeks in March. Required: Prepare the cash budget for the three months period ending 31 March, 2021.
Expert Solution
steps

Step by step

Solved in 2 steps with 1 images

Blurred answer
Knowledge Booster
Currency Market
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