Prepare an excel spreadsheet that contains a flexible budget

Assignment Help Financial Accounting
Reference no: EM13877041

Generating a Flexible Budget Balmer Corporation's master (static) budget for the year is shown below:

Sales (50,000 units) Cost of goods sold: Direct materials

$150,000

$1,600,000

Direct labor

450,000


Overhead (Variable overhead



applied at 40% of direct labor cost)

240,000

840,000

Gross profit


$ 760,000

Selling expenses:



Sales commissions (all variable)

$160,000


Rent (all fixed)

40,000


Insurance (all fixed)

30,000


General expenses:



Salaries (all fixed)

92,000


Rent (all fixed)

77,000


Depreciation (all fixed)

51,000

450,000

Operating income


$ 310,000

Required

1. During the year the company actually manufactured and sold 42,000 units of product. Prepare an Excel spreadsheet that contains a flexible budget for this level of output.

2. Suppose, however, that the actual level of output had been 52,000 units of output. Rerun your spread- sheet to generate a flexible budget for this level of output.

3. Of what relevance is the notion of "relevant range" when preparing pro forma budgets or a flexible budget for control purposes?

Reference no: EM13877041

Questions Cloud

Discuss the nature of exploitive colonies : Discuss the nature of exploitive colonies and give detailed examples. Describe how and why slavery systems were established to support exploitive colonies. Define " triangle trade systems"
Determine the direct labor efficiency varianc for october : Determine the following for October: Direct labor rate variance. Direct labor efficiency variance. Production manager's performance in managing direct labor costs.
What are the legal boundaries of an employees privacy : Find out if making these messages accessible violated the federal Wiretap Act. Quon v. Arch Wireless Operating Co., Inc., 145 F.Supp.2d 1116 - Can you articulate any privacy claims the employees might make?
What types of competitive strategies are the most effective : What types of competitive strategies are the most effective? Will the same strategy work in most venues? Why or why not? Supplement your answer with examples of organizations and their strategies as appropriate
Prepare an excel spreadsheet that contains a flexible budget : During the year the company actually manufactured and sold 42,000 units of product. Prepare an Excel spreadsheet that contains a flexible budget for this level of output.
Genetic information in promotion decisions : Find out whether The Genetic Information and Nondiscrimination Act of 2005, a proposed federal law that would extend protection against to private employees has become law. If not, has other federal legislation aimed at genetic testing been adopte..
What is the annual rate of growth of the population : Use Method One and find an exponential function Pt = cat for the US population.
How does that change the ethical calculus : Since then, genetic tests have become available for as little as $100, and direct-to-consumer testing is available over the Internet. How does that change the ethical calculus?
Estimates be the same as the estimates in the last problem : Use method One and find a natural exponential function M1t = ceβ t for the US money supply and Use the model and estimate the US money supply for months of August and September of 2012.

Reviews

Write a Review

Financial Accounting Questions & Answers

  Financial statement analysis and preparation

Financial Statement Analysis and Preparation

  Shareholder of a company

Describe the ways that a person can become a shareholder of a company. Why Wal-Mart would split its stock?

  Financial and accounting principles

An understanding of financial and accounting principles can be a valuable tool for managers. While not all managers will find themselves calculating financial ratios or preparing annual financial data.

  Prepare a statement of cash flow using the direct method

Prepare a Statement of Cash Flow using the Direct Method and Prepare the Operations section of the Statement of Cash Flow using the Indirect Method.

  Financial accounting assignment

This assignment has one case study and two question apart from case study. Questions related to document Liquidation question and Company financial statements question - Torquay Limited

  Prepare general journal entries for goela

Prepare general journal entries for Goela Ltd

  Principles of financial accounting

Prepare the journal entry to record the acquisition of the assets.

  Prepare general journal entries to record the transactions

Prepare general journal entries to record the transactions, assuming use of the periodic inventory system

  Global reporting initiative

Compare the view espoused by the economist Milton Friedman about the social responsibilities of business with the views express by Stigler.

  Explain the iasb conceptual frameworks

Explain the IASB Conceptual Framework's perspective of users and their decisions.

  Determine the company''s financial statements

T he focus of the report is to determine the extent to which you are comfortable relying on the financial statements as presented by management .

  Computation of free cash flow

Computation of Free Cash Flow

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd