Question

In: Operations Management

In this assignment, you will create a schedule for the month of December of this year...

In this assignment, you will create a schedule for the month of December of this year for your team members—John, Sally, Pedro, and Eunice. While creating the schedule, keep in mind the following conditions:

Every employee in the company needs to work for 45 hours per week.

John works from Saturdays to Wednesdays in the 6:00 a.m. to 4:00 p.m. shift, with a 1-hour lunch break.

Sally works from Mondays to Thursdays in the 3:00 p.m. to 3:00 a.m. shift, with two 1-hour breaks. To complete 45 hours of work, she can be either scheduled on Fridays or on Saturdays in a block of 5 hours, with no break.

Pedro can work on any day except Wednesdays from 12:00 noon to 5:00 p.m. His work schedule should be made available to him by 12:00 noon on Wednesday of the previous week.

Every week, Eunice works with both John and Sally—20 hours with John and 25 hours with Sally.

Your office is closed on December 24 and 25.

Eunice is on leave in the week after December 25.

John is on leave December 2 and 3.

Perform the following tasks:

Create a project schedule that incorporates all the conditions. Discuss the technique you used to implement the schedule.

Which software tool did you use to create the schedule?

Explain how helpful you found the tool.

Submit a 4- to 5-page report

Solutions

Expert Solution

You need a resource scheduler to solve this query on a regular basis.

Multiple resource planner applications are available in the market as on today. Some of them include Float, hub planner, Resource guru etc. There are also open source platforms which help you in scheduling the team.

However since the team size is smaller, you can also try using Google sheets and share the resource plan real time with your team and help them in planning efficiently.

I am doing the resource allocation manually. So here is my resource plan

Considering the month of Dec'18

Sat -

Day Dates User name Working hours Breaks
Sat 1,8,15,22,29 John , Eunice 6:00 AM to 4:00 PM 1 hr
Sun 9,16,23,30 John, Eunice 6:00 AM to 4:00 PM 1 hr
Mon 3,10,17,31 Sally 3:00 PM to 3:00 AM 2 hrs
Tue 4,11,18 Sally 3:00 PM to 3:00 AM 2 hrs
Mon 10,17,31 John 6:00 AM to 4;00 PM 1 hrs
Tue 4.11.18 John 6:00 AM to 4:00 PM 1 hr
Mon 3, 10,17 Eunice 2;00 PM to 2:00 AM 2 hrs
Tue 4,11,18 Eunice 2:00 PM to 2:00 AM 2 hrs
Wed 5.12.19,26 John 6:00 AM to 4:00 PM 2 hrs
Wed 5,12,19,26 Eunice 3:00 pm TO 3:00 AM 2 hrs
Thu 6,13,20,27 Sally 3:00 PM to 3;00 AM 2 hrs
Fri 7,14,21,28 Sally 3;00 PM to 8:00 PM 0
Sat 1,8,15,22,29 Pedro 12:00 PM to 5:00 PM 0
Sun 2,9,16,23,30 Pedro 12:00 PM to 5;00 PM 0
Mon 3,10,17,31 Pedro 12;00 PM to 5;00 PM 0
Tue 4,11,18 Pedro 12:00 PM to 5;00 PM 0
Thu 6,13,20,27 Pedro 12:00 PM to 5:00 PM 0
Fri 7,14,21,28 Pedro 12;00 PM to 5;

However the requested scheduler cant be made,as pedro is only working for 36 hrs instead of the target 45 hrs


Related Solutions

For this assignment, create a Project Schedule, and list the 20+ activities required to complete the...
For this assignment, create a Project Schedule, and list the 20+ activities required to complete the house that you identified in your Unit IV Project Budget. Assign a schedule to all identified activities. Please be sure to reserve two weeks for contingencies. In other words, you should schedule all the activities and set aside two weeks for contingencies. The entire project (including the two-week contingency period) should equal 24 months Unit 4 Project: Activity Description Est $ Architectural Design 50,000...
the charge nurse on the unit has posted the vacation schedule for the month of December,...
the charge nurse on the unit has posted the vacation schedule for the month of December, as a recent graduate, have requested to be off during the week of Christmas holidays. You notice on the schedule that none of the recent graduates has received the Christmas holidays off. You feel that this is unfair, because you will not have an opportunity to be with your family during the Christmas holidays. How can you resolve this conflict? Competition This is an...
Bg Sammies Sales, Inc. had the acquisition schedule below in December. During the month of december...
Bg Sammies Sales, Inc. had the acquisition schedule below in December. During the month of december the company sold 3000 units.   Units Purchased Units cost $ dec. 3- 900 units $50 dec. 8 1200 units $56 dec.19 1500 units $60 dec. 23 1000 units $62 REQUIRED: Assuming Big Sammies Sales, Inc. uses a periodic inventory system, calculate the amount of ending inventory under each of the following pricing methods: first-in, first-out; last-in, first-out; and weighted average. (Hint: calculate the Ending...
where can you create a new payroll schedule?
where can you create a new payroll schedule?
Assignment 1 Willy's Widget, a monopoly, faces the following demand schedule (sales in widgets per month):...
Assignment 1 Willy's Widget, a monopoly, faces the following demand schedule (sales in widgets per month): Price Quantity 80 0 75 10 70 20 65 30 60 40 55 50 50 60 45 70 40 80 35 90 30 100 25 110 20 120 Calculate marginal revenue over each interval in the schedule. If marginal cost is constant at $40 and fixed cost is $300, what is the profit maximizing level of output? What is the level of profit? Explain...
Assignment: The Ordered List In this assignment, you will create an ordered list of movies. The...
Assignment: The Ordered List In this assignment, you will create an ordered list of movies. The list will always be maintained in sorted order (ascending order, by movie title) by assuring that all new movies are inserted in the correct location in the list. Create a new project to hold your implementation of an ordered singly-linked list. You will need a main.cppto use as a test driver, as well as header and implementation files as described below. Movie To represent...
Create an Amortization Schedule for a $275,000 office building to be purchased with a 30-year loan...
Create an Amortization Schedule for a $275,000 office building to be purchased with a 30-year loan at an APR of 5% compounded monthly. Determine the monthly payments and how much interest is paid over the life of the loan. (format amortization schedule with the following columns: month, beginning principal, monthly payment, monthly interest, principal reduction, ending principal)
This assignment provides you with an opportunity to create a code of ethics for you and...
This assignment provides you with an opportunity to create a code of ethics for you and your family, as well as to explain the strategies and thought processes that went into developing the code. First, create an original code of ethics for your family by thinking about your family as an organization. In your code of ethics, please include the following items:  guiding principles,  purpose of the code,  core values,  training and education (How will you...
For this assignment you are required to create two loan amortization schedules. However, after you create...
For this assignment you are required to create two loan amortization schedules. However, after you create the first one, you can simply just copy and paste to add rows for the second schedule. Your directions are as follows: Create a loan amortization schedule using Excel for a $36,000 car loan that will be repaid over 60 months at an annual interest rate of 4.5%. What is your monthly payment? What is the total amount you have paid over the life...
Create the amortization schedule of a four-year ordinary annuity worth $ 15,000 and an effective annual...
Create the amortization schedule of a four-year ordinary annuity worth $ 15,000 and an effective annual return on 6 percent with monthly instalments, and calculate how much principal is expected to be paid in the first month of the second year. If it possible, could u do it in excel table. Thank you in advance.
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT