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.

College Accounting, Chapters 1-27
23rd Edition
ISBN:9781337794756
Author:HEINTZ, James A.
Publisher:HEINTZ, James A.
Chapter15: Financial Statements And Year-end Accounting For A Merchandising Business
Section: Chapter Questions
Problem 9SPB: FINANCIAL RATIOS Use the work sheet and financial statements prepared in Problem 15-8B. All sales...
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
  • SEE MORE QUESTIONS
Recommended textbooks for you
College Accounting, Chapters 1-27
College Accounting, Chapters 1-27
Accounting
ISBN:
9781337794756
Author:
HEINTZ, James A.
Publisher:
Cengage Learning,
College Accounting, Chapters 1-27 (New in Account…
College Accounting, Chapters 1-27 (New in Account…
Accounting
ISBN:
9781305666160
Author:
James A. Heintz, Robert W. Parry
Publisher:
Cengage Learning
Principles of Accounting Volume 1
Principles of Accounting Volume 1
Accounting
ISBN:
9781947172685
Author:
OpenStax
Publisher:
OpenStax College
Principles of Accounting Volume 2
Principles of Accounting Volume 2
Accounting
ISBN:
9781947172609
Author:
OpenStax
Publisher:
OpenStax College
Excel Applications for Accounting Principles
Excel Applications for Accounting Principles
Accounting
ISBN:
9781111581565
Author:
Gaylord N. Smith
Publisher:
Cengage Learning
Managerial Accounting: The Cornerstone of Busines…
Managerial Accounting: The Cornerstone of Busines…
Accounting
ISBN:
9781337115773
Author:
Maryanne M. Mowen, Don R. Hansen, Dan L. Heitger
Publisher:
Cengage Learning