Budgeted monthly sales revenue is as follows: MUR January 56,000 February 45,000 March 85,000 April 62,000 Sales are 40% cash and 60% credit. Credit sales are collected over a two-month period, 75% in the month of sale, 25% in the month following sale. Total sales revenue for the first month of operation of January 2018 amounts to Rs 30,000. 2. 50% of inventory purchased is paid in the month of purchase. The remaining 50% is paid for in the month following purchase. Purchases are budgeted as follows: MUR January 25,000 February 40,000 March 37,000 April 28,500 3. A grant of Rs 40,000 is expected to be received in mid March 2018. 4. A van which cost Rs 100,000 when purchased second hand four years ago is expected to be sold in April 2018 for Rs 50,000. At this time the

Excel Applications for Accounting Principles
4th Edition
ISBN:9781111581565
Author:Gaylord N. Smith
Publisher:Gaylord N. Smith
Chapter22: Master Budget (master)
Section: Chapter Questions
Problem 1R: Ranger Industries has provided the following information at June 30: Other information: Average...
icon
Related questions
icon
Concept explainers
Question

Budgeted monthly sales revenue is as follows: MUR January 56,000 February 45,000 March 85,000 April 62,000 Sales are 40% cash and 60% credit. Credit sales are collected over a two-month period, 75% in the month of sale, 25% in the month following sale. Total sales revenue for the first month of operation of January 2018 amounts to Rs 30,000. 2. 50% of inventory purchased is paid in the month of purchase. The remaining 50% is paid for in the month following purchase. Purchases are budgeted as follows: MUR January 25,000 February 40,000 March 37,000 April 28,500 3. A grant of Rs 40,000 is expected to be received in mid March 2018. 4. A van which cost Rs 100,000 when purchased second hand four years ago is expected to be sold in April 2018 for Rs 50,000. At this time the expected net book value of the van is Rs 37,500. 5. Equipment costing Rs 25,600 will be purchased and fully paid for in February 2018. The equipment will be depreciated on a straight line basis over three years. 6. Operating expenses are paid as incurred. These have been estimated as follows: MUR February 15,200 March 7,000 April 19,500 Page 6 of 6 7. The cash balance on 1st February is expected to amount to 80,000. REQUIRED Prepare a cash budget on a monthly basis and in total for the period February 2018 to April 2018.

 

Expert Solution
steps

Step by step

Solved in 2 steps

Blurred answer
Knowledge Booster
Budgeting
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
Excel Applications for Accounting Principles
Excel Applications for Accounting Principles
Accounting
ISBN:
9781111581565
Author:
Gaylord N. Smith
Publisher:
Cengage Learning
Managerial Accounting
Managerial Accounting
Accounting
ISBN:
9781337912020
Author:
Carl Warren, Ph.d. Cma William B. Tayler
Publisher:
South-Western College Pub
Cornerstones of Cost Management (Cornerstones Ser…
Cornerstones of Cost Management (Cornerstones Ser…
Accounting
ISBN:
9781305970663
Author:
Don R. Hansen, Maryanne M. Mowen
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
Principles of Accounting Volume 2
Principles of Accounting Volume 2
Accounting
ISBN:
9781947172609
Author:
OpenStax
Publisher:
OpenStax College
Principles of Cost Accounting
Principles of Cost Accounting
Accounting
ISBN:
9781305087408
Author:
Edward J. Vanderbeck, Maria R. Mitchell
Publisher:
Cengage Learning