Description of this paper

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

Description

solution


Question

module 1;GBA 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 assignment;GBA 334 Application Assignment 2 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 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.;#24;A 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 Below;a) 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 PoorEconomy;Small 70,000 28,000 -14,000;Medium 112,000 42,000 -28,000;Large 140,000 42,000 -56,000;Very large 420,000 35,000 -224,000;#37;Shamrock 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 3;GBA 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 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;Chap 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 SAT;Public 21,700 1990;Public 15,600 1620;Public 16,900 1810;Public 15,400 1540;Public 23,100 1540;Public 21,400 1600;Public 16,500 1560;Public 23,500 1890;Public 20,200 1620;Private 30,400 1630;Private 41,500 1840;Private 36,100 1980;Private 42,100 1930;Private 27,100 2130;Private 34,800 2010;Private 32,100 1590;Private 31,800 1720;Private 32,100 1770;# 31 pg 146;In 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 2008;Team Payroll millions victories;NY Yankees 209.1 89;Detroit Tigers 138.7 74;Boston Red Sox 133.4 95;Chicago White sox 121.2 89;Cleveland Indians 79 81;Baltimore Orioles 67.2 68;Oakland Athletics 48 75;Los Angeles Angels 119.2 100;Seattle Mariners 118 61;Toronto Blue Jays 98.6 86;Minnesota Twins 62.2 88;Kansas City 58.2 75;Tampa Bay 43.8 97;Texas Rangers 68.2 79;Develop 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;#32;In 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 AVG;New York Yankees 103 4.26 0.283;Los Angeles Angels 97 4.45 0.285;Boston Red Sox 95 4.35 0.27;Minnesota Twins 87 4.5 0.274;Texas Rangers 87 4.38 0.26;Detroit Tigers 86 4.29 0.26;Seaattle Mariners 85 3.87 0.258;Tampa Bay Rays 84 4.33 0.263;Chicago White Sox 79 4.14 0.258;Toronto Blue Jays 75 4.47 0.266;Oakland Athletics 75 4.26 0.262;Cleveland Indians 65 5.06 0.264;Kansas City Royals 65 4.83 0.259;Baltimore Orioles 64 5.15 0.268;A.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.25;Sales of industrial vacuum cleaners at R. Lowenthal Supply Co. over the past 13 months are as follows;Sales (1,000s) MONTH Sales (1,000s) MONTH;11 January 14 August;14 February 17 September;16 March 12 October;10 April 14 November;15 May 16 December;17 June 11 January;11 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 189;A major source of revenue in Texas is a state sales tax on certain;types of goods and services. Data are compiled and the state;comptroller uses them to project future revenues for the state budget.;One particular category of goods is classified as Retail Trade. Four;years of quarterly data for one particular area of southeast Texas;follows;quarter year 1 year 2 year 3 year 4;------------------------------------------------------------;1 218 225 234 250;2 247 254 265 283;3 243 255 264 289;4 292 299 327 356;a)compute seasonal indices for each quarter based on a CMA.;b)Deseasonalize the data and develop a trend line on the deseasonalized;data.;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.;module 4 assignment;Omar 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 37;Based 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;#20;1- 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 predecessors;DAYS;Activity A m b Immediate Predecessors;A 4 8 12 ---;B 4 10 13 A;C 7 14 18 B;D 9 16 20 B;E 6 9 12 B;F 2 4 6 D,E;G 4 7 13 C,F;H 3 5 7 G;I 2 3 4 G,H;A- Determine the expected times and variances for each activity;B- Construct a project network for this problem;C- 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?;# 22;The 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?;# 30;Bowman 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) CrashCost;A -- 3 1,000 2 1,600;B -- 2 2,000 1 2,700;C -- 1 300 1 300;D A 7 1,300 3 1,600;E B 6 850 3 1,000;F C 2 4,000 1 5,000;G D,E 4 1,500 2 2,000;And Q-35;modul 6;Q9;Bechtold 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?;Q11;12-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?;Q19;The 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? P;See attached file for full problem description.;Q34;A 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 8;Small 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;Weight;Time Box 1 Box 2 Box 3 Box 4;9 A.M. 9.8 10.4 9.9 10.3;10 A.M. 10.1 10.2 9.9 9.8;11 A.M. 9.9 10.5 10.3 10.1;Noon 9.7 9.8 10.3 10.2;1 P.M. 9.7 10.1 9.9 9.9;Using 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#23163 | Written in 18-Jul-2015

Price : $132
SiteLock