Prepare a master budget and a flexible budget in this

 

Prepare a master budget and a flexible budget in this two-part assessment.

Introduction

Note: Accounting requires specific steps that need to be executed in a sequence. The assessments in this course are presented in sequence and must be completed in order.

A master budget is a management tool for planning. A flexible budget provides crucial information for differing levels of business activity.

A master budget is a formal planning tool used to chart the organization’s future. Compiling a master budget serves to provide the financial information needed to make decisions, choose strategies, and create action plans. A master budget also helps to communicate the organization’s expenses to all employees.

Overview

Note: Accounting requires specific steps that need to be executed in a sequence. The assessments in this course are presented in sequence and must be completed in order.

A master budget is a formal planning tool used to chart the organization’s future. Compiling a master budget serves to provide the financial information needed to make decisions, choose strategies, and create action plans. A master budget also helps to communicate the organization’s expenses to all employees.

Instructions

This assessment has two parts.

Part A

For Part A, use the Master Budget Preparation Template [XLSX]. Based on the data in the template, which represents a company’s estimated balance sheet, prepare a complete master budget.

Part B

For Part B, use the Master Budget Preparation Template [XLSX]. Based on the data in the template, complete the problems on flexible budget preparation and computation of materials.

Competencies Measured

By successfully completing this assessment, you will demonstrate your proficiency in the course competencies through the following assessment scoring guide criteria:

  • Competency 1: Analyze cost accounting systems.
    • Compute the cost for each variable overhead item and its total per-unit costs and the total fixed costs.
  • Competency 2: Apply sound budgeting principles.
    • Construct a monthly selling expense budget.
    • Construct a monthly general and administrative expense budget.
    • Construct a monthly capital expenditures budget.
    • Construct a monthly cash budget.
    • Construct a budgeted income statement for a calendar quarter.
    • Construct a budgeted balance sheet for a calendar quarter.
    • Calculate the direct materials cost variance, including its price and quantity variances.
    • Calculate the direct labor cost variance, including its rate and efficiency variances.
    • Construct flexible overhead budgets for a calendar month.
  • Competency 4: Analyze financial statements.
    • Construct a monthly merchandise purchases budget.
    • Construct a monthly sales budget showing both budgeted unit sales and dollar sales.
    • Construct a detailed overhead variance report that shows variances for individual items of overhead.
  • Competency 5: Communicate in a manner that is professional and consistent with expectations for professionals in the field of accounting.
    • Communicate quantitative information accurately and effectively.

Share This Post

Email
WhatsApp
Facebook
Twitter
LinkedIn
Pinterest
Reddit

Order a Similar Paper and get 15% Discount on your First Order

Related Questions

Please respond to 2 peers My Initial post : Corporate

Please respond to 2 peers My Initial post :   Corporate governance is system by which company is required to conduct their business considering procedure of managing company. The board of director of company is responsible to manage corporate governance in a company. For effective corporate governance board of directors

Rural Health Care is a growing and demanding delivery model.

  Rural Health Care is a growing and demanding delivery model. Of the policies which address rural care the National Health Service Corps (NHSC) has been one of the most important. Explain the role of the National Health Service Corp (NHSC) and some of the efforts it makes and benefits

In your educational journey, you have been asked to do

  In your educational journey, you have been asked to do literature reviews and annotated bibliographies. In this course, you have been taught to use literature to solve a problem. This is different than filling a gap in the literature or adding to the body of knowledge. In your own

The laboratory plays an important role in the investigation and

  The laboratory plays an important role in the investigation and identification of the cause of food-borne illness outbreaks. The lab can be a much more important, and less celebrated, tool to prevent an outbreak of disease. Which steps of the food processing and distribution systems are of the most

Task- Respond to this post in a minimum of 125

 Task- Respond to this post in a minimum of 125 words.  NO references Needed The emerging technology I want to discuss is Block Chain. Blockchain has developed to have a few distinct applications till date ranging from financial sector to medical sector. Any industry that has a need to have its information

A research paper on a major environmental law

Write a research paper on a major environmental law (e.g., RCRA, CERCLA, Clean Air Act, Clean Water Act, Safe Drinking Water Act, TSCA, FIFRA, Energy Policy Act, Endangered Species Act, or any other that you would consider major). Your paper should discuss the following: why the law was enacted controversies

oday, there are various “stake holders,” people who have an

  oday, there are various “stake holders,” people who have an interest, in our federal, state, and local governments.  This was not obviously the case before our 1787 Founders met at their Constitutional Convention in Philadelphia.  They thought of politics rather simplistically, seeing the need for only a legislature, executive,

Week 1 Discussion: The First Total War No unread replies.11

   Week 1 Discussion: The First Total War No unread replies.11 reply. Required ResourcesRead/review the following resources for this activity: · Textbook: Chapter 2, 4 · Lesson · Minimum of 1 scholarly source (in addition to the textbook) Initial Post InstructionsWorld War I is different from most other wars in

Using your Budget workbook, generate the following graphs and sparklines

Using your Budget workbook, generate the following graphs and sparklines as described. Following criteria is minimum, but you should be creative and use as much topics as you learned in this section. For the Budget and Actuals, create a column chart to show your Budget versus Actuals create a combination

A 42-year-old woman has noticed dry skin, fatigue, and weight

  A 42-year-old woman has noticed dry skin, fatigue, and weight gain over the past 3 months. Her blood pressure is 110/70 mm Hg, pulse 60/min, and heart and lungs are normal. Her skin feels rough and dry, but the rest of her examination is normal. Her biochemistry is normal,

Each day, we use the Internet on our personal computers

 Each day, we use the Internet on our personal computers and mobile devices to access information and purchase goods. Websites often have their own mobile form factor while others maintain the same Website user experience, creating challenges when trying to use navigation, overcome errors, search, and complete the most mundane

Strange Case of Dr. Jekyll and Mr. Hyde.

 Read over Chapters 1-6 of Strange Case of Dr. Jekyll and Mr. Hyde. A free link to the book is provided below. Then follow the directions listed below and attached materials to complete the assignment. http://www.gutenberg.org/ebooks/43?msg=welcome_stranger INSTRUCTIONS: Imagine that you’re working at a company that wants to publish a new

Excel Webinar

watch all of the webinars that were hosted by SPS. While watching the webinars, use the excel spreadsheet attached here to simulate the presenter’s data. These videos contain lots of great information about using HIM data in excel. Once all videos are reviewed, specifically state what information you gleaned from

People Process Programme A visual representation of a case study –

A stakeholder is anyone with an interest in the project or business. Typically, they are independent parties who contribute to the process or outcome of a project. They are also investors and continue to partake into the project in regard to further developments and enhancing it.   Stakeholders:   § 

QUESTION 1 : List in a bulleted fashion four ways

QUESTION 1 :  List in a bulleted fashion four ways that teachers can engage in culturally responsive teaching.  Then for each of those ways provide a specific example of how a teacher might do this.    QUESTION 2:  Mrs. Ross is unfamiliar with the Japanese culture.  She wants to be a