Question: Based on the given information , a student needs to play as a decision maker on behalf of the company by addressing the following prompts:

Based on the given information, a student needs to play as a decision maker on behalf of the company by addressing the following prompts:

  1. As a manager, you know that inventory ordering policies address two basic issues, and they are: how much to order and when to order. Therefore, you need to determine both the optimal order quantity and the reorder point for product A of bracelets.
  2. Given that the management of the company sets 1500 units of product A of bracelets as the starting inventory of January, determine the ending inventory of each month during the entire year.
  3. According to the ending inventory information you have attained, calculate the total inventory costs including shortage, holding, and ordering costs.
  4. Develop a product sequence plan by determining the order in which all product types will be processed. Consider the following priority rules:
  • FCFS (First Come First Served)
  • SPT (Shortest Processing Time)
  • EDD (Earliest Due Date)
  • LPT (Largest Processing Time)
  1. As you have developed the sequence plan using SPT and EDD rules, determine the following:
  • The average amount of time from when a product type arrives until it is finished (Average flow time)
  • The time needed to complete the group of product types from the beginning of the first product type to the completion of the last product type (makespan)
  • The average tardiness
  • Which product is found tardy?
  • Which priority rule would you recommend for minimizing the average flow time? Justify your answer.
  • Draw a Gantt chart of the SPT rule sequence

Jewelry manufacturing industries are mostly labor-intensive industries that need high operator involvement. Jewelry items such as brooches, rings, bracelets, earrings, etc. are meant for adornment and can be worn by persons. A jewelry company reveals the following production information as shown in Table 1 including the different types of each product name, processing times and due dates. The production department does not consider product setup times on machines for its production.

Product name Bracelets Rings Brooches Earrings
Product type A B C D E F G H I J K L
Processing time/hour 0.5 0.2 0.7 0.1 0.3 0.5 0.6 0.9 0.7 0.3 0.4 0.2
Minutes until due 15 18 55 12 12 21 33 54 44 20 33 14

Table 1. Processing times and due dates of product types

The receiving department at the company orders materials for producing each finished product type. For example, one unit of product A of bracelets requires one unit of material A1, three units of material A2 and two units of material A3. Further, each unit of material A2 needs one unit of material A21, one unit of material A3 needs three units of A31, and finally one unit of material A31 needs five units of material A311. Moreover, the purchase costs and quality (quality scale is out of 100) of materials required from suppliers to build the finished product are shown in Table 2.

Product type A1 A2 A3 A21 A31 A311
Measures cost quality cost quality cost quality cost quality cost quality cost quality
Supplier 1 $4.0 60 n/a n/a $3.9 40 $2.9 40 $2.0 20 n/a n/a
Supplier 2 $4.5 30 $3.5 55 $3.7 40 $2.5 40 n/a n/a $1.5 25
Supplier 3 $4.7 50 n/a n/a $3.0 40 n/a n/a $2.3 10 $1.5 15

Table 2. Purchase costs and quality of materials

The production manager sets each machine to be available for 2000 hours per year (i.e., a department works one 8-hour shift per day, 250 days per year). Each machine costs $15000. Additionally, the marketing department brings the following customer demand information about product A of bracelets as shown in Table 3.

Month Jan. Feb. Mar. Apr. May Jun. Jul. Aug. Sept. Oct. Nov. Dec.
Demand 500 550 610 620 ? ? ? ? ? ? ? ?

Table 3. Available customer demand values

Finally, the management of inventory at the company, that plays a great role in the function of meeting the customer demand and smoothing production requirements, estimates the following:

  • Setup costs per order include $150 and $200 for both fixed cost transportation (trucking) and other order expenses, respectively.
  • Annual holding cost is 6% of the total cost of product A of bracelets.
  • Shortage cost is 25% of the total cost of product A of bracelets.
  • Lead time is one month.
  • Demand rate is assumed to be 470 unit per month
  • Starting (beginning) inventory for January is 1500 units.
  • No safety stock is specified.

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Accounting Questions!