![MATLAB: An Introduction with Applications](https://www.bartleby.com/isbn_cover_images/9781119256830/9781119256830_smallCoverImage.gif)
Question 4
(A)
A and C mall is a busy centre for residents in East Legon and its
sourrounding community. Assume that 2 customers arrive every 12 minutes
and 3 customers are served every 15 minutes and that currently, there is only
one cashier.
a) Determine the average waiting time in minutes before service begins.
b) Advice the management the proportion of the time that a customer has
to wait.
(B). Management perceives that the waiting time computed in (ii) above is
not acceptable and is faced with two options.
Management can either employ an assistant for the cashier or open a second
cash machine.
The former, if implemented, will enable 4 requests to be served every 15
minutes and the assistant will receive a monthly salary of GH₵160. The
latter, if implemented will improve the arrival rate to 1 customer every 12
minutes.
However, it requires an initial capital outlay of GH₵3000 and the cashier
who will operate the cash machine will receive a monthly salary of GH₵250.
The shop avoids a loss in sales of GH₵80 per month for each minutes that
average customer waiting time is reduced.
c) Calculate the financial gain to A and C mall under option 1 and advice
management on the option.
d) Calculate the financial gain to A and C mall under option 2, assuming the initial capital outlay is sunk cost and advice management on this option.
![Check Mark](/static/check-mark.png)
Step by stepSolved in 2 steps with 1 images
![Blurred answer](/static/blurred-answer.jpg)
- 3. Create the following calculated columns. a) In I4, and J4, use a VLOOKUP function that will look up the Product Price and Product Cost based on the Product Sold column which lists an ID number. [Hint: The Product Table sheet lists the Price and Cost] If any error messages appear, check the Range Lookup. b) In K4, use a formula to calculate Profit. Hint: Profit =(Product Price-Product Cost)*Units Sold 4. Format columns I, J, and K as currency with two decimal places. 5. Make a copy of the Sales sheet and rename it Online Sales by Date. Place this sheet to the right of the Sales sheet. Answer the following question by filtering the data accordingly.a) What was the total Profit for Online Sales? b) Sort the results by Date Sold (A/Z). * so apparently I need to learn to use the VLOOKUP to find a product on the first page and be able to get the Product Price and Cost from the second page. The following formula is NOT working - =VLOOKUP(D4, ProductTable!A:B, 2,FALSE). I need an EXACT…arrow_forwardStep 3: Assess the Evidence (Calculate the test statistic for the observed sample mean. Sketch the T-distribution and identify the position of the observed test statistic. Shade the area that represents the P-value. Use the test statistic to find the P-value.)arrow_forward5 Imagine that a company sells portable walkie-talkie radios to construction crews. The batteries for these radios last for an average of 55 hours. The purchasing manager for this company receives a brochure in the mail that advertises a new brand of batteries. This new brand of batteries is cheaper than the brand that the company currently uses. However, the purchasing manager is concerned that the cheaper batteries may have a shorter average battery life than the current brand. (Note: The number of hours that batteries last is called their battery life.) The pricing manager installs 40 randomly selected batteries of the cheaper brand in the company's walkie-talkie radios. He finds that the mean battery life for the sample is 52 hours, with a standard deviation of 10 hours. He wants to perform a statistical test at the 1% level of significance to determine whether the cheaper batteries have a shorter average battery life span than the average life span of the brand of batteries the…arrow_forward
- You are the VP, Advertising for “Yo’ Mama” brand, a fashion label that caters to the young, trendy crowd with an urban, hip-hop image. While your customer base has traditionally been largely African-American, you have recognized a tremendous influx of Hispanic consumers into your market. You are preparing for next week’s annual budget meetings and you have decided to recommend an Hispanic-focused advertising campaign if the average monthly per store sales to Hispanic customers are at least the same as the average monthly per store sales to African-American customers in a sample of typical stores (sales data given below). Using an alpha of .05 and the 5-step hypothesis testing process, what will you recommend? Hint: Think about how many data points you actually have.arrow_forward5. A blood sugar reading above 300 mg/dL can be dangerous, according to the University of Michigan, which recommends immediately informing your doctor if you have two or more readings of 300 mg/dL in a row. In severe cases, very high blood sugar levels (well above 300 mg/dL) can result in coma. On the other side of the scale, a blood sugar reading below 70 mg/dL can be dangerous. If you experience more than two blood sugar readings below 70 mg/dL in a week, notify your doctor. Suppose that blood sugar levels are normally distributed with a mean of 100 mg/dl (milligrams per deciliter) and a standard deviation of 10mg/dL. David has a blood sugar level of 85 mg/dl. Calculate and David's z-score. What percentile is David in for his blood sugar level? What blood sugar readings would be more or less than 2.5 standard deviations from the mean? lio * f4 $ Download 101 4 % Search 5 Print ^ ◄0 6 . & 7 hp * + 8 f10 ► 11 о fuarrow_forwardG.97.arrow_forward
- Kolkmeyer Manufacturing Company is considering adding two machines to its manufacturing operation. This addition will bring the number of machines to nine. The president of Kolkmeyer asked for a study of the need to add a second employee to the repair operation. The arrival rate is 0.05 machines per hour for each machine, and the service rate for each individual assigned to the repair operation is 0.4 machines per hour. Mention the queuing model that can be implemented for the analysis (notation of Kendall) and why that model was chosenarrow_forward|In a seafood plant, 75% of all fish fillets are processed by Line 1, while the remaining 25% are processed by Line 2. Inspectors give each pack of fillets a quality grade of A and B. In Line 1, 60% and 40% of fillets receive quality scores of A and B, respectively. In Problem 5 Line 2, 85% and 15% of fillets receive quality scores of A and B, respectively. Line 2 produces better quality fillets, but it is slower and more expensive to maintain than Line 1. Randomly select a fillet pack. (Hint: Draw a tree diagram.) a. What is the probability that the fillet pack will have grade A? b. Given that the fillet is selected from grade-A fillet, what is the probability that it comes from Line 2?arrow_forward
- MATLAB: An Introduction with ApplicationsStatisticsISBN:9781119256830Author:Amos GilatPublisher:John Wiley & Sons IncProbability and Statistics for Engineering and th...StatisticsISBN:9781305251809Author:Jay L. DevorePublisher:Cengage LearningStatistics for The Behavioral Sciences (MindTap C...StatisticsISBN:9781305504912Author:Frederick J Gravetter, Larry B. WallnauPublisher:Cengage Learning
- Elementary Statistics: Picturing the World (7th E...StatisticsISBN:9780134683416Author:Ron Larson, Betsy FarberPublisher:PEARSONThe Basic Practice of StatisticsStatisticsISBN:9781319042578Author:David S. Moore, William I. Notz, Michael A. FlignerPublisher:W. H. FreemanIntroduction to the Practice of StatisticsStatisticsISBN:9781319013387Author:David S. Moore, George P. McCabe, Bruce A. CraigPublisher:W. H. Freeman
![Text book image](https://www.bartleby.com/isbn_cover_images/9781119256830/9781119256830_smallCoverImage.gif)
![Text book image](https://www.bartleby.com/isbn_cover_images/9781305251809/9781305251809_smallCoverImage.gif)
![Text book image](https://www.bartleby.com/isbn_cover_images/9781305504912/9781305504912_smallCoverImage.gif)
![Text book image](https://www.bartleby.com/isbn_cover_images/9780134683416/9780134683416_smallCoverImage.gif)
![Text book image](https://www.bartleby.com/isbn_cover_images/9781319042578/9781319042578_smallCoverImage.gif)
![Text book image](https://www.bartleby.com/isbn_cover_images/9781319013387/9781319013387_smallCoverImage.gif)