Managerial Accounting (5th Edition)
5th Edition
ISBN: 9780134128528
Author: Karen W. Braun, Wendy M. Tietz
Publisher: PEARSON
expand_more
expand_more
format_list_bulleted
Concept explainers
Textbook Question
Chapter 10, Problem 10.26AE
Prepare a flexible budget performance report (Learning Objective 5)
Main Street Muffins sells its muffins to restaurants and coffee houses for an average selling price of $26 per case. The following information relates to the budget for Main Street Muffins for this year (all figures are annual totals unless otherwise noted):
Budgeted sales in cases | 9,100 cases |
Packaging cost per case | $ 1 |
Shipping expense per case | $ 2 |
Sales commission expense | 5% of sales price |
Salaries expense | $6,500 |
Office rent | $3,900 |
Depreciation | $2,500 |
Insurance expense | $1,800 |
Office supplies expense | $900 |
During the year, Main Street Muffins actually sold 9,500 cases, resulting in total sales revenue of $255,200. Actual expenses (in total) from this year are as follows:
Packaging cost | $ 10,600 |
Shipping expense | $ 19,500 |
Sales commission expense | $ 12,760 |
Salaries expense | $ 7,300 |
Office rent | $ 3,900 |
Depreciation | $ 2,500 |
Insurance expense | $ 1,600 |
Office supplies expense | $ 1,600 |
Requirement
Construct a flexible budget performance report for Main Street Muffins for the year. Be sure to indicate whether each variance is favorable (F) or unfavorable (U).
Expert Solution & Answer
Want to see the full answer?
Check out a sample textbook solutionStudents have asked these similar questions
Johnston Bookstore is the bookstore on campus for students and faculty. The bookstore
E9-18A Sales budget for a retail organization (Learning Objective 2)
shows the following sales projections in units by quarter for the upcoming year
School Supplies
Apparel
Miscellaneous
Quarter
Books
1,570
200
580
690
1st.
.....
2nd
800
190
330
540
3rd
1,790
240
880
890
4th
670
180
540
440
The average price of an item in each of the departments is as follows:
Average sales price per unit
Books..
$85
School supplies
Apparel..
Miscellaneous.
$18
$29
$ 6
Requirement
Prepare a sales budget for the upcoming year by quarter for the Johnston Bookstore,
with sales categorized by the four product groupings (books, school supplies, apparel,
and miscellaneous).
E9-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.
Prepare Hilton
goods sold computations.
2. Prepare a combined cash budget similar to exhibits in the chapter. If no financing ac-
P9-61A Cash budgets (Learning Objective 3)
and cash disbursements:
are
as follows:
Budgeted Sales Revenue
$62,000
January
$70,000
February.
b. Actual purchases of direct materials in December were $24,500. The companye
purchases of direct materials in January are budgeted to be $24,000 and $26.000 i
February. All purchases are paid 40% in the month of purchase and 60% the follow
month.
c. Salaries and sales commissions are also paid half in the month earned and half the
next month. Actual salaries were $8,000 in December. Budgeted salaries in Janu-
ary are $9,000 and February budgeted salaries are $10,500. Sales commissions each
month are 8% of that month's sales.
d. Rent expense is $3,500 per month.
e. Depreciation is $2,100 per month.
f. Estimated income tax payments are made at the end of January. The estimated tax
payment is projected to be $12,500.
g.…
Chapter 10 Solutions
Managerial Accounting (5th Edition)
Ch. 10 - (Learning Objective 1) Companies often...Ch. 10 - (Learning Objective 1) Which of the following is...Ch. 10 - (Learning Objective 1) In terms of responsibility...Ch. 10 - (Learning Objective 2) Which of the following is...Ch. 10 - (Learning Objective 2) A segment margin is the...Ch. 10 - Prob. 6QCCh. 10 - Prob. 7QCCh. 10 - Prob. 8QCCh. 10 - Prob. 9QCCh. 10 - Prob. 10QC
Ch. 10 - Identify and understand responsibility centers...Ch. 10 - Identify types of responsibility centers (Learning...Ch. 10 - Identify centralized and decentralized...Ch. 10 - Prob. 10.4SECh. 10 - Prob. 10.5SECh. 10 - Prob. 10.6SECh. 10 - Calculate ROI (Learning Objective 3) Refer to Epic...Ch. 10 - Prob. 10.8SECh. 10 - Prob. 10.9SECh. 10 - Prob. 10.10SECh. 10 - Prob. 10.11SECh. 10 - Interpret a performance report (Learning Objective...Ch. 10 - Prob. 10.13SECh. 10 - Classify KPIs by balanced scorecard perspective...Ch. 10 - Use vocabulary terms (Learning Objectives 1, 2, 3,...Ch. 10 - Prob. 10.16SECh. 10 - Identify type of responsibility center (Learning...Ch. 10 - Complete and analyze a performance report...Ch. 10 - Prepare a segment margin performance report...Ch. 10 - Compute and interpret the expanded ROI equation...Ch. 10 - Prob. 10.21AECh. 10 - Prob. 10.22AECh. 10 - Comparison of ROI and residual income (Learning...Ch. 10 - Prob. 10.24AECh. 10 - Comprehensive flexible budget problem (Learning...Ch. 10 - Prepare a flexible budget performance report...Ch. 10 - Work backward to find missing values (Learning...Ch. 10 - Construct a balanced scorecard (Learning Objective...Ch. 10 - Sustainability and the balanced scorecard...Ch. 10 - Identify type of responsibility center (Learning...Ch. 10 - Complete and analyze a performance report...Ch. 10 - Prob. 10.32BECh. 10 - Prob. 10.33BECh. 10 - Prob. 10.34BECh. 10 - Prob. 10.35BECh. 10 - Prob. 10.36BECh. 10 - Prob. 10.37BECh. 10 - Prob. 10.38BECh. 10 - Prob. 10.39BECh. 10 - Prob. 10.40BECh. 10 - Prob. 10.41BECh. 10 - Sustainability and the balanced scorecard...Ch. 10 - Prepare a budget with different volumes for...Ch. 10 - Prepare and interpret a performance report...Ch. 10 - Prob. 10.45APCh. 10 - Prob. 10.46APCh. 10 - Prob. 10.47APCh. 10 - Evaluate subunit performance (Learning Objectives...Ch. 10 - Prob. 10.49BPCh. 10 - Prob. 10.50BPCh. 10 - Evaluate divisional performance (Learning...Ch. 10 - Prob. 10.52BPCh. 10 - Determine transfer price at a manufacturer under...Ch. 10 - Evaluate subunit performance (Learning Objectives...Ch. 10 - Prob. 10.55SC
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
- In Organizational Development (OD), each area of OD has its own budget to maintain. Please create a spreadsheet indicating the following purchases for the different OD areas and the remaining balance for each department based on the beginning budget and purchases as indicated. The Center for the Advancement of Teaching and Learning Beginning Budget $60,000 Speaker Books Speaker Gifts $2,000 100 @ $22.50 each $200.00 Leadership Development Beginning Budget $40,000 Retreat Location Rental Retreat Lunch Conference Awards $8,000 $11.00 each for 72 attendees $9,000 $8,800 Creative and Strategic Initiatives Beginning Budget $25,000 Camera Software Digital subscriptions $7,000 $2,000 $550.00arrow_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_forwardRoberds 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_forward
- ShawnTech 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_forward1. 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…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_forward
- Learning Objective 2 Product Costs and Product Profitability Reports, using a Single Plantwide Factory Overhead Rate Isaac Engines Inc. produces three products-pistons, valves, and cams-for the heavy equipment industry. Isaac Engines has a very simple production process and product line and uses a single plantwide factory overhead rate to allocate overhead to the three products. The factory overhead rate is based on direct labor hours. Information about the three products for 20Y2 is as follows: Pistons Valves Cams Budgeted Volume (Units) 6,000 13,000 1,000 Pistons Direct Labor Hours Per Unit Valves Cams If required, round all per unit answers to the nearest cent. a. Determine the plantwide factory overhead rate. $ 28 ✔per dlh 0.30 0.50 0.10 0.3 ✔ dlh The estimated direct labor rate is $20 per direct labor hour. Beginning and ending inventories are negligible and are, thus, assumed to be zero. The budgeted factory overhead for Isaac Engines is $235,200. 0.5 dlh 0.1 ✓dlh Price Per Unit…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_forwardHomework Saved Help Walton Company sells lamps and other lighting fixtures. The purchasing department manager prepared the following inventory purchases budget. Walton's policy is to maintain an ending inventory balance equal to 20 percent of the following month's cost of goods sold. April's budgeted cost of goods sold is $78,000. Required a. Complete the inventory purchases budget by filling in the missing amounts. b. Determine the amount of cost of goods sold the company will report on its first quarter pro forma income statement. c. Determine the amount of ending inventory the company will report on its pro forma balance sheet at the end of the first quarter. Complete this question by entering your answers in the tabs below. Req A Req B and C Complete the inventory purchases budget by filling in the missing amounts. Inventory Purchases Budget January February March Budgeted cost of goods sold 54,000 $ 58,000 $ 64,000 11,600 Inventory needed 65,600 10,800 Required purchases (on…arrow_forward
- MULTI 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_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_forwardRoberds 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: Revenue Faculty wages Course supplies Administrative expenses Actual students Actual courses Revenue Expenses: Faculty wages Course supplies Administrative expenses Total expense Net operating income In March, the school budgeted for 1,720 students and 69 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 Students Courses Revenue Expenses: Fixed element per month Faculty wages Course supplies Administrative expenses $0 $0 $0 $ 25,550 Total expense Net operating income Variable element per student $203 $0 $33 Required: Prepare a flexible budget performance report showing both the school's activity variances and revenue and spending variances for March. Label each variance 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:PEARSONIntermediate AccountingAccountingISBN:9781259722660Author:J. David Spiceland, Mark W. Nelson, Wayne M ThomasPublisher:McGraw-Hill EducationFinancial 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