Problem 1 The following data relate to Bookshop Ltd: The financial manager has made the following sales forecasts for the first five months of the coming year, commencing from 1 April 2012: Month Sales($) April May June July August Other data: (i) 40,000 45,000 55,000 60,000 50,000 Debtors' and creditors' balance at the beginning of the year are $30,000 and $14,000,. T balance of other relevant assets and liabilities are: Cash Balance Stock Accrued Sales Commission $7,500 $51,000 $3,500 40% sales are on cash basis. Credit sales are collected in the month following the sale. Cost of sales in 60 per cent on sales. (iv) The only other variable cost is a 5% commission to sales agents. The Sales Commission is paid a month after it is earned. respectively (iv) Inventory (stock) is kept equal to sales requirements for the next two month budgeted so Trade creditors are paid in the following month after purchases. (v) (vii) Fixed costs are $5,000 per month including $2,000 depreciation.

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

Please do not give solution in image format thanku 

Problem 1
The following data relate to Bookshop Ltd:
The financial manager has made the following sales forecasts
for the first five months of the coming year, commencing from 1 April 2012:
Month
Sales($)
April
May
June
July
August
Other data:
(i)
(ii)
40,000
45,000
55,000
60,000
50,000
Debtors' and creditors' balance at the beginning of the year are $30,000 and $14,000,. The
balance of other relevant assets and liabilities are:
Cash Balance
Stock
Accrued Sales Commission
$7,500
$51,000
$3,500
40% sales are on cash basis. Credit sales are collected in the month following the sale.
Cost of sales in 60 per cent on sales.
(iv) The only other variable cost is a 5% commission to sales agents. The Sales Commission is paid in
a month after it is earned. respectively
(iv)
Inventory (stock) is kept equal to sales requirements for the next two month budgeted sales
Trade creditors are paid in the following month after purchases.
(v)
(vii) Fixed costs are $5,000 per month including $2,000 depreciation.
You are required to prepare a cash budget for the months of April, May and June 2012, respectively.
Transcribed Image Text:Problem 1 The following data relate to Bookshop Ltd: The financial manager has made the following sales forecasts for the first five months of the coming year, commencing from 1 April 2012: Month Sales($) April May June July August Other data: (i) (ii) 40,000 45,000 55,000 60,000 50,000 Debtors' and creditors' balance at the beginning of the year are $30,000 and $14,000,. The balance of other relevant assets and liabilities are: Cash Balance Stock Accrued Sales Commission $7,500 $51,000 $3,500 40% sales are on cash basis. Credit sales are collected in the month following the sale. Cost of sales in 60 per cent on sales. (iv) The only other variable cost is a 5% commission to sales agents. The Sales Commission is paid in a month after it is earned. respectively (iv) Inventory (stock) is kept equal to sales requirements for the next two month budgeted sales Trade creditors are paid in the following month after purchases. (v) (vii) Fixed costs are $5,000 per month including $2,000 depreciation. You are required to prepare a cash budget for the months of April, May and June 2012, respectively.
Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 3 steps with 4 images

Blurred answer
Knowledge Booster
Interim financial reporting
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
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