Horngren's Accounting: The Managerial Chapters, Student Value Edition (12th Edition)
12th Edition
ISBN: 9780134491509
Author: MILLER-NOBLES, Tracie L., Mattison, Brenda L., Matsumura, Ella Mae
Publisher: PEARSON
expand_more
expand_more
format_list_bulleted
Concept explainers
Videos
Textbook Question
Chapter 22, Problem E22.27E
Preparing a financial budget—schedule of cash payments Learning Objective 4 Mar. total cash pmts. $11,500
Marcel Company has the following projected costs for manufacturing and selling and administrative expenses:
| January | February | March | |
| Direct materials purchases | $3,100 | $ 3,500 | $ 4,800 |
| Direct labor costs | 3,300 | 3,500 | 3,600 |
| 550 | 550 | 550 | |
| Utilities for plant | 550 | 650 | 650 |
| Property taxes on plant | 200 | 200 | 200 |
| Depreciation on office | 550 | 550 | 550 |
| Utilities for office | 250 | 250 | 250 |
| Property taxes on office | 170 | 170 | 170 |
| Office salaries | 3,500 | 3,500 | 3,500 |
All costs are paid in month incurred except: direct materials, which are paid in the month following the purchase; utilities, which are paid in the month after incurred, and property taxes, which are prepaid for the year on January 2. The Accounts Payable and Utilities Payable accounts have a zero balance on January 1. Prepare a schedule of cash payments for Marcel for January. February and March. Determine the balances in Prepaid Property Taxes, Accounts Payable, and Utilities Payable as of March 31.
Note: Exercises E22-26 and E22-27must be completed before attempting Exercise E22-28.
Expert Solution & Answer
Want to see the full answer?
Check out a sample textbook solution
Students have asked these similar questions
Management Accounting
Course Project – Part 1, B Group
The Terranova Company is preparing information to complete its master budget for the quarter ending December 31, 2020. The company intends to make unit sales in the related months as follows:
September 5,000
October 9,750
November 11,700
December 14,625
Units are to be sold for $10 each. Sales are 60% for cash and 40% on credit. Credit sales are collected in the month following the sale.
*Required:
1) Prepare a sales budget for Terranova for the quarter ending December 31, 2020. Show activity by month and in total. (Hint: a quarter = 3 months.)
2) Complete a schedule of expected cash collections for the quarter ending December 31, 2020. Show activity by month and in total.
Student question
Garden Sales, Incorporated, sells garden supplies. Management is planning its cash needs for the second quarter. The company usually has to borrow money during this quarter to support peak sales of lawn care equipment, which occur during May. The following information has been assembled to assist in preparing a cash budget for the quarter:
Budgeted monthly absorption costing income statements for April–July are:
April
May
June
July
Sales
$ 730,000
$ 910,000
$ 610,000
$ 520,000
Cost of goods sold
511,000
637,000
427,000
364,000
Gross margin
219,000
273,000
183,000
156,000
Selling and administrative expenses:
Selling expense
91,000
110,000
72,000
52,000
Administrative expense*
50,500
68,800
44,600
49,000
Total selling and administrative expenses
141,500
178,800
116,600
101,000
Net operating income
$ 77,500
$ 94,200
$ 66,400
$ 55,000
*Includes $33,000 of depreciation each month.
Sales are 20% for cash and 80% on account.
Sales…
Please prepare a consolidated budget pivot table in Excel by budget class and year. Please upload your excel document.
Budget Class – Staff Costs
• Salary of the Project Manager @ USD 5,000 per month.
• Salary of the Admin Finance Officer @ USD 3,500 per month.
• Salary of Admin. & Finance Assistant @USD 1,000 per month
• Salary of Driver @USD 500 per month
Budget Class – Equipment & Furniture
Cost of the office equipment and furniture required for the project is USD 30,000 for three years to be procured during the 1st year of the project.
Budget Class – Operating Costs (training)
Two trainers are required for each training. Each training lasts for 5 days. The total number of participants for each training is 30.
• DSA/ ticket cost of each participant @ USD1, 000 per training.
• Total number of 5-day trainings planned for each year is 4.
• Fee for Trainer @ USD 2,000 per training.
• Cost of logistic arrangements for each training @ USD 10,000.
In addition to the main direct…
Chapter 22 Solutions
Horngren's Accounting: The Managerial Chapters, Student Value Edition (12th Edition)
Ch. 22 - Prob. 1QCCh. 22 - A company prepares a five-year budget. This budget...Ch. 22 - Which of the following is the cornerstone of the...Ch. 22 - Suppose Iron City manufactures cast iron skillets....Ch. 22 - Suppose Iron City manufactures cast iron skillets....Ch. 22 - Suppose Iron City manufactures cast iron skillets....Ch. 22 - Suppose Iron City manufactures cast iron skillets....Ch. 22 - The budgeted income statement is part of which...Ch. 22 - Prob. 9QCCh. 22 - Suppose Mallcentral sells 1,000 hardcover books...
Ch. 22 - Suppose Mallcentral sells 1,000 hardcover books...Ch. 22 - The budgeted balance sheet is part of which...Ch. 22 - Information technology has made it easier for...Ch. 22 - Prob. 1RQCh. 22 - Prob. 2RQCh. 22 - How is benchmarking beneficial?Ch. 22 - What is budgetary slack? Why might managers try to...Ch. 22 - Explain the difference between strategic and...Ch. 22 - Explain the difference between static and flexible...Ch. 22 - What is a master budget?Ch. 22 - In a manufacturing company, what are the three...Ch. 22 - Why is the sales budget considered the cornerstone...Ch. 22 - Prob. 10RQCh. 22 - What is the formula used to determine the amount...Ch. 22 - What are the two types of manufacturing overhead?...Ch. 22 - How is the predetermined overhead allocation rate...Ch. 22 - What is the capital expenditures budget?Ch. 22 - What are the three sections of the cash budget?Ch. 22 - Prob. 16RQCh. 22 - How does the master budget for a merchandising...Ch. 22 - Prob. 18RQCh. 22 - Prob. 19RQCh. 22 - Prob. 20RQCh. 22 - Budgeting benefits Learning Objective 1 List the...Ch. 22 - S22-2 Budgeting types
Learning Objective...Ch. 22 - Prob. S22.3SECh. 22 - S22-4 Preparing an operating budget—production...Ch. 22 - Prob. S22.5SECh. 22 - Prob. S22.6SECh. 22 - Prob. S22.7SECh. 22 - Prob. S22.8SECh. 22 - Prob. S22.9SECh. 22 - Prob. S22.10SECh. 22 - Prob. S22.11SECh. 22 - S22-12 Understanding the components of the master...Ch. 22 - S22-13 Preparing an operating budget—sales...Ch. 22 - Prob. S22.14SECh. 22 - Prob. S22.15SECh. 22 - Prob. S22.16SECh. 22 - Prob. S22.17SECh. 22 - Prob. S22.18SECh. 22 - Prob. S22.19SECh. 22 - Prob. S22.20SECh. 22 - Prob. E22.21ECh. 22 - Prob. E22.22ECh. 22 - Prob. E22.23ECh. 22 - Preparing an operating budget—direct materials,...Ch. 22 - E22-25 Preparing an operating budget—cost of goods...Ch. 22 - Prob. E22.26ECh. 22 - Preparing a financial budget—schedule of cash...Ch. 22 - Prob. E22.28ECh. 22 - E22-29 Preparing the financial budget-cash...Ch. 22 - Preparing the financial budget—budgeted balance...Ch. 22 - Prob. E22.31ECh. 22 - Prob. E22.32ECh. 22 - Prob. E22.33ECh. 22 - Prob. E22.34ECh. 22 - E22-35 Preparing a financial budget—cash...Ch. 22 - Prob. E22.36ECh. 22 - Using sensitivity analysis Learning Objective 7 1....Ch. 22 - Preparing an operating budget—sales, production,...Ch. 22 - Prob. P22.39APGACh. 22 - Preparing a financial budgetbudgeted income...Ch. 22 - Completing a comprehensive budgeting...Ch. 22 - Prob. P22.42APGACh. 22 - Prob. P22.43APGACh. 22 - P22-44A Preparing a financial budget—budgeted...Ch. 22 - Prob. P22.45APGACh. 22 - Prob. P22.46APGACh. 22 - Prob. P22.47BPGBCh. 22 - Prob. P22.48BPGBCh. 22 - Prob. P22.49BPGBCh. 22 - Prob. P22.50BPGBCh. 22 - Prob. P22.51BPGBCh. 22 - Prob. P22.52BPGBCh. 22 - Prob. P22.53BPGBCh. 22 - Preparing a comprehensive budgeting...Ch. 22 - Prob. P22.55BPGBCh. 22 - Using Excel for to prepare an operating budget...Ch. 22 - Prob. P22.57CPCh. 22 - Prob. 22.1TIATCCh. 22 - Prob. 22.1DCCh. 22 - Prob. 22.1EICh. 22 - Prob. 22.1FC
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_forward1. Question Content Area Direct Materials Purchases Budget FlashKick Company manufactures and sells soccer balls for teams of children in elementary and high school. FlashKick’s best-selling lines are the practice ball line (durable soccer balls for training and practice) and the match ball line (high-performance soccer balls used in games). In the first four months of next year, FlashKick expects to sell the following: Practice Balls Match Balls Units Selling Price Units Selling Price January 49,000 $8.50 6,900 $17.30 February 60,000 $8.50 7,500 $17.30 March 88,000 $8.50 12,000 $17.30 April 115,000 $8.50 17,000 $17.30 FlashKick requires ending inventory of product to equal 20 percent of the next month’s unit sales. Beginning inventory in January was 9,800 practice soccer balls and 1,380 match soccer balls. Every practice ball requires 0.7 square yard of polyvinyl chloride panels, one bladder with valve (to fill with air), and 2…arrow_forwardPreparing a financial budget—schedule of cash receipts and schedule of cash payments</b></p><p>Agua Cool is a distributor of bottled water. For each of the items, compute the number of cash receipts or payments Agua Cool will budget for September. The solution to one item may depend on the answer to an earlier item. Management expects to sell equipment that cost $14,000 at a gain of $7,000. Accumulated depreciation on this equipment is $55,000. Management expects to sell 7,100 cases of water in August and 9,000 cases in September. Each case sells for $14. Cash sales average 20% of total sales, and credit sales make up the rest. Three-fourths of credit sales are collected in the month of the sale, with the balance collected the following month. The company pays rent and property taxes of $4,500 each month. Commissions and other selling expenses average 30% of sales. Agua Cool pays one—half of the commissions and other selling expenses in the month incurred, with the…arrow_forward
- Relevant data from the Poster Company’s operating budgets are: Quarter 1 Quarter 2 Sales $208,470 $211,539 Direct material purchases 115,290 120,832 Direct labor 75,205 73,299 Manufacturing overhead 25,400 25,400 Selling and administrative expenses 33,400 33,400 Depreciation included in selling and administrative 1,400 1,100 Collections from customers 215,391 240,154 Cash payments for purchases 114,300 119,253 Additional data:Capital assets were sold in January for $9,000 and $4,600 in May.Dividends of $4,400 were paid in February. The beginning cash balance was $60,359 and a required minimum cash balance is $58,000. Use this information to prepare a cash budget for the first two quarters of the year: If an amount box does not require an entry, leave it blank. The Poster Company Cash Budget For the First Two Quarters Quarter 1 Quarter 2 Beginning Cash Balance $fill in the blank 2 $fill in the blank 3 Add: Cash Receipts Collections from…arrow_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_forwardRelevant data from the Poster Company’s operating budgets are: Quarter 1 Quarter 2 Sales $208,480 $211,540 Direct material purchases 115,300 120,832 Direct labor 75,205 73,298 Manufacturing overhead 25,300 25,400 Selling and administrative expenses 33,400 33,500 Depreciation included in selling and administrative 1,500 900 Collections from customers 215,392 240,154 Cash payments for purchases 114,290 119,254 Additional data:Capital assets were sold in January for $10,000 and $4,400 in May.Dividends of $4,600 were paid in February. The beginning cash balance was $60,360 and a required minimum cash balance is $59,000. Use this information to prepare a cash budget for the first two quarters of the year: If an amount box does not require an entry, leave it blank. The Poster CompanyCash BudgetFor the First Two Quarters Quarter 1 Quarter 2 $Beginning Cash Balance $Beginning Cash Balance Add: Cash Receipts Collections from Customers…arrow_forward
- eBook Show Me How Question Content Area Budget Performance Reports for Cost Centers Partially completed budget performance reports for Delmar Company, a manufacturer of light duty motors, follow: Delmar CompanyBudget Performance Report—Vice President, ProductionFor the Month Ended June 30 Plant Actual Budget OverBudget (Under)Budget Eastern Region $561,500 $561,500 $0 Central Region 400,300 404,300 (4,000) Western Region (g) (h) (i) $(j) $(k) $(l) $(4,000) Delmar CompanyBudget Performance Report—Manager, Western Region PlantFor the Month Ended June 30 Department Actual Budget OverBudget (Under)Budget Chip Fabrication $(a) $(b) $(c) Electronic Assembly 72,400 71,470 930 Final Assembly 114,150 115,070 $(920) $(d) $(e) $(f) $(920) Delmar CompanyBudget Performance Report—Supervisor, Chip FabricationFor the Month Ended June 30 Cost Actual…arrow_forwardRelevant data from the Poster Company’s operating budgets are: Quarter 1 Quarter 2 Sales $208,480 $211,540 Direct material purchases 115,295 120,832 Direct labor 75,210 73,298 Manufacturing overhead 25,400 25,400 Selling and administrative expenses 33,600 33,400 Depreciation included in selling and administrative 1,600 900 Collections from customers 215,393 240,156 Cash payments for purchases 114,295 119,254 Additional data:Capital assets were sold in January for $9,000 and $4,500 in May.Dividends of $4,600 were paid in February. The beginning cash balance was $60,359 and a required minimum cash balance is $59,000. Use this information to prepare a cash budget for the first two quarters of the year: If an amount box does not require an entry, leave it blank. The Poster CompanyCash BudgetFor the First Two Quartersarrow_forwardHugo Medical Supply has applied for a loan. Pacific Commerce Bank has requested a budgeted balance sheet as of April 30, and a combined cash budget for April. As Hugo Medical Supply's controller, you have assembled the following information: a. March 31 equipment balance, $52,600; accumulated depreciation, $41,300. b. April capital expenditures of $ 42,400 budgeted for cash purchase of equipment. c. April depreciation expense, $700. d. Cost of goods sold, 60%of sales. e. Other April operating expenses, including income tax, total $14,200, 35% of which will be paid in cash and the remainder accrued at April 30. f. March 31 owners' equity, $92,600. g. March 31 cash balance, $40,300. h. April budgeted sales, $90,000, 70% of which is for cash. Of the remaining 30%, half will be collected in April and half in May. i. April cash collections on March sales, $29,100. j. April cash payments of March 31 liabilities incurred for March…arrow_forward
- eBook Show Me How Print Item Question Content Area Budget Performance Reports for Cost Centers Partially completed budget performance reports for Garland Company, a manufacturer of light duty motors, follow: Garland CompanyBudget Performance Report—Vice President, ProductionFor the Month Ended November 30 Plant Budget Actual Over Budget Under Budget Eastern Region $2,300,000 $2,287,900 $(12,100) Central Region 3,000,000 2,988,400 (11,600) Western Region (g) (h) (i) $(j) $(k) $(l) $(23,700) Garland CompanyBudget Performance Report—Manager, Western Region PlantFor the Month Ended November 30 Department Budget Actual Over Budget Under Budget Chip Fabrication $(a) $(b) $(c) Electronic Assembly 700,000 703,200 3,200 Final Assembly 525,000 516,600 $(8,400) $(d) $(e) $(f) $(8,400) Garland CompanyBudget Performance Report—Supervisor, Chip FabricationFor the Month Ended…arrow_forwardMaterial purchases budgetHard Core had budgeted sales of 152,000 feet of its concrete culvert products for June. Each foot of product requires 4 pounds of concrete ($0.10 per pound) and 7.5 pounds of gravel ($0.04 per pound). Actual beginning inventories and projected ending inventories follow. June 1 June 30 Finished Goods Inventory (in feet) 9,800 8,000 Concrete (in pounds) 32,800 27,440 Gravel (in pounds) 26,120 37,000 Note: When answering the following questions, round your answers to the nearest whole dollar or pound.a. How many pounds of concrete did Hard Core plan to purchase in June? Answer poundsWhat was the cost of those purchases? $Answerb. How many pounds of gravel did Hard Core plan to purchase in June? Answer poundsWhat was the cost of those purchases? $Answerarrow_forwardSchedule of Cash Payments Organic Physical Therapy Inc. is planning its cash payments for operations for the three months ending March 31. The Accrued Expenses Payable balance on January 1 is $25,900. The budgeted expenses for the next three months are as follows: January February March Salaries $59,600 $72,500 $80,300 Utilities 4,900 5,400 6,500 Other operating expenses 45,300 49,400 54,400 Total $109,800 $127,300 $141,200 Other operating expenses include $3,200 of monthly depreciation expense and $700 of monthly insurance expense that was prepaid in the prior year. Of the remaining expenses, 75% are paid in the month in which they are incurred, with the remainder paid in the following month. The Accrued Expenses Payable balance on January 1 relates to the expenses incurred in December. Prepare a schedule of cash payments for operations for January, February, and March. 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:PEARSON
Intermediate AccountingAccountingISBN:9781259722660Author:J. David Spiceland, Mark W. Nelson, Wayne M ThomasPublisher:McGraw-Hill Education
Financial 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