What is the optimal production plan and associated cost

Assignment Help Applied Statistics
Reference no: EM132392822

Answer the following Questions

Question 1. A textile manufacturer has received fifteen orders for one of its main products. These orders have to be fulfilled in the next 13 weeks. Orders can be fulfilled by production on either Machine A or Machine B, or by outsourcing the production. Due to some special requirements, the first four orders cannot be produced on Machine B. The company owns 15 machines type A and 80 machines type B. The machines operate 24 hours per day and 7 days per week.

Each machine is down for regular maintenance 2 hours per week. Assume that orders may be split between machines and any fraction may be outsourced. Company policies dictate that no more than half of an order may be outsourced. For instance, for an order of 10,000 yards, no more than 5,000 yards may be outsourced. The following table shows the order size (in yards), the number of yards that each machine can produce per hour, the cost per yard for each machine and for the outsourcing option.

Order

Size (yds)

Machine A
Yds/hr         Cost/yd

Machine B
Yds/hr         Cost/yd

Outsourcing
Cost/yd

1

14000

4.510

$2.66

 

 

$2.77

2

52000

4.796

$2.55

 

 

$2.73

3

44000

4.629

$2.64

 

 

$2.85

4

20000

4.256

52.56

 

 

$2.73

5

77500

5.145

51.61

5.428

$1.60

$1.76

6

109500

3.806

$1.62

3.935

$1.61

$1.76

7

120000

4.168

$1.64

4.316

$1.61

$1.76

8

60000

5.251

$1.48

5.356

$1.47

$1.59

9

7500

5.223

51.50

5.277

$1.50

51.71

10

69500

5.216

$1.44

5.419

$1.42

$1.63

11

68500

3.744

$1.64

3.835

$1.64

$1.80

12

83000

4.157

$1.57

4.291

$1.56

$1.78

13

10000

4.422

$1.49

4.558

$1.48

$1.63

14

381000

5.281

$1.31

5.353

$1.30

$1.44

15

64000

4.222

$1.51

4.288

$1.50

$1.69

a. Formulate a linear programming model for this problem. What is the optimal production plan and associated cost?

Answer the following questions using information from the Sensitivity Report. Show the calculations associated with your answers.

b. How would the total cost change if one of the machines type A broke down and could not be used for 5 weeks to fulfill these orders?

c. How would the total cost change if an additional machine type B would be available for one week to work on these orders?

d. If the outsource policy is not applied to order 13 (i.e., if more than half of order 13 could be outsourced), would the optimal production/outsourcing plan change? Why?

e. If the company is able to negotiate a 5% discount on the outsource cost for order 10, would the optimal production/outsourcing plan change? Why?

f. The customer that placed order 5 would like to increase the order size to 80,000 yards. What would be the cost associated with the additional yards?

Question 2. A university administrator believes that some academic departments might be overstaffed and perhaps over budget. She would like to identify some potential budget, faculty, and staff reductions.

The administrator has collected data from last academic year for 26 academic departments, for which she considers the main inputs to be their annual budget (in thousands), the number of faculty, and the size of the administrative staff. She thinks that the main outputs are the number of publications per year and the size of the graduating class.

Dept.

Budget

Faculty

Staff

Pubs

Grads

A

9127

74

32

48

346

B

4221

32

20

155

142

C

22514

181

94

121

1453

D

759

3

10

S

41

E

2272

19

8

18

36

F

2907

13

31

24

285

G

12391

112

24

236

201

H

44981

366

175

503

790

 

1471

6

18

1

45

J

16154

137

52

S

184

IC

12169

97

49

98

1326

L

25876

207

97

257

1826

M

1479

S

18

6

126

N

851

4

9

2

105

0

4472

30

27

48

71

 

10291

90

25

109

179

0

2215

12

22

142

226

R

5345

42

21

10

260

 

10384

91

25

90

215

T

4166

33

18

155

74

U

3490

17

33

46

71

V

104130

963

149

1457

143

 

9754

74

47

45

110

X

9119

78

28

96

135

 

4076

30

20

104

84

 

5782

44

28

46

135

Use data envelopment analysis to determine whether there is any reason to believe that Department L is overstaffed and over budget.

a. Is this department relatively efficient?

b. What is this department reference set?

c. According to the DEA model, at what budget, faculty, and administrative staff levels should this department have to operate in order to be efficient compared to the other departments at this university?

Reference no: EM132392822

Questions Cloud

Discuss investment appraisal methods : Discuss investment appraisal methods and which method is most appropriate to today's business world. Justify your answer based proper sources.
Determine profit or loss from transactions : Your total commission cost for selling and buying the shares came to ?$111 Determine your profit or loss from these transactions.
Actuals vs Forecast Creation and Analysis : Actuals vs. Forecast Creation & Analysis - Please provide variance commentaries based on the Actuals incurred and the Forecast details provided
MGT-316 Entrepreneurship Assignment Problem : MGT-316 Entrepreneurship Assignment Help and Solution - Write essay on the characteristics and approaches of two famous entrepreneurs
What is the optimal production plan and associated cost : Formulate a linear programming model for this problem. What is the optimal production plan and associated cost? What is this department reference set?
ENGIN5304 Advanced Robotics Assignment Problem : ENGIN5304 Advanced Robotics Assignment Help and Solution, Federation University, Australia - Calculate degrees of freedom
What is the firm expected dividend stream : a. What is the firm's expected dividend stream over the next 3 years? b. What is the firm's current stock price?
What your required rate of return would be : Now your decision, if you were thinking about investing in a stock with a beta (b) of 1.5, show me what your required rate of return would be?
What is the company cost of equity capital : The firm's weighted average cost of capital is 9 percent and its pretax cost of debt is 6 percent. The tax rate is 21 percent.

Reviews

Write a Review

Applied Statistics Questions & Answers

  Hypothesis testing

What assumptions about the number of pedestrians passing the location in an hour are necessary for your hypothesis test to be valid?

  Calculate the maximum reduction in the standard deviation

Calculate the maximum reduction in the standard deviation

  Calculate the expected value, variance, and standard deviati

Calculate the expected value, variance, and standard deviation of the total income

  Determine the impact of social media use on student learning

Research paper examines determine the impact of social media use on student learning.

  Unemployment survey

Find a statistics study on Unemployment and explain the five-step process of the study.

  Statistical studies

Locate the original poll, summarize the poling procedure (background on how information was gathered), the sample surveyed.

  Evaluate the expected value of the total number of sales

Evaluate the expected value of the total number of sales

  Statistic project

Identify sample, population, sampling frame (if applicable), and response rate (if applicable). Describe sampling technique (if applicable) or experimental design

  Simple data analysis and comparison

Write a report on simple data analysis and comparison.

  Analyze the processed data in statistical survey

Analyze the processed data in Statistical survey.

  What is the probability

Find the probability of given case.

  Frequency distribution

Accepting Manipulation or Manipulating

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd