Reference no: EM13948249
Task Details:
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" [down the column] for each product):
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" [down the column] for each product):
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.
Attachment:- Assignment Standard Costing and Variances Transit.xlsx
Design the program so that it automatically counts
: Label all output, and design the program so that it automatically counts the respondents.
|
Isothermal transformation diagram
: Make a copy of the isothermal transformation diagram for an iron-carbon alloy of eutectoid composition (Figure 10.22) and then sketch and label time-temperature paths on this diagram to produce the following microstructures:
|
Compute the payback period for the new equipment
: Compute the payback period for the new equipment. Compute the accounting rate of return using both original investment and average investment.
|
Driving force for the formation of spheroidite
: 1. Briefly cite the differences between pearlite, bainite, and spheroidite relative to micro structure and mechanical properties. 2. What is the driving force for the formation of spheroidite?
|
Costing system in the world in manufacturing firms
: 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.
|
Transform the 2 relations into domain/key normal form
: Transform the following 2 relations into Domain/Key Normal Form (DK/NF). Make and state the appropriate assumptions about functional dependencies and domains.
|
Should the company keep the old computer
: Madison Company is considering replacing its existing mainframe computer with a new model manufactured by a different company. Compute NPV of each alternative. Should the company keep the old computer, or buy the new one?
|
Calculate the critical radius and the number of stable
: 1. (a) Assume for the solidification of nickel (Problem 10.4) that nucleation is homogeneous, and the number of stable nuclei is 106 nuclei per cubic meter. Calculate the critical radius and the number of stable nuclei that exist at the followi..
|
What are the elements of capital in corporations
: What are the elements of capital in corporations? What is the difference between a loan awarded to the company and the company issuing stock to shareholders? what would a debt/equity ratio tell you about a company?
|