Homework Help is Here – Start Your Trial Now!
Business
Accounting
Please model the following decision in a spreadsheet, optimize it using MS-Excel Solver, and then upload that spreadsheet by attaching it to this question. I will grade this question on the accuracy of your () spreadsheet model (decision variables, objective, and constraints), (i) Solver parameters, (i optimal solution. Partial credit is available. The personnel-planning problem of Lexington Bank. The main branch of Lexington Bank is open for retail business from 8:00 AM to 4:00 PM on weekdays. The staffing requires from 8 to 15 tellers on duty depending on the time of day, as indicated in the following table. Time Period Minimum No. of Tellers 8:00 AM - 10:00 AM 10:00 AM - 12:00 PM 12:00 PM - 2:00 PM 10 15 2:00 PM - 4:00 PM 12 Full-time tellers work 8 consecutive hours (from 8:00 AM to 4:00 PM) at $15 per hour. Part-time workers work 4 consecutive hours at $8 per hour starting at 8:00 AM, 10:00 AM, or 12:00 noon. Assume workers never take breaks. Union regulations require that all times at least 60% of the tellers be full time. As the bank operations manager, you have been asked to make a recommendation as to the number of full-time and part-time employees needed throughout the day to minimize the total daily cost. Create a spreadsheet that very clearly indicates what your decision variables are, what your objective function is, and what the constraints are. Then solve this spreadsheet using Excel Solver and upload the sprpadsheet showing the optimal solution (optimal staffing and minimum daily staffing cost). Please highlight your answers with yellow shaded cells (optimal values of decision variables, objective function value).

Please model the following decision in a spreadsheet, optimize it using MS-Excel Solver, and then upload that spreadsheet by attaching it to this question. I will grade this question on the accuracy of your () spreadsheet model (decision variables, objective, and constraints), (i) Solver parameters, (i optimal solution. Partial credit is available. The personnel-planning problem of Lexington Bank. The main branch of Lexington Bank is open for retail business from 8:00 AM to 4:00 PM on weekdays. The staffing requires from 8 to 15 tellers on duty depending on the time of day, as indicated in the following table. Time Period Minimum No. of Tellers 8:00 AM - 10:00 AM 10:00 AM - 12:00 PM 12:00 PM - 2:00 PM 10 15 2:00 PM - 4:00 PM 12 Full-time tellers work 8 consecutive hours (from 8:00 AM to 4:00 PM) at $15 per hour. Part-time workers work 4 consecutive hours at $8 per hour starting at 8:00 AM, 10:00 AM, or 12:00 noon. Assume workers never take breaks. Union regulations require that all times at least 60% of the tellers be full time. As the bank operations manager, you have been asked to make a recommendation as to the number of full-time and part-time employees needed throughout the day to minimize the total daily cost. Create a spreadsheet that very clearly indicates what your decision variables are, what your objective function is, and what the constraints are. Then solve this spreadsheet using Excel Solver and upload the sprpadsheet showing the optimal solution (optimal staffing and minimum daily staffing cost). Please highlight your answers with yellow shaded cells (optimal values of decision variables, objective function value).

Accounting Information Systems
Accounting Information Systems
10th Edition
ISBN:9781337619202
Author:Hall, James A.
Publisher:Hall, James A.
Chapter13: Systems Development And Program Change Activities
Section: Chapter Questions
Problem 1P: ANNOUNCING A NEW INFORMATION SYSTEM The AJAX Company is considering implementing a new accounting...
See similar textbooks
icon
Related questions
Question
Please model the following decision in a spreadsheet, optimize it using MS-Excel Solver, and then upload that spreadsheet by attaching it to this question. I will grade this question on the accuracy of your () spreadsheet model (decision variables, objective, and constraints), (i) Solver parameters, (i optimal solution. Partial credit is available. The personnel-planning problem of Lexington Bank. The main branch of Lexington Bank is open for retail business from 8:00 AM to 4:00 PM on weekdays. The staffing requires from 8 to 15 tellers on duty depending on the time of day, as indicated in the following table. Time Period Minimum No. of Tellers 8:00 AM - 10:00 AM 10:00 AM - 12:00 PM 12:00 PM - 2:00 PM 10 15 2:00 PM - 4:00 PM 12 Full-time tellers work 8 consecutive hours (from 8:00 AM to 4:00 PM) at $15 per hour. Part-time workers work 4 consecutive hours at $8 per hour starting at 8:00 AM, 10:00 AM, or 12:00 noon. Assume workers never take breaks. Union regulations require that all times at least 60% of the tellers be full time. As the bank operations manager, you have been asked to make a recommendation as to the number of full-time and part-time employees needed throughout the day to minimize the total daily cost. Create a spreadsheet that very clearly indicates what your decision variables are, what your objective function is, and what the constraints are. Then solve this spreadsheet using Excel Solver and upload the sprpadsheet showing the optimal solution (optimal staffing and minimum daily staffing cost). Please highlight your answers with yellow shaded cells (optimal values of decision variables, objective function value).
Transcribed Image Text:Please model the following decision in a spreadsheet, optimize it using MS-Excel Solver, and then upload that spreadsheet by attaching it to this question. I will grade this question on the accuracy of your () spreadsheet model (decision variables, objective, and constraints), (i) Solver parameters, (i optimal solution. Partial credit is available. The personnel-planning problem of Lexington Bank. The main branch of Lexington Bank is open for retail business from 8:00 AM to 4:00 PM on weekdays. The staffing requires from 8 to 15 tellers on duty depending on the time of day, as indicated in the following table. Time Period Minimum No. of Tellers 8:00 AM - 10:00 AM 10:00 AM - 12:00 PM 12:00 PM - 2:00 PM 10 15 2:00 PM - 4:00 PM 12 Full-time tellers work 8 consecutive hours (from 8:00 AM to 4:00 PM) at $15 per hour. Part-time workers work 4 consecutive hours at $8 per hour starting at 8:00 AM, 10:00 AM, or 12:00 noon. Assume workers never take breaks. Union regulations require that all times at least 60% of the tellers be full time. As the bank operations manager, you have been asked to make a recommendation as to the number of full-time and part-time employees needed throughout the day to minimize the total daily cost. Create a spreadsheet that very clearly indicates what your decision variables are, what your objective function is, and what the constraints are. Then solve this spreadsheet using Excel Solver and upload the sprpadsheet showing the optimal solution (optimal staffing and minimum daily staffing cost). Please highlight your answers with yellow shaded cells (optimal values of decision variables, objective function value).
Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 3 steps with 3 images

SEE SOLUTIONCheck out a sample Q&A here
Blurred answer
Similar questions
  • SEE MORE QUESTIONS
Recommended textbooks for you
Accounting Information Systems
Accounting Information Systems
Accounting
ISBN:
9781337619202
Author:
Hall, James A.
Publisher:
Cengage Learning,
Excel Applications for Accounting Principles
Excel Applications for Accounting Principles
Accounting
ISBN:
9781111581565
Author:
Gaylord N. Smith
Publisher:
Cengage Learning
Pkg Acc Infor Systems MS VISIO CD
Pkg Acc Infor Systems MS VISIO CD
Finance
ISBN:
9781133935940
Author:
Ulric J. Gelinas
Publisher:
CENGAGE L
SEE MORE TEXTBOOKS