Horngren's Accounting (12th Edition)
12th Edition
ISBN: 9780134486444
Author: Tracie L. Miller-Nobles, Brenda L. Mattison, Ella Mae Matsumura
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
profile-image Student question Time to preview question: 00 : 08 : 51 The Epsilon Co. have a building, which houses three production department, Alpha, Beta and Gamma, and one service department Delta. The service department, Delta is wholly involved in working for the three production departments and it is estimated that department Alpa uses 50%, department Beta uses 30% and department Gamma uses 20% of the services of department Delta. The budgeted overhead for the four departments for a period were:
REQUIRED: a. Apportion the costs to the departments on the most equitable bases and calculate the overhead absorption rate, based on labour hours, for all the production department.
6. Question Content Area
Administrative Expense Budget
Green Earth Landscaping Company provides monthly and weekly landscaping and maintenance services to residential customers in the tri-city area. Green Earth has no variable administrative expense. Fixed administrative expenses for June, July, and August include:
Salaries
$10,000
Insurance
2,100
Depreciation
3,900
Accounting services
800
Required:
Question Content Area
1. Construct an administrative expense budget for Green Earth Landscaping Company for the three summer months. Show total amounts by month and in total for the three-month period.
Green Earth Landscaping CompanyAdministrative Expense BudgetFor the Summer Months
June
July
August
Total
Salaries
$fill in the blank 532c4bfc1f8bfa8_1
$fill in the blank 532c4bfc1f8bfa8_2
$fill in the blank 532c4bfc1f8bfa8_3
$fill in the blank 532c4bfc1f8bfa8_4
Insurance
fill in the blank 532c4bfc1f8bfa8_5
fill in the blank 532c4bfc1f8bfa8_6
fill in…
Instruction: I want you to prepare a production budget of Learning is Fun Company with the provided
information below.
Learning is Fun Company forecasts sales in units for January to May as follows:
Jan
Feb
Mar
Apr
2,800
May
3,000
Units
2,000
2,200
2,500
Additional Information:
• The Company would like to maintain 100 units in its ending inventory at the end of each month.
• Beginning inventory at the start of January amounts to 50 units.
Chapter 22 Solutions
Horngren's Accounting (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
- 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_forwardLearning Objective 4 Wiki Wiki Company has determined that the variable overhead rate is $4.50 per direct labor hour in the Fabrication Department. The normal production capacity for the Fabrication Department is 10,000 hours for the month. Fixed costs are budgeted at $60,000 for the month. a. Prepare a monthly factory overhead flexible budget for 9,000, 10,000, and 11,000 hours of production. Enter all amounts as positive numbers. Wiki Wiki Company Monthly Factory Overhead Cost Budget-Fabrication Department Direct labor hours Variable factory overhead cost Fixed factory overhead cost Total factory overhead cost 9,000 $ $ 10,000 $ $ 11,000 b. How much overhead would be applied to production if 9,000 hours were used in the department during the month? If required, round your calculations to two decimal places and your final answer to the nearest dollar.arrow_forwardhelp please answer in text form with proper workings and explanation for each and every part and steps with concept and introduction no AI no copy paste remember answer must be in proper format with all workingarrow_forward
- Need 1,2,3 pleasearrow_forwardgive an answer as per introduction i want correct answerarrow_forwardPreparing an Accounts Payable Schedule Wight Inc. purchases raw materials on account for use in production. The direct materials purchases budget shows the following expected purchases on account: April $375,000 May 410,800 June 415,800 Wight typically pays 30% on account in the month of billing and 70% the next month. Required: 1. How much cash is required for payments on account in May?$fill in the blank 1 2. How much cash is expected for payments on account in June?$fill in the blank 2arrow_forward
- Howard Cooper, the president of Campbell Computer Services, needs your help. He wonders about the potential effects on the firm's net income if he changes the service rate that the firm charges its customers. The following basic data pertain to fiscal Year 3. Standard rate and variable costs Service rate per hour $ 85.00 Labor cost 37.00 Overhead cost 7.10 Selling, general, and administrative cost Expected fixed costs Facility maintenance Selling, general, and administrative 3.80 $522,000 142,000 Required: a. Prepare the pro forma income statement that would appear in the master budget if the firm expects to provide 45,000 hours of services in Year 3. b. A marketing consultant suggests to Mr. Cooper that the service rate may affect the number of service hours that the firm can achieve. According to the consultant's analysis, if Campbell charges customers $80 per hour, the firm can achieve 50,000 hours of services. Prepare a flexible budget using the consultant's assumption. c. The same…arrow_forwardE9-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.arrow_forwardRefer to Cornerstone Exercise 8.2 for the production budgets for practice balls and match balls. Every practice ball requires 0.7 square yard of polyvinyl chloride panels, one bladder with valve (to fill with air), and 3 ounces of glue. FlashKicks policy is that 20 percent of the following months production needs for raw materials be in ending inventory. Beginning inventory in January for all raw materials met this requirement. Required: 1. Construct a direct materials purchases budget for each type of raw materials for the practice ball line for January and February of the coming year. 2. What if FlashKick decreased the ending inventory percentage to 15 percent of the next months production needs? What impact would that have on the direct materials purchases budgets prepared in Requirement 1? Refer to Cornerstone Exercise 8.1, through Requirement 1. FlashKick requires ending inventory of product to equal 20 percent of the next months unit sales. Beginning inventory in January was 3,100 practice soccer balls and 400 match soccer balls. Required: 1. Construct a production budget for each of the two product lines for FlashKick Company for the first three months of the coming year. 2. What if FlashKick wanted a production budget for the two product lines for the month of April? What additional information would you need to prepare this budget?arrow_forward
- Refer to Cornerstone Exercise 8.1, through Requirement 1. FlashKick requires ending inventory of product to equal 20 percent of the next months unit sales. Beginning inventory in January was 3,100 practice soccer balls and 400 match soccer balls. Required: 1. Construct a production budget for each of the two product lines for FlashKick Company for the first three months of the coming year. 2. What if FlashKick wanted a production budget for the two product lines for the month of April? What additional information would you need to prepare this budget? FlashKick Company manufactures and sells soccer balls for teams of children in elementary and high school. FlashKicks 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: Required: 1. Construct a sales budget for FlashKick for the first three months of the coming year. Show total sales for each product line by month and in total for the first quarter. 2. What if FlashKick added a third linetournament quality soccer balls that were expected to take 40 percent of the units sold of the match balls and would have a selling price of 45 each in January and February, and 48 each in March? Prepare a sales budget for Flash- Kick for the first three months of the coming year. Show total sales for each product line by month and in total for the first quarter.arrow_forwardRelevant data from the Poster Company’s operating budgets are: Quarter 1 Quarter 2 Sales $208,470 $211,538 Direct material purchases 115,295 120,833 Direct labor 75,210 73,299 Manufacturing overhead 25,400 25,200 Selling and administrative expenses 33,500 33,600 Depreciation included in selling and administrative 1,500 1,100 Collections from customers 215,393 240,154 Cash payments for purchases 114,290 119,253 Additional data:Capital assets were sold in January for $9,000 and $4,400 in May.Dividends of $4,500 were paid in February. The beginning cash balance was $60,360 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 $fill in the blank 2 $fill in the blank 3 Add: Cash Receipts fill in the blank 5 fill in the blank…arrow_forwardRelevant 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_forward
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you
Survey of Accounting (Accounting I)AccountingISBN:9781305961883Author:Carl WarrenPublisher:Cengage Learning
Managerial AccountingAccountingISBN:9781337912020Author:Carl Warren, Ph.d. Cma William B. TaylerPublisher:South-Western College Pub
Cornerstones of Cost Management (Cornerstones Ser...AccountingISBN:9781305970663Author:Don R. Hansen, Maryanne M. MowenPublisher:Cengage Learning
Principles of Accounting Volume 2AccountingISBN:9781947172609Author:OpenStaxPublisher:OpenStax College
Survey of Accounting (Accounting I)
Accounting
ISBN:9781305961883
Author:Carl Warren
Publisher:Cengage Learning
Managerial Accounting
Accounting
ISBN:9781337912020
Author:Carl Warren, Ph.d. Cma William B. Tayler
Publisher:South-Western College Pub
Cornerstones of Cost Management (Cornerstones Ser...
Accounting
ISBN:9781305970663
Author:Don R. Hansen, Maryanne M. Mowen
Publisher:Cengage Learning
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