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.28AE
Cash collections budget (Learning Objective 3)
Holiday Corporation has found that 60% of its sales in any given month are credit sales, while the remainder are cash sales. Of the credit sales, Holiday Corporation has experienced the following collection pattern:
25% received in the month of the sale |
50% received in the month after the sale |
16% received two months after the sale |
9% of the credit sales are never received |
November sales for last year were $90,000, while December sales were $115,000. Projected sales for the next three months are as follows:
January sales | $145,000 |
February sales | $125,000 |
March sales | $180,000 |
Requirement
Prepare a cash collections budget for the first quarter, with a column for each month and for the quarter.
Expert Solution & Answer
Want to see the full answer?
Check out a sample textbook solutionStudents have asked these similar questions
Prepare Hilton
goods sold computations.
2. Prepare a combined cash budget similar to exhibits in the chapter. If no financing ac-
P9-61A Cash budgets (Learning Objective 3)
and cash disbursements:
are
as follows:
Budgeted Sales Revenue
$62,000
January
$70,000
February.
b. Actual purchases of direct materials in December were $24,500. The companye
purchases of direct materials in January are budgeted to be $24,000 and $26.000 i
February. All purchases are paid 40% in the month of purchase and 60% the follow
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 Janu-
ary 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.…
ing price of $26 per case. The following information relates to the budget for Main Street
a flexible budget performance report (Learning Objective 5)
Main Street Muffins sells its muffins to restaurants and coffee houses for an average sell-
Muffins for this year (all figures are annual totals unless otherwise noted):
Performance Evaluation
629
E10-26A Prepare
Budgeted sales in cases
9,100 cases
Packaging cost per case.
%24
Shipping expense per case
Sales commission expense.
2
5% of sales price
Salaries expense..
$6,500
Office rent
$3,900
Depreciation.
$2,500
Insurance expense...
$1,800
$ 900
Office supplies expense.
During the year, Main Street Muffins actually sold 9,500 cases, resulting in total sales rev-
enue of $255,200. Actual expenses (in total) from this year are as follows:
Packaging cost.
$ 10,600
$ 19,500
$ 12,760
$ 7,300
Shipping expense..
Sales commission expense.
Salaries expense...
$ 3,900
$ 2,500
$ 1,600
Office rent
Depreciation.
Insurance expense..
$ 1,600
Office…
Given the following information, prepare an annual income statement budget for the Great Student Corporation as of 12/31/2018.
1. Sales: 1000 Units; Price $1,000 per Unit
2. Cost of Goods Sold (COGS): 60% of Sales
3. Wages: 15 Employees; Average Cost per Employee $15000
4. SGA Expenses: 12% of Sales
5. Depreciation: Straight Line $4000 per year
6. Interest Expense: 1% of Sales
What was the company's budgeted gross profit?
O A. $403,000
O B. $400,000
O C. $41,000
O D. $359,000
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
- Treasure 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.) A (Click the icon to view the collections data.) The company's sales are 20% cash and 80% credit. How much cash will be collected in Janua More Info 25% in the month of the sale 50% in the month after the sale 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 do 20% two months after the sale Treasure Service 5% are never collected Cash Collections Budget For the Months of January through March January Data Table Print Done Cash sales Collection of credit sales: 25% Month of sale November December January February March 50% Month after Sales revenue....... 16,100 $ 10,000 $ 15,200 $ 12,000 $ 14,200 20% Two months after Total cash collections Print Donearrow_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_forwardA cash budget is prepared for a retail company. The company requires a minimum cash balance of at least $5,000 to start each quarter. Fill in the missing amounts (Note: Omit 000's in your answers). Quarter 1 3 3 4 Year Cash Balance, Beginning $ 6 Add: Collections from Customers 93 322 Total Cash Available before current financing 66 Deduct Disbursements: Purchase of Inventory 36 46 35 Operating Expenses 33 31 114 Equipment Purchases 10 10 11 35 Dividends 2 2 2 2 Total Disbursements 91…arrow_forward
- Garden Depot Is a retailer that provided the following budgeted cash flows for next year. 1st Quarter 2nd Quarter $410,000 $ 260,000 $ 316,000 $ 286,000 3rd Quarter $ 290,000 $ 276,000 Total cash receipts Total cash disbursements The company's beginning cash balance for next year will be $36,000. The company requires a minimum cash balance of $10,000 and may borrow money at the beginning of any quarter and may repay any part of its loans at the end of any quarter. Interest payments, based on a quarterly Interest rate of 3%, are due on any principal at the time it is repaid. For simplicity, assume Interest is not compounded. Required: Prepare the company's cash budget for next year. Note: Repayments, Interest, and cash deficiencies should be indicated by a minus sign. Beginning cash balance Total cash receipts Total cash available Total cash disbursements Excess (deficiency) of cash available over disbursements Financing Borrowings Repayments Interest Total financing Ending cash balance…arrow_forwardWeek 6 South Hampton University is preparing its budget for the upcoming academic year. This is a specialised private university that charges fees for all degree courses. Currently, 30,000 students are enrolled on campus. However, the university is forecasting a 5 per cent growth in student numbers in the coming year, despite an increase in fees to $3,000 per subject. The following additional information has been gathered from an examination of university records and conversations with university managers: South Hampton is planning to award scholarships to 200 students, which will cover their fees. The average class has 80 students, and the typical student takes 4 subjects per semester. South Hampton operates 2 semesters per year. The average academic staff salary is $120,000 per annum including on-costs. South Hampton’s academic staff are evaluated on the basis of teaching, research, administration and professional/community service. Each of the academic staff…arrow_forwardJohnston Bookstore is the bookstore on campus for students and faculty. The bookstore E9-18A Sales budget for a retail organization (Learning Objective 2) shows the following sales projections in units by quarter for the upcoming year School Supplies Apparel Miscellaneous Quarter Books 1,570 200 580 690 1st. ..... 2nd 800 190 330 540 3rd 1,790 240 880 890 4th 670 180 540 440 The average price of an item in each of the departments is as follows: Average sales price per unit Books.. $85 School supplies Apparel.. Miscellaneous. $18 $29 $ 6 Requirement Prepare a sales budget for the upcoming year by quarter for the Johnston Bookstore, with sales categorized by the four product groupings (books, school supplies, apparel, and miscellaneous).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_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_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_forward
- Example 2: Cash Budget: Assuming the same details as in the purchases budget problem above, prepare a cash budget for the month of February given the following information: The company pays for 50% of all purchases in the month of purchase and 50% in the following month. Purchases for the month of January were $208,000. All sales are on account. The Company has historically collected 40% in the month of sale and 55% in the following month. Five percent of all credit sales are normally uncollectible. The cash balance on February 1 was $20,000. The Company borrowed $50,000 on February 2 from the bank and paid interest of $500 to the bank in February. Out-of-pocket selling and administrative costs of $15,000 were paid in February. Also, furniture costing $5,000 was purchased with cash. No other transactions affecting cash occurred in February.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_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
- 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