Managerial Accounting
15th Edition
ISBN: 9780078025631
Author: Ray H Garrison, Eric Noreen, Peter C. Brewer Professor
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
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…
help me provide the sales budget for the 4th quarter of 2014 ( 2nd photo attached)
FORMAT NEEDED AND used for the sales budget of 2014 ( refer to first attached photo)
please help me provide the 1st,2nd,3rd, and 4th quarter budget sales of martins sales budget.
to be answered: ( 1st picture)
example of format is attached ( 2nd picture)
Chapter 9 Solutions
Managerial Accounting
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 - Prob. 19PCh. 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 - Prob. 26CCh. 9 - ...Ch. 9 - Prob. 28C
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
- How do I solve for the chart?arrow_forwardPrior midnight March 11, post at least once about this week's Wiley assignment. You may post asking your fellow learners for help or share your own insight as you work through the assignment. Some guiding points: - - What is the first step you will take to successfully complete a budget for yourself ? - What are some of the challenges in creating a budget for a company?arrow_forwardSelect a current issue for which you can find background material. Become familiar with the issue and build a budget request that provides a solution to the issue. If a solution is already publicly available, work through the data so that you can re-create the budget request. Prepare a verbal briefing of no more than 10 minutes that reviews the background of the issue, identifies why it must be addressed, describes what your proposal will do to address the issue, and gives the amount of your budget request.arrow_forward
- First Discussion Board Post (due Wednesday) In your internet browser, search for the terms "Participatory Budgeting" and "Budgetary Slack." Review a few of the results so you understand what the terms mean and the implications when used by managers. Then, read the "Ethics Challenge" near the end of the Master Budgeting chapter problems in your textbook. Required: Share your responses to the following questions with your classmates. Based on your reading: 1. Do you think Granger Stokes is using budgets appropriately? 2. What sort of behavioral consequences may occur as a result of the way budgets are used at Prime Drive? 3. What would you do if you were in Keri Kalani's position?arrow_forwardPrepare 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_forwardScenario You are the project manager working on a Market Mailing project. The client informed your project team during the project planning phase that the project must be completed on time in order to sync with the launch of the new product. Also, the client informed you and the team that there is no cash reserve for the project so the project has to be completed within budget. Below is the status update that two project team members (Jennifer and Ben) put together. Based on the project's performance to date, complete the Rating Project Risk exercise on the next page. Task| Budgeted Actual Percent works Estimate Planned Planned Actual Projected| Planned to Actual Resource Resource Utilization Utilization works end date work complete complete date start start date end cost cost date to date 60 hours I $600 50 hours I $500 June 15 March June 15 120 hours / $1200 120 hours / $1200 A 30% 90 hours March 25% 30% I $900 15 30 May 15 April 8 B 30% April 1 May 30 30% 60 hours I $600 50% Rating…arrow_forward
- please answer within the format by providing formula the detailed workingPlease provide answer in text (Without image)Please provide answer in text (Without image)Please provide answer in text (Without image)arrow_forwardplease help me provide the sales budget for the 4th quarter of 2014, FORMAT: sales budget format for the 4th quarter.arrow_forwardIn 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_forward
- Barlow Company manufactures book bags and has provided the following information for June 2018: E (Click the icon to view the information.) Requirements 1. Prepare a flexible budget performance report. (Hint: You will need to calculate the flexible budget amounts for 10,000 units.) 2. As the company owner, which employees would you praise or criticize after you analyze this performance report? Requirement 1. Prepare a flexible budget performance report. (Hint. You will need to calculate the flexible budget amounts for 10,000 units.) (Enter a "0" for any zero balances. For any $0 variances, leave the Favorable (F)/Unfavorable (U) input blank. Enter all amounts as positive values.) Barlow Company Flexible Budget Performance Report For the Month Ended June 30, 2018 1 2 3 4 - X Data Table (1) - (3) (3) - (5) Budget Flexible Sales Amounts Actual Budget Flexible Volume Static Static Budget Actual Results Per Unit Results Variance Budget Variance Budget Units 10,000 11,000 Units Sales Revenue…arrow_forwardDon't use AI.arrow_forward3. Using the format demonstrated in your textbook - Prepare the following budgets (be sure to show/demonstrate ALL calculations - include quarterly AND yearly totals) in excel or google drive: a. production budget b. direct materials budget c. direct labor budget d. manufacturing overhead budget e. selling and administrative budgetarrow_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