Horngren's Accounting: The Managerial Chapters, Student Value Edition Plus Mylab Accounting With Pearson Etext - Access Card Package (12th Edition)
12th Edition
ISBN: 9780134643168
Author: MILLER-NOBLES, Tracie L.; Mattison, Brenda L.; Matsumura, Ella Mae
Publisher: PEARSON
expand_more
expand_more
format_list_bulleted
Concept explainers
Textbook Question
Chapter 23, Problem E23.15E
Preparing a flexible budget Learning Objective 1
$229,500 Op. Inc. for 55,000 units
Office Plus sells its main product, ergonomic mouse pads, for $13 each. Its variable cost is $5.10 per pad. Fixed costs are $205,000 per month for volumes up to 65,000 pads. Above 65,000 pads, monthly fixed costs are $250,000. Prepare a monthly flexible budget for the product, showing sales revenue, variable costs, fixed costs, and operating income for volume levels of 45,000, 55,000, and 75,000 pads.
Expert Solution & Answer
Want to see the full answer?
Check out a sample textbook solutionStudents have asked these similar questions
1. 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…
Prepare 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…
1. Question Content Area
Sales 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
50,000
$8.25
7,000
$16.00
February
58,000
$8.25
8,000
$16.00
March
80,000
$8.25
13,000
$16.00
April
100,000
$8.25
18,000
$16.00
Required:
Question Content Area
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. If required, round your answers to the nearest cent.
FlashKick CompanySales BudgetFor the First Quarter of Next Year…
Chapter 23 Solutions
Horngren's Accounting: The Managerial Chapters, Student Value Edition Plus Mylab Accounting With Pearson Etext - Access Card Package (12th Edition)
Ch. 23 - Prob. 1QCCh. 23 - MajorNet Systems is a start-up company that makes...Ch. 23 - MajorNet Systems is a start-up company that makes...Ch. 23 - MajorNet Systems is a start-up company that makes...Ch. 23 - MajorNet Systems has budgeted three hours of...Ch. 23 - MajorNet Systems has budgeted three hours of...Ch. 23 - FrontGrade Systems allocates manufacturing...Ch. 23 - FrontGrade Systems allocates manufacturing...Ch. 23 - FrontGrade Systems allocates manufacturing...Ch. 23 - The person probably most responsible for the...
Ch. 23 - HajorNet System’s static budget predicted...Ch. 23 - What is a variance?Ch. 23 - Explain the difference between a favorable and an...Ch. 23 - What is a static budget performance report?Ch. 23 - How do flexible budgets differ from static...Ch. 23 - How is a flexible budget used?Ch. 23 - What are the two components of the static budget...Ch. 23 - What is a flexible budget performance report?Ch. 23 - What is a standard cost system?Ch. 23 - Explain the difference between a cost standard and...Ch. 23 - Give the general formulas for determining cost and...Ch. 23 - How does the static budget affect cost and...Ch. 23 - List the direct materials variances, and briefly...Ch. 23 - List the direct labor variances, and briefly...Ch. 23 - List the variable overhead variances, and briefly...Ch. 23 - List the fixed overhead variances, and briefly...Ch. 23 - How is the fixed overhead volume variance...Ch. 23 - What is management by exception?Ch. 23 - List the eight product variances and the manager...Ch. 23 - Briefly describe how journal entries differ in a...Ch. 23 - What is a standard cost income statement?Ch. 23 - Matching terms Learning Objective 1 Match each...Ch. 23 - Preparing flexible budgets Learning Objective 1...Ch. 23 - Calculating flexible budget variances Learning...Ch. 23 - Matching terms Learning Objective 2 Match each...Ch. 23 - Identifying the benefits of standard costs...Ch. 23 - Calculating materials variances Learning Objective...Ch. 23 - Calculating labor variances Learning Objective 3...Ch. 23 - Interpreting material and labor variances Learning...Ch. 23 - Computing standard overhead allocation rates...Ch. 23 - Computing overhead variances Learning Objective 4...Ch. 23 - Understanding variance relationships Learning...Ch. 23 - Journalizing materials entries Learning Objectives...Ch. 23 - Journalizing labor entries Learning Objectives 6...Ch. 23 - Preparing a standard cost income statement...Ch. 23 - Preparing a flexible budget Learning Objective 1...Ch. 23 - Preparing a flexible budget performance report...Ch. 23 - Preparing a flexible budget performance report...Ch. 23 - Defining the benefits of setting cost standards...Ch. 23 - Calculating materials and labor variances Learning...Ch. 23 - Computing overhead variances Learning Objective 4...Ch. 23 - Calculating overhead variances Learning Objective...Ch. 23 - Preparing a standard cost income statement...Ch. 23 - Preparing journal entries Learning Objective 6 MOH...Ch. 23 - Preparing a standard cost income statement...Ch. 23 - Preparing a flexible budget performance report...Ch. 23 - Preparing a flexible budget computing standard...Ch. 23 - Computing standard cost variances and reporting to...Ch. 23 - Computing and journalizing standard cost variances...Ch. 23 - Prob. P23.29APGACh. 23 - Preparing a flexible budget performance report...Ch. 23 - Preparing a flexible budget and computing standard...Ch. 23 - Prob. P23.32BPGBCh. 23 - Prob. P23.33BPGBCh. 23 - Preparing a standard cost income statement...Ch. 23 - Prob. P23.35CTCh. 23 - Preparing a flexible budget and performance report...Ch. 23 - Prob. 23.1TIATCCh. 23 - Decision Case 23-1 Suppose you manage the local...Ch. 23 - Fraud Case 23-1 Drew Castello, general manager of...
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.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_forwardStudent 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_forwardPlease 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…arrow_forward
- Sanchez 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_forwardPreparing a flexible budget and performance report This continues the Piedmont Computer Company situation from Chapter 22. Assume Piedmont Computer Company has created a standard cost card for the PCC model tablet computer, with overhead allocated based on direct labor hours: During the month of September, Piedmont Computer Company incurred the following costs while manufacturing 1,100 PCC model tablets; Requirements Prepare a flexible budget for September for 900, 1,000, and 1,100 PCC model tablets. The tablet has a standard sales price of $675. List variable costs separately. Using 1,000 PCC model tablets for the static budget, prepare a flexible budget performance report for September. Total sales revenue for the month was $767,800. The company sold 1,100 tablets. What insights can the management of Piedmont Computer Company draw from the performance report?arrow_forwardDirect Materials Purchases Budget Smart Strike Company manufactures and sells soccer balls for teams of children in elementary and high school. Smart Strike'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, Smart Strike expects to sell the following: Practice Balls Match Balls Units Selling Price Units Selling Price January 48,000 $8.85 6,400 $17.20 February 58,000 $8.85 7,500 $17.20 March 86,000 $8.85 13,000 $17.20 April 105,000 $8.85 17,000 $17.20 Smart Strike requires ending inventory of product to equal 20 percent of the next month's unit sales. Beginning inventory in January was 9,600 practice soccer balls and 1,280 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 ounces of glue.…arrow_forward
- 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 48,000 $8.75 6,100 $16.50 February 62,000 $8.75 7,800 $16.50 March 87,000 $8.75 13,000 $16.50 April 100,000 $8.75 16,000 $16.50 FlashKick requires ending inventory of product to equal 20 percent of the next month’s unit sales. Beginning inventory in January was 9,600 practice soccer balls and 1,220 match soccer balls. Every practice ball requires 0.6 square yard of polyvinyl chloride panels, one bladder with valve (to fill with air), and 3 ounces of glue. FlashKick’s…arrow_forwardDirect 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 45,000 $8.95 6,900 $17.10 February 57,000 $8.95 8,200 $17.10 March 88,000 $8.95 12,000 $17.10 April 100,000 $8.95 17,500 $17.10 FlashKick requires ending inventory of product to equal 20 percent of the next month’s unit sales. Beginning inventory in January was 9,000 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 ounces of glue. FlashKick’s…arrow_forwardDirect 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 45,000 $8.95 6,900 $17.10 February 57,000 $8.95 8,200 $17.10 March 88,000 $8.95 12,000 $17.10 April 100,000 $8.95 17,500 $17.10 FlashKick requires ending inventory of product to equal 20 percent of the next month’s unit sales. Beginning inventory in January was 9,000 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 ounces of glue. FlashKick’s…arrow_forward
- Task 1 Pedro Sdn Bhd. manufactures and sells two cookware products in a single plant. The new manager wants to have quarterly budgets and has prepared the following information for the first quarter of 2021. The following information is available: Budgeted sales: Product A …….60,000 units @RM100 each Product B …….40,000 units @RM125 each Budgeted inventories: Beginning Ending Product A Product B Direct material (Metal) Direct material (Plastic) Direct material (Handles) 20,000 8,000 32,000 kg 29,000 kg 6,000 units 25,000 10,000 36,000 kg 32,000 kg 7,000 units Standard variable costs: Product A Product B Direct materials: Metal Plastic Handles Total materials 5kg @RM8.00 3kg@RM5.00 1 unit @RM3.00 RM40.00 15.00 3.00 58.00 4kg @RM8.00 3kg@RM5.00 RM32.00 15.00 47.00 Direct labour Variable manufacturing overhead Total 2hours@RM12.00 2hours@RM1.50 24.00 3.00 85.00 3hours@RM16.00 3hours@RM1.50 48.00 4.50…arrow_forwardActivity-Based Flexible Budgeting Foy Company has a welding activity and wants to develop a flexible budget formula for the activity. The following resources are used by the activity: • Four welding units, with a lease cost of $15,000 per year per unit • Six welding employees each paid a salary of $58,000 per year (A total of 12,000 welding hours are supplied by the six workers.) • Welding supplies: $400 per job • Welding hours: 4 hours used per job During the year, the activity operated at 95 percent of capacity and incurred the following actual activity and resource costs. • Lease cost: $60,000 • Salaries: $365,400 • Parts and supplies: $1,134,200 Required: 1. Prepare a flexible budget formula for the welding activity using welding hours as the driver. Welding cost = $fill in the blank e95687f99006fa4_1 + $fill in the blank e95687f99006fa4_2 X 2. Prepare a performance report for the welding activity. In the last column of Foy Company Activity-Based…arrow_forwardQuestion Content Area I AM NEEDING THE PICTURES ANWSERED THE PASSAGE IS JUST FOR ASSISTANCE TO ANSWER THE QUESTIONS Question Content Area LearnCo 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…arrow_forward
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you
- Managerial AccountingAccountingISBN:9781337912020Author:Carl Warren, Ph.d. Cma William B. TaylerPublisher:South-Western College PubCornerstones of Cost Management (Cornerstones Ser...AccountingISBN:9781305970663Author:Don R. Hansen, Maryanne M. MowenPublisher: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
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