How do spreadsheets aid application of sensitivity analysis

Assignment Help Financial Accounting
Reference no: EM131051941

Problem 1 - Planning and Control

Write an essay of 1000 words demonstrating your conceptual understanding of the following Problems.

1. Is budgeting used primarily for scorekeeping, attention, directing or problem solving?
2. How do strategic planning, long range planning and budgeting differ?
3. Why is budgeted performance better than past performance as a basis for judging actual results?
4. What are the major benefits of budgeting?
5. Is budgeting an unnecessary burden for day to day problems? Explain your answer.
6. Why is the sales forecast the starting point for budgeting?
7. How do Spreadsheets aid the application of sensitivity analysis?

Problem 2 - Budget Preparation - Intellectual and Practical Skills

Application of learning:

Prepare the following budgets for the 6 months ending September 2013. You are required to use Excel spreadsheets, which can be copied into word once you finish, should you wish. A template is available for you to use as a basis.

a) Sales budget
b) Cash Budget
c) Debtors Budget
d) Creditors Budget
e) Production Cost Budget
f) Raw Materials and finished goods Budget
g) Profit and Loss Account Budget
h) Balance Sheet Budget

Draw conclusions from your budgets and prepare a short management report.

Europe Ltd
Balance Sheet as at 31st March 2013

Fixed Assets

£

£

Current Assets

 

100,000

Debtors (Feb E10000, March E14000)

24,000


Stock Raw Materials

9,000


Finished Goods

13,000


 

46,000


Current Liabilities

 


Creditors (Feb E8000, March E10000)

18,000


Bank

(3,000)


 

21,000


Net Current Assets / Working Capital


25,030

NET ASSETS


125,000

Financed by:

 


Share Capital

 

100,000

Profit and Loss


25,000

TOTAL SHAREHOLDERS FUNDS


125,000


Notes:
-Fixed Assets are depreciated at 20% straight line method per year.
-Purchases will be £5,000 in April, increasing by £1000 per month and paid 2 months after purchase.
-Sales in April will be £20,000, increasing by £2,000 per month and paid 2 months in arrears.
-Production costs per unit will be:
o Direct materials £15
o Direct Labour £12
o Production overheads £5
-Direct Labour and production overheads are paid as they are incurred.
-Production units per month are 500 units
-Sales units in April are 400 units, increasing by 40 units per month.
-Expenses run at £10,000 per month, paid in the month that they are incurred.

Reference no: EM131051941

Questions Cloud

Occurring in the business environment : 1. Go to the National Taxpayers Union website (www.ntu.org). Search for "Who Pays Income Taxes? See Who Pays What." Study the tables showing what percentage of taxes the various income groups pay. Do you think that businesspeople pay their fair sh..
Coasts of the west and the east of usa : Describe the general differences (shape & size) between the coasts of the west and the east of USA. In general, why are they different?
The technological and e-commerce revolutions : Form into teams of four or five and discuss the technological and e-commerce revolutions. How many students now shop for goods and services online? What have been their experiences?
What do you feel wortham means in the above quote : In what ways might culture impact assessments (i.e. language barriers)? Finally, think back to how you viewed assessment at the start of this course. How have your views of assessment changed? How will the knowledge you have gained of assessment s..
How do spreadsheets aid application of sensitivity analysis : How do Spreadsheets aid the application of sensitivity analysis? Is budgeting an unnecessary burden for day to day problems? Explain your answer.
Suffering agonizing pain : John has been suffering agonizing pain with each breath and has been informed by the physician that he has pleurisy. (a) Specifically, what membranes are involved in this condition?  (b) What is their usual role in the body?  (c) Explain why John'..
Progressive muscle wasting : Parents of a toddler boy noticed he began to walk on his toes, was falling often, and struggled to stand back up. Over time it became more difficult for him to life his knees high, which affected his ability to run. At age six, doctors noted that ..
The united states enjoy a high standard of living : What indicates that you and other people in the United States have a high standard of living? What are some signs that maintaining such a high standard of living may have a negative impact on quality of life?
Photosynthetic dark reactions : C4 plants have an altered the strategy by which the CO2 in photosynthetic dark reactions is "fixed".This "improved strategy" is intended to address what"negative property" of the enzyme rubisco?

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