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.51BE
Sales and cash collections budgets (Learning Objectives 2 & 3)
Alexander Reeds, a manufacturer of saxophone, oboe, and clarinet reeds, has projected sales to be $904,000 in October, $960,000 in November, $1,060,000 in December, and $930,000 in January. Alexander’s sales are 30% cash and 70% on credit. The company’s collection history indicates that credit sales are collected as follows:
20% in the month of the sale |
65% in the month after the sale |
10% two months after the sale |
5% are never collected |
Requirements
- 1. Prepare a sales budget for all four months, showing the breakdown between cash and credit sales.
- 2. Prepare a
cash collection budget for December and January. Round all answers up to the nearest dollar.
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.…
E9-26A Budgeted income statement (Learning Objective 2)
Delta Labs performs a specialty lab test for local companies for $45 per test. For the
upcoming quarter, Delta Labs is projecting the following sales:
January
February
March
Number of lab tests
5,600
4,900
5,700
The budgeted cost of performing each test is $21. Operating expenses are projected to
be $59,000 in January, $57,000 in February, and $58,000 in March. Delta Labs is subject
to a corporate tax rate of 30%.
Requirement
Prepare a budgeted income statement for the first quarter, with a column for each month
and for the quarter.
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…
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
- (Learning Objective 5: Use the COGS model to make management decisions)Spicer Industries prepares budgets to help manage the company. Spicer is budgeting forthe fiscal year ended January 31, 2018. During the preceding year ended January 31, 2017,sales totaled $9,700 million and cost of goods sold was $6,400 million. At January 31, 2017,inventory was $1,500 million. During the upcoming 2018 year, suppose Spicer expects costof goods sold to increase by 12%. The company budgets next year’s ending inventory at$1,800 million.Requirement1. One of the most important decisions a manager makes is how much inventory to buy. Howmuch inventory should Spicer purchase during the upcoming year to reach its budget?arrow_forwardGiven 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,000arrow_forwardIn Organizational Development (OD), each area of OD has its own budget to maintain. Please create a spreadsheet indicating the following purchases for the different OD areas and the remaining balance for each department based on the beginning budget and purchases as indicated. The Center for the Advancement of Teaching and Learning Beginning Budget $60,000 Speaker Books Speaker Gifts $2,000 100 @ $22.50 each $200.00 Leadership Development Beginning Budget $40,000 Retreat Location Rental Retreat Lunch Conference Awards $8,000 $11.00 each for 72 attendees $9,000 $8,800 Creative and Strategic Initiatives Beginning Budget $25,000 Camera Software Digital subscriptions $7,000 $2,000 $550.00arrow_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) $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_forwardPelican Merchandising & More is a family-owned store. The business is now approaching the end of the year and is in the process of identifying its cash needs for the first quarter of the new year. You are the management accountant of the entity and have been tasked to prepare the cash budget for the business for the quarter ending Mar 31, 2022 1 Extracts from the sales and purchases budgets are as follows Month 2021 - 2022 Cash Sales $ Sales on A/C $ Cash Purchases $ Purchases on A/C $ Nov 2021 138,100 480,000 345,000 Dec 2021 156,500 600,000 25,800 380,000 Jan 2022 170,975 650,000 44,625 400,000 Feb 2022 135,740 700,000 30,400 480,000 Mar 2022 226,420 800,000 55,100 540,000 2 An analysis of the records shows that trade receivables (accounts receivable) are settled according to the following credit pattern in accordance with the credit terms 4/30, n90 55% in the month of sale 35% in the first month…arrow_forwardPelican Merchandising & More is a family-owned store. The business is now approaching the end of the year and is in the process of identifying its cash needs for the first quarter of the new year. You are the management accountant of the entity and have been tasked to prepare the cash budget for the business for the quarter ending Mar 31, 2022 1 Extracts from the sales and purchases budgets are as follows Month 2021 - 2022 Cash Sales $ Sales on A/C $ Cash Purchases $ Purchases on A/C $ Nov 2021 138,100 480,000 345,000 Dec 2021 156,500 600,000 25,800 380,000 Jan 2022 170,975 650,000 44,625 400,000 Feb 2022 135,740 700,000 30,400 480,000 Mar 2022 226,420 800,000 55,100 540,000 2 An analysis of the records shows that trade receivables (accounts receivable) are settled according to the following credit pattern in accordance with the credit terms 4/30, n90 55% in the month of sale 35% in the first month following the sale 8% in the second month following the sale The…arrow_forward
- Week 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_forwardTreasure 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_forwardBUS 203: INTRODUCTION TO COST AND MANAGEMENT ACCOUNTING PROJECT: CASH BUDGETING ASSOCIATE DEGREE YEAR 2: SEMESTER 1 (2020/21)Ronstadt Limited’s budget for the four months from January to April includes the following data:1. MonthSalesMaterialsWagesOverheads $000$000$000$000January615115.030360February636120.033390March690135.036420April684130.040425 2. One-third of sales revenue is received one month after sale and the remainder is received two months after sale. The sales in the previous two months were: November $600 000; December $540 000.3. One-quarter of purchases of materials are paid for in the month of purchase. The remainder are paid for two months later. Purchases in the previous two months were: November $108 000; December $106 000.4. Two-thirds of the wages are paid in the month in which they are earned, and the balance is paid in the following month. The wages for the previous December amounted to $30 000.5. One-half of the overhead expenditure is paid in the month in…arrow_forward
- Suppose you are the controller of a University. The university president is preparing for her annual fund-raising campaign for 2021-2022. To set an appropriate target, she has asked you to prepare a budget for the academic year 2021-2022. You have collected the following data for the current year 2020-2021: Undergraduate Division Graduate Division Average annual salary of a faculty member $ 58,000 $ 58,000 Average faculty teaching load in semester credit-hours per year (eight undergraduate courses or six graduate courses) 24 18 Average number of students per class 30 20 Total enrolment (full-time and part-time students) 3,600 1,800 Average number of credit hours registered each year per student 25 20 Full-time load, semester hours per year 30 24 For 2021-2022, all faculty and staff will receive a 6% salary increase. Undergraduate enrolment is expected to decline by 2%, but graduate enrolment is expected to increase by…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_forwardPelican Merchandising & More is a family-owned store. The business is now approaching theend of the year and is in the process of identifying its cash needs for the first quarter of the newyear. You are the management accountant of the entity and have been tasked to prepare the cashbudget for the business for the quarter ending March 31, 2022.(i) Extracts from the sales and purchases budgets are as follows:Month2021 - 2022CashSalesSalesOnAccountCashPurchasesPurchasesOnAccountNovember 2021 $138,100 $480,000 $345,000December 2021 $156,500 $600,000 $25,800 $380,000January 2022 $170,975 $650,000 $44,625 $400,000February 2022 $135,740 $700,000 $30,400 $480,000March 2022 $226,420 $800,000 $55,100 $540,000arrow_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