Summarized below are the Income and Expenditure forecasts of Preston Company for the months of March to August 2007.   Sales(all credit sales) Purchases(all credit purchases) Wages Manufacturing Expenses Office Expenses Selling Expenses March 60,000 36,000  9,000      4,000   2,000  4,000 April 62,000 38,000  8,000      3,000   1,500  5,000 May 64,000 33,000 10,000      4,500   2,500  4,500 June 58,000 35,000   8,500      3,500   2,000  3,500 July 56,000 39,000   9,500      4,000   1,000  4,500 August 60,000 34,000   8,000      3,000   1,500   4,500   You are given the following further information. Plant costing $16,000 is due for delivery in July payable 10% on delivery and the balance after three months. Advance tax of $8,000 is payable in March and also the same amount of tax is payable in June. Period of credit allowed (i) by suppliers is 2 months and (ii) to customers is one month. Lag in payment of manufacturing expenses is half a month. Lag in payment of all other expenses is one month.   REQUIRED: Prepare a cash budget for the three months starting on 1st May 2007 when there was a cash balance of $8,000.

FINANCIAL ACCOUNTING
10th Edition
ISBN:9781259964947
Author:Libby
Publisher:Libby
Chapter1: Financial Statements And Business Decisions
Section: Chapter Questions
Problem 1Q
icon
Related questions
icon
Concept explainers
Topic Video
Question
100%

Summarized below are the Income and Expenditure forecasts of Preston Company for the months of March to August 2007.

 

Sales(all credit sales)

Purchases(all credit purchases)

Wages

Manufacturing Expenses

Office Expenses

Selling Expenses

March

60,000

36,000

 9,000

     4,000

  2,000

 4,000

April

62,000

38,000

 8,000

     3,000

  1,500

 5,000

May

64,000

33,000

10,000

     4,500

  2,500

 4,500

June

58,000

35,000

  8,500

     3,500

  2,000

 3,500

July

56,000

39,000

  9,500

     4,000

  1,000

 4,500

August

60,000

34,000

  8,000

     3,000

  1,500

  4,500

 

You are given the following further information.

  • Plant costing $16,000 is due for delivery in July payable 10% on delivery and the balance after three months.
  • Advance tax of $8,000 is payable in March and also the same amount of tax is payable in June.
  • Period of credit allowed (i) by suppliers is 2 months and (ii) to customers is one month.
  • Lag in payment of manufacturing expenses is half a month.
  • Lag in payment of all other expenses is one month.

 

REQUIRED: Prepare a cash budget for the three months starting on 1st May 2007 when there was a cash balance of $8,000.    

Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 2 steps with 2 images

Blurred answer
Knowledge Booster
Financial Statements
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