1. The following information is budgeted for McCracken Plumbing Supply Corporation for next quarter. April May June Sales 110,000 130,000 180,000 Merchandise Purchases 85,000 92,000 105,000 Selling and Administrative Expenses 50,000 50,000 50,000 All sales at McCracken are on credit. Forty percent are collected in the month of sale, 58% in the month following the sale, and the remaining 2% are uncollectable. Merchandise purchases are paid in full the month following the month of purchase. The selling and administrative expenses above include $8,000 of depreciation on display fixtures and warehouse equipment. All other selling and administrative expenses are paid as incurred. McCracken wants to maintain a cash balance of $15,000. Any amount below this can be borrowed from a local bank as needed in increments of $1,000 at a 12% annual interest rate. All borrowings are made at the beginning of the month so interest expense will need to be accrued. McCracken expects to have $24,000 of cash on hand at the beginning of May. Prepare McCracken’s cash budget for May and June. (Interest is calculated principle x rate x time). When feasible, loans are repaid at the end of the month so interest expense will also need to be recorded. Please Answer With A Step By Step Solutions

EBK CONTEMPORARY FINANCIAL MANAGEMENT
14th Edition
ISBN:9781337514835
Author:MOYER
Publisher:MOYER
Chapter4: Financial Planning And Forecasting
Section: Chapter Questions
Problem 5P
icon
Related questions
icon
Concept explainers
Question

1. The following information is budgeted for McCracken Plumbing Supply Corporation for next quarter.

                                                                   April               May                 June

Sales                                                        110,000         130,000           180,000
Merchandise Purchases                           85,000          92,000              105,000

Selling and Administrative Expenses       50,000           50,000             50,000

 

 

All sales at McCracken are on credit. Forty percent are collected in the month of sale, 58% in the month following the sale, and the remaining 2% are uncollectable. Merchandise purchases are paid in full the month following the month of purchase. The selling and administrative expenses above include $8,000 of depreciation on display fixtures and warehouse equipment. All other selling and administrative expenses are paid as incurred. McCracken wants to maintain a cash balance of $15,000. Any amount below this can be borrowed from a local bank as needed in increments of $1,000 at a 12% annual interest rate. All borrowings are made at the beginning of the month so interest expense will need to be accrued. McCracken expects to have $24,000 of cash on hand at the beginning of May. Prepare McCracken’s cash budget for May and June. (Interest is calculated principle x rate x time). When feasible, loans are repaid at the end of the month so interest expense will also need to be recorded.

 

Please Answer With  A Step By Step Solutions 

Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 3 steps

Blurred answer
Follow-up Questions
Read through expert solutions to related follow-up questions below.
Follow-up Question

Could you please explain the process by which you got these answers? I am trying to learn how to do problems similar to these but don't understand where the numbers come from.

Solution
Bartleby Expert
SEE SOLUTION
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
EBK CONTEMPORARY FINANCIAL MANAGEMENT
EBK CONTEMPORARY FINANCIAL MANAGEMENT
Finance
ISBN:
9781337514835
Author:
MOYER
Publisher:
CENGAGE LEARNING - CONSIGNMENT
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
Managerial Accounting
Accounting
ISBN:
9781337912020
Author:
Carl Warren, Ph.d. Cma William B. Tayler
Publisher:
South-Western College Pub
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 Cost Accounting
Principles of Cost Accounting
Accounting
ISBN:
9781305087408
Author:
Edward J. Vanderbeck, Maria R. Mitchell
Publisher:
Cengage Learning
Principles of Accounting Volume 2
Principles of Accounting Volume 2
Accounting
ISBN:
9781947172609
Author:
OpenStax
Publisher:
OpenStax College