*please use excel and provide the formulas Acme Systems, Inc. produces a very large volume of...

*please use excel and provide the formulas

Acme Systems, Inc. produces a very large volume of plastic rods on a regular basis. These rods require an extremely accurate diameter. Thus, the Quality Control manager wants to know if the production process is producing rods at a consistent diameter. 220 rods have been sampled each day for 10 days. Defects have been recorded. Develop a “p” control chart for the proportion of defects across the 10 days. Assume Z = 2.58. Do any of the rods appear to be “out of control”? Comment on your findings.

Day	Defects
1	12
2	29
3	18
4	10
5	14
6	22
7	7
8	23
9	9
10	10

Expert Solution

please check the excel worksheet

as we can see there is only day 2 which have proportion value greater than upper control limit

now showing formula

orchestra answered 2 years ago

*please use excel and provide formulas Super Markets Inc. is considering expanding into the Scottsdale, Arizona,...

*please use excel and provide formulas Super Markets Inc. is considering expanding into the Scottsdale, Arizona, area. You as director of planning must present an analysis of the proposed expansion to the operating committee of the board of directors. As a part of your proposal, you need to include information on the amount people in the region spend per month for grocery items. You would also like to include information on the relationship between the amount spent for grocery items...

please use excel and provide the formulas The Times-Observer is a daily newspaper in Metro City....

please use excel and provide the formulas The Times-Observer is a daily newspaper in Metro City. Like many city newspapers, the TimesObserver is suffering through difficult financial times. The circulation manager is studying other papers in similar cities in the United States and Canada. She is particularly interested in what variables relate to the number of subscriptions to the paper. She is able to obtain the following sample information on 25 newspapers in similar cities. Ignore the data in the...

PLEASE SHOW THE EXCEL INPUTS AND FORMULAS AS I AM VERY NEW TO THIS SUBJECT AND...

PLEASE SHOW THE EXCEL INPUTS AND FORMULAS AS I AM VERY NEW TO THIS SUBJECT AND WANT TO LEARN EXCEL INPUTS. Problem 7-18 Abandonment We are examining a new project. We expect to sell 6,300 units per year at $57 net cash flow apiece for the next 10 years. In other words, the annual operating cash flow is projected to be $57 × 6,300 = $359,100. The relevant discount rate is 12 percent, and the initial investment required is $1,740,000....

I need this in an excel file with formulas please: 1) Use an Excel spreadsheet to...

I need this in an excel file with formulas please: 1) Use an Excel spreadsheet to solve problem #31 (the PUTZ, Inc. project) for Chapter 10 in the textbook. 2) Conduct a sensitivity analysis that focuses on the sales price by increasing the price by 10% above the best estimate, and then by decreasing the price by 10% below the best estimate. 3) You must provide one spreadsheet for each of the three situations—the base case estimate, the best case,...

***Excel is required to solve this problem. Please use excel and show all formulas used in...

***Excel is required to solve this problem. Please use excel and show all formulas used in each cell I would really appreciate the work*** Three-Stage FCFE Model: Biomet Inc., designs, manufactures and markets reconstructive and trauma devices, and reported earnings per share of $0.56 in 1993, on which it paid no dividends. (It had revenues per share in 1993 of $2.91). It had capital expenditures of $0.13 per share in 1993 and depreciation in the same year of $0.08 per...

Please use excel and show formulas ( formula auditing mode) please: Climate Control, Inc. makes expedition-quality...

Please use excel and show formulas ( formula auditing mode) please: Climate Control, Inc. makes expedition-quality rain gear for outdoor enthusiasts. Management prepared a forecast of sales (in suits) for next year and now must prepare a production plan. The company has traditionally maintained a level workforce strategy. All nine workers are treated like family and have been employed by the company for a number of years. Each employee can produce 2,000 suits per month. At present, finished goods inventory...

please provide me work book(Excel) with formulas in Excel to value options based on block sholes...

please provide me work book(Excel) with formulas in Excel to value options based on block sholes model

5. Use either R or Excel for the following. Provide the formulas or code that you...

5. Use either R or Excel for the following. Provide the formulas or code that you are using. Let x1 be a random variable that is N(100, 225). Let x2 be a random variable that is U(50,150) and let x3 be a random variable that is U(500,1500). Set Y = (X1)(X2)/ (X3) a) Use R to create 500 random numbers of each type (X1, X2, X3 and Y). b) Estimate P(0.1 < Y < 0.25) c) Estimate E(Y) and the...

Please use excel and show the excel formulas in detail. Alice wants to deposit $35,000 now...

Please use excel and show the excel formulas in detail. Alice wants to deposit $35,000 now $45,000 at the end of 6 years at a bank that pays 10% interest compounded semiannually. She wants to withdraw an amount every year for the first 6 years and to withdraw exactly $1000 more for the following four years. What is the maximum amount she could withdraw in year 1?

1) (note: Please also provide the excel formulas used to solve it ) You work for a...

1) (note: Please also provide the excel formulas used to solve it ) You work for a soft-drink company in the quality control division. You are interested in the standard deviation of one of your production lines as a measure of consistency. The product is intended to have a mean of 12 ounces, and your team would like the standard deviation to be as low as possible. You gather a random sample of 18 containers. Estimate the population standard deviation at...

Question