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