maths

1

Quantitative Methods for Business (S2 2014)

Assignment 2

Due Monday 8 September 2014

 The assignments are to be submitted by 1:00pm on the due date on line. A hard copy is to be handed in during class.

 An assignment submitted late, without an extension being granted, will attract a penalty of 5% (5 marks) per each working day or part thereof beyond the due day and time. Please refer to the Course

Information Booklet for the course policy regarding extensions.

 Please remember to fill out and attach a cover sheet. A copy of the cover sheet can be downloaded from the Course web page.

 Please make sure that the pages of your submission are in the correct order and that they are stapled securely in the top left-hand corner only. Please make sure that each page shows your name and the page

number.

 Your assignment submission does not have to be typed; neat and legible hand-written solutions are sufficient. Poor presentation will attract a penalty of 10%.

 Please – no plastic sleeves or any type of folder!

 Show all your work!

Question 1 (Total of 30 marks)

(a) You are the manager of a toy company. The company takes its name from your email id (“email id Toy Company” and you insert your own email id into that part of the company name). Your company manufactures a variety of soft toys and you are trying to improve the efficiency of your operations. You wish to adhere to an annual operating budget and to develop operating plans using quantitative methods wherever possible. The overall budget for the year for production of two different soft toys is $500,000. The soft toys are koalas and kangaroos. The budget is intended to pay for labour and materials. Processing requirements for the two toys, on a per unit basis, are shown in the table.

Product Grey cloth

White cloth

Stuffing Labour

Koala 1.5 metres

0.5 metres

350gms 1.75 hours

Kangaroo 1.0 metres

1.0 metres

400gms 1.50 hours

The company has a contractual agreement to produce a minimum of 3,000 toys per year. There must be at least 200 of each toy produced.

2

The production costs for the toys are:

Material Cost

Labour/hour $9.50

Grey material/metre $5.50

White material/metre $8.50

Stuffing/100gms $0.35

The company can only get a maximum of 5,000 metres of each material.

You wish to minimise the number of labour hours required to meet your contractual obligation.

Give the full mathematical model for this problem.

a. (1 mark) What are the decision variables for this problem?

b. (2 marks) Using decision variables identified in part (a), formulate the objective function for this problem. Is the quantity of interest to be maximized or minimized? Explain briefly.

c. (2 marks) What is the limited resource in this problem? Using decision variables from part (a), formulate the constraint for this resource.

d. (4 marks) What other constraints are relevant to this problem? Using the decision variables from part (a), formulate those constraints.

e.

(6 marks) Use SOLVER to produce the answer and sensitivity reports required to answer the following questions.

1. (2 marks) What is the optimal number of toys? 2. (2 marks) The amount of labour hours required to meet the contractual agreement 3. (2 marks) How much of the budget has been spent?

4. (3 marks) The manager realises that labour per unit is actually the same for koalas as it is for kangaroos. Does this change the optimum number of toys of each kind to be produced. Explain how you know

3

5. (3 marks) The company Accountant believes that that amount labour required to make a kangaroo has changed to 1.7 hours. Discuss the impact that this change in the number of hours will have on the minimum value.

6. (3 marks) The Accountant further recommends that the budget be increased to $520,000. What impact will this change have on the minimum value?

Question 2 (Total 25 marks)

You are asked to analyze the results of a group of QMB students. You decide to summarise their assignment 2 and exam marks and comment on them. The data is found in the file QMB_Results.xlsx

(a) (8 marks) You decide to describe the shapes (symmetry, modality, outliers) of the distribution for both assignment 2 and Exam marks. To do this you use EXCEL to produce histograms and appropriate summary measures. You then present your findings

(b) (5 marks) Whether an observation is an outlier is a matter of judgement. One rule commonly used for identifying outliers is the so-called 1.5 × IQR rule. An observation is suspected to be an outlier if it is more than 1.5 × IQR below the first quartile Q1 or 1.5*IQR above the third quartile Q3.

Apply this rule to both distributions and identify suspected outliers (if any) by using the calculated amounts.

(c) (5 marks) You need to discuss which measures of location and dispersion should be used to describe these distributions? Give (brief) reasons. For each distribution you state which measures should be used giving reasons for your choices.

(d) (3 marks) You then write down and interpret the values of the summary measures you have chosen

Question 3 (Total 20 marks)

You then decide to investigate whether there is a linear relationship between the assignment 2 mark received and exam mark using QMB_RESULTS.xlsx.

a) (5 marks) You produce a regression plot that includes the regression equation and the coefficient of determination.

b) You then answer the following questions

i) (1 mark) Which is the explanatory and which is the response variable?

ii) (2 marks) What is the value of the slope for this equation? Interpret what this value means.

iii) (2 marks) What is value of the intercept for this equation? Interpret what the value means

iv) (2.5 marks) Calculate the coefficients of determination for this data set and explain what the value means.

v) (3.5 marks) Using the equation predict the exam mark when assignment 2 mark is 40%.

vi) (2.5 marks) Are you confident about your prediction? Give reasons for your answer.

vii) (1.5 marks) Should any marks be removed from the data sets?

4

Question 4 (Total 15 marks)

The following contingency table contains a breakdown of the age and gender of a sample of 100 South Australian general practitioners in 2003-2004.

Age

<35 35- 44

45- 54

>55 Total

Gender Male 5 15 20 24 64

Female 5 13 12 6 36

Total 10 28 32 30 100

(a) (3 marks) Produce a stacked percentage bar chart using the data in this contingency table

(b) (1.5 marks) What is the probability that one randomly selected general practitioner is 45-54 years old?

(c) (1.5 marks) What is the probability that one randomly selected general practitioner is both a woman and 35-44 years old?

(d) (2 marks) What is the probability that one randomly selected general practitioner is a woman or >55 years old? (e) (2 marks) What is the probability that one randomly selected general practitioner is a woman given she is 35-44 years old?

(f) (5 marks) Are the events Male and Age > 55 dependent? Give reasons for your answer.

5

Question 5 (Total of 10 marks)

Suppose the average weekly earnings of a production worker in 1997 was $424.20. A researcher randomly selects 54 production workers and obtains a representative earnings statement for one week from each worker.

(a) (5 marks) If the current average weekly earnings of the workers keeps the same as that of 1997, find the probability that the researcher gets a sample average of greater than $430 out of the 54 workers? Assume that the population standard deviation is $33.90. Please include a diagram to illustrate your answer

(b) (5 marks) Assuming the resulting sample average of the 54 randomly selected workers is $432.69, construct the 90% confidence interval of the mean weekly earnings of the production worker today. Assume that the population standard deviation is $33.90. Interpret the meaning of the confidence interval.