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 P22.56CT
Using Excel for to prepare an operating budget (manufacturing company)
Download an Excel template for this problem online in MyAccountingLab or at http://www.pearsonhighered.com/Horngren
Thunder Creek Company is preparing budgets for the first quarter of 2O18. All relevant information is presented on the Excel template.
Requirements
1 Prepare a Sales Budget.
2 Prepare a Production Budget.
3. Prepare a Direct Materials Budget.
4. Prepare a Direct Labor Budget.
5. Prepare a Manufacturing
6. Prepare a Cost of Goods Sold Budget.
7. Prepare a Selling and Administrative Expense Budget.
Expert Solution & Answer
Want to see the full answer?
Check out a sample textbook solution
Students have asked these similar questions
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…
The Bakery Department of Culbert Dessert Corporation has submitted the following forecast of fruit pies to be produced by quarter for
the upcoming fiscal year.
Units to be produced
First
Quarter
9,300
Second Third
Quarter Quarter
12,300 10,300
Units to be produced
Direct labour time per unit (hours)
Total direct labour-hours needed
Direct labour cost per hour
Total direct labour cost
Each unit requires 0.40 direct labour-hours, and direct labour-hour workers are paid $9.00 per hour.
In addition, the variable manufacturing overhead rate is $1.00 per direct labour-hour. The fixed manufacturing overhead is $26,250 per
quarter. The only non-cash element of manufacturing overhead is depreciation, which is $7,650 per quarter.
Required:
1. Prepare the company's direct labour budget for the upcoming fiscal year, assuming that the direct labour workforce is adjusted each
quarter to match the number of hours required to produce the forecast number of units produced.
Fourth
Quarter
14,300
Culbert…
Answer-Prepare for January 2023:
-Direct materials purchases budget
-Direct labor costs budget
-Factory overhead budget
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
- Refer to Cornerstone Exercise 8.6. Required: 1. Calculate the total budgeted cost of units produced for Play-Disc for the coming year. Show the cost of direct materials, direct labor, and overhead. 2. Prepare a cost of goods sold budget for Play-Disc for the year. 3. What if the beginning inventory of finished goods was 75,200 (for 16,000 units)? How would that affect the cost of goods sold budget? (Assume Play-Disc uses the FIFO method.) Play-Disc makes Frisbee-type plastic discs. Each 12-inch diameter plastic disc has the following manufacturing costs: For the coming year, Play-Disc expects to make 300,000 plastic discs, and to sell 285,000 of them. Budgeted beginning inventory in units is 16,000 with unit cost of 4.75. (There are no beginning or ending inventories of work in process.) Required: 1. Prepare an ending finished goods inventory budget for Play-Disc for the coming year. 2. What if sales increased to 290,000 discs? How would that affect the ending finished goods inventory budget? Calculate the value of budgeted ending finished goods inventory.arrow_forwardA company has prepared the operating budget and the cash budget. It is now preparing the budgeted balance sheet. Identify the document that contains each of these balances. A. cash B. accounts receivable C. finished goods inventory D. accounts payable E. equipment purchasesarrow_forwardThe Bakery Department of Culbert Dessert Corporation has submitted the following forecast of fruit pies to be produced by quarter for the upcoming fiscal year. First Second Third Fourth Quarter 8,300 Quarter Quarter 9,300 Quarter 13,300 Units to be produced 11,300 Each unit requires 0.60 direct labour-hours, and direct labour-hour workers are paid $9.00 per hour. In addition, the variable manufacturing overhead rate is $1.50 per direct labour-hour. The fixed manufacturing overhead is $23,750 per quarter. The only non-cash element of manufacturing overhead is depreciation, which is $7,150 per quarter. Required: 1. Prepare the company's direct labour budget for the upcoming fiscal year, assuming that the direct labour workforce is adjusted each quarter to match the number of hours required to produce the forecast number of units produced.arrow_forward
- Please help me with all answers thankuarrow_forwardQ4: Use the following terms in preparing the budget: Insurance Maintenance Utilities Depreciation Expense Sales Commissions Depreciation Indirect Material Maintenance Salaries Indirect Labor Supervisory Salaries Sales Salaries Insurance Expense Spree Party Lights overhead expenses are: PLEASE NOTE: All dollar amounts are rounded to whole dollars and shown with "$" and commas as needed (i.e. $12,345). Using the terms and the information above, prepare a manufacturing overhead budget if the number of units to produce for January, February, and March are 2,500, 3,000, and 2,700, respectively (use the format shown in the textbook): Spree Party Lights Manufacturing Overhead Budget For the Quarter Ending March, 2019 Jan. Feb. Mar. Units to Produce 2,500 3,000 2,700 Variable Costs: Total Variable Manufacturing Costs Fixed Costs: Total Fixed Manufacturing Costs…arrow_forwardplease provide answer within one hour,thanksarrow_forward
- Ramos Co. provides the following sales forecast and production budget for the next four months. July 660 600 Sales (units) Budgeted production (units) April 560 500 The company plans for finished goods inventory of 180 units at the end of June. In addition, each finished unit requires 6 pounds of direct materials and the company wants to end each month with direct materials inventory equal to 25% of next month's production needs. Beginning direct materials inventory for April was 750 pounds. Direct materials cost $3 per pound. Each finished unit requires 0.20 hours of direct labor at the rate of $22 per hour. The company budgets variable overhead at the rate of $26 per direct labor hour and budgets fixed overhead of $8,600 per month. 1. Prepare a direct labor budget for April, May, and June. 2. Prepare a factory overhead budget for April, May, and June. Required 1 Required 2 May 640 630 Complete this question by entering your answers in the tabs below. RAMOS CO. June 590 600 Prepare a…arrow_forwardPlease use Excel.arrow_forwardanswer in text form please (without image)arrow_forward
- Prepare schedules for (1) expected collections from customers and (2) expected payments for direct materials purchases for January and February. Prepare a cash budget for January and February in columnar form. please dont provide answer in an image format thnkuarrow_forwardplease dear expert need true help and show all work with steps answer in text Required: For each quarter, calculate the: Sales budget. Production budget. Direct labour budget.arrow_forwardYou are required to prepare operational budget for the upcoming year including following: 1) Sales budget; 2) Production budget and Readymade production budget; 3) Direct materials budget; 4) Direct labor budget; 5) Purchase’s budget; 6) Overheads budget; 7) General production costs distribution; 8) Cost of sales budget; 9) Selling expenses budget; 10) Ending materials and ending Readymade production; 11) Profit and loss(Income statement).arrow_forward
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you
Excel Applications for Accounting PrinciplesAccountingISBN:9781111581565Author:Gaylord N. SmithPublisher:Cengage Learning
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
Excel Applications for Accounting Principles
Accounting
ISBN:9781111581565
Author:Gaylord N. Smith
Publisher:Cengage Learning
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