Qgramming -- product outputnbspnbsp

Assignment Help Applied Statistics
Reference no: EM13381198

Q1 Linear Programming -- Product Output 
   
A company produces 3 different products, A, B, and C.  All products require time in up to 5 different processing departments.  The amount of time each product requires with each department is listed in the table below:
   
  Product A Product B Product C Available
Melting 6 hrs 2 hr 0 hrs 1200 hrs
Cooling 3 hrs 2 hrs 1 hr 1240 hrs
Shaping 3 hrs 2 hrs 1 hr 2000 hrs
Sanding 2 hrs 3 hr 3 hrs 1875 hrs
Painting 1 hr 2 hrs 2 hrs 1550 hrs
   
Suppose product A sells for $200/unit, product B sells for $225/unit, and product C sells for $125/unit.  And suppose that all products have a guaranteed buyer (i.e., no matter how many are produced it will be sold for the asking price).  Management has asked for your recommendations about how many of each product type to produce that maximize revenue.  So question...
   
Question:  
a) How much of each product do you recommend be produced that you believe maximizes revenue?   
b) How much revenue would be made if they followed your recommendation?
 
Question 2: Suppose your company sells 4 different kinds of pies, Apple Pies, Banana Pies, Cherry Pies, and Danish Pies, where each Apple Pie sells for $8, each Banana Pie sells for $9, each Cherry Pie sells for $7, and each Danish Pie sells for $10.  Further, suppose to make these pies, each must be processed on 2 different machines in your factory and each takes a different amount of time on the two machines.  Specifically, to make one Apple Pie requires 1 hour on machine #1 and 2 hours on machine #2.  To make one Banana Pie requires 2 hours on machine #1 and 3 hours on machine #2.  To make one Cherry Pie requires 2 hours on machine #1 and 1 hour on machine #2.  And to make one Danish Pie requires 1 hour on machine #1 and 0.5 hours on machine #2.  Finally, suppose there can be no more than a total of 150 hours of processing time on machine number 1 and no more than a total of 175 hours of processing time on machine number 2.  Management has asked for your recommendation about how many of each product type to produce that maximizes revenue.  
Question:
a) How much of each product do you recommend be produced that you believe maximizes revenue? 
b) How much revenue would be made if they followed your recommendation?
Question 3: Q3  Control Charts 
Your local cell phone company records how mani milliseconds for each cell phone to connect
to the tower when a call is made.  You randomly selected a sample of cell phone connection times
times in order to determine if the connection times are in control are not.
Below are the connection times of different phone calls that were randomly selected.
Questions:  Both tell you answer and explain/justify it.
a) Are the connection times normally distributed?  
b) How many values are outliers?  
c) Is the connection time in control or out of control?  Explain 
d) What are the business implications of your answer to question d?  
e) Given the business implications, what concrete business recommendations do you have for the company?  
# Data
1 60
2 184
3 127
4 206
5 133
6 174
7 86
8 34
9 151
10 147
11 149
12 220
13 132
14 168
15 202
16 158
17 101
18 177
19 172
20 196
21 137
22 211
23 171
24 128
25 226
26 149
27 172
28 212
29 105
30 128
31 196
32 181
Q4  Statistcal Process Control: A set of data has been collected and evaluated for process failures using Statistical Process Controls. After the quantitiate analysis had been completed, several observations were made.
Questions:  Both tell you answer and explain/justify it.
a) If no values are outside of the control limits, what are the implications for the business and what would you recommend they do?  
b) If 10% of the values are outside of the +/-1 standard deviation control limits, what are the implications for the business and what would you recommend they do? 
c) If 10% of the values are outside of the +/-3 standard deviation control limits, what are the implications for the business and what would you recommend they do? 
d) If 10% of the values are higher than the +3 standard deviation control limit and no values are below the -3 standard deviation control limit, what are the implications for the business and what would you recommend they do?  
Q5  Queuing : The BUS670 store is a small facility that sells all sorts of supplies, snacks, etc.  It has one checkout counter where one employee operates the cash register.  Once customers select their items for purchase, they line up at the counter in a first-come-first-served basis to pay for their selections.
You monitored the store for a few days and found that customers arrive on the waiting line to pay for the selections at an average of 24 customers per hour (assume Poisson distribution) and the cashier seems to be able to serve an average of 30 customers per hour (assuming exponential distribution).
The owner of the store has hired you to answer the following questions:
Part 1 In a typical 8 hour work day, how much time in total will the cashier be idle?
Part 2 How many customers on average are waiting in line to pay?
Part 3 What is the average amount of time a customer is waiting in line?
Part 4 What is the probability a customer will have to wait in the line before being able to pay?
Q6  Queuing
Multiple Choice -- please select the right answer
Part 1 If the average time to serve a customer is 3 minutes, then the service rate, µ, would be
2 points
a. 3 per hour
b. 12 per hour
c. 16 per hour
d. 20 per hour
Part 2 If, on average, it takes 90 seconds to serve a customer then the hourly service rate, µ, would be
2 points
a. 90 per hour
b. 40 per hour
c. 30 per hour
d. 1.5 per hour
Part 3 An espresso stand has a single server. Customers arrive to the stand at the rate of 28 per hour according to a Poisson distribution.  Service times are exponentially distributed with a service rate of 35 customers per hour.
Part 3a The probability that the server is busy is
a. 0.20
b. 0.60
c. 0.80
d. 1.00
Part 3b The average number of customers waiting in line for service is
a. 4.0
b. 3.8
c. 3.5
d. 3.2
Part 3c The average time a customer spends waiting in line for service is
a. 0.114 minute
b. 0.143 minute
c. 6.857 minutes
d. 8.58 minutes
Part 3d If the arrival rate remains at 28 customers per hour and the stand’s manager wants to have the average time a customer spends in the system (i.e., wait time line and service time) to be a maximum of 6 minutes on average, then the service rate must
a. decrease by 2 to 33 customers per hour
b. decrease by 3 to 32 customers per hour
c. increase by 3 to 38 customers per hour
d. increase by 2 to 37 customers per hour
Q7  Others
a) Why are Control Charts important?
b) What are the key steps from implementing Statistical Process Control and what are the benefits? 
Extra Credit -- Linear Programming -- Inventory Management 

An alcohol manufacturer specializes in 3 different drinks, called Xena, Yolanda, and Zorgon.  Each of these drinks has an ingredient unique to it, but these also share 3 ingredients in common.
1) Each keg of Xenas requires at least 3 gallons of special ingredient A, and must contain at least 3 gallons of special ingredient B, and must contain at least 6 gallons of special ingredient C.  Plus each keg must also contain exactly 25 gallons in total of across all 3 of these special ingredients.
2) Each keg of Yolandas requires at least 4 gallons of special ingredient A, and must contain at least 3 gallons of special ingredient B, and must contain at least 2 gallons of special ingredient C.  Plus each keg must also contain exactly 18 gallons in total of across all 3 of these special ingredients.
3) Each keg of Zorgons requires at least 8 gallons of special ingredient A, and must contain at least 9 gallons of special ingredient B, and must contain at least 8 gallons of special ingredient C.  Plus each keg must also contain exactly 30 gallons in total of across all 3 of these special ingredients.
The mixture of these special ingredients cannot be dominated by any one particular ingredient.  Specifically, in each keg, no one individual special ingredient can have more than double the amount of any other special ingredient.
The manufacturer must make 1 keg of each of the three drinks, but must also attempt to reduce the total cost of the special ingredients.
·         1 gallon of special ingredient A costs the manufacturer $18.
·         1 gallon of special ingredient B costs the manufacturer $20.
·         1 gallon of special ingredient C costs the manufacturer $15.
HINT:  Note to solve this problem, you will need to have 9 variables (3 for Xena, 3 for Yolanda, and 3 for Zorgon; each of these 3 corresponding to the number of gallons of ingredient A, B, and C they each require).
Questions:
a) What is the optimal amount of each special ingredient for each drink?
b) What is the optimal cost of the special ingredients in total? 

Reference no: EM13381198

Questions Cloud

Part a instructionsread the followingbulldonaldson t 1996 : part a instructionsread the followingbulldonaldson t. 1996 september. values in tension ethics away from home. harvard
Individual assignment 1 mind the gap you have spent some : individual assignment 1 mind the gap you have spent some time in this unit examining resources that focus on values
Question 1 a financial analyst forecasts the financial : question 1 a financial analyst forecasts the financial statements of jim amp brothers inc. a small grocery store. the
1 you are considering employing manufacturing workers : 1. you are considering employing manufacturing workers in japan in 1987. directly analogous workers for an
Qgramming -- product outputnbspnbsp : q1 linear programming -- product outputnbspnbsp nbspa company produces 3 different products a b and c.
Valuation basicsa best-selling author decides to cash in on : valuation basicsa best-selling author decides to cash in on her latest novel by selling the rights to the books
You and your friends are thinking about starting a : you and your friends are thinking about starting a motorcycle company named apple valley choppers. your initial
Are you better off playing the lottery or saving the money : are you better off playing the lottery or saving the money? assume you can buy one ticket for 5 draws are made monthly
Assume you have 1 million now and you have just retired : assume you have 1 million now and you have just retired from your job. you expect to live for 20 years and you want to

Reviews

Write a Review

Applied Statistics Questions & Answers

  Hypothesis testing

What assumptions about the number of pedestrians passing the location in an hour are necessary for your hypothesis test to be valid?

  Calculate the maximum reduction in the standard deviation

Calculate the maximum reduction in the standard deviation

  Calculate the expected value, variance, and standard deviati

Calculate the expected value, variance, and standard deviation of the total income

  Determine the impact of social media use on student learning

Research paper examines determine the impact of social media use on student learning.

  Unemployment survey

Find a statistics study on Unemployment and explain the five-step process of the study.

  Statistical studies

Locate the original poll, summarize the poling procedure (background on how information was gathered), the sample surveyed.

  Evaluate the expected value of the total number of sales

Evaluate the expected value of the total number of sales

  Statistic project

Identify sample, population, sampling frame (if applicable), and response rate (if applicable). Describe sampling technique (if applicable) or experimental design

  Simple data analysis and comparison

Write a report on simple data analysis and comparison.

  Analyze the processed data in statistical survey

Analyze the processed data in Statistical survey.

  What is the probability

Find the probability of given case.

  Frequency distribution

Accepting Manipulation or Manipulating

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