Q1 - The BUS670 Company has for projects to complete and four workers with varying degree os expertise for each project. Estimates of process time (in hours) for each project by each worker are shown below. Development time costs an average of $125 per hour. Assign each worker to a project so that cost is minimized.
| Worker |
Project 1 |
Project 2 |
Project 3 |
Project 4 |
| Bryan |
14 |
13 |
11 |
20 |
| Kari |
13 |
20 |
8 |
11 |
| Noah |
21 |
19 |
10 |
19 |
| Chris |
20 |
19 |
11 |
20 |
Part 1a If management wishes to schedule workers with specific projects that minimizes total cost and gets all projects done, what would that minimized cost be?
Part 1b Which project should be assigned to which worker for minimizing the total cost?
Answer: Bryan is assigned project #
Kari is assigned project #
Noah is assigned project #
Chris is assigned project #
Q2 - Scheduling
The local car wash has five cars waiting to be washed and waxed. The time required in minutes for each activity is given below.
| Car |
Washing |
Waxing |
| 1 |
12 |
9 |
| 2 |
5 |
5 |
| 3 |
9 |
7 |
| 4 |
10 |
11 |
| 5 |
7 |
7 |
Part 2a In what order should the cars be processed through the facility that is the most efficient overall?
Part 2b How long from start to finish will it take to complete the processing the five cars?
Part 2c How much idle time was incurred by the washing process?
Part 2d How much idle time was incurred by the waxing process?
Q3 - Forecasting
Suppose today is May 18, 2015 and the data below are the historical sales figures for the BUS670 company for the last few years.
Part 1 -- Forecast the weekly sales for the next 52 weeks and put these values in cells B180 through B231 below.
Part 2 -- How many more or fewer sales will the forecasted 52 weeks have over the prior 52 weeks?
Part 3 -- Which forecasted week is expected to have the greatest sales volume?
Part 4 -- Which forecasted week is expected to have the lowest sales volume?