Reference no: EM13738894

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?