Final Version of Acct. 306 Assessment Project—Spring 20171. Assessing computer literacy: For purposes of assessing computer literacy , use theaccompanying data as directed below.Graphical analysis:a. Create a scatterplot of the observed number of units produced and the relatedmanufacturing overhead.b. Fit a regression line to the scatterplot.c. Display the equation of that line and also r-squared on the scatterplot.d. Simple regression: Use the Regression tool under the add-in “Data Analysis” ofExcel to generate a spreadsheet of output data with “UNITS PRODUCED” as theINDEPENDENT variable and “MANUFACTURING OVERHEAD” as theDEPENDENT variable.e. Multiple regression: Use the Regression tool to determine a regression equationusing the following two independent variables—(1) “units produced” and (2)“number of production batches” and using manufacturing overhead as theDEPENDENT variable.2. Assessing critical thinking: For purposes of assessing critical thinking, please answer thefollowing questions:a. What kind of relationship does the scatterplot show between the variables identifiedin 1(a)?b. Using the result of question 1(d), what is your estimate of manufacturing overhead if150 units were to be produced?c. How would you describe the quality of the relationship in part (a) based on the valueof r-squared?d. After doing 1(e), do you believe that adding a second independent variable, “numberof production batches” to the regression analysis improves the resulting regressionestimate compared to the result obtained using the simple regression equation thatyou computed by using just one independent variable, “number of units produced?”Explain the reason for your answer from the Regression tool output.e. DETERMINE THE FOLLOWING DATA: (1) average values for DM cost/unit andDL cost/unit and (2) the VARIABLE manufacturing overhead cost/unit and the totalFIXED manufacturing overhead cost from the SIMPLE regression analysis. Once youhave the data, calculate the BREAKEVEN POINT IN UNITS by inserting a formulainto a cell on your Excel spreadsheet.
Delivering a high-quality product at a reasonable price is not enough anymore.
That’s why we have developed 5 beneficial guarantees that will make your experience with our service enjoyable, easy, and safe.
You have to be 100% sure of the quality of your product to give a money-back guarantee. This describes us perfectly. Make sure that this guarantee is totally transparent.Read more
Each paper is composed from scratch, according to your instructions. It is then checked by our plagiarism-detection software. There is no gap where plagiarism could squeeze in.Read more
Thanks to our free revisions, there is no way for you to be unsatisfied. We will work on your paper until you are completely happy with the result.Read more
Your email is safe, as we store it according to international data protection rules. Your bank details are secure, as we use only reliable payment systems.Read more
By sending us your money, you buy the service we provide. Check out our terms and conditions if you prefer business talks to be laid out in official language.Read more