How much idle time was incurred by the waxing process

Assignment Help Applied Statistics
Reference no: EM13315909

Q1 Scheduling

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 $200 per hour. Assign each worker to a project so that cost is minimized.

Worker Project 1 Project 2 Project 3 Project 4
Bryan 20 10 12 20
Kari 12 4 8 12
Noah 14 12 10 12
Chris 18 10 8 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?

Q2 Scheduling

Car Washing Waxing
1 10 10
2 3 2
3 7 5
4 8 6
5 5 5

The local car wash has five cars waiting to be washed and waxed. The time required in minutes for each activity is given below.

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 16, 2014 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 B174 through B225 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.


Attachment:- ASTAT_Question.xlsx

Verified Expert

Reference no: EM13315909

Questions Cloud

Laws pertaining to worker compensation and rights : There are various regulations or laws pertaining to worker compensation and rights. Some of these laws and regulations are:
Discuss the cyclical behaviour of the budget deficit in : Discuss the cyclical behaviour of the budget deficit in South Africa and provide an explanation for this behaviour. (half a page with references)
Rewrite the extract.pl using bioperl : Rewrite the "extract.pl" using BioPerl, including the use of Bio::SeqIO to read the genome FASTA file ("mystery_seq1.fas") and the use of Bio::Seq for obtaining coding sequences and translating sequences.
Explain the budget identity and fixed budgetary commitments : Explain the budget identity and fixed budgetary commitments, with specific reference to the South African 2009/2010 budget, as constraints on the pursuit of discretionary fiscal policy
How much idle time was incurred by the waxing process : Management wishes to schedule workers with specific projects that minimizes total cost and gets all projects done, what would that minimized cost be and Part 1b Which project should be assigned to which worker for minimizing the total cost?
What is the hydrostatic force on one of the side portals : A sightseeing tourist submarine is constructed. The portals along the side can be assumed to be essentially flat, vertical and 1 meter in diameter. Assume a specific weight of seawater of 10,000 N/m3.
Use a chain reaction to explain the impact : Use a chain reaction to explain the impact of a reduction in the budget surplus on GDP (use a complete chain reaction). Is this an example of expansionary or restrictive fiscal policy?
Clear and concise description of the market : Clear and concise description of the market in which the organization operate
Determine the daily discharge per 1000 feet into the river : A canal was constructed running parallel to a river 1500 ft away. Both fully penetrate a sand aquifer with a hydraulic conductivity of 1.2 ft/d. The area is subject to rainfall of 1.8 ft/y and evaporation of 1.3 ft/y.

Reviews

Write a Review

 

Applied Statistics Questions & Answers

  Evaluate the volumetric flux

Prepare a Scilab script to evaluate the volumetric flux of smoke in a plume produced by a fire of given HRR Q' The plume loses α percent of its heat by radiation and β percent by other means.

  Quantitative analysis for decision making assignment

Graphical Solutions in Linear Programming have limited number of decision variables. What is the maximum number of decision variables used in graphical solutions?

  Draw the density function

What are the possible values of this random variable and draw the density function.

  Problem statement and review of ralated literature

The purpose of this assignmentto test a student's expertise in developing an introduction and writing a review of related literature and developing research gaps that can be addressed by future studies

  Prepare a report using the numerical methods

Prepare a report using the numerical methods of descriptive statistics presented in this module to learn how the variables contribute to the success of a motion picture.

  Find correlation between anca and the clinical manifestation

Find the correlation between ANCA and the clinical manifestations - Please describe which tests you used and write a short narration to explain the results.

  Relationship between perceptions of police performance

the hypothesis that there is a relationship between perceptions of police performance and area of the city for Montgomery. What might you tell the police chief?

  Find the mean, variance and standard deviation

Find the mean, median, mode, variance and standard deviation for the following nine data values and find the four quartiles and the 20 th and 80 th percentiles for the above data.

  Filtering and summarizing data

Filtering and Summarizing Data

  Binomial probability distribution

Binomial probability distribution

  Calculate mortgage rates and production lot size

Calculate mortgage rates, production lot size, forecast the demand for the products, track epidemics and their spread, help solve crimes, even help estimate tax revenues.

  Degrees of freedom for the chi-square hypothesis tests

How are the degrees of freedom for the chi-square hypothesis tests different from those of most other hypothesis tests? In most previous hypothesis tests, the degrees of freedom have been based on sample size.

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd