Question: Given the following initial inventory, forecast and order quantities for an item. The MPS or the lot size is 100 because of the production run.

  1. Given the following initial inventory, forecast and order quantities for an item. The MPS or the lot size is 100 because of the production run. Production rule is to schedule when the projected on- hand is less than 10. Use the worksheet on the next page to answer the question. (10 pts.)

  1. Projected Ending inventory
  2. Availabletopromise inventory (ATP).

On- hand/Beginning Inventory 60

June

July

1

2

3

4

5

6

7

8

Forecast

60

85

110

90

120

45

55

80

Booked Orders(com mitted)

70

60

35

20

Requirements=

Max (F, OB)

Projected Ending Inventory

MPS

AvailableTo Promising Inventory (ATP)

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 General Management Questions!

Q:

Given the following initial inventory, forecast and order quantities for an item. The MPS or the lot size is 100 because of the production run. Production rule is to schedule when the projected on-...

Q:

Word File Edit View Insert Format Tools Table Window Help 87% 0 Mon 5:34 PM a AutoSave OFF 58 w Assignment06 (1) Q Home Insert Draw Design Layout References Mailings Review View Share O Comments X LO...

Q:

N 1. Given the following information: Inventory on Hand: Z= A=0 B=0 Routing File: Bill of Materials: Lot size Part WC Setup (min) Run Time (min/unit) B (3) C (4) 100 75 50 Z B 30 40 50 35 25 45 5.0...

Q:

N 1. Given the following information: Inventory on Hand: Z=0 A=0 B=0 Routing File: Bill of Materials: Lot size Part WC Setup (min) Run Time (min/unit) 5.0 B (3) C (4) 100 75 50 Z B 30 40 50 35 25 45...

Q:

Z 1. Given the following information: Inventory on Hand: Z=0 A=0 B=0 Routing File: Bill of Materials: Lot size Part WC Setup (min) Run Time (min/unit) B (3) C (4) 100 75 50 N 30 40 50 35 25 45 5.0...

Q:

Show all your work please!! Problem 1 Given the following information: Inventory on Hand: None Bill of Materials: Z Routing File: Lot Part Size WC Setup (min) Run Time (min/unit) D(2) F(2) Z 50 F(1)...

Q:

Work Center Model A Model B 10 2.4 3.5 The master production schedule for the next 5 weeks is Week 1 2 3 4 5 Model A 70 50 50 60 48 Model B 20 40 55 30 45 a. Using the resource bill and the master...

Q:

Given the following data. There are 1 0 0 on hand ( Project Available Balance at beginning ) . The lot size is 2 0 0 . To determine MPS ( no shortage, no excessive inventory ) , the MPS at 4 th week...

Q:

Given the following data. There are 1 0 0 on hand ( Project Available Balance at beginning ) . The lot size is 2 0 0 . The MPS has been determined as needed ( no shortage, no excessive inventory ) ....

Q:

C. The Master Production Schedule (MPS) calls for 450 units in Week 1 and 600 in week of product Z. Fill in the Work center loads (minutes) for the two weeks in the table below: Week 1 Week 2 WC Z Z...

Q:

Multiple Choice Questions 1. If a publicly traded company is trying to maximize its perceived value to decision makers external to the corporation, the company is most likely to understate which of...

Q:

Create a statement of cash flows with this information? Sales Cost of Goods Sold Gross Margin Operating Expenses: Salaries and Wages Expense Rent Expense Depreciation Expense Spartan Cases Inc....

Q:

The proceeds, if any, of a derivative lawsuit, go to: the shareholders of the corporation. the shareholders who actually filed the lawsuit. the board of directors. the corporation.

Q:

Write a 700- to 1,050-word paper in which you explain the process for conducting and closing procurements. Include the following: Explain high-level process steps for conducting project procurements....