Calculate the flexed and actual budget

Assignment Help Financial Accounting
Reference no: EM131025758

Case Study Assignment - Budgets and variances

For this assignment, you will provide possible explanations for the variances that you have calculated and suggestions as to how the company might try to improve its cost control.

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.

A. Calculate the flexed and actual budget.

B. Calculate the following variances:
o Sales variances; volume and price
o Direct material variances; usage and price
o Direct labour variances; efficiency and rate
o Fixed overhead variance; spending

C. 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.

This assignment should be around 1,000 words for the main body of your Business Report.

Reference no: EM131025758

Questions Cloud

Show that s and t are linear and st is not equal to ts : Let X be a finite dimensional linear space. Show that, for every subspace Y of X, Y perp perp = Y (that is, the annihilator of the annihilator of Y is Y)
Streams of cash flows-future cash flows in stream : Consider two streams of cash flows, A & B. Stream A's first cash flow is $8,900 and is received three years from today. Future cash flows in Stream A grow by 4 percent in perpetuity. Stream B's first cash flow is -$10,000, is received two years from ..
What is the geometric average return on this stock : Over the past four years a stock had prices of 15.40, 15.85, 16.30, and 15.70, respectively. The stock pays an annual dividene of .50 a share. What is the geometric average return on this stock please show work
Appropriate discount rate to reflect risk of the strategy : Capital budgeting analysis is not a framework for evaluating all business decisions; it is only a tool for the “financial” types. Proper analysis will identify irrelevant cash flows and an appropriate discount rate to reflect the risk of the strategy..
Calculate the flexed and actual budget : Calculate the flexed and actual budget and calculate the variances - Sales variances, volume and price and direct material variances, usage and price
Determine the voltage induced in the wire segment : A 20-cm length of wire moves at 15m/s in a constant flux density of 0.4T. The wire, direction of motion, and direction of the flux are mutually perpendicular. Determine the voltage induced in the wire segment.
Find the slope and the y-intercept for theline y= - x+5 : Find the slope of the line through the points (0, 4) and (5, 0)
Determine the voltage induced in the coil : Suppose we have a ten-turn square coil 25 cm on each side lying in the x-y plane. A magnetic flux density is directed in the positive z direction and is given by 0.7 sin(120πt) T. The flux is constant with respect to x, y, and z. Determine the vol..

Reviews

Write a Review

Financial Accounting Questions & Answers

  Use managerial accounting information

Identify a publicly traded company, and explain three ways that this company might use managerial accounting information. Do not select a company that one of your classmates has already posted on. Participate in discussion by suggesting additional wa..

  Determine cost of goods sold amounts to record

Quadrado uses the LIFO method to account for inventory costs. Determine cost of goods sold amounts to record dor the three months ending September 30,2011.

  Question marina del rey manufacturing corp uses a typical

question marina del rey manufacturing corp. uses a typical cost system that records raw materials at real cost records

  Account balances

Normal 0 false false false EN-US X-NONE X-NONE MicrosoftInternetExplorer4 ..

  List of vendors with account balances sorted

Management wants a list of vendors with account balances sorted from the largest to the smallest amount outstanding. The following columns are to be included from left to right: active status, vendor name, balance payable, type of vendor, and terms.

  What is the incremental effect on net income if division

If this division is eliminated, the fixed expenses will be allocated to the company's other divisions. What is the incremental effect on net income if the division is dropped?

  What was free cash flow for the fiscal year ended in 2011

Does Lowe's use the direct or indirect method to report cash flows from operating activities? How can you be sure about this? Include in your answer the first three items in the Cash from Operations section.

  Zero coupon bond

Zero Coupon Bonds [LO2] Suppose your company needs to raise $ 45 million and you want to issue 30- year bonds for this purpose. Assume the required return on your bond issue will be 6 percent, and you're evaluating two issue alternatives: a 6 percent..

  Santana rey is considering the purchase of equipment for

santana rey is considering the purchase of equipment for business solutions that would allow the company to add a new

  Abc organization unadjusted trial balance as of 31 december

abc organization unadjusted trial balance as of 31 december 2012account codes dr cr cash 10789furniture and fixtures

  Effect on return on equity of raising capital through debt

Debt has deadlines. Deadlines can be missed. Common stock lasts indefinitely. The higher percentage of resources raised from debt, the higher percentage resources subject to deadlines, hence risk. What is the effect on return on equity of raising cap..

  Compute the selling price per composite chair

Success system sells upscale modular desk units and office chairs in the ratio of 3:2 (desk unit: chair). The selling prices are $1,250 per desk and $500 per chair. The variable cost are $750 per desk unit and $250 per chair. Fixed cost are $120,000.

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