Managerial Accounting
3rd Edition
ISBN: 9780077826482
Author: Stacey M Whitecotton Associate Professor, Robert Libby, Fred Phillips Associate Professor
Publisher: McGraw-Hill Education
expand_more
expand_more
format_list_bulleted
Concept explainers
Question
Chapter 8, Problem 9ME
To determine
Introduction:
Budgeting is an important part of the business process. Without budgeting a business cannot track its process and improve its performance.
To prepare:
Budgeted cash receipts
Expert Solution & Answer
Want to see the full answer?
Check out a sample textbook solutionStudents have asked these similar questions
Marlin Company projects the follwoing sales for the first thre months of the year: $11500 in January; $10100 in February and $10400 in March. the company expects 60% of the sales to be cash and the remainder on accounts. Sales on account are collected 50% in the month of the sale and 50% in the following month. The Account Receivable account has a zero on January.
1. Prepare a schedule of cash receipts for Marlin for January, February and March. What is the balance in Accounts Receivable on March 31?
2. Prepare a revised schedule of cash receipts if receipts from sales on account are 70% in the month of the sale, 20% in the following month of the sale and 10% in the second month of the sale. What is the balance in Accounts Receivable on March 31?
Magenta Corporation has the following sales forecasts for the selected three-month period for the current year:
Month
Sales
July
$30,000
August
15,000
September
12,000
All sales are on account. Sixty percent of sales are collected in the month of the sale, and the remainder are collected in the following month.
Accounts receivable balance (July 1)
$28,000
Cash balance (July 1)
17,000
Minimum cash balance is $13,000. Cash can be borrowed in $2,000 increments from the local bank (assume no interest charges).What is the cash balance at the end of July, assuming that cash is received only from customers and that $53,000 is paid out during July?
a.$18,500
b.$14,000
c.$25,000
d.$20,200
Chapter 8 Solutions
Managerial Accounting
Ch. 8 - Briefly describe why budgetary planning is...Ch. 8 - What role do budgets play in the planning and...Ch. 8 - Prob. 3QCh. 8 - Prob. 4QCh. 8 - Prob. 5QCh. 8 - Prob. 6QCh. 8 - What are the advantages and disadvantages of...Ch. 8 - What is budgetary slack and why might it be...Ch. 8 - Briefly explain how each of the following helps to...Ch. 8 - What is the master budget, and what are its...
Ch. 8 - Explain why the sales budget is the starting point...Ch. 8 - Prob. 12QCh. 8 - What are tile components of tile operating...Ch. 8 - Prob. 14QCh. 8 - Prob. 15QCh. 8 - Prob. 16QCh. 8 - Prob. 17QCh. 8 - Prob. 18QCh. 8 - How does the budgeting process differ for a...Ch. 8 - Prob. 20QCh. 8 - Prob. 1MCCh. 8 - Prob. 2MCCh. 8 - Prob. 3MCCh. 8 - Prob. 4MCCh. 8 - Prob. 5MCCh. 8 - Prob. 6MCCh. 8 - Which of the following budgets is affected by the...Ch. 8 - Prob. 8MCCh. 8 - Prob. 9MCCh. 8 - Prob. 10MCCh. 8 - Describing Advantages of Budgetary Planning...Ch. 8 - Classifying Components of Master Budget Classify...Ch. 8 - Prob. 4MECh. 8 - Prob. 5MECh. 8 - Prob. 6MECh. 8 - Prob. 7MECh. 8 - Preparing Selling and Administrative Expense...Ch. 8 - Prob. 9MECh. 8 - Prob. 10MECh. 8 - Prob. 11MECh. 8 - Prob. 1ECh. 8 - Using Terms to Complete Sentences about Budgets...Ch. 8 - Prob. 3ECh. 8 - Prob. 4ECh. 8 - Prob. 5ECh. 8 - Prob. 6ECh. 8 - Prob. 7ECh. 8 - Prob. 8ECh. 8 - Prob. 9ECh. 8 - Prob. 10ECh. 8 - Prob. 11ECh. 8 - Preparing Production, Raw Materials Purchases...Ch. 8 - Prob. 13ECh. 8 - Prob. 14ECh. 8 - Prob. 15ECh. 8 - Prob. 16ECh. 8 - Prob. 17ECh. 8 - Prob. 18ECh. 8 - Prob. 19ECh. 8 - Prob. 20ECh. 8 - Prob. 21ECh. 8 - Prob. 1.1GAPCh. 8 - Prob. 1.2GAPCh. 8 - Prob. 1.3GAPCh. 8 - Prob. 1.4GAPCh. 8 - Prob. 1.5GAPCh. 8 - Prob. 1.6GAPCh. 8 - Prob. 1.7GAPCh. 8 - Prob. 2GAPCh. 8 - Prob. 3.1GAPCh. 8 - Prob. 3.2GAPCh. 8 - Prob. 3.3GAPCh. 8 - Prob. 4.1GAPCh. 8 - Prob. 4.2GAPCh. 8 - Preparing Operating Budget Components Wesley Power...Ch. 8 - Prob. 4.4GAPCh. 8 - Prob. 5.1GAPCh. 8 - Prob. 5.2GAPCh. 8 - Preparing Operating Budget Components Refer to the...Ch. 8 - Prob. 6.1GAPCh. 8 - Prob. 6.2GAPCh. 8 - Prob. 6.3GAPCh. 8 - Prob. 6.4GAPCh. 8 - Prob. 6.5GAPCh. 8 - Prob. 1.1GBPCh. 8 - Prob. 1.2GBPCh. 8 - Prob. 1.3GBPCh. 8 - Prob. 1.4GBPCh. 8 - Prob. 1.5GBPCh. 8 - Prob. 1.6GBPCh. 8 - Prob. 1.7GBPCh. 8 - Prob. 2GBPCh. 8 - Prob. 3.1GBPCh. 8 - Prob. 3.2GBPCh. 8 - Prob. 3.3GBPCh. 8 - Prob. 4.1GBPCh. 8 - Prob. 4.2GBPCh. 8 - Prob. 4.3GBPCh. 8 - Prob. 4.4GBPCh. 8 - Prob. 5.1GBPCh. 8 - Prob. 5.2GBPCh. 8 - Prob. 5.3GBPCh. 8 - Prob. 6.1GBPCh. 8 - Prob. 6.2GBPCh. 8 - Prob. 6.3GBPCh. 8 - Prob. 6.4GBPCh. 8 - Prob. 6.5GBP
Knowledge Booster
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
- Cash collections for Renew Lights found that 65% of sales were collected in the month of sale, 25% was collected the month after the sale, and 10% was collected the second month after the sale. Given the sales shown, how much cash will be collected in March and April?arrow_forwardHalifax Shoes has 30% of its sales in cash and the remainder on credit. Of the credit sales, 65% is collected in the month of sale, 25% is collected the month after the sale, and 5% is collected the second month after the sale. How much cash will be collected in August if sales are estimated as $75,000 in June, $65,000 in July, and $90,000 in August?arrow_forwardSchedule of cash payments for service company Horizon Financial Inc. was organized on February 28. Projected selling and administrative expenses for each of the first three months of operations are as follows: Depreciation, insurance, and property taxes represent 9,000 of the estimated monthly expenses. The annual insurance premium was paid on February 28, and property taxes for the year will be paid in June. Seventy percent of the remainder of the expenses are expected to be paid in the month in which they are incurred, with the balance to be paid in the following month. Prepare a schedule of cash payments for selling and administrative expenses for March, April, and May.arrow_forward
- A companys sales for the coming months are as follows: About 20 percent of sales are cash sales, and the remainder are credit sales. The company finds that typically 10 percent of a months credit sales are paid in the month of sale, 70 percent are paid the next month, and 15 percent are paid in the second month after sale. Expected cash receipts in July are budgeted at what amount? a. 114,520 b. 143,150 c. 145,720 d. 156,000arrow_forwardEarthies Shoes has 55% of its sales in cash and the remainder on credit. Of the credit sales, 70% is collected in the month of sale, 15% is collected the month after the sale, and 10% is collected the second month after the sale. How much cash will be collected in June if sales are estimated as $75,000 in April, $65,000 in May, and $90,000 in June?arrow_forwardCash collections for Wax On Candles found that 60% of sales were collected in the month of the sale, 30% was collected the month after the sale, and 10% was collected the second month after the sale. Given the sales shown, how much cash will be collected in January and February?arrow_forward
- Cash budget The controller of Bridgeport Housewares Inc. instructs you to prepare a monthly cash budget for the next three months. You are presented with the following budget information: The company expects to sell about 10% of its merchandise for cash. Of sales on account, 70% are expected to be collected in the month following the sale and the remainder the following month (second month following sale). Depreciation, insurance, and property tax expense represent 50,000 of the estimated monthly manufacturing costs. The annual insurance premium is paid in January, and the annual property taxes are paid in December. Of the remainder of the manufacturing costs, 80% are expected to be paid in the month in which they are incurred and the balance in the following month. Current assets as of September 1 include cash of 40,000, marketable securities of 75,000, and accounts receivable of 300,000 (60,000 from July sales and 240,000 from August sales). Sales on account for July and August were 200,000 and 240,000, respectively. Current liabilities as of September 1 include 40,000 of accounts payable incurred in August for manufacturing costs. All selling and administrative expenses are paid in cash in the period they are incurred. An estimated income tax payment of 55,000 will be made in October. Bridgeports regular quarterly dividend of 25,000 is expected to be declared in October and paid in November. Management desires to maintain a minimum cash balance of 50,000. Instructions Prepare a monthly cash budget and supporting schedules for September, October, and November. On the basis of the cash budget prepared in part (1), what recommendation should be made to the controller?arrow_forwardCASH BUDGETING Helen Bowers, owner of Helens Fashion Designs, is planning to request a line of credit from her bank. She has estimated the following sales forecasts for the firm for parts of 2019 and 2020: Estimates regarding payments obtained from the credit department are as follows: collected within the month of sale, 10%; collected the month following the sale, 75%; collected the second month following the sale, 15%. Payments for labor and raw materials are made the month after these services were provided. Here are the estimated costs of labor plus raw materials: General and administrative salaries are approximately 27,000 a month. Lease payments under long-term leases are 9,000 a month. Depreciation charges are 36,000 a month. Miscellaneous expenses are 2,700 a month. Income tax payments of 63,000 are due in September and December. A progress payment of 180,000 on a new design studio must be paid in October. Cash on hand on July 1 will be 132,000, and a minimum cash balance of 90,000 should be maintained throughout the cash budget period. a. Prepare a monthly cash budget for the last 6 months of 2019. b. Prepare monthly estimates of the required financing or excess fundsthat is, the amount of money Bowers will need to borrow or will have available to invest. c. Now suppose receipts from sales come in uniformly during the month (that is, cash receipts come in at the rate of 1/30 each day), but all outflows must be paid on the 5th. Will this affect the cash budget? That is, will the cash budget you prepared be valid under these assumptions? If not, what could be done to make a valid estimate of the peak financing requirements? No calculations are required, although if you prefer, you can use calculations to illustrate the effects. d. Bowers sales are seasonal, and her company produces on a seasonal basis, just ahead of sales. Without making any calculations, discuss how the companys current and debt ratios would vary during the year if all financial requirements were met with short-term bank loans. Could changes in these ratios affect the firms ability to obtain bank credit? Explain.arrow_forwardPilsner Inc. purchases raw materials on account for use in production. The direct materials purchases budget shows the following expected purchases on account: Pilsner typically pays 25% on account in the month of billing and 75% the next month. Required: 1. How much cash is required for payments on account in May? 2. How much cash is expected for payments on account in June?arrow_forward
- Ranger Industries has provided the following information at June 30: Other information: Average selling price, 196 Average purchase price per unit, 110 Desired ending inventory, 40% of next months unit sales Collections from customers: In month of sale20% In month after sale50% Two months after sale30% Projected cash payments: Inventory purchases are paid for in the month following acquisition. Variable cash expenses, other than inventory, are equal to 25% of each months sales and are paid in the month of sale. Fixed cash expenses are 40,000 per month and are paid in the month incurred. Depreciation on equipment is 2,000 per month. REQUIREMENT You have been asked to prepare a master budget for the upcoming quarter (July, August, and September). The components of this budget are a monthly sales budget, a monthly purchases budget, a monthly cash budget, a forecasted income statement for the quarter, and a forecasted September 30 balance sheet. The worksheet MASTER has been provided to assist you. Ranger Industries desires to maintain a minimum cash balance of 8,000 at the end of each month. If this goal cannot be met, the company borrows the exact amount needed to reach its goal. If the company has a cash balance greater than 8,000 and also has loans payable outstanding, the amount in excess of 8,000 is paid to the bank. Annual interest of 18% is paid on a monthly basis on the outstanding balance.arrow_forwardPalmgren Company produces consumer products. The sales budget for four months of the year is presented below. Company policy requires that ending inventories for each month be 25 percent of next months sales. At the beginning of July, the beginning inventory of consumer products met that policy. Required: Prepare a production budget for the third quarter of the year. Show the number of units that should be produced each month as well as for the quarter in total.arrow_forwardAll Temps has a policy of always paying within the discount period, and each of its suppliers provides a discount of 2% if paid within 10 days of purchase. Because of the purchase policy, 80% of its payments are made in the month of purchase and 20% are made the following month. The direct materials budget provides for purchases of $23,812 in February, $23,127 in March, $21,836 in April, and $28,173 in May.What is the balance in accounts payable for April 30, and May 31?arrow_forward
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you
- Cornerstones of Cost Management (Cornerstones Ser...AccountingISBN:9781305970663Author:Don R. Hansen, Maryanne M. MowenPublisher:Cengage LearningManagerial AccountingAccountingISBN:9781337912020Author:Carl Warren, Ph.d. Cma William B. TaylerPublisher:South-Western College PubPrinciples of Accounting Volume 2AccountingISBN:9781947172609Author:OpenStaxPublisher:OpenStax College
- Intermediate Financial Management (MindTap Course...FinanceISBN:9781337395083Author:Eugene F. Brigham, Phillip R. DavesPublisher:Cengage Learning
Cornerstones of Cost Management (Cornerstones Ser...
Accounting
ISBN:9781305970663
Author:Don R. Hansen, Maryanne M. Mowen
Publisher:Cengage Learning
Managerial Accounting
Accounting
ISBN:9781337912020
Author:Carl Warren, Ph.d. Cma William B. Tayler
Publisher:South-Western College Pub
Principles of Accounting Volume 2
Accounting
ISBN:9781947172609
Author:OpenStax
Publisher:OpenStax College
Intermediate Financial Management (MindTap Course...
Finance
ISBN:9781337395083
Author:Eugene F. Brigham, Phillip R. Daves
Publisher:Cengage Learning
The management of receivables Introduction - ACCA Financial Management (FM); Author: OpenTuition;https://www.youtube.com/watch?v=tLmePnbC3ZQ;License: Standard YouTube License, CC-BY