Calculate the available to promise using the following data. There are $90$ units on hand.

Week	1	2	3	4	5	6
Customer Orders	70	70	20	40	10
MPS		100		100		100
ATP

Worldwide Can-Openers, Inc., makes a family of two hand-operated can openers. The production plan is based on months. There are $4$ weeks in this month. Opening inventory is $2000$ dozen, and it is planned to increase that to $4000$ dozen by the end of the month. The MPS is made using weekly periods. The forecast and projected available balance for the two models follow. The lot size for both models is $1000$ dozen. Calculate the production plan and the MPS for each item.

Model A

Model B

Given the following data, can an order for $40$ more units for delivery in week $5$ be accepted? If not, what do you suggest can be done? There are zero units on hand.

Solve $x^2-5 x-2=0$, using a calculator to approximate the solutions to three decimal places.

Where is the resource bill used?

What is the purpose of a rough-cut capacity plan?

The Acme Widget Company makes widgets in two models, and the bottleneck operation is in work center $10$. Following is the resource bill (in hours per part).

The master production schedule for the next $5$ weeks is

a. Using the resource bill and the master production schedule, calculate the number of hours required in work center $10$ for each of the $5$ weeks. Use the following table to record the required capacity on the work center.

b. If the available capacity at work station $10$ is $260$ hours per week, suggest possible ways of meeting the demand in week $3$.

In one of the previous examples, the MPS was unsatisfactory because there were poor inventory balances compared to the production plan. There was also a stockout for product C in periods $2$ and $3$. Revise the production plans for the three products to cut out or reduce these problems.

What are the three steps in making an MPS?

Where does the information come from to develop an MPS?

Where does the information come from to develop an MPS?

The Amalgamated Mailbox Company manufactures a family of two mailboxes. The production plan and the MPS are developed on a quarterly basis. The forecast for the product group follows. The opening inventory is $270$ units, and the company wants to reduce this to $150$ units at the end of the year. Develop a level production plan.

Does the MPS work with families of products or with individual items?

What functions does the MPS perform between sales and production?