Looking for help with an assignment? Connect with an assignment Expert Now!

Determine the material variances using the Excel template provided.

Determine the material variances using the Excel template provided.. In this assignment, you will be looking at both material and labor variances for Dr. Mitchell Olander’s Orthodontic practice and providing the doctor with recommendations based on your analysis.

Dr. Mitchell Olander has established a standard of 4 labor hours per device.   He pays his technician $25.00 per hour even though the market rate for technicians is $23.00 per hour since the technician has over 10 years of experience.   During the most recent month 1,280 devices were made and it actually took the technician about 60% more time to make these devices. In addition, Dr. Olander changed to a new vendor for the material that goes into the devices.  He was paying $17.20 per unit but the new vendor is selling the material for $15.00 per unit.  Each device typically takes (standard) 3 units of material to make but Dr. Olander notices that this month it actually took 5 units of material per device.

Prepare a 6 page narrative report (including exhibits) in Microsoft Word (using the template provided) with at least 2 scholarly sources. You will embed a Microsoft Excel spreadsheet with your calculations into your Word document. Follow the template provided for the calculations. The narrative explanation requires the use of proper APA format, complete sentences and citations in APA format. Written in third-person perspective. New Times Roman, Size 12.

1. Determine the material variances using the Excel template provided. Be sure to calculate total quantity.

2. Determine the labor variances using the Excel template provided. Be sure to calculate total hours.

Review the results and discuss what these results indicate to you as a manager and how you will use this information to assist Dr. Olander making future decisions about the materials and labor costs used in his practice.  Be sure to include in your discussion a detailed explanation how you would investigate the unfavorable variances further and/or how you plan to improve performance in areas with unfavorable variance.

Submit your work in the “Week 6 Case Format Template.docx” document embedding the calculations from the “Week 6 Case Excel Template.xlsx” spreadsheet provided.

Determine the material variances using the Excel template provided.

Get a Quick Quote

Approximately 250 words
Total price (USD) $: 10.99

Pressed for time on your upcoming paper? We can help!

Bored with homework

Reviews from Clients who Ordered from Our Website

Why Us?

Quality

We use grammar & plagiarism softwares and a Quality Assurance Editing Team to ensure you get a ready to submit paper

Fast

We understand how tight deadlines can get and are always eager to work and beat tight deadlines

Revision

To deliver the best results we offer endless revisions to ensure you get just what they asked for

Personalised

You get to chat and interact with the writer to ensure the paper meets all standard requirements

How it Works

Place an Order

Provide your contact information, select an order type, and describe your requirements. This isn’t going to take long!

Image showing step 1 of making an order
Image showing how to make payment for your order

Select an Appropriate Writer

We’ll match your specifications with our available authors after we have all of the relevant information concerning your order.

Image showing how to download your completed results

Enjoy the End Product

One of our specialists will fulfill your purchase according to your specifications so that you are happy with the end result.