GEN COMBO LL MANAGERIAL ACCOUNTING; CONNECT ACCESS CARD
16th Edition
ISBN: 9781260088458
Author: Ray H Garrison
Publisher: McGraw-Hill Education
expand_more
expand_more
format_list_bulleted
Videos
Textbook Question
Chapter 9, Problem 2AE
The Excel worksheet form that appears below is to be used to recreate the Renew Problem relating to Harrald’s Fish House. Download the workbook containing this form from Connect, where you will also receive instructions about how to use this worksheet form.
You should proceed to the requirements below only after completing your worksheet.
Required:
2. Revise the data in your worksheet to reflect the results for the following year;
Using the flexible budget performance report, briefly evaluate the company’s performance for the year and indicate where attention should be focused.
Expert Solution & Answer
Want to see the full answer?
Check out a sample textbook solution
Students have asked these similar questions
Perfect Parties, Inc. has several divisions, one of which provides birthday parties at their facility, and has provided the actual and planning budget results for the month of June. The Controller has asked you prepare the Birthday Party Division Budget Performance Report.
Please provide me with the answers for the cells in yellow. greatly appreciate your help!
provide the followinf inforamtion to help prepare the master budget for the next four months of opration
Could you solve ( D , E , F and G ) only thanks
The management of Mecca Copy, a photocopying center located on University Avenue, has compiled the following data to use in preparing its budgeted balance sheet for next year:
Chapter 9 Solutions
GEN COMBO LL MANAGERIAL ACCOUNTING; CONNECT ACCESS CARD
Ch. 9 - Prob. 1QCh. 9 - What is a flexible budget and how does it differ...Ch. 9 - Prob. 3QCh. 9 - Why is it difficult to interpret a difference...Ch. 9 - What is an activity variance and what does it...Ch. 9 - What is a revenue variance and what does it mean?Ch. 9 - 9-7 What is a spending variance and what does it...Ch. 9 - 9-8 What does a flexible budget performance report...Ch. 9 - How does a flexible budget based on two cost...Ch. 9 - 9-10 What assumption is implicitly made about cost...
Ch. 9 - 9-11 What assumption is implicitly made about cost...Ch. 9 - The Excel worksheet form that appears below is to...Ch. 9 - The Excel worksheet form that appears below is to...Ch. 9 - Adger Corporation is a service company that...Ch. 9 - Prob. 2F15Ch. 9 - Prob. 3F15Ch. 9 - Adger Corporation is a service company that...Ch. 9 - Adger Corporation is a service company that...Ch. 9 - Adger Corporation is a service company that...Ch. 9 -
L09-1, LO9-2, LO9-3
Adger Corporation is a...Ch. 9 - Prob. 8F15Ch. 9 - Adger Corporation is a service company that...Ch. 9 - Prob. 10F15Ch. 9 - Prob. 11F15Ch. 9 - Prob. 12F15Ch. 9 - Prob. 13F15Ch. 9 - Prob. 14F15Ch. 9 - Prob. 15F15Ch. 9 - Prob. 1ECh. 9 - Prob. 2ECh. 9 -
EXERCISE 9-3 Revenue and Spending Variances...Ch. 9 - Prob. 4ECh. 9 - Prob. 5ECh. 9 - EXERCISE 9-6 Critique a Variance ReportLO9-6 The...Ch. 9 - Prob. 7ECh. 9 - EXERCISE 9-8 Flexible Budgets and Activity...Ch. 9 - Fixed Cost...Ch. 9 - ...Ch. 9 -
EXERCISE 9-11 Flexible Budget L09-1
Refer to the...Ch. 9 - EXERCISE 9-12 Activity Variances LO9-2
Refer to...Ch. 9 - ...Ch. 9 -
EXERCISE 9-14 Prepare a Flexible Budget...Ch. 9 - Prob. 15ECh. 9 -
EXERCISE 9-16 Flexible Budgets and Revenue and...Ch. 9 - EXERCISE 9-17 Flexible Budget Performance Report...Ch. 9 - Prob. 18ECh. 9 - PROBLEM 919: Flexible Budget Performance Reports;...Ch. 9 -
PROBLEM 9-20 Activity and Spending Variances...Ch. 9 - Prob. 21PCh. 9 - Prob. 22PCh. 9 - Prob. 23PCh. 9 -
PROBLEM 9-24 Critiquing a Report; Preparing a...Ch. 9 -
PROBLEM 9-25 Critiquing a Variance Report;...Ch. 9 - PROBLEM 9-26 Critiquing a Cost Report; Preparing a...Ch. 9 - Prob. 27CCh. 9 - ...Ch. 9 - Prob. 29C
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
- Friendly Bank is attempting to determine the cost behavior of its small business lending operations. One of the major activities is the application activity. Two possible activity drivers have been mentioned: application hours (number of hours to complete the application) and number of applications. The bank controller has accumulated the following data for the setup activity: Required: 1. Estimate a regression equation with application hours as the activity driver and the only independent variable. If the bank forecasts 2,600 application hours for the next month, what will be the budgeted application cost? 2. Estimate a regression equation with number of applications as the activity driver and the only independent variable. If the bank forecasts 80 applications for the next month, what will be the budgeted application cost? 3. Which of the two regression equations do you think does a better job of predicting application costs? Explain. 4. Run a multiple regression to determine the cost equation using both activity drivers. What are the budgeted application costs for 2,600 application hours and 80 applications?arrow_forwardNorton Company, a manufacturer of infant furniture and carriages, is in the initial stages of preparing the annual budget for the coming year. Scott Ford has recently joined Nortons accounting staff and is interested in learning as much as possible about the companys budgeting process. During a recent lunch with Marge Atkins, sales manager, and Pete Granger, production manager, Ford initiated the following conversation. FORD: Since Im new around here and am going to be involved with the preparation of the annual budget, Id be interested in learning how the two of you estimate sales and production numbers. ATKINS: We start out very methodically by looking at recent history, discussing what we know about current accounts, potential customers, and the general state of consumer spending. Then, we add that usual dose of intuition to come up with the best forecast we can. GRANGER: I usually take the sales projections as the basis for my projections. Of course, we have to make an estimate of what this years closing inventories will be, which is sometimes difficult. FORD: Why does that present a problem? There must have been an estimate of closing inventories in the budget for the current year. GRANGER: Those numbers arent always reliable since Marge makes some adjustments to the sales numbers before passing them on to me. FORD: What kind of adjustments? ATKINS: Well, we dont want to fall short of the sales projections so we generally give ourselves a little breathing room by lowering the initial sales projection anywhere from 5 to 10 percent. GRANGER: So, you can see why this years budget is not a very reliable starting point. We always have to adjust the projected production rates as the year progresses, and of course, this changes the ending inventory estimates. By the way, we make similar adjustments to expenses by adding at least 10 percent to the estimates; I think everyone around here does the same thing. Required: 1. Marge Atkins and Pete Granger have described the use of budgetary slack. a. Explain why Atkins and Granger behave in this manner, and describe the benefits they expect to realize from the use of budgetary slack. b. Explain how the use of budgetary slack can adversely affect Atkins and Granger. 2. As a management accountant, Scott Ford believes that the behavior described by Marge Atkins and Pete Granger may be unethical and that he may have an obligation not to support this behavior. By citing the specific standards of competence, confidentiality, integrity, and/or credibility from the Statement of Ethical Professional Practice (in Chapter 1), explain why the use of budgetary slack may be unethical. (CMA adapted)arrow_forwardPerfect Parties, Inc. has several divisions, one of which provides birthday parties at their facility, and has provided the actual and planning budget results for the month of June. The Controller has asked you prepare the Birthday Party Division Budget Performance Report. Please provide me with the FORMULAS needed for each yellow cell. for ex: the planning budget for the number of parties would be =b10 which would then make the answer 80. thank youarrow_forward
- In this task you are provided with an excel file with 2 spread sheets (Budgeted Rooms Revenue Sheet, Actual Rooms Revenue sheet) with the actual figures on the rooms for a given quarter. You are required to calculate the actual revenue that has been generated for each month in the given quarter based on the actual occupancy rate. Calculate the following details using the appropriate sheet as per the given instructions Budgeted Rooms Revenue Sheet Refer to the projected data sheet. In this sheet first calculate the total projected/forecasted revenue per room type for all 365 days. You are also required to calculate total projected/forecasted revenue per room type for each month for Jan, Feb and Mar. Calculate the total rooms for each month Calculate the Total Revenue for all room types for each month Calculate the total projected revenue for 3 months (Jan, Feb and Mar) Actual Rooms Revenue Sheet In this sheet you are provided with the Actual occupancy for each month. Calculate the…arrow_forwardTerry Travers is the manufacturing supervisor of Aurora Manufacturing Company, which produces avariety of plastic products. Some of these products are standard items that are listed in the company’scatalog, while others are made to customer specifications. Each month, Travers receives a performancereport showing the budget for the month, the actual activity, and the variance between budget and actual.Part of Travers’s annual performance evaluation is based on his department’s performance against budget.Aurora’s purchasing manager, Sally Christensen, also receives monthly performance reports and she, too,is evaluated in part on the basis of these reports.The monthly reports for June had just been distributed when Travers met Christensen in the hallwayoutside their offices. Scowling, Travers began the conversation, “I see we have another set of monthlyperformance reports hand-delivered by that not very nice junior employee in the budget office. He seemedpleased to tell me that I’m in…arrow_forwardIn addition to putting the budget in an Excel spreadsheet; the following items are required: Describe three actual team building activities- use actual costs if possible Write a proposal for a Six Sigma project. Project should center around one of the following issues – low attendance, orders being entered into system incorrectly, or high turnover Write an announcement explaining that three positions are being eliminated in November. Keep in mind reassuring the remaining employees that their jobs are not be effected if productivity and profits go up.arrow_forward
- Prepare a 12-month Master Budget for a company of your choosing. It can be a company that you are closely connect too or one randomly selected. COMPLETED IN EXCEL. As you are preparing the Master Budget, some information is NOT provided. You are required to decide or predict or forecast this information. Provide an introduction for the company you have chosen. The introduction should include the following: Name of company Location of company Name of owner Nature of the business. Type of product Fiscal period For the company that you have selected - Prepare a 12-month Master Budget. Your submission must show each month’s activities. Here are some considerations to include in preparing the budget: You must forecast your sales, purchases, direct labour and manufacturing overhead for each month and any other information as required All sales are on accounts Expected collections are to be 50% in the month of the sale, 30 % in the first month following the sale, and 20% in the second…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_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
- Pease Contractors is a local home remodeling company. In analyzing financial performance, the accountant compares actual results with a flexible budget. The standard direct labor rates used in the flexible budget are established each year at the time the annual plan is formulated and held constant for the entire year. The standard direct labor rates in effect for the current fiscal year and the standard hours allowed for the actual output of work for August are shown in the following schedule. Worker Classification Standard Direct Labor Rate per Hour Standard Direct Labor-Hours Allowed for Output Supervisor $ 50 1,800 Skilled 30 2,250 General 20 4,950 The actual direct labor-hours worked and the actual direct labor rates per hour experienced for the month of August were as follows. Worker Classification Actual Direct Labor Rate per Hour Actual Direct Labor-Hours Supervisor $ 54 2,112 Skilled 32 2,112 General 18 5,376 Required: Calculate the dollar…arrow_forwardThe controller of the Stump Company is preparing the budget for 2021 and needs to estimate a cost function for delivery costs. Information regarding delivery costs incurred in the prior 2 months are: LOADING... (Click the icon to view the information.) Requirements 1. Estimate the cost function for delivery. 2. Can the constant in the cost function be used as an estimate of fixed delivery cost per month? Explain. Requirement 1. Estimate the cost function for delivery. Delivery costs = + ( × ) Delivery costs = + ( × ) Requirement 2. Can the constant in the cost function be used as an estimate of fixed delivery cost per month? Explain. The cost function in requirement 1 is an estimate of how costs behave ▼ outside of within the relevant range, not at cost levels ▼ outside within the relevant range. If there are no months with zero miles driven represented in the delivery cost…arrow_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_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
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
IAS 29 Financial Reporting in Hyperinflationary Economies: Summary 2021; Author: Silvia of CPDbox;https://www.youtube.com/watch?v=55luVuTYLY8;License: Standard Youtube License