AM is a trading entity. Purchases are on credit, with 70% paid in the month following the date of purchase and 30% paid in the month after that. Sales are partly on credit and partly for cash. Customers who receive credit are given 30 days to pay. On average 60% pay within30 days, 30% pay between 30 and 60 days and 5% pay between 60 and 90 days. The balance is written off as irrecoverable. Other overheads, including salaries, are paid within the month incurred. AM plan to purchase new equipment at the end of June 2015, the expected cost of which is P250,000. The equipment will be purchases on 30 days credit, payable at the end of July. The cash balance on 1 May 2015 is P96,000. The actual/budgeted figures for the six month to July 2015 were:        actual   budgeted       FEB P000 MAR P000 APRIL P000 MAY P000 JUNE P000 JULY P000 credit sales 100 100 110 110 120 120 cash sales 30 30 30 35 40 40 credit purchases 45 50 50 55 55 60 other overhead expenses 40 40 40 40 50 50                 Required: a. Prepare a monthly cash budget for the period May to July 2015.  b. Assess the likelihood of AM being able to pay for the equipment when it falls due.

Cornerstones of Cost Management (Cornerstones Series)
4th Edition
ISBN:9781305970663
Author:Don R. Hansen, Maryanne M. Mowen
Publisher:Don R. Hansen, Maryanne M. Mowen
Chapter8: Budgeting For Planning And Control
Section: Chapter Questions
Problem 24E: Del Spencer is the owner and founder of Del Spencers Mens Clothing Store. Del Spencers has its own...
icon
Related questions
Question
100%

AM is a trading entity. Purchases are on credit, with 70% paid in the month following the date of
purchase and 30% paid in the month after that.
Sales are partly on credit and partly for cash. Customers who receive credit are given 30 days to
pay. On average 60% pay within30 days, 30% pay between 30 and 60 days and 5% pay between
60 and 90 days. The balance is written off as irrecoverable. Other overheads, including salaries,
are paid within the month incurred.
AM plan to purchase new equipment at the end of June 2015, the expected cost of which is
P250,000. The equipment will be purchases on 30 days credit, payable at the end of July.
The cash balance on 1 May 2015 is P96,000.
The actual/budgeted figures for the six month to July 2015 were: 

 

    actual   budgeted    
  FEB P000 MAR P000 APRIL P000 MAY P000 JUNE P000 JULY P000
credit sales 100 100 110 110 120 120
cash sales 30 30 30 35 40 40
credit purchases 45 50 50 55 55 60
other overhead expenses 40 40 40 40 50 50
             

 

Required:
a. Prepare a monthly cash budget for the period May to July 2015. 


b. Assess the likelihood of AM being able to pay for the equipment when it falls due. 

 

 

Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 3 steps

Blurred answer
Knowledge Booster
Financial Reporting in Hyperinflationary Economies
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
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
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
Intermediate Financial Management (MindTap Course…
Intermediate Financial Management (MindTap Course…
Finance
ISBN:
9781337395083
Author:
Eugene F. Brigham, Phillip R. Daves
Publisher:
Cengage Learning
Auditing: A Risk Based-Approach (MindTap Course L…
Auditing: A Risk Based-Approach (MindTap Course L…
Accounting
ISBN:
9781337619455
Author:
Karla M Johnstone, Audrey A. Gramling, Larry E. Rittenberg
Publisher:
Cengage Learning