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

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?

Our Essay Format
  • Times New Roman, 12 pt
  • 1 Inch Margins
  • Double/ Single Spacing
  • 275/ 550 Words Per Page
  • MLA/ APA/ Turabian/ Chicago style, etc

A standard double-spaced page contains 275 words

Free Features
  • Hiring a preferred expert
  • Bibliography & cover page
  • Revisions within 14-30 days
  • 24/7 customer support
payments

Team of Professional Essay Writers

With our essay service, you'll find an essay writer for any task. Their rating is based on previous customer reviews and successful orders. Before you hire a writer, you can familiarize yourself with their track record in detail.