A company manufactures two types of DVD players, A and B. Although there are differences among the products, there are a number of common parts within each player. Each model A requires one subassembly C and two subassembly D’s. Each subassembly C requires two F’s and two G’s. Each subassembly D requires two units of F. Each F requires two units of raw material I, while each G requires one unit of raw material H. Each model B requires two subassemblies C’s and two subassemblies E’s. Each E requires two units of G. The lead times and current inventory on hand of the parts and components are as follows:
Item |
Number currently in stock |
Leadtime (weeks) |
DvD Model A |
30 |
1 |
DvD Model B |
50 |
2 |
Subassembly C |
75 |
1 |
Subassembly D |
80 |
2 |
Subassembly E |
100 |
1 |
Part F |
150 |
1 |
Part G |
40 |
1 |
Raw material H |
200 |
2 |
Raw material I |
300 |
2 |
.
The Company has created a forecast that it plans to use as its master production schedule. Part of the MPS shows demand for 700 units of model A and 1200 units of model B in week ten. (a) Draw product trees for A and B. (b) Develop an MRP schedule for the products and each component to meet demand for DVD models A and B in week ten. Use chase strategy lot sizing.
(a)
(b)
Use the following method to complete the MRP tables:
Item - A | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | |
Gross requirements | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 700 | |
Scheduled receipts | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | |
Projected on-hand | 30 | 30 | 30 | 30 | 30 | 30 | 30 | 30 | 30 | 30 | 0 |
Net requirements | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 670 | |
Planned order release | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 670 | |
Planned order receipt | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 670 | 0 | |
Item - B | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | |
Gross requirements | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1200 | |
Scheduled receipts | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | |
Projected on-hand | 50 | 50 | 50 | 50 | 50 | 50 | 50 | 50 | 50 | 50 | 0 |
Net requirements | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1150 | |
Planned order release | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1150 | |
Planned order receipt | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1150 | 0 | 0 | |
Item - C | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | |
Gross requirements | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 2300 | 670 | 0 | |
Scheduled receipts | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | |
Projected on-hand | 75 | 75 | 75 | 75 | 75 | 75 | 75 | 75 | 0 | 0 | 0 |
Net requirements | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 2225 | 670 | 0 | |
Planned order release | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 2225 | 670 | 0 | |
Planned order receipt | 0 | 0 | 0 | 0 | 0 | 0 | 2225 | 670 | 0 | 0 | |
Item - D | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | |
Gross requirements | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1340 | 0 | |
Scheduled receipts | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | |
Projected on-hand | 80 | 80 | 80 | 80 | 80 | 80 | 80 | 80 | 80 | 0 | 0 |
Net requirements | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1260 | 0 | |
Planned order release | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1260 | 0 | |
Planned order receipt | 0 | 0 | 0 | 0 | 0 | 0 | 1260 | 0 | 0 | 0 | |
Item - E | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | |
Gross requirements | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 2300 | 0 | 0 | |
Scheduled receipts | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | |
Projected on-hand | 100 | 100 | 100 | 100 | 100 | 100 | 100 | 100 | 0 | 0 | 0 |
Net requirements | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 2200 | 0 | 0 | |
Planned order release | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 2200 | 0 | 0 | |
Planned order receipt | 0 | 0 | 0 | 0 | 0 | 0 | 2200 | 0 | 0 | 0 | |
Item - F | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | |
Gross requirements | 0 | 0 | 0 | 0 | 0 | 0 | 6970 | 1340 | 0 | 0 | |
Scheduled receipts | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | |
Projected on-hand | 150 | 150 | 150 | 150 | 150 | 150 | 150 | 0 | 0 | 0 | 0 |
Net requirements | 0 | 0 | 0 | 0 | 0 | 0 | 6820 | 1340 | 0 | 0 | |
Planned order release | 0 | 0 | 0 | 0 | 0 | 0 | 6820 | 1340 | 0 | 0 | |
Planned order receipt | 0 | 0 | 0 | 0 | 0 | 6820 | 1340 | 0 | 0 | 0 | |
Item - G | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | |
Gross requirements | 0 | 0 | 0 | 0 | 0 | 0 | 8850 | 1340 | 0 | 0 | |
Scheduled receipts | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | |
Projected on-hand | 40 | 40 | 40 | 40 | 40 | 40 | 40 | 0 | 0 | 0 | 0 |
Net requirements | 0 | 0 | 0 | 0 | 0 | 0 | 8810 | 1340 | 0 | 0 | |
Planned order release | 0 | 0 | 0 | 0 | 0 | 0 | 8810 | 1340 | 0 | 0 | |
Planned order receipt | 0 | 0 | 0 | 0 | 0 | 8810 | 1340 | 0 | 0 | 0 | |
Item - H | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | |
Gross requirements | 0 | 0 | 0 | 0 | 0 | 8810 | 1340 | 0 | 0 | 0 | |
Scheduled receipts | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | |
Projected on-hand | 200 | 200 | 200 | 200 | 200 | 200 | 0 | 0 | 0 | 0 | 0 |
Net requirements | 0 | 0 | 0 | 0 | 0 | 8610 | 1340 | 0 | 0 | 0 | |
Planned order release | 0 | 0 | 0 | 0 | 0 | 8610 | 1340 | 0 | 0 | 0 | |
Planned order receipt | 0 | 0 | 0 | 8610 | 1340 | 0 | 0 | 0 | 0 | 0 | |
Item - I | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | |
Gross requirements | 0 | 0 | 0 | 0 | 0 | 13640 | 2680 | 0 | 0 | 0 | |
Scheduled receipts | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | |
Projected on-hand | 300 | 300 | 300 | 300 | 300 | 300 | 0 | 0 | 0 | 0 | 0 |
Net requirements | 0 | 0 | 0 | 0 | 0 | 13340 | 2680 | 0 | 0 | 0 | |
Planned order release | 0 | 0 | 0 | 0 | 0 | 13340 | 2680 | 0 | 0 | 0 | |
Planned order receipt | 0 | 0 | 0 | 13340 | 2680 | 0 | 0 | 0 | 0 | 0 |
Calculations in Excel (week 3 to 9 are hidden and contains formulae to be simply copied)
A company manufactures two types of DVD players, A and B. Although there are differences among...
HiTech Products manufacures three types of DVD players. Economy, Standard and Deluxe. The company, which uses activity-based costing, has identified five activities (and relative cost drivers). Each activity, its budgeted cost and related cost driver is identified below: Activity Cost Cost Driver Material Handling $225,000 Number of parts Material insertion 2,475,000 Number of parts Automated machinery 840,000 Machine hours Finishing 170,000 Direct lbor hours Packaging 170,000 Order shipped Total 3,880,000 The following information pertains to each product line of DVD...
please show all steps clearly 1. A company manufactures three types of items: A, B, and C. Each type of item produced incurs a variable cost and a raw material cost. Table 1 gives associated costs together with the selling price of each product. There are two types of resources (labor) used for producing each item, namely machinery time and craftsman time (Table 2). Each week, the company can obtain all the needed raw material but only 140 craftsman hours...
The Bloomington Bike Company produces two models: the Basic and the Supra. Herb Hoosier, the owner, plans to assemble 10 Basics and 15 Supras in each week during periods 4 to 8. Product structure trees for each bike are shown below: Develop a materials requirement plan (MRP) for component parts X and F over the next eight weeks. Data on all lead times, current inventory and ordering rules are given below: Scheduled receipts are: Period 1: 20 B’s, 18 W’s;...
Question number 2.2.2) TRY. An Air Conditioner (Aircon) is made up of 2 pumps (A): 2 motors (B); and 1 evaporator assembly (C). The evaporator assembly (C) is made up of 4 aluminium plates (D), 2 fans (E) and 2 copper tubing subassemblies (F). Each copper tubing subassembly (F) is made up of 2 brackets (G) and 2 sheets (H). The table below shows the lead times for each component: Lead Time Component Aircon NN w Nowa F G H...
Q.1 Ecoclock manufactures four environmentally friendly consumer products, and the firm is organized as four operating centers, each responsible for a single product. The main mechanism of each product is the same and requires an identical initial processing step, although subsequent processing for each product is very different. Ecoclock’s management has decided to centralize the initial processing function and purchase new equipment that has a 40,000 unit annual practical capacity. For budgeting and costing purposes, the initial processing function will...
j Canine Kennels Company (CKC) manufactures two different types of dog chew toys (A and B, sold in 1,000-count boxes) that are manufactured and assembled on three different workstations (W, X, and Y) using a small-batch process (see the figure below). Batch setup times are negligible. The flowchart denotes the path each product follows through the manufacturing process, and each product's price, demand per week, and processing times per unit are indicated as well. Purchased parts and raw materials consumed...
Use the scenario given below to answer the following question(s) Ray Inc. manufactures two types of gaming consoles, the sp2 hybrid and the sp3 hybrid models. The manufacturing process consists of two principal departments: design and production. The design department has 58 skilled workers, each of whom works 7 hours per day. The production department has 25 workers, who also work a 7-hour shift. On an average, to produce a sp2 hybrid, Ray Inc. requires 3.5 labor hours for design...
Analytics Exercise 9-1 Recently, Phil Harris, the production control manager at Brunswick, read an article on time-phased requirements planning. He was curious about how this technique might work in scheduling Brunswick's engine assembly operations and decided to prepare an example to illustrate the use of time phased requirements planning. Phil's first step was to prepare a master schedule for one of the engine types produced by Brunswick: the Model 1000 engine. This schedule indicates the number of units of the...
Consider a chocolate manufacturing company which produces only two types of chocolate- A and B. Both the chocolates require Milk and Choco only. To manufacture each unit of A and B, following quantities are required: . Each unit of A requires 1 unit of Milk and 3 units of Choco . Each unit of B requires 1 unit of Milk and 2 units of Choco The company kitchen has a total of 5 units of Milk and 12 units of Choco. On each...
b) A manufacturing of UT CUver Sheet mak ng company makes two models A and B of a product. Each piece Model A requires 9 labor hours for fabricating and 1 labor hour for finishing. Each piece of Model B requires 12 labor hours for fabricating and 3 labor hours for finishing For fabricating and finishing, the maximum labor hours available are 180 and 30 respectively. The company makes a profit of AED 8000 on each piece of model A...