Click here to have a similar A+ quality paper

Order Now

Problem 12-7 Eighty units of end item X are needed at the beginning of week 6, and another 30 units are needed at the beginning of week 8. Picture Prepare a material requirements plan for component D. D can only be ordered in whole cases (50 units per case). One case of D is automatically received every other week, beginning in week 1 (i.e., weeks 1, 3, 5, 7). Also, there are 30 units of B and 20 units of D now on hand. Lead times for all items are a function of quantity: one week for up to 100 units, two weeks for 101 to 200 units, three weeks for 201 to 300 units, and four weeks for 301 or more units. (Leave no cells blank – be certain to enter “0” wherever required.) Part D Beg. Inv. 1 2 3 4 5 6 7 8 Gross requirements Scheduled receipts On hand Net requirements Planned-order receipt Planned-order release

Problem 12-7

Eighty units of end item X are needed at the beginning of week 6, and another 30 units are needed at the beginning of week 8.

Picture

Prepare a material requirements plan for component D. D can only be ordered in whole cases (50 units per case). One case of D is automatically received every other week, beginning in week 1 (i.e., weeks 1, 3, 5, 7). Also, there are 30 units of B and 20 units of D now on hand. Lead times for all items are a function of quantity: one week for up to 100 units, two weeks for 101 to 200 units, three weeks for 201 to 300 units, and four weeks for 301 or more units. (Leave no cells blank – be certain to enter “0” wherever required.)

 

Part D      Beg. Inv.         1        2        3        4        5        6        7           8
  Gross requirements
  Scheduled receipts
  On hand
  Net requirements
  Planned-order receipt
  Planned-order release

 

Problem 12-9

Assume that you are the manager of a shop that assembles power tools. You have just received an order for 56 chain saws, which are to be shipped at the start of week 8. Pertinent information on the saws is

 

Item Lead Time (weeks) On Hand     Components
Saw 2 15   A(2), B(1), C(4)
A 1 10   E(3), D(1)
B 2 5   D(2), F(3)
C 2 65   E(2), D(2)
D 1 20
E 1 10
F 2 30

 

b. Develop the material requirements plan for component E using lot-for-lot ordering. (Leave no cells blank – be certain to enter “0” wherever required.)

 

  Item: E(3) & E(2) LT = 1 wk.       Beg. Inv.        1      2      3      4      5     6     7     8
  Gross requirements
  Scheduled receipts
  Projected on hand
  Net requirements
  Planned order receipt
  Planned order release

 

Problem 12-12

A firm that produces electric golf carts has just received an order for 200 carts, which must be ready for delivery at the start of week 8. Information concerning the product structure, lead times, and quantities on hand is shown in the following table. Use this information to do each of the following:

 

Parts List for Electric Golf Cart Lead Time Quantity on Hand
  Electric golf cart 1 0
      Top 1 40
      Base 1 20
  Top
      Supports (4) 1 200
      Cover 1 0
  Base
      Motor 2 300
      Body 3 50
      Seats (2) 2 120
  Body
      Frame 1 35
      Controls 1 0
      Wheel assemblies (4) 1 240

 

Develop a material requirements plan that will provide 200 golf carts by week 8 assuming lot-for-lot ordering. (Negative amounts should be indicated by a minus sign. Leave no cells blank – be certain to enter “0” wherever required.)

 

Master Schedule for golf carts

 

  Week          Beg. Inv.        1         2        3        4        5        6        7        8
  Quantity

 

  Item: Golf Cart LT = 1 wk.        Beg. Inv.     1       2       3     4       5       6        7     8
  Gross requirements
  Scheduled receipts
  Projected on hand
  Net requirements
  Planned order receipts
  Planned order releases

 

  Item: Top LT = 1 wk.        Beg. Inv.     1       2       3       4       5       6       7     8
  Gross requirements
  Scheduled receipts
  Projected on hand
  Net requirements
  Planned order receipts
  Planned order releases

 

  Item: Supports (4) LT = 1 wk.        Beg. Inv.     1       2       3       4       5       6       7     8
  Gross requirements
  Scheduled receipts
  Projected on hand
  Net requirements
  Planned order receipts
  Planned order releases

 

  Item: Cover LT = 1 wk.        Beg. Inv.     1       2       3       4       5       6     7     8
  Gross requirements
  Scheduled receipts
  Projected on hand
  Net requirements
  Planned order receipts
  Planned order releases

 

  Item: Base LT = 1 wk.        Beg. Inv.     1       2       3       4       5       6       7     8
  Gross requirements
  Scheduled receipts
  Projected on hand
  Net requirements
  Planned order receipts
  Planned order releases

 

  Item: Motor LT = 2 wks.        Beg. Inv.     1       2       3       4       5       6       7     8
  Gross requirements
  Scheduled receipts
  Projected on hand
  Net requirements
  Planned order receipts
  Planned order releases

 

  Item: Body LT = 3 wks.        Beg. Inv.     1       2       3       4       5       6       7     8
  Gross requirements
  Scheduled receipts
  Projected on hand
  Net requirements
  Planned order receipts
  Planned order releases

 

  Item: Seats LT = 2 wks.        Beg. Inv.     1       2       3       4       5       6       7     8
  Gross requirements
  Scheduled receipts
  Projected on hand
  Net requirements
  Planned order receipts
  Planned order releases

 

  Item: Frame LT = 1 wk.        Beg. Inv.     1       2       3       4       5       6       7     8
  Gross requirements
  Scheduled receipts
  Projected on hand
  Net requirements
  Planned order receipts
  Planned order releases

 

  Item: Controls LT = 1 wk.        Beg. Inv.     1       2       3     4       5       6       7     8
  Gross requirements
  Scheduled receipts
  Projected on hand
  Net requirements
  Planned order receipts
  Planned order releases

 

  Item: Wheel Assemblies LT = 1 wk.     Beg. Inv.     1        2       3       4       5       6       7     8
  Gross requirements
  Scheduled receipts
  Projected on hand
  Net requirements
  Planned order receipts
  Planned order releases

 

Problem 12-15

A company that manufactures paving material for driveways and parking lots expects the following demand for its product for the next four weeks:
  Week number 1 2 3 4
  Material (tons) 40 80 60 70

The company’s labor and machine standards and available capacities are as follows:
Labor Machine
  Production standard (hours per ton) 4 3
  Weekly production capacity (hours) 300 200

a. Determine the capacity utilization for labor and machine for each of the four weeks. (Round your answers to 1 decimal place. Omit the “%” sign in your response.)
Week     Capacity Utilization
for Labor
    Capacity Utilization
for Machine
1 % %
2 % %
3 % %
4 % %

Click here to have a similar A+ quality paper

Order Now