Q1 :
Company has 5 projects to complete and 4 workers with varying degree of expertise for each project. Estimates of process time (in hours) for each project by each worker are shown below. Project time costs an average of $125 per hour. Assign each worker to at least one project so the cost is minimized.
| Worker |
Project 1 |
Project 2 |
Project 3 |
Project 4 |
Project 5 |
| Bryan |
11 |
20 |
8 |
19 |
13 |
| Kari |
14 |
11 |
13 |
19 |
10 |
| Noah |
21 |
11 |
11 |
19 |
19 |
| Chris |
13 |
20 |
14 |
21 |
20 |
Part 1 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 1 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 eight trucks waiting to be washed and waxed. The time required in minutes for each activity is given below. The washing must occur before the waxing.
| Truck |
Washing |
Waxing |
| A |
12 |
9 |
| B |
5 |
6 |
| C |
9 |
7 |
| D |
10 |
11 |
| E |
7 |
9 |
| F |
8 |
9 |
| G |
3 |
8 |
| H |
1 |
2 |
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 eight trucks?
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 July 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?
Q4 Consulting
Part 1 -- Project Consulting
Please refer to the four PowerPoint documents. These are actual analyses produced about specific companies. Please select ONE of these 4 presentations and in a Word document, please provide detailed suggestions to the authors of the material that would improve the quality of the content, as though you were the teacher grading the material. The comments should be of value, and not cosmetic or immaterial, such as wording suggestions, number of pages or length suggestions, etc., but instead should be focused on crisp, clear, and concise recommendations that would increase the value the output. For the sake of this question, suppose this project was scored a C. Please list all the recommedations that would make it an A+.
Part 2 -- BusinessConsulting
Refering to the same PowerPoint project you addressed in part 1 above, in a Word document, please provide a critique of this document from a BUSINESS CONSULTING perspective. For this question, your comments about about business implications, recommendations, and your thoughts of the project as it relates to business issues. If you think there is a poingnat point that was not made in the PowerPout but should have been, that is a comment about content that you should list here. If they never discussed the impact of a certain element of the business, or perhaps did not mention the impact on the product, pricing, customer, comeptitor, workers, etc. these are comments woth making. If the recommendations they made do not help the business but instead you have a better recommendation stemming from the material that could aid the business, then that is a comment you should produce. You are not critiquing the PowerPoint from an teacher point of view here. You are critiquing it from a BUSINESS CONSULTING point of view. Please pick the same one PowerPoint document for part 1 and part 2 and provide whatever obserations, comments, etc that themselves add value.