Reference no: EM13523059
1. Mac-in-the-Box sells computer equipment by mail and telephone order. Mac sells 2,400 flat-bed scanners per year. Ordering cost is $300 and the annual holding cost is 25 percent of the item's price. There are 300 working days in the year and the lead time is 3 days. The scanner manufacturer offers the following price structure to Mac-in-the Box:
|
Order Quantity
|
Price per Unit
|
|
1 to 199
|
$520.00
|
|
200 to 499
|
$515.00
|
|
500 or more
|
$512.00
|
- Given the above information and basing your decision on the economics, what order quantity do you recommend that Mac order from the scanner manufacturer? Why?
- How much more expensive is the next lowest cost option?
- For the optimal order quantity, what is the inventory position immediately after an order is placed?
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 forecast for these products and will be developing an aggregate capacity plan for the plant based on this forecast. The quarterly sales forecasts for the disk units are as follows:
|
1st Quarter
|
2nd Quarter
|
3rd Quarter
|
4th Quarter
|
|
1,800
|
2,340
|
1,980
|
1,800
|
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 or carrying cost is $100 per disk unit per quarter. The holding cost is based on the inventory at the end of each 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 zero disk 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 price reduction is $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 filling orders, backlogged items will always be filled before current quarter items,
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 starting in the second 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 $475 per disk unit for the labor and you provide the material
i. Demand during the fourth quarter of the prior year was 1,980 units.
j. Because there is a scheduled plant shut-down at the beginning of next year, the company wants to have the beginning inventory for next year at 360 units. This can be considered as additional fourth quarter demand. There will be no holding cost associated with these 360 units.
k. Assume that workers hired in any quarter will not need any training to reach full production in that quarter.
l. Compare the following three sales and operations plans.
i) Computer Products is considering a modified "matching" demand planning model for meeting the disk production. The company will hire and layoff workers to match the demand requirements each quarter as long as the capacity of the resulting workforce does not exceed 2,250 units per quarter. If it cannot meet the demand in a quarter because of this restriction, it will backlog the shortage until the next quarter. Ignoring the material cost, what is the total cost to produce the disks for the year? All workers will be fully utilized each quarter, in other words, there is no under utilization.
ii) As an alternative, the company will maintain a workforce capable of producing the demand during the fourth quarter of last year. If there are more workers in a quarter than required to produce the demand for that quarter, only the units required will be produced in that quarter and there will be underutilization. If demand is greater in a quarter than can be produced by the available workforce using straight time, the excess units will be outsourced. What is the total cost of this option, excluding the material cost?
iii) As an alternative, the company will establish in quarter one and then maintain a workforce capable of producing 2,160 units in a quarter. If there are more workers in a quarter than required to produce the demand for that quarter, only the units required will be produced in that quarter and there will be underutilization. If demand is greater in a quarter than can be produced by the available workforce using regular time labor, the excess units will be completed by using overtime, not to exceed 25% of the available straight time hours, and then backlogged until the next quarter when they will be produced using regular time labor. What is the total cost of this option, excluding the material cost?
3. You are scheduling production of your popular Rustic Coffee table. The demand for these coffee tables is 640 tables on day 5, 640 tables on day 6 and 256 tables on day 7. The components of the table are a top and a base assembly. The base assembly is composed of 4 legs, 2 short braces and 2 long braces. There is a brass cap that goes on the bottom of each leg.
|
Item
|
On Hand
|
Safety Stock
|
Allocated
|
Lot Size*
|
Lead Time (Days)
|
Scheduled Receipts
|
|
Coffee table
|
100
|
25
|
25
|
LFL
|
1
|
|
|
Top
|
200
|
100
|
0
|
LFL
|
3
|
|
|
Base Assembly
|
50
|
0
|
50
|
LFL
|
1
|
600 at the start of Day 3
|
|
Short Braces
|
0
|
0
|
0
|
LFL
|
2
|
|
|
Long Braces
|
0
|
0
|
0
|
LFL
|
2
|
|
|
Legs
|
0
|
0
|
0
|
1000@
|
3
|
3,000 at the start of Day 1
|
|
Brass caps
|
2,000
|
0
|
0
|
1,000+
|
1
|
|
*Notes:
- The company wants to try buying a pre-assembled Base Assembly in the future so it has bought 600 from a potential supplier and these are scheduled to arrive at the start of Day 3. There are also 3,000 Legs already scheduled to arrive at the start of Day 1.
- For the brass caps, the plus (+) sign indicates the minimum order quantity is 1,000; above that the order quantity is LFL.
- For the Legs, the @ sign indicates that the legs are ordered in increments of 1,000.
a) Construct the product structure tree for the coffee table and all of the items required to construct the table.
b) Complete the MRP for the coffee table and all of the items required to construct the table.
4. Harkin Electronics is planning its production for the next quarter for its two product lines, relays and capacitors. The profit contribution is $250 for a case of relays and $200 for a case of capacitors. Three resources limit how much of each product the company can produce: labor, stamping capacity, and testing capacity. Next quarter 80,000 labor hours will be available; a case of relays requires 200 labor hours and a case of capacitors requires 150. The stamping machine will be available for 1,200 hours next quarter and a case of relays requires 4 hours on the stamping machine and a case of capacitors requires 2 hours. Relays require 3 hours of testing per case and capacitors require 5. The testing machine will be available for 2,000 hours next quarter. For every case of capacitors, the company can produce no more than two cases of relays. At a minimum the company must produce at least 150 cases of relays.
a) To maximize total profit next quarter, how many cases of relays and capacitors should Harkin Electronics produce during that period? If your answer is in fractional units of cases that is acceptable - do not round to whole number of cases.
b) How much profit will result? As a reminder, provide your linear programming formulation and the software solution to receive any credit for this problem.
c) Using your sensitivity analysis output, answer the following questions. You must indicate the source of your answers from the sensitivity analysis output.
- For which resources would it make sense to add additional capacity based on the company's objective? Why?
- If you excluded a resource, why did you exclude it?
- For those resources for which you would consider adding additional units, what is the range on the right-hand side values for the shadow prices to remain valid?
- How much would you need to change the price of the capacitor so that its value in the optimal solution changes from the current value or in other words when the current optimal solution is no longer valid? Explain.
d) Now suppose that there is a requirement that of the total labor hours used by Harkins, at least 60% must be hours used for producing relays. Write the constraint for this requirement. However, you do not need to resolve the problem.
5. Levy Furniture, a furniture manufacturer is planning a factory expansion project. The activities required, their immediate predecessors, and the optimistic, most likely, and pessimistic estimates of their times (in days) are provided below. The project network is also provided.
|
Activity
|
Description
|
Immediate Predecessors
|
Optimistic Time (days)
|
Most Likely Time (days)
|
Pessimistic Time (days)
|
|
A
|
Develop initial plans
|
--
|
2
|
2.5
|
6
|
|
B
|
Secure financing
|
A
|
1
|
2
|
3
|
|
C
|
Develop final plans
|
A
|
2
|
3
|
10
|
|
D
|
Hire contractor
|
C
|
1
|
3
|
5
|
|
E
|
Secure permits
|
C
|
1
|
4
|
7
|
|
F
|
Construct addition
|
B,D,E
|
3
|
11
|
13
|
|
G
|
Order equipment
|
A
|
6
|
11
|
22
|
|
H
|
Install equipment
|
F,G
|
1
|
3
|
5
|
a) Construct the project network.
b) Identify the critical path and provide the project completion time.
c) Calculate the slack time for each activity and for each path (relative to the critical path).
d) Looking at only the critical path, find the probability that the store will take more than 23 working days to open.
e) What is the probability of completing path AGH in time for the store to open within 23 working days?
6. The Oxford Copy Shop and Typing Pool is a local copy shop that produces course packets. Professors take copies of handout and other course-related materials to the Copy Shop, which duplicates them and sells them to students. The jobs are due at the end of the day on the Due Dates that are provided. It is now the beginning of Day 6 and the store has the following jobs on hand:
|
Job
|
Day Brought to Shop
|
Processing Time (Days)
|
Due at the end of Day ___
|
|
BA 426
|
1
|
4
|
14
|
|
MGT 302
|
2
|
2
|
9
|
|
MKT 291
|
3
|
8
|
14
|
|
ACC 321
|
4
|
6
|
22
|
|
MIS 235
|
5
|
7
|
20
|
You are asked to schedule and evaluate several sequencing rules. You are ready to schedule these six jobs. They are all ready to be processed.
a) Determine the sequence of jobs using the following rules:
- Critical ratio rule (CR) - (remaining time to promised time)/(remaining processing time)
- Longest Processing Time (LPT)
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 (in other words, the late time would be set at zero if a job is early).
d) Prioritize the rules used in a) based on average early time with no penalty for completing any test late (in other words, the early time would be set at zero if a job is late).
7. The Peace Care Hospital uses 3,500 boxes of sterile bandages per month. The annual holding cost rate per year is 20% of the acquisition price. A typical box of sterile bandages costs $14.50 to purchase. The ordering cost is $25 each time an order is placed, regardless of the order quantity. There is storage space for at most 750 boxes of bandages at any time. The hospital operates 365 days per year. Peace Care Hospital would like to use the EOQ model.
a) How many boxes of sterile bandages should be ordered each time an order is placed if they want to minimize the annual inventory cost?
b) How many orders per years should be expected?
c) What is the expected total inventory (holding and ordering) cost per year?
d) How many days should one order last on average?
8. The manager of Cheryl's hospital is determining how often to perform preventive maintenance. When the testing machine fails, it costs the company $15,000 in lost production. However, the cost of preventive maintenance is somewhat expensive. The cost of performing preventive maintenance is $3,000.
|
Weeks between Preventive Maintenance
|
Average Number of Breakdowns between Preventive Maintenance
|
|
1
|
0.039
|
|
2
|
0.110
|
|
3
|
0.131
|
|
4
|
0.151
|
|
5
|
0.176
|
a) Which interval do you recommend for performing preventive maintenance? Base this recommendation on the economics as presented.
b) Suppose that the company has outsourced the preventive maintenance work. The cost of the preventive maintenance work is negotiable. With everything else being the same as provided above, what is the preventive maintenance cost that makes the manager indifferent between a one week and a two week preventive maintenance strategy? Assume that the preventive maintenance costs the same regardless of the weeks between preventive maintenance.
9. ABC Construction has developed the following set of activities for its budgeting process.
|
Activity
|
Predecessor
|
Normal Time (Days)
|
Resulting Activity Time if Activity is Crashed (Days)
|
Total Cost to complete activity in Normal Time
|
Total Cost to complete activity in Crash Time
|
|
A
|
--
|
4
|
2
|
$200
|
$600
|
|
B
|
A
|
6
|
3
|
$300
|
$1200
|
|
C
|
A
|
4
|
1
|
$300
|
$900
|
|
D
|
B, C
|
3
|
2
|
$500
|
$550
|
|
E
|
D
|
4
|
1
|
$500
|
$1700
|
a) Using the Normal Times, what is the critical path and project completion time for the budgeting process? Also, what is the cost to complete the project based on the Normal Times?
b) If we want to reduce the project completion time to the minimum possible time by crashing activities, what is the new project completion time and what is the new total project cost?
c) Modify the problem as follows. There is now an indirect cost of $75 per day, which is in addition to the cost identified above. There is also a penalty cost of $200 per day for any project completion time over 11 days. What is the minimum cost schedule for the project and what is the total cost for this schedule? Identify what are the time and the path of this minimum cost schedule.
d) Suppose that the company wants to crash the project 4 days. Based on the information provided in the table and in part c) and the results from part c), what would the minimum penalty cost have to be for this to be supported by the economics in the problem? Assume that the indirect cost remains at $75 per day.