Managerial Accounting - With Helios Access
5th Edition
ISBN: 9780134493916
Author: Braun
Publisher: PEARSON
expand_more
expand_more
format_list_bulleted
Concept explainers
Textbook Question
Chapter 9, Problem 9.69BP
Cash budgets (Learning Objective 3)
Ivan’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 70% cash and 30% credit. Credit sales are collected 10% 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 | $60,000 |
February | $68,000 |
- b. Actual purchases of materials in December were $23,000. The company’s purchases of direct materials in January are budgeted to be $20,500 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 $7,000 in December. Budgeted salaries in January are $8,000, and February budgeted salaries are $9,500. Sales commissions each month are 15% of that month’s sales.
- d. Rent expense is $2,900 per month.
- e.
Depreciation is $2,200 per month. - f. Estimated income tax payments are made at the end of January. The estimated tax payment is projected to be $13,000.
- g. The cash balance at the end of the prior year was $24,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 . 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
Personal Budget
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)
$8,680
Purchase season football tickets in September
120
Additional entertainment for each month
300
Pay fall semester tuition in September
4,700
Pay rent at the beginning of each month
420
Pay for food each month
240
Pay apartment deposit on September 2 (to be returned December 15)
600
Part-time job earnings each month (net of taxes)
1,080
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…
Personal Budget
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)
$8,860
Purchase season football tickets in September
120
Additional entertainment for each month
310
Pay fall semester tuition in September
4,800
Pay rent at the beginning of each month
430
Pay for food each month
240
Pay apartment deposit on September 2 (to be returned December 15)
600
Part-time job earnings each month (net of taxes)
1,100
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…
Personal Budget
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 Malloy
Cash Budget
For the Four…
Chapter 9 Solutions
Managerial Accounting - With Helios Access
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
- Personal Budget 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: 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. Craig KovarCash BudgetFor the Four Months Ending December 31 September October…arrow_forwardPersonal Budget 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: Cash balance, September 1 (from a summer job) $7,520 Purchase season football tickets in September 100 Additional entertainment for each month 260 Pay fall semester tuition in September 4,100 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) 930arrow_forwardPersonal Budget 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: Cash balance, September 1 (from a summer job) $7,050 Purchase season football tickets in September 100 Additional entertainment for each month 240 Pay fall semester tuition in September 3,800 Pay rent at the beginning of each month 340 Pay for food each month 190 Pay apartment deposit on September 2 (to be returned December 15) 500 Part-time job earnings each month (net of taxes) 870 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 Kovar Cash Budget For the Four Months Ending December 31 September October…arrow_forward
- Personal Budget 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: Cash balance, September 1 (from a summer job) $8,860 Purchase season football tickets in September 120 Additional entertainment for each month 310 Pay fall semester tuition in September 4,800 Pay rent at the beginning of each month 430 Pay for food each month 240 Pay apartment deposit on September 2 (to be returned December 15) 600 Part-time job earnings each month (net of taxes) 1,100 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 Kovar Cash Budget For the Four Months Ending December 31 September…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,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_forwardPersonal Budget 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: Cash balance, September 1 (from a summer job) $7,780 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 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) 960 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 Kovar Cash Budget For the Four Months Ending December 31 September October…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) $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) $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…arrow_forwardAt the beginning of the school year, Craig Kovar decided to prepare a cash budget for the monthsof 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 followinginformation relates to the budget: Cash balance, September 1 (from a summer job) . . . . . . . . . . . . . . . . . $9,250Purchase season football tickets in September . . . . . . . . . . . . . . . . . . . . . . 160Additional entertainment for each month . . . . . . . . . . . . . . . . . .. . . . . . . . . 250Pay fall semester tuition in September . . . . . . . . . . . . . . . . . . . . . . . . . . . . 4,800Pay rent at the beginning of each month . . . . . . . . . . . . . . . . . . . . . . . . . . . 600Pay for food each month . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 550Pay apartment deposit on September 2 (to be returned December 15) . 600Part-time job earnings each…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) $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 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) $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
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 PubPrinciples of Accounting Volume 2AccountingISBN:9781947172609Author:OpenStaxPublisher:OpenStax College
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
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