Answered step by step
Verified Expert Solution
Question
1 Approved Answer
hi! what other information do you need? i have attached everything within the excel sheet Using the Excel file Exam 500896 - Motomart Excel Spreadsheet
hi! what other information do you need? i have attached everything within the excel sheet Using the Excel file "Exam 500896 - Motomart Excel Spreadsheet" as per the instructions found above under the "Project Requirements", reproduce and complete the following Table 5 and answer the four questions. The Excel file provides an example of how to arrive at the figures that need to be entered into the Table. You will create new worksheets for each of the remaining expenses. Do the work to arrive at the figures for each expense. Be sure to include the Excel file as part of your submission to "backup" the data presented in the Table in the Word document being submitted. The Excel spread sheet, while it will be included in your submission for the project, will not be graded. It is supporting documentation for what is being presented in the Word document. Only the information that is in the Word document will be graded. The FC and VC should be rounded to the nearest dollar. The R-sq is a percentage figure carried out to 2 decimal places. Table 5 \begin{tabular}{|l|l|c|c|c|} \hline Column & \multicolumn{1}{|c|}{ Expense } & FC & VC & R-sq \\ \hline 1 & Salaries & $106,866 & $110 & 4.10% \\ \hline 2 & Vacation & & & \\ \hline 3 & Advertising and training & & & \\ \hline 4 & Supplies/tools/laundry & & & \\ \hline 5 & Freight & & & \\ \hline 6 & Vehicles & & & \\ \hline 7 & Demonstrators & & & \\ \hline 8 & Floor planning & & & \\ \hline 9 & Computed total & & & \\ \hline \end{tabular} Complete the cost equations for the table. Use the R-squared as the single measure of "goodness of fit." Don't attempt to improve your results with the elimination of "outliers" or "influential outliers." As you complete Table 5, answer the following questions: 1. What problems did you encounter? 2. Are the R-squared measures high or low? 3. Are the slopes negative or positive? 4. Are your conclusions consistent with thosel from the high-low effort? Using the Excel file "Exam 500896 - Motomart Excel Spreadsheet" as per the instructions found above under the "Project Requirements", reproduce and complete the following Table 5 and answer the four questions. The Excel file provides an example of how to arrive at the figures that need to be entered into the Table. You will create new worksheets for each of the remaining expenses. Do the work to arrive at the figures for each expense. Be sure to include the Excel file as part of your submission to "backup" the data presented in the Table in the Word document being submitted. The Excel spread sheet, while it will be included in your submission for the project, will not be graded. It is supporting documentation for what is being presented in the Word document. Only the information that is in the Word document will be graded. The FC and VC should be rounded to the nearest dollar. The R-sq is a percentage figure carried out to 2 decimal places. Table 5 \begin{tabular}{|l|l|c|c|c|} \hline Column & \multicolumn{1}{|c|}{ Expense } & FC & VC & R-sq \\ \hline 1 & Salaries & $106,866 & $110 & 4.10% \\ \hline 2 & Vacation & & & \\ \hline 3 & Advertising and training & & & \\ \hline 4 & Supplies/tools/laundry & & & \\ \hline 5 & Freight & & & \\ \hline 6 & Vehicles & & & \\ \hline 7 & Demonstrators & & & \\ \hline 8 & Floor planning & & & \\ \hline 9 & Computed total & & & \\ \hline \end{tabular} Complete the cost equations for the table. Use the R-squared as the single measure of "goodness of fit." Don't attempt to improve your results with the elimination of "outliers" or "influential outliers." As you complete Table 5, answer the following questions: 1. What problems did you encounter? 2. Are the R-squared measures high or low? 3. Are the slopes negative or positive? 4. Are your conclusions consistent with thosel from the high-low effort
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started