Скачать или смотреть Exp22_Excel_Ch06_ML2 - Employee Wages 1.1 | Exp22 Excel Ch06 ML2 Employee Wages 1.1

Exp22_Excel_Ch06_ML2 - Employee Wages 1.1 | Exp22 Excel Ch06 ML2 Employee Wages 1.1


Contact us:

WhatsApp : +92 3167810143

WhatsApp Link:
https://bit.ly/4cQIYgZ

Gmail: [email protected]

We can handle all online courses, Business and Management, Business and Finance, Business and Accounting, Nursing, psychology, Statistics, Information Technology, Computer Science and Many more We will help you in weekly quizzes, assignments, exams, thesis writing, dissertation writing, MylTLab all Courses

Project Description:
You are the business manager for Hamilton Classic Timepieces, an independent jewelry maker that specializes in timepieces. Your company has three full-time and five part-time employees. Your store is currently open 40 hours per week, and based on demand, you require 200 weekly labor hours. Full-time employees work between 30 and 50 hours per week. Part-time employees work between 1 and 20 hours per week.

Start Excel. Download and open the file named Exp22_Excel_Ch06_ML2_Wages.xlsx. Grader has automatically added your last name to the beginning of the filename.

‪@Mylab930Lab‬
@Pearson Mylab Assignment
@Pearson Mylab Assignment
@Pearson Mylab Assignment

Create range names based on the values in the range I10:I11.
Edit the range name Gross_Earnings so it displays as Gross.
Apply the Gross and Total_Wages_Paid range names to the formula in cell I12 using the Apply Range name method.
Load the Solver add-in if it is not available. Set the objective cell to Min Total Wages Paid (cell F13).
Assign Hours Worked (range E5:E12) as the Changing Variables Cells.
Set a constraint to ensure hours scheduled per employee are whole numbers.
Set constraints (two required) to ensure full time employees work between 30 and 50 hours per week.
Set constraints (two required) to ensure part time employees work between 0 and 20 hours.

@Pearson Mylab Assignment
@Pearson Mylab Assignment
@Pearson Mylab Assignment

Set a constraint to ensure exactly 200 hours are scheduled for the week.
Solve the model and create an Answer Report to outline your findings.
Create a new worksheet named RangeNames and paste a list of the range names created for the analysis starting in cell A1.