Calculate the flexed and actual budget

Assignment Help Finance Basics
Reference no: EM132443192

Orchid Ltd. is a small furniture manufacturer. It was established as a family-owned business 30 years ago and prides itself on high-quality products. Most of its products are made to order as a result of direct orders from Internet-based sales. Typically the company has been profitable, operating at the top end of the market; recently, however, costs appear to have been increasing and the company has also seen a decline in its sales. The workforce is highly skilled and recently several of the experienced craftspeople who make the products have retired, and the company has had problems recruiting, training and retaining suitably skilled employees. One of its products, a table, has the following standard costs:

  £
Direct materials (8m @  £30/m)  240.00
Direct labour (10 hours @ £25/hr)  250.00
Fixed overheads 160.00
  650.00
Selling price 950.00
Standard profit margin 300.00

The table is made from solid oak and the above materials reflect the size of the table in square metres. The labour required to make the table is highly skilled.

The monthly production and sales are planned to be 800 units. The actual results for March were as follows:

  £  
Sales revenue 753,300  
Less      
  Direct materials (192,500) (7,000m)
Direct labour (221,000)  (8500 hours)
Fixed overheads (130,000)  
Operating profit 209,800  

There were no opening or closing stocks. The company manufactured and sold 810 tables; this is more than budgeted due to a successful marketing campaign.

Required

Parts 1 and 2 should be submitted as an operating statement, as per your Key Concept Overview, and within the Business Report as required for part 3.

  1. Calculate the flexed and actual budget.
  2. Calculate the following variances:
    • Sales variances; volume and price
    • Direct material variances; usage and price
    • Direct labour variances; efficiency and rate
    • Fixed overhead variance; spending
  3. Present the above information as a part of a Business Report, providing possible explanations for the variances that you have calculated and suggestions as to how the company might try to improve its cost control.

Reference no: EM132443192

Questions Cloud

Locate the liabilities section of the balance sheet : Locate the liabilities section of the balance sheet of both firms- Wal-Mart and Target for year 2015 and provide an overall analysis of each company.
Discuss the energy efficiency initiative in hospitals : Evaluation of how your initiative will improve patient care and outcomes.Analysis of the costs and benefits associated with your initiative
Discuss some of the challenges faced in its implementation : Provide an example of an IT project from your readings, experience, and/or other sources and discuss some of the challenges faced in its implementation.
State the two priority nursing diagnoses : State the two priority nursing diagnoses.List 2 categories of medications that you may be administering to this pt and give an example in each category
Calculate the flexed and actual budget : Calculate the flexed and actual budget. Calculate the following variances:
Evaluate project management software for overall project : Explain how the software addresses the requirements of the stages of a project plan - evaluate project management software for overall project performance
What is the difference between compiletime and runtime : Research the concept of compilation with regards to code. What is the difference between compiletime and runtime?
Discuss effective strategy for resolving workplace conflict : Discuss effective strategies for resolving workplace conflict and encouraging interprofessional collaboration.Outline the purpose of an organization's mission
Discuss the experimental and nonexperimental research design : Discuss and Provide examples of experimental and nonexperimental research design. Contrast the levels of control applied to each.

Reviews

Write a Review

Finance Basics Questions & Answers

  Use technology to help establish a personal financial plan

specifically address the following required elements1. use working knowledge of personal finance to construct a

  Calculation of discount rate for cash flows

What is the future value at year 3 of the following set of cash flows if the appropriate discount rate is 11%?

  Wilsons realty has total assets of 46800 net fixed assets

wilsons realty has total assets of 46800 net fixed assets of 37400 current liabilities of 6100 and long-term

  What will the price-earnings ratio of the postmerger firm

If there are no synergy gains, what will the share price of A be after the merger? What will the price-earnings ratio be? What does your answer for the share price tell you about the amount A bid for B? Was it too high? Too low? Explain.

  What is the yield to maturity

It has 10.00 years to maturity and a coupon rate of 5.00%. Par value is $1,000. What is the yield to maturity?

  Accounting team for assessments

As in many other cases, the finance manager will work closely with the accounting team for such assessments of capital structure as suggested by M&M.

  What kind of adjustment to cost of goods sold would have

What kind of adjustment to Cost of Goods Sold (debit or credit) would have the effect of boosting earnings?

  Prefer using the profitability index approach

With a total budget of $500,000 and given the following data, which project or project combination would you prefer using the Profitability Index Approach?

  Project net present value

What is the project"s net present value?

  Seaboard shipping company

Compute L, Lq, W, and Wq. (Round answers to 1 decimal place, e.g. 15.5.)

  Determining the npv of reggie redbird

Reggie Redbird, the CEO of University Park Minivans, Inc. believes that the firm could create additional value by adding golf carts to its product mix.

  The analyst used the overall beta to value

The risk-free rate is 2% and the implied equity premium is 6 %. Your firm's overall bottom-up unlevered beta is 1.2. When examining the latest valuations for a potential investment in a new factory, however, you notice that the analyst used the overa..

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