Question: A rm uses components A, B, and C to assemble a nal product F; see the bill of materials in Figure 2. Calculate the total

A …rm uses components A, B, and C to assemble a …nal product “F”; see the bill of materials in Figure 2.

F A(2) B(2) B(3) С


Calculate the total inventory cost for the end item F during the eight weeks. Note that, for each week, the inventory cost includes a …xed ordering cost and a holding cost. We assume that the per order …xed ordering cost is $200/order, and the unit holding cost is $1 per item per week. The …xed cost is incurred each time when the …rm places an order. The holding cost is calculated according to the number of remaining items at the end of each week.

Week

1

2

3

4

5

6

7

8

MPS









Component A

Lot-sizing policy: …xed period of two; Lead time: 2 weeks;

Present on hand: 68; Scheduled receipts: 100 units in Week 1.

Gross Requirement









Scheduled Receipts









Projected On Hand









Net Requirements









PO Receipts









PO Releases









Component B

Lot-sizing policy: lot-for-lot; Lead time: 2 weeks;

Present on hand: 310; Scheduled receipts: 200 units in Week 2.

Gross Requirement









Scheduled Receipts









Projected On Hand









Net Requirements









PO Receipts









PO Releases









Table 2: MRP table for Question AQ5.

F A(2) (2) (3)

Step by Step Solution

3.49 Rating (172 Votes )

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock

The formulas and calculations have been shown in the excel above ATP is calculated as the difference ... View full answer

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!