Reference no: EM13947795
SUMMARY of Task Specification
Case study: Coachbuilders Limited
You will be assessed according to the following criteria:
Accuracy of calculations and use of electronic worksheet formulas
Quality of written report and descriptive materials (and referencing)
All submissions must be accompanied by a signed KOI Assignment Coversheet.
Task Details:
(Specific requirements)
Students are to use the MS Excel Worksheet related to Coachbuilders' 65 Seat Bus project and calculate and review ALL of the following Standard Cost variances:
Direct Material Variances (These can be calculated for EACH line item [ROW] AND "Summed"
Direct Material Price Variance (DMPV)
Direct Material Quantity Variance (DMQV)
Total Direct Material Variance (Sum the above two variances and check if it equals total difference between the budgeted/standard cost and actual cost - it should!)
Direct Labour Variances (These can be calculated for EACH line item [ROW] AND "Summed"
Direct Labour Rate Variance (DLRV)
Direct Labour Efficiency Variance (DLEV)
Total Direct Labour Variance (Sum the above two variances and check if it equals total difference between the budgeted/standard cost and actual cost - it should!)
Variable Overhead:
Standard Variable Spending Variance (SVOHD Spending Variance)
Standard Variable Efficiency Variance (SVOHD Efficiency Variance)
Fixed Overhead:
Standard Fixed Spending Variance (SFOHD Spending Variance)
Standard Fixed Overhead Production-Volume Variance (SFOHD Volume Variance)
PLUS: Over [or Under] applied Fixed Overhead
Students should comment briefly (500-700 word report) on the overall cost and business outcome of Coachbuilders' 65 Seat Bus project based on the standard cost variances calculated. Please DO NOT simply re-write the actual numbers in your summary, these can be seen by the tutors in your Excel workbook when they review your submission! Rather, comment on the size and type of variances and whether you believe Coachbuilders are managing costs well or not.
Were there any great results or ‘EXCEPTIONS' that you believe should be investigated further?
Is there anything else? A brief explanation to be written and submitted on the topic given below.
Why do you think standard costing is the most widely used costing system in the world in manufacturing firms, even though more sophisticated systems might be available? Discuss. (One or two paragraphs should be sufficient.)
Attachment:- excel sheet.xlsx
Estimate average relative density of sand
: Assume the uniformity coefficient sCud of the sand to be 2.8 and an overconsolidation ratio (OCR) of 2. Estimate the average relative density of the sand between the depth of 3 to 6 m. Use Eq. (3.21).
|
Write differences between podcasts and streaming media
: What are the differences between podcasts and streaming media
|
Cause companies to better market their products and services
: Should there be an increase in regulation enacted to cause companies to better market their products and services? Why or why not? Provide an example to support your response.
|
Design of a shallow foundation
: Using Eq. (3.30), determine the variation of the peak soil friction angle, f9. Estimate an average value of f9 for the design of a shallow foundation. (Note: For depth greater than 20 ft, the unit weight of soil is 118 lb/ft3.)
|
Why do you think standard costing is the most widely used
: Accuracy of calculations and use of electronic worksheet formulas - Quality of written report and descriptive materials (and referencing) - Why do you think standard costing is the most widely used costing system in the world in manufacturing firms,..
|
Dives off of a raft - what happens to the diver
: A tennis racquet hits a tennis ball. Why doesn't the racquet swing backwards when the ball hits it? (Shouldn't it swing back because of action-reaction forces?)
|
Discuss your own perception of students with an id
: Identify at least two appropriate classroom instruction accommodations for students with an ID and explain their relevance. Use outside resources or websites in order to find the information, and cite them within your response. Discuss your own pe..
|
The company refused to pay, contending that the employees
: The company refused to pay, contending that the employees were at-will and there was no enforceable contract, the alleged agreement was illusory and, in any case, it violated the statute of frauds because it took more than one year to come into effec..
|
Create a visual c-sharp program for an ice cream shop.
: Create an Order class that includes a Customer object and an array of 10 Cone objects (the maximum number of ice cream cones a customer can order is 10).
|