Assignment Task: Advanced Statistics
Problem 1: The Bellevue University bookstore purchases sweatshirts with the school name and logo from a vendor. The vendor sells the sweatshirts to the store for $38 per shirt. The cost to the bookstore for placing an order is $120 and the annual carrying cost is 25 percent of the cost of a sweatshirt. The bookstore manager estimates that 1700 sweatshirts will be sold during the year. The vendor has offered the bookstore the following volume discount schedule:
Order Size
|
1-200
|
201-599
|
600-799
|
800+
|
Discount
|
0%
|
3%
|
3.50%
|
5%
|
a) What is the bookstore's optimal order quantity given this quantity discount information? Why?
b) What will be its annual inventory cost (including the holding cost, ordering cost and cost of the sweatshirts) for this optimal order quantity?
c) What is the lowest total annual inventory cost (as defined in b) for each of the other price (equivalently discount) options?
Problem 2: The Austin, Texas plant of Computer Products produces disk units for personal and small business computers. Gerald Knox, the plant's production planning director, is looking over next year's sales forecasts for these products and will be developing an aggregate capacity plan for the plant. The quarterly sales forecasts for the disk units are as follows:
1st Quarter
|
2nd Quarter
|
3rd Quarter
|
4th Quarter
|
2,610
|
2,520
|
2,520
|
2,700
|
Ample machine capacity exists to produce the forecast. Each disk unit takes an average of 20 labor-hours. In addition, you have collected the following information:
a. Inventory holding cost is $100 per disk unit per quarter. The holding cost is based on the inventory at the end of the quarter.
b. The plant works the same number of days in each quarter, 12 five-day weeks, 6 hours per day.
c. Beginning inventory is 90 (ninety) disk units and these will be used to meet the initial demand in the first quarter and there is no holding cost associated with these units.
d. In a backlog situation, the customer will wait for his order to be filled but will expect a price reduction each quarter he waits. The backlog costs are $300 per disk for the first quarter the customer waits, $700 for the second quarter the customer waits, and $900 for the third quarter the customer waits. In any quarter, if there is a backlog, this backlog will be filled before the demand for that period is filled.
e. The cost of hiring a worker is $800 while the cost of laying off a worker is $950.
f. The straight time labor rate is $20 per hour for the first quarter and increases to $22 per hour beginning in the third quarter.
g. Overtime work is paid at time and a half (150%) of the straight time work.
h. Outsourcing (contract work) is paid at the rate of $480 per disk unit for the labor and you provide the material.
i. Demand is projected to increase this year. Demand during the fourth quarter of the prior year was 2,340 units. The demand for the first quarter of the next year (year following the year you are analyzing) is projected to be at the 2,700 unit level.
a) You want to maintain a work force capable of producing 2,520 in a quarter outsourcing any disk units over this quantity. Excess units produced in a quarter would be carried over to meet demand in a subsequent quarter. Any additional demand is met through outsourcing. All workers will be fully utilized each quarter. In other words, there is no under utilization. What is the total cost of this option, excluding the material cost? Be sure to include any hiring and layoff costs.
b) The company will maintain a work force capable of producing 2,430 units in a quarter. It will allow backlogs to occur until the fourth quarter when it will outsource all demand that cannot be met with its own workforce. All workers will be fully utilized each quarter. In other words, there is no under utilization. What is the total cost of this option, excluding the material cost? Be sure to include any hiring and layoff costs.
Problem 3: Your Company is assembling product X. It is composed of two subassemblies: one B and two E. B is composed of one component C and two subassemblies D. In addition, E is composed of one of component C and two of component F.
The demand for X is for a total of 1,500 units.
How many units of each assembly must be made and how many units of each of the purchased items are required to meet the demand for X. Assume that all of the items On Hand include the Safety Stock and the Allocated (those already committed to another use). It is not necessary to provide the requirements by time period. You are simply asked to provide demand and requirements for the table and its assemblies, subassemblies and purchased items.
Item
|
On Hand
|
Safety Stock
|
Allocated
|
X
|
800
|
100
|
100
|
B
|
200
|
50
|
0
|
E
|
200
|
50
|
50
|
C
|
150
|
50
|
0
|
D
|
300
|
150
|
150
|
F
|
300
|
100
|
0
|
Problem 4: WeHaul Trucking is planning its truck purchases for the coming year. It allocated $600,000 for the purchase of additional trucks, of which three sizes are available. A large truck costs $150,000 and will return the equivalent of $15,000 per year to profit. A medium-sized truck costs $90,000 and will return the equivalent of $12,000 per year. A small truck costs $50,000 and will return the equivalent of $9,000 per year. WeHaul has maintenance capacity to service either four large trucks, five medium-sized trucks, or eight small trucks, or some equivalent combination. WeHaul believes that it will be able to hire a maximum of seven new drivers for these added trucks. The company cannot spend more than one/half of the total funds it actually spends to purchase medium-sized trucks. (Hint: this is not necessarily one half of the total funds it has allocated for the purchase of additional trucks).
You must submit your linear programming formulations and show the linear programming software solution to this problem to receive credit. If you solve this using another linear programming approach, you may submit that instead of the software solution.
a) Formulate a linear programming model to be used for determining how many of each size of truck to purchase if the company wants to maximize its profit. Ignore the time value of money. Provide the linear programming variables, the objective function, and the constraints for the problem.
b) At optimality, how much profit will result and what is the optimal combination of trucks? You must submit your linear programming formulations and show the linear programming software solution to this problem to receive credit. If your answer is in fractional units of trucks that is acceptable - do not round to whole number of trucks.
c) Using your sensitivity analysis output, provide two sensitivity analysis interpretations. One must be for the objective function and one must be for one of the constraints. You must provide the source of your answers from the sensitivity analysis output.
d) Now suppose that there is a requirement that WeHaul must purchase at least two small trucks for each medium size truck. Also, the number of larger trucks cannot be more than the total number of medium and small trucks. Write the constraint(s) for this requirement. However, you do not need to resolve the problem.
Problem 5: Development of a new deluxe version of a particular toy is being considered by T-O-Y Inc. The activities necessary for the completion of this project along with the relevant information for each activity are listed in the following table. The Total Crash Time represents the time for that activity after it has been crashed the maximum crash time allowed for that activity. For example, we can reduce the time for Activity A by one week to 3 weeks after crashing it.
Activity
|
Time to complete using Normal Time (Weeks)
|
Time activity is completed using Crash Time (Weeks)
|
Total Normal Cost
|
Crash Cost per period
|
Immediate Predecessors
|
A
|
4
|
3
|
$2,000
|
$600
|
--
|
B
|
2
|
1
|
2,200
|
$800
|
--
|
C
|
3
|
3
|
500
|
$0
|
--
|
D
|
8
|
4
|
2,300
|
$750
|
A
|
E
|
6
|
3
|
900
|
$100
|
B
|
F
|
3
|
2
|
3,000
|
$1,200
|
C
|
G
|
4
|
2
|
1,400
|
$300
|
D,E
|
a) Using the normal time, what is the critical path, the project completion time, the total time required to complete all of the activities, and the slack time for each path and each activity? (The slack time for each path should be relative to the time to complete the critical path.)
b) If you wish to reduce the time required to complete this project by one week, which activity should be crashed, and how much will this increase the total cost?
c) Now, we want to crash the project to the minimum possible time crashing any and all activities necessary to do this using the crash cost per period rule we have studied. What is the project completion time now? How much would the total cost increase?
d) Let's return to the results found in a). Suppose the company believes that reducing the project completion time from the time reported in part a), will help the company realize an additional $700 per week in revenue for the first two weeks the project time is reduced, $650 per week in revenue for the next two weeks the project is reduced and $500 per week in revenue after that for every week the project is reduced. How many weeks should the company reduce the project completion time and what is the resulting cost of the project considering the additional revenue as an offset to the cost associated with crashing the project? The company is interested in selecting the project duration and reduced activity times that minimize the cost of the project.
Problem 6: There are seven lab tests (shown below) that need to be run in the lab at Cheryl's hospital. The technician who does the testing can only do one at a time. Each test has a testing duration and due date (promised time). In all seven cases, the test results are coordinated with the results of other tests done in separate labs. Missing the deadline could delay a diagnosis. The tests are numbered as they come in the lab, but not all tests go through this department (hence the missing sequence numbers).
|
Test Time (Hours)
|
Promised Time (End of Hour) From Now
|
Test #104
|
8
|
22
|
Test #108
|
2
|
7
|
Test #112
|
5
|
6
|
Test #132
|
6
|
14
|
Test #141
|
3
|
9
|
Test #143
|
1
|
12
|
Test #150
|
4
|
19
|
It is now the end of the first hour and you have not started any of these tests. You are asked to schedule and evaluate two sequencing rules. You are ready to schedule these seven tests. They are all ready to be run.
a) Determine the sequence of jobs using the following rules:
- FCFS (First Come First Serve)
- Critical ratio rule (CR)
b) Prioritize the rules used in a) based on average flow time measured from now.
c) Prioritize the rules used in a) based on average lateness with no credit for completing any test early. If a job is late, its late time is zero ("0").
d) Prioritize the rules used in a) based on average early time. If a job is late, its early time is zero ("0").
Problem 7: A food processor uses approximately 28,000 glass jars a month for its fruit juice product. Because of storage limitations, a lot size (order quantity) of 4,000 jars has been used. The monthly holding cost is 18 percent of the jar's cost of $1.00. The ordering cost is $60 per order. The company operates an average of 20 days a month, twelve months a year. The lead time is 6 working days. The product is used uniformly throughout the 20 days.
a) What is the reorder point and what is the time between orders?
b) The manager would prefer ordering every 4 days (5 times per month) but would have to justify any change in the order size from its current 4,000 order quantity. One possibility is to simplify and improve the order processing activity to reduce the ordering cost. From a cost perspective, assuming everything else remains the same, what ordering cost per order for ordering every 4 days would enable the manager to justify ordering every fourth day compared to its current 4,000 order quantity? Assume the ordering cost for the current strategy of 4,000 jars remains at $60.
c) If the manager were to use the EOQ strategy, what would the order quantity be? What is the inventory position immediately after placing this order?
Problem 8: Rick Wing is looking at improving the temperature control on one of his machines. This system currently has four integrated controllers in series:
A → B → C → D
The reliability of these four controllers are 0.90 (A), 0.92 (B), 0.94 (C), and 0.96 (D).
Rick is looking at installing a back-up for each of the controllers. The back-up controllers all have a reliability of 0.90.
a) What is the reliability of the new system which provides a back-up for each of the controllers and what is the percent improvement compared to the current design?
b) Suppose that Rick is considering another back-up design. Here he would create a back-up system in parallel to the current system. This is shown below. The reliability of all four back-ups, A1, B1, C1, and D1, are each 0.90.
![2269_Back-up design.png](https://secure.tutorsglobe.com/CMSImages/2269_Back-up design.png)
What is the reliability of this back-up design?
Problem 9: A South American country has 17 planes in its air force. They are short on money and do not want to spend any more than necessary to keep the planes in running condition. The cost to perform preventive maintenance on all 17 planes is $16,000 in local dollars. If a plane has a malfunction between preventive maintenance, it costs $5,000 (local dollars) to while the plane is out of service for repairs and other related costs (referred to as the breakdown cost). The malfunction history on the planes is as follows.
Months Between PM
|
Average Number of Breakdowns Between PM Cycles
|
1
|
2.52
|
2
|
5.64
|
3
|
8.2
|
4
|
12.24
|
a) How often should preventive maintenance be performed based on a cost analysis?
b) What is the breakdown cost that would equate the monthly total maintenance strategy for a two-month PM cycle with a three-month PM cycle? For this analysis, assume that except for the cost of a breakdown all other data (facts and figures) are the same as given in the original problem statement.
Problem 10: The estimated times and immediate predecessors for the activities in a project at Caesar Douglas's screening company are given in the following table. Assume that the activity times are independent. All times are in weeks.
Activity
|
Predecessors
|
Optimistic Time (a)
|
Most Likely Time (m)
|
Pessimistic Time (b)
|
A
|
--
|
9
|
10
|
11
|
B
|
--
|
4
|
10
|
16
|
C
|
A
|
9
|
10
|
11
|
D
|
B
|
5
|
8
|
11
|
a) What is the critical path based on expected times? You may use any method to determine this?
b) What is the probability of completing the project in 22 weeks or less?
In order to avail the benefits of our Advanced Statistics Assignment Help service, you just have to contact our professional tutors and they will offer the best assignment solution that no other in the industry can offer.
Tags: Advanced Statistics Assignment Help, Advanced Statistics Homework Help, Advanced Statistics Coursework, Advanced Statistics Solved Assignments, Annual Inventory Cost Assignment Help, Annual Inventory Cost Homework Help, Linear Programming Model Assignment Help, Linear Programming Model Homework Help, Critical Path Assignment Help, Critical Path Homework Help, Breakdown Cost Assignment Help, Breakdown Cost Homework Help