Food Processing RawCooked 1.1341.02 1.1381.034 1.1361.034 1.1341.016 1.1361.028 1.1381.012 1.1340.998 1.1341.016 1.1361.018 1.1361.018 1.1361.028 1.131.018 1.1340.998 1.1361.038...

Hello,I was wondering if you would be able to solve this assignment and how much it would cost, thank you.


Food Processing RawCooked 1.1341.02 1.1381.034 1.1361.034 1.1341.016 1.1361.028 1.1381.012 1.1340.998 1.1341.016 1.1361.018 1.1361.018 1.1361.028 1.131.018 1.1340.998 1.1361.038 1.1361.026 1.1361.024 1.1361.042 1.1361.008 1.1360.994 1.1361.032 1.1341.034 1.1321.042 1.1361.024 1.1361.018 1.1360.974 1.1361.032 1.1361.034 1.1361.012 1.1360.998 1.141 1.1361.016 1.1361.02 1.140.974 1.1341.02 1.1341.038 1.1361.026 1.1361.018 1.1361.028 1.1361.036 1.1381.042 1.1361.04 1.1361.032 1.1361.04 1.1381.044 Maintanenace Requests Maintenance Request by Department Bucket15 Clean room50 Core36 Coupler6 Foundry4 Gate House1 Machine Shop2 Melting19 Misc.15 Molding34 Office1 Pattern1 Shipping2 Warehouse1 Bacardi MonthSales JAN1141 FEB1424 MAR1503 APR1491 MAY2319 JUN1955 JUL1385 AUG1932 SEP1263 OCT2348 NOV2055 DEC 2360 JAN1247 FEB1545 MAR1708 APR1368 MAY2799 JUN1637 JUL1430 AUG2006 SEP1296 OCT2364 NOV2112 DEC 2310 Filling Time Head7:008:009:0010:0011:0012:0013:0014:0015:0016:00 11313.313.613.21412.914.212.914.513.5 214.11413.713.414.414.314.813.913.514.3 314.214.11413.913.91414.513.613.312.9 412.813.113.614.514.612.913.114.41414.4 513.114.114.212.913.31414.113.113.613.7 61413.613.213.413.914.51414.413.914.6 712.914.31412.914.214.814.513.112.713.9 813.614.413.114.513.513.31413.613.514.3 913.213.813.712.813.413.813.313.714.113.7 1013.713.813.413.714.112.813.713.814.114.3 Water Quality Age yrsMn ppbFe ppb 782360.253 80140.98 682.20.029 67380.446 61480.704 550.30.006 55530.276 48120.045 48120.009 46150.092 440.70.005 397.50.019 381.20.01 38470.109 357.50.084 32450.226 33340.003 48350.19 32330.23 23140.102 18130.08 14370.159 4240.21 12020.35 Travel Table 550 Travel Expense, Length of Trip, and Expense per Day, 100 Trips Trip NumberLength (Days)Expenses (dollars)Expense per DayTrip NumberLength (Days)Expenses (dollars)Expense per Day 17.7564.928.38513.0021.607.20 23.5030.708.77523.0022.217.40 36.5027.454.22537.2545.206.23 44.0033.448.36544.7517.983.79 51.7516.389.36551.5018.0012.00 64.7535.057.38563.7535.179.38 72.7519.267.00575.0028.205.64 83.5021.746.21581.5017.1911.46 91.008.728.72592.5029.6311.85 103.5022.246.35609.7555.205.66 114.2542.8310.08615.0044.698.94 124.7530.776.48623.7523.236.19 134.7529.156.14636.2532.415.19 142.5019.587.83642.0022.4811.24 154.7531.966.73652.0029.0114.51 162.5026.4110.56662.5012.645.06 173.7527.097.226714.0076.405.46 182.5025.2210.09682.7518.406.69 193.2533.6810.36692.0024.0812.04 202.7523.168.42703.2528.018.62 213.7527.307.28713.0021.937.31 222.0018.179.09723.0020.736.91 234.2528.816.78733.7529.137.77 244.0031.947.99742.2519.848.82 251.7518.8210.75754.5031.517.00 261.7521.1112.06763.7532.078.55 276.0027.824.64772.0020.5010.25 282.0017.858.93783.7525.486.79 292.0015.917.96794.0039.299.82 302.7527.219.89804.2543.8310.31 314.2532.497.64815.0034.696.94 320.5013.0926.18824.0025.376.34 339.0061.506.83832.0037.3018.65 345.5024.534.46845.2537.617.16 351.2516.3713.10851.5016.8011.20 362.0028.9114.46862.5024.659.86 373.2535.2610.85871.7516.019.15 382.7520.647.51886.5046.087.09 392.0028.3014.15891.0015.3515.35 403.2528.928.90904.7529.156.14 412.2522.269.89912.5017.456.98 421.5020.2013.47924.0034.228.56 431.5012.458.30932.7531.2411.36 442.0028.9614.48943.2529.339.02 454.0025.966.49954.5046.6110.36 464.0023.685.92962.5024.089.63 472.7517.576.39976.2537.215.95 483.0029.969.99982.7522.128.04 492.7527.219.89992.5043.8317.53 501.5021.6414.431004.2539.069.19 IDX QuarterQuantity (Units) I12 II18 III26 IV16 I16 II24 III28 IV18 BUS 605: Statistics for Managers Assignment I – Fall 2021 Name: Guidelines · For each methods of analysis, provide a brief background. · Show all mathematical calculations. Clearly mark graphs. All units specified. · Each table and figure should be numbered and given a short but explicit title. · Relevant data sets are provided in the Excel file; for example (Food Processing). · Begin each problem at the top of a new page. · Upload assignment on Blackboard. PDSA Cycle Discussion Discuss the elements of Plan – Do – Study – Act (PDSA) Cycle. Particularly address the following topics: · Linear(pipeline) Learning vs. Cyclical Learning · Evolution of PDCA Cycle · For each element discuss the concept and relevant ideas. For example, for Plan (plan), discuss the topic of operational definitions. The Germ Theory and Funnel Experiment After reading The Germ Theory of Management, Don’t Touch That Funnel papers and the funnel experiment in class, discuss the following topics: · Give a brief report on your understanding of the Germ Theory of Management. What did you take away from reading this paper? How some of the topics discussed in the paper are related to your workplace (your experience, life in general)? Give examples. · Give a brief report on your understanding of Don’t Touch that Funnel and the funnel experiment. Describe the four rules of the funnel and provide examples. Downtime MFG Plant The management is concerned about the high cost of maintenance and excessive downtime of the machines in a manufacturing plant. The data set below shows the recent maintenance requests. Considering data analysis methods discussed in class, discuss your observations and findings with the management using relevant chart(s). (Maintenance Requests) Food Processing A food processing operation consists of mixing ingredients, forming and cooking. Figure below shows the cooking process where the formed material travels through a cooking oven on a conveyer belt. The material is subject to shrinkage due to the cooking process. The specification limits for shrinkage is between 5% and 9%. There are two machines operating two shifts daily. A technician selects samples before and after cooking process and calculates percent shrinkage. The weight is in pounds. (Food Processing) · Develop histograms for both raw and cooked data sets. · Descriptive statistics for both raw and cooked data sets. · Using CV determine which varies more about the mean. · Show the run chart for both raw and cooked data. For clarity of discussion use the same Y scale for both data sets. Bacardi Sales The operations manager, marketing director and other managers of a local beverage company would like to develop a forecasting method for a popular brand of Bacardi rum. The discussion centered on demand patterns. (Bacardi) · Develop a run chart and discuss your findings. · Using MAD as a measure of forecasting method, which forecasting method do you recommend. Apply the following forecasting methods. It is helpful to present graphs and show a table of your results. · Three, six and nine period moving average. · Three period weighted moving average using .2, .3, .5 weights. · Exponential smoothing using Filling Management of a shampoo bottling company is concerned about consistency of the filling process. The specification target bottle size is 13.5 ounces. The process is depicted below. Every day, on the hour, an operator collects 10 samples, one from each filling head (Filling).                                                                                                                                                                                                                                 Head 1 2 3 4 5 6 7 8 9 10 a) Estimate sample standard deviation using population standard deviation. b) Estimate sample standard deviation using ten hourly averages. Compare and discuss the results in (a) and (b). c) Develop a histogram of individual measurements and a histogram of hourly averages. Compare the graphs and discuss your findings. Water Quality A few years ago the city of Madison published a report showing water quality test. The data showed water well ages and chemical test results (Water Quality). Are chemicals present in the water related to the age of the well? Discuss. Travel Travel and expenses for an organization is audited by the business office. Travel Expense and Length of Trip for 100 Trips for reimbursement purposes have been provided (Travel). Review and discuss the following analyses: · Develop histograms for both Travel Expense and Length of Trip. · Descriptive statistics for both Travel Expense and Length of Trip. · Apply the Empirical Rule to both variables, Show the values. · Using CV determine which varies more about the mean, Travel Expense (dollars) or Length of Travel (days). · Relate Length of Trip (days) to Travel Expense (dollars). Discuss and determine the strength of the relationship. Forecasting Sales IDX Tucson Machinery, Inc. manufactures numerically controlled machines, which sells for an average price of $0.5 million each. Unit sales for the past two years are used for forecasting. What are the quarterly sales for year three. (IDX). 2
Nov 01, 2021
SOLUTION.PDF

Get Answer To This Question

Related Questions & Answers

More Questions »

Submit New Assignment

Copy and Paste Your Assignment Here