# Assignment Problems (82 points in total): Company E sells personal computers.

Question

Assignment Problems (82 points in total):

1. Company E sells personal computers. The monthly sales for the previous 4 months are summarized as follows:

Month

Actual Sales

May

20,000

June

18,000

July

20,000

August

24,000

(a) Compute the sales forecast for September using a 3-month moving average. Please include at least one step of calculation and the correct answer for full credit. (4 points)

(b) Compute the sales forecast for September using a weighted 3-month moving average using 0.20 for June, 0.30 for July, and 0.50 for August. Please include the formula, at least one step of calculation and the correct answer for full credit. (6 points)

(c) Suppose the forecast for August was 20,000 units. Using a smoothing constantα= 0.2, compute the sales forecast for September. Please include the formula, at least one step of calculation and the correct answer for full credit. (6 points)

2. Suppose the revenue for a firm is $2,500,000. Its cost of goods sold is $85,000, and its average inventory value for the year is $62,000. What is the firm’s inventory turnover?

Please include the formula, at least one step of calculation, and the correct answer for full credit. (6 points)

3. Given the following information, compute the economic order quantity of the inventory system.

Annual Demand

50,000 units

Order Cost

$150 per order

Unit Cost

$100 per unit

Inventory Holding

10% of unit cost

Please include the formula, at least one step of calculation, and the correct answer for full credit. (6 points)

4. Company X can purchase a certain component from either Supplier A or Supplier B. Supplier A charges $10 per unit for the first 2,000 units in an order, $9 per unit for the next 2,000 units in the order, and $8 per unit for any unit beyond. Supplier B charges $9 per unit for orders of no more than 4,000 units and $8.5 per unit for any bigger orders.

(a) Suppose Company X decides to buy 5,500 units from Supplier A. What is the average unit cost of the order? Please provide at least one step of calculation and the correct answer for full credit. (4 points)

(b) If Company X wants to place an order of 5,500 units, which supplier offers a lower total cost. Provide the reason for full credit. (4 points)

5. Please do your own research and provide a brief discussion of no less than 150 words regarding the relationships among VMI, EDI, and Continuous Replenishment. (6 points)

6. An assembly line is to operate 8 hours a day with a desired daily output of 240 units. The following table contains information on this product’s task times and sequential relationships:

Task

Task Time (seconds)

Immediate Predecessor

A

40

—–

B

30

A

C

20

A

D

50

B

E

60

D

F

20

C

G

40

E, F

H

50

G

Please answer the following questions based on the information given.

(a) Specify the sequential relationships among the tasks using a diagram. An example can be found on the lecture slides for Week 5. Please include all the tasks, arrows, and task times in the diagram for full credit. (10 points)

(b) What is the required workstation cycle time in this case? Please include the formula, at least one step of calculation, and the correct answer for full credit. (6 points)

(c) Suppose the application of some primary and secondary assignment rules suggests the following task assignment sequence: A, B, D, C, E, F, G, H.That is, Task A will be the first task to assign to a workstation, followed by Task B, Task D, and all the way to Task H. Then which tasks are assigned to each workstation? Label the workstations as Workstation 1, Workstation 2, and so on. Please list the workstation assignment of each task for full credit. (16 points)

(d) What is the efficiency of your design? Please include the formula, at least one step of calculation, and the correct answer for full credit. (6 points)

(e) Is the efficiency satisfactory and why? This is an open question. (2 points)