Managerial Accounting (5th Edition)
5th Edition
ISBN: 9780134128528
Author: Karen W. Braun, Wendy M. Tietz
Publisher: PEARSON
expand_more
expand_more
format_list_bulleted
Concept explainers
Question
Chapter 9, Problem 9.11SE
To determine
The cash collections budget for the month of January, February, and March and total cash collection for the quarter ended on March 31.
Expert Solution & Answer
Want to see the full answer?
Check out a sample textbook solutionStudents have asked these similar questions
Emerald Service anticipates the following sales revenue over
a five-month period
Its collection history indicates that credit sales are
collected as follows
E (Click the icon to view the sales data )
The company's sales are 40% cash and 60% credit
O (Click the icon to view the collections data)
How much cash will be collected in January? In
February? In March? For the quarter in total?
Complete the cash budget to determine how much cash will be collected in January, February, March and for the quarter in
total. (Round your answers to the nearest whole dollar)
Emerald Service
Cash Collections Budget
For the Months of January through March
January
Cash sales
6,080
Collection of credit sales
25% Month of sale
2,280
50% Month after
15% Two months after
Total cash collections
At the beginning of the school year, Katherine Malloy decided to prepare a cash budget for the months of September, October, November, and December. The budget must plan for enough cash on December 31 to pay the spring semester tuition, which is the same as the fall tuition. The following information relates to the budget:
Cash balance, September 1 (from a summer job)
$9,060
Purchase season football tickets in September
120
Additional entertainment for each month
310
Pay fall semester tuition in September
4,900
Pay rent at the beginning of each month
440
Pay for food each month
250
Pay apartment deposit on September 2 (to be returned December 15)
600
Part-time job earnings each month (net of taxes)
1,120
a. Prepare a cash budget for September, October, November, and December. Enter all amounts as positive values except an overall cash decrease which should be indicated with a minus sign.
KATHERINE MALLOYCash BudgetFor the Four Months Ending December 31…
Markham Company has completed Its sales budget for the first quarter of Year 2. Projected credit sales for the first four months of the year are shown below:
January
February
March
April
The company's past records show collection of credit sales as follows: 40% In the month of sale and the balance in the following month. The total cash collection from receivables in
March is expected to be:
Multiple Choice
O
O
$ 40,000
$ 46,000
$ 55,000
$ 58,000
O
$51,400.
$49,600.
$55,000.
$42,400.
Chapter 9 Solutions
Managerial Accounting (5th Edition)
Ch. 9 - (Learning Objective 1) Which term describes the...Ch. 9 - (Learning Objective 1) Benefits of budgeting...Ch. 9 - Prob. 3QCCh. 9 - Prob. 4QCCh. 9 - Prob. 5QCCh. 9 - Prob. 6QCCh. 9 - Prob. 7QCCh. 9 - Prob. 8QCCh. 9 - Prob. 9QCCh. 9 - Prob. 10QC
Ch. 9 - Short Exercises S9-1 Order of preparation and...Ch. 9 - Explain why companies use zero-based budgeting...Ch. 9 - Understanding key terms and definitions (Learning...Ch. 9 - Sales Budget (Learning Objective 2) Jefferson...Ch. 9 - Production budget (Learning Objective 2) Nichols...Ch. 9 - Direct materials budget (Learning Objective 2)...Ch. 9 - Prob. 9.7SECh. 9 - Prob. 9.8SECh. 9 - Prob. 9.9SECh. 9 - Prob. 9.10SECh. 9 - Prob. 9.11SECh. 9 - Cash payments budget (Learning Objective 3) Finley...Ch. 9 - Cash budget (Learning Objective 3) SaveCo...Ch. 9 - Prob. 9.14SECh. 9 - Prob. 9.15SECh. 9 - Identify ethical standards violated (Learning...Ch. 9 - Prob. 9.17AECh. 9 - Sales budget for a retail organization (Learning...Ch. 9 - Prob. 9.19AECh. 9 - Production budget (Learning Objective 2) Hoffman...Ch. 9 - Direct materials budget (Learning Objective 2)...Ch. 9 - Production and direct materials budgets (Learning...Ch. 9 - Direct labor budget (Learning Objective 2)...Ch. 9 - Manufacturing overhead budget (Learning Objective...Ch. 9 - Operating expenses budget and an income statement...Ch. 9 - Budgeted income statement (Learning Objective 2)...Ch. 9 - Prob. 9.27AECh. 9 - Cash collections budget (Learning Objective 3)...Ch. 9 - Cash payments budget (Learning Objective 3) The...Ch. 9 - Prob. 9.30AECh. 9 - Prob. 9.31AECh. 9 - Budgeted balance sheet (Learning Objective 3) Use...Ch. 9 - Prob. 9.33AECh. 9 - Prob. 9.34AECh. 9 - Cost of goods sold, inventory, and purchases...Ch. 9 - Cost of goods sold, inventory, and purchases...Ch. 9 - Prob. 9.37BECh. 9 - Prob. 9.38BECh. 9 - Prob. 9.39BECh. 9 - Prob. 9.40BECh. 9 - Direct materials budget (Learning Objective 2) Moe...Ch. 9 - Prob. 9.42BECh. 9 - Prob. 9.43BECh. 9 - Manufacturing overhead budget (Learning Objective...Ch. 9 - Prob. 9.45BECh. 9 - Prob. 9.46BECh. 9 - Prob. 9.47BECh. 9 - Prob. 9.48BECh. 9 - Prob. 9.49BECh. 9 - Combined cash budget (Learning Objective 3)...Ch. 9 - Sales and cash collections budgets (Learning...Ch. 9 - Prob. 9.52BECh. 9 - Prob. 9.53BECh. 9 - Prob. 9.54BECh. 9 - Prob. 9.55BECh. 9 - Prob. 9.56BECh. 9 - Comprehensive budgeting problem (Learning...Ch. 9 - Cash budgets under two alternatives (Learning...Ch. 9 - Comprehensive summary problem (Learning Objectives...Ch. 9 - Prob. 9.60APCh. 9 - Cash budgets (Learning Objective 3) Elis...Ch. 9 - Prob. 9.62APCh. 9 - Cost of goods sold, inventory, and purchases...Ch. 9 - Prob. 9.64APCh. 9 - Problems Group B P9-65B Comprehensive budgeting...Ch. 9 - Cash budgets under two alternatives (Learning...Ch. 9 - Comprehensive summary problem (Learning Objectives...Ch. 9 - Prob. 9.68BPCh. 9 - Cash budgets (Learning Objective 3) Ivans...Ch. 9 - Combined cash budget and a budgeted balance sheet...Ch. 9 - Prob. 9.71BPCh. 9 - Prepare comprehensive budgets for a retailer...Ch. 9 - Prob. 9.73SCCh. 9 - Discussion Questions 1. The sales budget is the...Ch. 9 - Budgeting for a Single Product In this activity,...Ch. 9 - Ethics and budgetary slack (Learning Objectives 1,...Ch. 9 - Prob. 9.77ACT
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
- At the beginning of the school year, Katherine Malloy decided to prepare a cash budget for the months of September, October, November, and December. The budget must plan for enough cash on December 31 to pay the spring semester tuition, which is the same as the fall tuition. The following information relates to the budget: Cash balance, September 1 (from a summer job) $7,380 Purchase season football tickets in September 100 Additional entertainment for each month 260 Pay fall semester tuition in September 4,000 Pay rent at the beginning of each month 360 Pay for food each month 200 Pay apartment deposit on September 2 (to be returned December 15) 500 Part-time job earnings each month (net of taxes) 920 a. Prepare a cash budget for September, October, November, and December. Enter all amounts as positive values except an overall cash decrease which should be indicated with a minus sign. KATHERINE MALLOY Cash Budget For the Four Months Ending December…arrow_forwardAt the beginning of the school year, Katherine Malloy decided to prepare a cash budget for the months of September, October, November, and December. The budget must plan for enough cash on December 31 to pay the spring semester tuition, which is the same as the fall tuition. The following information relates to the budget: Cash balance, September 1 (from a summer job) $7,650 Purchase season football tickets in September 100 Additional entertainment for each month 270 Pay fall semester tuition in September 4,100 Pay rent at the beginning of each month 370 Pay for food each month 210 Pay apartment deposit on September 2 (to be returned December 15) 500 Part-time job earnings each month (net of taxes) 950 Question Content Area a. Prepare a cash budget for September, October, November, and December. Enter all amounts as positive values except an overall cash decrease which should be indicated with a minus sign. KATHERINE MALLOYCash BudgetFor the Four Months…arrow_forwardAt the beginning of the school year, Katherine Malloy decided to prepare a cash budget for the months of September, October, November, and December. The budget must plan for enough cash on December 31 to pay the spring semester tuition, which is the same as the fall tuition. The following information relates to the budget: Cash balance, September 1 (from a summer job) $5,750 Purchase season football tickets in September 210 Additional entertainment for each month 275 Pay fall semester tuition in September 3,700 Pay rent at the beginning of each month 600 Pay for food each month 235 Pay apartment deposit on September 2 (to be returned December 15) 500 Part-time job earnings each month (net of taxes) 1,400 Are the four monthly budgets that are presented prepared as static budgets or flexible budgets?Static c. Malloy can see that her present plan will not provide sufficient cash. If Malloy did not budget but went ahead with the original plan, she would be $fill in…arrow_forward
- At the beginning of the school year, Katherine Malloy decided to prepare a cash budget for the months of September, October, November, and December. The budget must plan for enough cash on December 31 to pay the spring semester tuition, which is the same as the fall tuition. The following information relates to the budget: Cash balance, September 1 (from a summer job) $5,750 Purchase season football tickets in September 210 Additional entertainment for each month 275 Pay fall semester tuition in September 3,700 Pay rent at the beginning of each month 600 Pay for food each month 235 Pay apartment deposit on September 2 (to be returned December 15) 500 Part-time job earnings each month (net of taxes) 1,400 a. Prepare a cash budget for September, October, November, and December. Enter all amounts as positive values except an overall cash decrease which should be indicated with a minus sign. Katherine MalloyCash BudgetFor the Four Months Ending December 31…arrow_forwardAt the beginning of the school year, Katherine Malloy decided to prepare a cash budget for the months of September, October, November, and December. The budget must plan for enough cash on December 31 to pay the spring semester tuition, which is the same as the fall tuition. The following information relates to the budget: Cash balance, September 1 (from a summer job) $7,180 Purchase season football tickets in September 100 Additional entertainment for each month 250 Pay fall semester tuition in September 3,900 Pay rent at the beginning of each month 350 Pay for food each month 200 Pay apartment deposit on September 2 (to be returned December 15) 500 Part-time job earnings each month (net of taxes) 890 a. Prepare a cash budget for September, October, November, and December. Enter all amounts as positive values except an overall cash decrease which should be indicated with a minus sign. b. Are the four monthly budgets that are presented prepared as static…arrow_forwardAt the beginning of the school year, Priscilla Wescott decided to prepare a cash budget for the months of September, October, November, and December. The budget must plan for enough cash on December 31 to pay the spring semester tuition, which is the same as the fall tuition. The following information relates to the budget: Cash balance, September 1 (from a summer job) $6,000 Purchase season football tickets in September 150 Additional entertainment for each month 250 Pay fall semester tuition in September 3,500 Pay rent at the beginning of each month 450 Pay for food each month 400 Pay apartment deposit on September 2 (to be returned December 15) 450 Part-time job earnings each month (net of taxes) 1,300 Question Content Area a. Prepare a cash budget for September, October, November, and December. Enter all amounts as positive values except cash decrease which should be indicated with a minus sign. Priscilla WescottCash BudgetFor the Four Months Ending…arrow_forward
- Markham Company has completed its sales budget for the first quarter of Year 2. Projected credit sales for the first four months of the year are shown below: January $ 32,000 February $ 38,000 March $ 47,000 April $ 50,000 The company's past records show collection of credit sales as follows: 32% in the month of sale and the balance in the following month. The total cash collection from receivables in March is expected to be: Multiple Choice $47,000. $33,920. $44,120. $40,880. Huang Company reported the following information for the current year: Sales $ 860,000 Average operating assets $ 560,000 Margin 9 % The company's return on investment was: Multiple Choice 9.00%. 15.36%. 13.82%. Cannot be ascertained from the information provided.arrow_forwardMarkham Company has completed its sales budget for the first quarter of Year 2. Projected credit sales for the first four months of the year are shown below: January February March April $ 20,000 $ 26,000 $ 35,000 $ 38,000 The company's past records show collection of credit sales as follows: 40% in the month of sale and the balance in the following month. The total cash collection from receivables in March is expected to be: Multiple Choice $29,600. $22,100. $31,850. $35,000.arrow_forwardMarkham Company has completed its sales budget for the first quarter of Year 2. Projected credit sales for the first four months of the year are shown below: January February March April $ 21,000 $ 27,000 $ 36,000 $ 39,000 The company's past records show collection of credit sales as follows: 40% in the month of sale and the balance in the following month. The total cash collection from receivables in March is expected to be: Multiple Choice О $30,600. ○ $22,920. $33,120. $36,000.arrow_forward
- Cash Receipts Budget and Accounts Receivable Aging Schedule Shalimar Company manufactures and sells industrial products. For next year, Shalimar has budgeted the following sales: Quarter 1 $4,760,000 Quarter 2 5,620,000 Quarter 3 3,060,000 Quarter 4 7,720,000 In Shalimar's experience, 10 percent of sales are paid in cash. Of the sales on account, 65 percent are collected in the quarter of sale, 25 percent are collected in the quarter following the sale, and 7 percent are collected in the second quarter after the sale. The remaining 3 percent are never collected. Total sales for the third quarter of the current year are $5,310,000 and for the fourth quarter of the current year are $7,350,000. Required: 1. Calculate cash sales and credit sales expected in the last two quarters of the current year, and in each quarter of next year. Quarter Cash Sales Credit Sales 3, current year 4, current year 1, next year 2, next year 3. next vear 4, next year 2. Construct a cash receipts budget for…arrow_forwardAt the beginning of the school year, Craig Kovar decided to prepare a cash budget for the months of September, October, November, and December. The budget must plan for enough cash on December 31 to pay the spring semester tuition, which is the same as the fall tuition. The following information relates to the budget: Cash balance, September 1 (from a summer job) $8,050 Purchase season football tickets in September 140 Additional entertainment for each month 220 Pay fall semester tuition in September 4,200 Pay rent at the beginning of each month 530 Pay for food each month 480 Pay apartment deposit on September 2 (to be returned December 15) 530 Part-time job earnings each month (net of taxes) 1,050 This information has been collected in the Microsoft Excel Online file. Open the spreadsheet, perform the required analysis, and input your answers in the questions below.arrow_forwardCash Receipts Budget and Accounts Receivable Aging Schedule Shalimar Company manufactures and sells industrial products. For next year, Shalimar has budgeted the following sales: Quarter 1 $4,750,000 Quarter 2 6,000,000 Quarter 3 2,890,000 Quarter 4 8,530,000 In Shalimar's experience, 10 percent of sales are paid in cash. Of the sales on account, 65 percent are collected in the quarter of sale, 25 percent are collected in the quarter following the sale, and 7 percent are collected in the second quarter after the sale. The remaining 3 percent are never collected. Total sales for the third quarter of the current year are $5,250,000 and for the fourth quarter of the current year are $7,360,000.arrow_forward
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you
- Managerial AccountingAccountingISBN:9781337912020Author:Carl Warren, Ph.d. Cma William B. TaylerPublisher:South-Western College Pub
Managerial Accounting
Accounting
ISBN:9781337912020
Author:Carl Warren, Ph.d. Cma William B. Tayler
Publisher:South-Western College Pub
Responsibility Accounting| Responsibility Centers and Segments| US CMA Part 1| US CMA course; Master Budget and Responsibility Accounting-Intro to Managerial Accounting- Su. 2013-Prof. Gershberg; Author: Mera Skill; Rutgers Accounting Web;https://www.youtube.com/watch?v=SYQ4u1BP24g;License: Standard YouTube License, CC-BY