Managerial Accounting, Student Value Edition Plus MyLab Accounting with Pearson eText -- Access Card Package (5th Edition)
5th Edition
ISBN: 9780134642093
Author: Karen W. Braun, Wendy M. Tietz
Publisher: PEARSON
expand_more
expand_more
format_list_bulleted
Concept explainers
Videos
Textbook Question
Chapter 9, Problem 9.20AE
Production budget (Learning Objective 2)
Hoffman Foods produces specialty soup sold in jars. The projected sales in dollars and jars for each quarter of the upcoming year are as follows:
| Total sales revenue | Number of jars sold | |
| 1st quarter | $181,000 | 152,500 |
| 2nd quarter | $219,000 | 181,500 |
| 3rd quarter | $255,000 | 213,000 |
| 4th quarter | $199,000 | 160,500 |
Hoffman anticipates selling 223,000 jars with total sales revenue of $260,000 in the first quarter of the year following the year given in the preceding table. Hoffman has a policy that the ending inventory of jars must be 30% of the following quarter’s sales. Prepare a production budget for the year that shows the number of jars to be produced each quarter and for the year in total.
Expert Solution & Answer
Want to see the full answer?
Check out a sample textbook solution
Students have asked these 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?
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…
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 9 Solutions
Managerial Accounting, Student Value Edition Plus MyLab Accounting with Pearson eText -- Access Card Package (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
- Roberds Tech is a for-profit vocational school. The school bases its budgets on two measures of activity (i.e., cost drivers), namely student and course. The school uses the following data in its budgeting: Fixed element per month Variable element per student Variable element per course Revenue $ 0 $ 298 $ 0 Faculty wages $ 0 $ 0 $ 3,100 Course supplies $ 0 $ 52 $ 40 Administrative expenses $ 26,500 $ 27 $ 52 In March, the school budgeted for 1,910 students and 88 courses. The school's income statement showing the actual results for the month appears below: Roberds Tech Income Statement For the Month Ended March 31 Actual students 1,810 Actual courses 91 Revenue $ 411,340 Expenses: Faculty wages 214,950 Course supplies 62,590 Administrative expenses 84,562 Total expense 362,102 Net operating income $ 49,238 Required: Prepare a flexible budget performance report showing both the school's activity variances and revenue and spending…arrow_forwardChapter : Budgeting 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 teaches…arrow_forwardMULTI COLORED PICTURE ATTACHED IS THE PART I NEED HELP WITH SECOND IS PART OF THE INFORMATION GIVEN WITH THE QUESTION The Grady Tire Company manufactures racing tires for bicycles. Grady sells tires for $70 each. Grady is planning for the next year by developing a master budget by quarters. Grady's balance sheet for Decembe 31,2018, follows: a. Budgeted sales are 1,800 tires for the first quarter and expected to increase by 50 tires per quarter. Cash sales are expected to be 20% of total sales, with the remaining 80% of sales on account. b. Finished Goods Inventory on December 31, 2018 consists of 100 tires at $36 each. c. Desired ending Finished Goods Inventory is 50% of the next quarter's sales; first quarter sales for 2020 are expected be 2,000 tires. FIFO inventory costing method is used. d. Raw Materials Inventory on December 31, 2018, consists of 200 pounds of rubber compound used to manufacture the tires. e. Direct materials requirements are 2 pounds of a rubber compound…arrow_forward
- 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…arrow_forwardShawnTech is a for-profit vocational school. The school bases its budgets on two measures of activity (i.e., cost drivers), namely student and course. The school uses the following data in its budgeting: Fixed element per month variable element per student variable element per course revenue $0 $354 $0 faculty wages $0 $0 $2,300 course supplies $0 $48 $40 administrative expenses $41,700 $13 $21 In October, the school budgeted for 1,400 students and 127 courses. The actual activity for the month was 1,500 students and 129 courses. Prepare a report showing the school's activity variances for October. Label each variance as favorable (F) or unfavorable (U).arrow_forwardScholar Suppliers manufactures backpacks for students. The backpacks come in two sizes: Small, and Large. Scholar Suppliers anticipates the following sales volumes and prices for the coming period: Size Sales Volume Selling Price Small 3,000 backpacks $25 each Large 6,000 backpacks $75 each What is the budgeted level of revenue for the coming period?arrow_forward
- Personal Budget 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) $8,680 Purchase season football tickets in September 120 Additional entertainment for each month 300 Pay fall semester tuition in September 4,700 Pay rent at the beginning of each month 420 Pay for food each month 240 Pay apartment deposit on September 2 (to be returned December 15) 600 Part-time job earnings each month (net of taxes) 1,080 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…arrow_forwardSanchez Corporation manufactures tables for schools. The 2023 operating budget is based on sales of 100,000 units at $500 per table. Budgeted variable costs are $350 per unit, while fixed costs total $6,000,000. For 2023, actual sales were 110,000 units at $490 each. Actual variable costs were $360 per unit and fixed costs totaled $5,800,000. Required: a) Prepare a report showing actual results, a static budget and a flexible budget. b) Explain the significance of a flexible budget versus a static budget.arrow_forwardPrepare a operating budget based on the following information: Expected Sales Art Course 2 Semesters for the year 3 Courses offered each semester Maximum enrolment 32 students Expected capacity 94% Tuition $5,000 per student Customized Courses 15 Courses 15 Students per course Course Fee $110,000 per course Each course is 5 weeks In order to achieve these goals The Marketing department spend $350,000 on print, television and radio advertising as well as increase the sales commission rate from 4% to 6% of revenue. Direct Materials : Each student will receive a set of Student brushes. It is expected that they will cost approximately $750 each While we do not have any brushes right now I would also like to end the year with 10 extra sets of tools in inventory Direct Labour For our employees who are Direct Labour: associated with instruction. Instructors- 3 hours per day, 5 days per week for duration of course Qualified Artists 3 hours per day 5 days per week for duration of course I…arrow_forward
- Personal Budget 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) $8,860 Purchase season football tickets in September 120 Additional entertainment for each month 310 Pay fall semester tuition in September 4,800 Pay rent at the beginning of each month 430 Pay for food each month 240 Pay apartment deposit on September 2 (to be returned December 15) 600 Part-time job earnings each month (net of taxes) 1,100 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…arrow_forwardPersonal Budget 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) $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 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…arrow_forwardLearnCo PARAGRAPH IS FOR ASSISTANCE TO HELP WITH THE QUESTIONS IN THE IMAGES ONLY WANT THE IMAGES ANWSERED LearnCo manufactures and sells one product, an abacus for classroom use, with two models, the Basic model and the Deluxe model. The company began operations on January 1, 20Y1, and is planning for 20Y2, its second year of operations, by preparing budgets from its master budget. The company is trying to decide how many units to manufacture, how much it might spend on direct materials and direct labor, and what their factory overhead expenses might be. In addition, the company is interested in budgeting for selling and administrative costs, and in creating a budgeted income statement showing a prediction of net income for 20Y2. You have been asked to assist the controller of LearnCo in preparing the 20Y2 budgets. Sales Budget The sales budget often uses the prior year’s sales as a starting point, and then sales quantities are revised for various factors such as planned advertising…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