Description of this paper

Saint GBA334 all module assignments [module 1 to module 8 assignments ]

Description

solution


Question

Question;module 1GBA 334 Application Assignment 1 Instructions;Application assignments require solving problems from the;textbook. Most of the;problems require that you use Excel QM. Some chapters will;require you to use POM;QM for Windows or TreePlan. The answers must be submitted to;the Dropbox in a;Microsoft Word or Microsoft Excel file.;You must state your answers within a complete sentence so;that your understanding of;applying the results of the computations can be observed.;You should also include the;work for your computation, this will assist in applying;partial credit if your answers are;not correct.;Do not submit QM for Windows files as server security;policies do not allow many of;these files to be passed in the system. If you need to show;the QM work, either save as;an Excel file (a function within QM) or paste a screen;capture of the QM Entry Screen;before solving AND the QM result screen(s).;NOTE: QM files should not be sent through the online system.;If using QM for your;solution, run the file in QM and then copy and paste the;solution into a MS Excel file;(within QM there is an option tab at bottom of the screen to;save as MS Excel.) If you;cannot do this, with the QM solution file open on your;screen, select alt-print screen and;then paste the image into a MS Excel file.;If you need any assistance, please do not hesitate to;contact your instructor. He or she;will be happy to assist.;For this module, you will complete the following problems;from the textbook;? Chapter 1, page 18, Problems 22 and 23 using Excel;? Chapter 2, page 63, Problems 43 and 45 using Excel;(disregard instructions to;use Appendix C in Problem 43 Part a, use Excel instead);Submit Application Assignment 1 to the Dropbox no later than;Sunday 11:59 EST/EDT;of Module 1. Remember, the required formats are Microsoft;Word and Microsoft Excel. module 2 assignmentGBA 334 Application Assignment 2 InstructionsApplication assignments require solving problems from the textbook. Most of the problems require that you use Excel QM. Some chapters will require you to use POM QM for Windows or TreePlan. The answers must be submitted to the Dropbox in a Microsoft Word or Microsoft Excel file.You must state your answers within a complete sentence so that your understanding of applying the results of the computations can be observed. You should also include the work for your computation, this will assist in applying partial credit if your answers are not correct.Do not submitQM for Windows files as server security policies do not allow many ofthese files to be passed in the system. If you need to show the QM work, either save as an Excel file (a function within QM) or paste a screen capture of the QM Entry Screen before solving AND the QM result screen(s).NOTE: QM files should not be sent through the online system. If using QM for yoursolution, run the file in QM and then copy and paste the solution into a MS Excel file (within QM there is an option tab at bottom of the screen to save as MS Excel.) If you cannot do this, with the QM solution file open on your screen, select alt-print screen and then paste the image into a MS Excel file.If you need any assistance, please do not hesitate to contact your instructor. He or she will be happy to assist.For this module, you will complete the following problems from the textbook: Chapter 3, page 107, Problem 24 using Excel/Excel QM and page 110, Problem 37 using TreePlan.#24A souvenir retailer has an opportunity to establish a new location inside a large airport. The annual returns will depend primarily on the size of the space she rents and if the economy will be favorable. The retailer has worked with the airport concession commission, and has projected the following possible annual earnings associated with renting a small, medium, large or very large space:Chart Belowa) What is the souvenir retailer's maximax decision?b) What is her maximin decision?c) What is her equally likely decision?d) What is her criterion of realism decision, using a = 0.8?e) What is her minimax decision?Here is the chart:Size GoodEconomy FairEconomy PoorEconomySmall 70,000 28,000 -14,000Medium 112,000 42,000 -28,000Large 140,000 42,000 -56,000Very large 420,000 35,000 -224,000#37Shamrock oil owns a parcel of land that has the potential to be an underground oil field. It will cost $500,000 to drill for oil. If oil does exist on the land, shamrock will realize a payoff of $4,000,000 (not including drill cost). With current information, shamrock estimates that there is a 0.2 probability that oil is present on the site. Shamrock also has the option of selling the land as is for $400,000, without further information about the likelihood of oil being present. A third option is to perform geological test at the site, which would cost $100,000. There is a 30% chance that the test results will be positive, after which shamrock can sell the land for $650,000 or drill the land, with a 0.65 probability that oil exists. if the test results are negative, shamrock can sell the land for $50,000 or drill the land, with a 0.05 probability that oil does exists.a) Using a decision tree, recommend a course of action for Shamrock Oil.module 3GBA 334 Application Assignment 3 Instructions;Application assignments require solving problems from the;textbook. Most of the;problems require that you use Excel QM. Some chapters will;require you to use POM;QM for Windows or TreePlan. The answers must be submitted to;the Dropbox in a;Microsoft Word or Microsoft Excel file.;You must state your answers within a complete sentence so;that your understanding of;applying the results of the computations can be observed.;You should also include the;work for your computation, this will assist in applying;partial credit if your answers are;not correct.;Do not submit QM for Windows files as server security;policies do not allow many of;these files to be passed in the system. If you need to show;the QM work, either save as;an Excel file (a function within QM) or paste a screen;capture of the QM Entry Screen;before solving AND the QM result screen(s).;NOTE: QM files should not be sent through the online system.;If using QM for your;solution, run the file in QM and then copy and paste the;solution into a MS Excel file;(within QM there is an option tab at bottom of the screen to;save as MS Excel.) If you;cannot do this, with the QM solution file open on your;screen, select alt-print screen and;then paste the image into a MS Excel file.;If you need any assistance, please do not hesitate to;contact your instructor. He or she;will be happy to assist.;For this module, you will complete the following problems;from the textbook;? Chapter 4, pages 146-147, Problems 30, 31, and 32 using;the Data Analysis;Add-In for Microsoft Excel;? Chapter 5, pages 188-189, Problems 25 and 31 using either;Excel?s Data;Analysis Add-In or Excel QM;Submit Application Assignment 3 to the Dropbox no later than;Sunday 11:59 EST/EDT;of Module 3. Remember, the required formats are Microsoft;Word and Microsoft Excel.For this module, you will;complete the following problems from the textbook:? Chapter 4, pages 146-147;Problems 30, 31, and 32 using the Data AnalysisAdd-In for Microsoft Excel? Chapter 5, pages 188-189;Problems 25 and 31 using either Excel?s DataAnalysis Add-In or Excel QMChap 3#30 pg 146 A sample of nine public;universities and nine private universities wastaken. The total cost for the;year (including room and board) and the median SAT score (maximum total is;2400) at each school were recorded. It was felt that schools with higher median;SAT scores would have a better reputation and would charge more tuition as a;result of that. The data is in the table below. Use regression to help answer;the following questions based on this sample data. Do schools with higher SAT;scores charge more in tuition and fees? Are private schools more expensive than;public schools when SAT scores are taken into consideration? Discuss how;accurate you believe these results are using information related the regression;models.Category Total Cost Median;SATPublic 21,700 1990Public 15,600 1620Public 16,900 1810Public 15,400 1540Public 23,100 1540Public 21,400 1600Public 16,500 1560Public 23,500 1890Public 20,200 1620Private 30,400 1630Private 41,500 1840Private 36,100 1980Private 42,100 1930Private 27,100 2130Private 34,800 2010Private 32,100 1590Private 31,800 1720Private 32,100 1770# 31 pg 146In 2008, the total payroll;for the New York Yankees was $209.1 million, while the total payroll for the;Tampa By Rays was about $43.8 million about 1/5th of that of the Yankees. The;table below lists the payrolls in millions for all 14 MLB teams in the American;league and the total victories for 2008Team Payroll millions;victoriesNY Yankees 209.1 89Detroit Tigers 138.7 74Boston Red Sox 133.4 95Chicago White sox 121.2 89Cleveland Indians 79 81Baltimore Orioles 67.2 68Oakland Athletics 48 75Los Angeles Angels 119.2;100Seattle Mariners 118 61Toronto Blue Jays 98.6 86Minnesota Twins 62.2 88Kansas City 58.2 75Tampa Bay 43.8 97Texas Rangers 68.2 79Develop a regression model;to predict total number of victories based on payroll of the team. Based on;results discuss how accurate the model is. Use the model to predict the number;of victories for a team with a payroll of $79million#32In 2009, the New York;Yankees won 103 baseball games during the regular season. The table on the next;page lists the number of victories (W), the earned-run- average (ERA), and the;batting average (AVG) of each team in the American League. The ERA is one;measure of the effectiveness of the pitching staff, and a lower number is *****;The batting average is one measure of effectiveness of the hitters, and a;higher number is *****TEAM W ERA AVGNew York Yankees 103 4.26;0.283Los Angeles Angels 97 4.45;0.285Boston Red Sox 95 4.35 0.27Minnesota Twins 87 4.5;0.274Texas Rangers 87 4.38 0.26Detroit Tigers 86 4.29 0.26Seaattle Mariners 85 3.87;0.258Tampa Bay Rays 84 4.33;0.263Chicago White Sox 79 4.14;0.258Toronto Blue Jays 75 4.47;0.266Oakland Athletics 75 4.26;0.262Cleveland Indians 65 5.06;0.264Kansas City Royals 65 4.83;0.259Baltimore Orioles 64 5.15;0.268A.Develop a regression;model that could be used to predict the number of victories based on the ERA.B.Develop a regression;model that could be used to predict the number of victories based on the;batting average.C.Which of the two models;is better for predicting the number of victories?D.Develop a multiple;regression model that includes both ERA and batting average. How does this;compare to the previous models?Q5.25Sales of industrial vacuum;cleaners at R. Lowenthal Supply Co. over the past 13 months are as follows:Sales (1,000s) MONTH Sales (1,000s) MONTH11 January 14;August14 February 17 September16 March 12 October10 April 14 November15 May 16 December17 June 11 January11 July (a) Using a moving average;with three periods, determine the demand for vacuum cleaners for next February.(b) Using a weighted moving;average with three periods, determine the demand for vacuum cleans for;February. Use 3, 2 and 1 for the weights of the most recent, second most;recent, and third most recent periods, respectively. For example, if you were;forecasting the demand for February, November would have a weight of 1;December would have a weight of 2, and January would have a weight of 3.(c) Evaluate the accuracy;of each of these methods.(d) What other factors;might R. Lowenthal consider in forecasting sales?#31 pg 189A major source of revenue;in Texas is a state sales tax on certaintypes of goods and;services. Data are compiled and the;statecomptroller uses them to;project future revenues for the state budget. One particular category of goods is classified;as Retail Trade. Fouryears of quarterly data for;one particular area of southeast Texasfollows:quarter year 1 year 2 year 3 year 4------------------------------------------------------------1 218 225 234 2502 247 254 265 2833 243 255 264 2894 292 299 327 356a)compute seasonal indices;for each quarter based on a CMA.b)Deseasonalize the data;and develop a trend line on the deseasonalizeddata.c)Use the trend line to;forecast the sales for each quarter of year 5.d)Use the seasonal indices;to adjust the forecasts found in part (c)to obtain the final;forecasts.;="msonormal">module 4 assignmentOmar Haaris receives 5000 tripods annually from Top-Grade Supplier to meet his annual demand. Omar runs a large photographic outlet, and the tripods are used primarily with 35mm cameras. The ordering cost is $15 per order, and the carrying cost is $0.50 per unit per year. Weekly demand is 100 tripods. A) What is the optimal order quantity? Question 37Based on available information, lead time demand for CD-ROM drives averages 250 units (normally distributed), with a standard deviation of 25 drives. Management want s a 98% service level. A)How many drives should be carried as safety stock? B)What is the appropriate ROP?module 5#201- A series of activities must be completed in a coordinated fashion to complete a landscaping overhaul. The following table shows the activities their optimistic, most likely and pessimistic durations and their immediate predecessorsDAYSActivity A m b Immediate PredecessorsA 4 8 12 ---B 4 10 13 AC 7 14 18 BD 9 16 20 BE 6 9 12 BF 2 4 6 D,EG 4 7 13 C,FH 3 5 7 GI 2 3 4 G,HA- Determine the expected times and variances for each activityB- Construct a project network for this problemC- Determine the EST, EFT, LST, LFT and slack for each activity. Also determine the critical path and project completion time.D- What is the probability that the project will be finished in less than 57 days?E- What is the probability that the project will need at least 50 days?# 22The expected project completion time for the construction of a pleasure yacht is 21 months, and the project variance is 6. What is the probability that the project will:Require at least 17 months?Be completed within 20 months?Require at least 23 months?Be completed within 25 months?# 30Bowman Builders manufactures steel storage sheds for commercial use, Joe Bowman, president of Bowman Builders, is contemplating producing sheds for home use. The activities necessary to build an experimental model and related data are given in the table on the next page. The project completion time using standard times is 14 weeks. How much does it cost to reduce the duration of this project from 14 weeks to 10 weeks?Activity Immediate Predec. Standard time Stand. Cost Crashtime(weeks) CrashCostA -- 3 1,000 2 1,600B -- 2 2,000 1 2,700C -- 1 300 1 300D A 7 1,300 3 1,600E B 6 850 3 1,000F C 2 4,000 1 5,000G D,E 4 1,500 2 2,000And Q-35modul 6Q9Bechtold Construction is in the process of installing power lines to a large housing development. Steve Bechtold wants to minimize the total length of wire used, which will minimize his costs. The housing development is shown as a network in Figure.Each house has been numbered, and the distances between houses are given in hundreds of feet. What do you recommend?Q1112-9 Transworld Moving has been hired to move the office furniture and equipment of Cohen Properties to their new headquarters. What route do you recommend?Q19The road system around the hotel complex on International Drive (node 1) to Disney World (node 11) in Orlando, Florida, is shown in the network of Figure 12.27. The numbers by the nodes represent the traffic flow in hundreds of cars per hour. What is the maximum flow of cars from the hotel complex to Disney World? PSee attached file for full problem description.Q34A technician monitors a group of five computers that run an automated manufacturing facility. It takes an average of 15 minutes (exponentially distrubuted) to adjust a computer that develops a problem. The computers run for an average of 85 minutes (Poisson distributed) without requiring adjustments. What is the(A) average number of computers waiting for adjustment?(B) average number of computers not in working order?(C) probability the system is empty?(D) average time in the queue?(E) average time in the systenmentsm?week 8Small boxes of NutraFlakes cereal are labeled ?net weight 10 ounces.? Each hour, random samples of size n = 4 boxes are weighed to check process control. Five hours of observations yielded the following:WeightTime Box 1 Box 2 Box 3 Box 49 A.M. 9.8 10.4 9.9 10.310 A.M. 10.1 10.2 9.9 9.811 A.M. 9.9 10.5 10.3 10.1Noon 9.7 9.8 10.3 10.21 P.M. 9.7 10.1 9.9 9.9Using these data and the information in the Control Chart Limits Factors Table below (if you are doing it by hand), construct limits for xbar- and R-charts. Is the process in control? What other steps should the QC department follow at this point?

 

Paper#53407 | Written in 18-Jul-2015

Price : $117
SiteLock