Answered step by step
Verified Expert Solution
Link Copied!

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

image text in transcribed
image text in transcribed
image text in transcribed
image text in transcribed
hi! what other information do you need? i have attached everything within the excel sheet
image text in transcribed
image text in transcribed
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

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Accounting In Business

Authors: R. J. Bull

5th Edition

0408014865, 978-0408014861

More Books

Students also viewed these Accounting questions

Question

1. Walk to the child, look into his or her eyes.

Answered: 1 week ago