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
Textbook Question
Chapter 9, Problem 9.61AP
Cash budgets (Learning Objective 3)
Eli’s Restaurant Supply is preparing its cash budgets for the first two months of the upcoming year. Here is the information about the company’s upcoming cash receipts and cash disbursements:
- a. Sales are 65% cash and 35% credit. Credit sales are collected 20% in the month of sale and the remainder in the month after sale. Actual sales in December were $54,000. Schedules of budgeted sales for the two months of the upcoming year are as follows:
Budgeted Sales Revenue | |
January | $62,000 |
February | $70,000 |
- b. Actual purchases of direct materials in December were $24,500. The company’s purchases of direct materials in January are budgeted to be $24,000 and $26,000 in February. All purchases are paid 40% in the month of purchase and 60% the following month.
- c. Salaries and sales commissions are also paid half in the month earned and half the next month. Actual salaries were $8,000 in December. Budgeted salaries in January are $9,000 and February budgeted salaries are $10,500. Sales commissions each month are 8% of that month’s sales.
- d. Rent expense is $3,500 per month.
- e. Depreciation is $2,100 per month.
- f. Estimated income tax payments are made at the end of January. The estimated tax payment is projected to be $12,500.
- g. The cash balance at the end of the prior year was $22,000.
Requirements
- 1. Prepare schedules of (a) budgeted cash collections, (b) budgeted cash payments for purchases, and (c) budgeted cash payments for operating expenses. Show totals for each month and totals for January and February combined.
- 2. Prepare a combined
cash budget similar to exhibits in the chapter. If no financing activity takes place, what is the budgeted cash balance on February 28?
Expert Solution & Answer
Want to see the full answer?
Check out a sample textbook solutionStudents have asked these 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)
$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…
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…
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,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…
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,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, 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_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 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_forward
- At 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_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_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)..... $9,250 Purchase season football tickets in September.....160 Additional entertainment for each month.....250 Pay fall semester tuition in September......4,800 Pay rent at the beginning of each month.....600 Pay for food each month....550 Pay apartment deposit on September 2 (to be returned December 15).....600 Part-time job earnings each month (net of taxes)....1,200 a. Prepare a cash budget for September, October, November, and December. Use the minus sign to indicate cash outflows, a decrease in cash or cash payments. b. Are the four monthly budgets that are presented prepared as static budgets or flexible budgets?…arrow_forward
- At 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: Line Item Description Amount Cash balance, September 1 (from a summer job) $7,870 Purchase season football tickets in September 110 Additional entertainment for each month 270 Pay fall semester tuition in September 4,200 Pay rent at the beginning of each month 380 Pay for food each month 220 Pay apartment deposit on September 2 (to be returned December 15) 500 Part-time job earnings each month (net of taxes) 980 Question Content Area a. Prepare a cash budget for September, October, November, and December. Use the minus sign to indicate cash outflows, a decrease in cash or cash payments. Craig KovarCash BudgetFor the Four Months Ending…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) $6,540 Purchase season football tickets in September 90 Additional entertainment for each month 230 Pay fall semester tuition in September 3,500 Pay rent at the beginning of each month 320 Pay for food each month 180 Pay apartment deposit on September 2 (to be returned December 15) 500 Part-time job earnings each month (net of taxes) 810 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, 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) $9,250 Purchase season football tickets in September 160 Additional entertainment for each month 250 Pay fall semester tuition in September 4,800 Pay rent at the beginning of each month 600 Pay for food each month 550 Pay apartment deposit on September 2 (to be returned December 15) Part-time job earnings each month (net of taxes) 600 1,200 a. Prepare a cash budget for September, October, November, and December. Answer + Check Figure: December 31 cash balance, $3,490 b. Are the four monthly budgets that are presented prepared as static budgets or flexible budgets? What are the budget implications for Craig Kovar? C.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: \table[[Cash balance, September 1 (from a summer job), $8, 430 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: \table[[Cash balance, September 1 (from a summer job), $8,430arrow_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) $9,250 Purchase season football tickets in September 160 Additional entertainment for each month 250 Pay fall semester tuition in September 4,800 Pay rent at the beginning of each month 600 Pay for food each month 550 Pay apartment deposit on September 2 (to be returned December 15) 600 Part-time job earnings each month (net of taxes) 1,200 Prepare a cash budget for September, October, November, and December. Answer Check Figure: December 31 cash balance, $3,490 Are the four monthly budgets that are presented prepared as static budgets or flexible budgets? What are the budget implications 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,900 Purchase season football tickets in September 190 Additional entertainment for each month 290 Pay fall semester tuition in September 4,600 Pay rent at the beginning of each month 700 Pay for food each month 640 Pay apartment deposit on September 2 (to be returned December 15) 700 Part-time job earnings each month (net of taxes) 1,400 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. a. Prepare a cash budget for September, October, November, and December. Enter all amounts as…arrow_forward
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you
- AccountingAccountingISBN:9781337272094Author:WARREN, Carl S., Reeve, James M., Duchac, Jonathan E.Publisher:Cengage Learning,Accounting Information SystemsAccountingISBN:9781337619202Author:Hall, James A.Publisher:Cengage Learning,
- Horngren's Cost Accounting: A Managerial Emphasis...AccountingISBN:9780134475585Author:Srikant M. Datar, Madhav V. RajanPublisher:PEARSONIntermediate AccountingAccountingISBN:9781259722660Author:J. David Spiceland, Mark W. Nelson, Wayne M ThomasPublisher:McGraw-Hill EducationFinancial and Managerial AccountingAccountingISBN:9781259726705Author:John J Wild, Ken W. Shaw, Barbara Chiappetta Fundamental Accounting PrinciplesPublisher:McGraw-Hill Education
Accounting
Accounting
ISBN:9781337272094
Author:WARREN, Carl S., Reeve, James M., Duchac, Jonathan E.
Publisher:Cengage Learning,
Accounting Information Systems
Accounting
ISBN:9781337619202
Author:Hall, James A.
Publisher:Cengage Learning,
Horngren's Cost Accounting: A Managerial Emphasis...
Accounting
ISBN:9780134475585
Author:Srikant M. Datar, Madhav V. Rajan
Publisher:PEARSON
Intermediate Accounting
Accounting
ISBN:9781259722660
Author:J. David Spiceland, Mark W. Nelson, Wayne M Thomas
Publisher:McGraw-Hill Education
Financial and Managerial Accounting
Accounting
ISBN:9781259726705
Author:John J Wild, Ken W. Shaw, Barbara Chiappetta Fundamental Accounting Principles
Publisher:McGraw-Hill Education
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