Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

begin{tabular}{|c|c|c|} hline Step & Instructions & begin{tabular}{l} Points Possible end{tabular} hline 1 & begin{tabular}{l} Start Excel. Download and open the file named Exp22_Excel_Ch06_ML2_Wages.xisx.

image text in transcribed
image text in transcribed
\begin{tabular}{|c|c|c|} \hline Step & Instructions & \begin{tabular}{l} Points \\ Possible \end{tabular} \\ \hline 1 & \begin{tabular}{l} Start Excel. Download and open the file named Exp22_Excel_Ch06_ML2_Wages.xisx. Grader \\ has automatically added your last name to the beginning of the filename. \end{tabular} & 0 \\ \hline 2 & Create range names based on the values in the range I10:I11. & 15 \\ \hline 3 & Edit the range name Gross_Earnings so it displays as Gross. & 10 \\ \hline 4 & \begin{tabular}{l} Apply the Gross and Total_Wages_Paid range names to the formula in cell 112 using the \\ Apply Range name method. \end{tabular} & 8 \\ \hline 5 & \begin{tabular}{l} Load the Solver add-in if it is not avallable. Set the objective cell to Min Total Wages Paid (cell \\ F13). \end{tabular} & 8 \\ \hline 6 & Assign Hours Worked (range E5:E12) as the Changing Variables Cells. & 6 \\ \hline 7 & Set a constraint to ensure hours scheduled per employee are whole numbers. & 6 \\ \hline 8 & \begin{tabular}{l} Set constraints (two required) to ensure full time employees work between 30 and 50 hours \\ per week. \end{tabular} & 12 \\ \hline 9 & Set constraints (two required) to ensure part time employees work between 0 and 20 hours. & 12 \\ \hline 10 & Set a constraint to ensure exactly 200 hours are scheduled for the week. & 6 \\ \hline 11 & Solve the model and create an Answer Report to outline your findings. & 9 \\ \hline 12 & \begin{tabular}{l} Create a new worksheet named RangeNames and paste a list of the range names created for \\ the analysis starting in cell A1. \end{tabular} & 8 \\ \hline 13 & Save and close Exp22_Excel_Ch06_ML2_Wages.xisx. Exit Excel. Submit the file as directed. & 0 \\ \hline & Total Points & 100 \\ \hline \end{tabular} A Hamilton Classic Time Pieces \begin{tabular}{|c|l|r|r|r|} \hline Employee Number & Status & Hourly Rate & Hours Worked & Total Wages Paid - \\ \hline 201474 & Full Time & $15.75 & 0 & $50.00 \\ \hline 403257 & Full Time & $12.75 & 0 & $0.00 \\ \hline 745987 & Full Time & $11.50 & 0 & $5.00 \\ \hline 179069 & Part Time & $9.95 & 0 & $0.00 \\ \hline 634601 & Part Time & $5.75 & 0 & $0.00 \\ \hline 505183 & Part Time & $7.25 & 0 & $0.00 \\ \hline 356879 & Part Time & $7.25 & 0 & $0.00 \\ \hline 254141 & Part Time & $7.00 & 0 & $0.00 \\ \hline Total & & & 0 & $0.00 \\ \hline \end{tabular} \begin{tabular}{|c|c|c|} \hline Constraints & & \\ \hline Total Hours Needed & 200 & \\ \hline Full Time Hours & >=30 & c=50 \\ \hline Part Time Hours & >=0 & 20 \\ \hline \multicolumn{3}{|l|}{ Output } \\ \hline Gross Earnings & $10,500,00 & - \\ \hline Total Wages Paid & 50.00 & \\ \hline Net Earnings & $10,500.00 & \\ \hline \end{tabular} \begin{tabular}{|c|c|c|} \hline Step & Instructions & \begin{tabular}{l} Points \\ Possible \end{tabular} \\ \hline 1 & \begin{tabular}{l} Start Excel. Download and open the file named Exp22_Excel_Ch06_ML2_Wages.xisx. Grader \\ has automatically added your last name to the beginning of the filename. \end{tabular} & 0 \\ \hline 2 & Create range names based on the values in the range I10:I11. & 15 \\ \hline 3 & Edit the range name Gross_Earnings so it displays as Gross. & 10 \\ \hline 4 & \begin{tabular}{l} Apply the Gross and Total_Wages_Paid range names to the formula in cell 112 using the \\ Apply Range name method. \end{tabular} & 8 \\ \hline 5 & \begin{tabular}{l} Load the Solver add-in if it is not avallable. Set the objective cell to Min Total Wages Paid (cell \\ F13). \end{tabular} & 8 \\ \hline 6 & Assign Hours Worked (range E5:E12) as the Changing Variables Cells. & 6 \\ \hline 7 & Set a constraint to ensure hours scheduled per employee are whole numbers. & 6 \\ \hline 8 & \begin{tabular}{l} Set constraints (two required) to ensure full time employees work between 30 and 50 hours \\ per week. \end{tabular} & 12 \\ \hline 9 & Set constraints (two required) to ensure part time employees work between 0 and 20 hours. & 12 \\ \hline 10 & Set a constraint to ensure exactly 200 hours are scheduled for the week. & 6 \\ \hline 11 & Solve the model and create an Answer Report to outline your findings. & 9 \\ \hline 12 & \begin{tabular}{l} Create a new worksheet named RangeNames and paste a list of the range names created for \\ the analysis starting in cell A1. \end{tabular} & 8 \\ \hline 13 & Save and close Exp22_Excel_Ch06_ML2_Wages.xisx. Exit Excel. Submit the file as directed. & 0 \\ \hline & Total Points & 100 \\ \hline \end{tabular} A Hamilton Classic Time Pieces \begin{tabular}{|c|l|r|r|r|} \hline Employee Number & Status & Hourly Rate & Hours Worked & Total Wages Paid - \\ \hline 201474 & Full Time & $15.75 & 0 & $50.00 \\ \hline 403257 & Full Time & $12.75 & 0 & $0.00 \\ \hline 745987 & Full Time & $11.50 & 0 & $5.00 \\ \hline 179069 & Part Time & $9.95 & 0 & $0.00 \\ \hline 634601 & Part Time & $5.75 & 0 & $0.00 \\ \hline 505183 & Part Time & $7.25 & 0 & $0.00 \\ \hline 356879 & Part Time & $7.25 & 0 & $0.00 \\ \hline 254141 & Part Time & $7.00 & 0 & $0.00 \\ \hline Total & & & 0 & $0.00 \\ \hline \end{tabular} \begin{tabular}{|c|c|c|} \hline Constraints & & \\ \hline Total Hours Needed & 200 & \\ \hline Full Time Hours & >=30 & c=50 \\ \hline Part Time Hours & >=0 & 20 \\ \hline \multicolumn{3}{|l|}{ Output } \\ \hline Gross Earnings & $10,500,00 & - \\ \hline Total Wages Paid & 50.00 & \\ \hline Net Earnings & $10,500.00 & \\ \hline \end{tabular}

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

Internal Auditing An Integrated Approach

Authors: Richard Cascarino

3rd Edition

1485110599, 978-1485110590

More Books

Students also viewed these Accounting questions