Case Study TRA2098

The Acme Water Pump Company has a problem. The pumps are fairly expensive to make and store so the company tends to keep the inventory low. At the same time it is important to respond to demand quickly since a customer who wants a water pump is very likely to get one from a competitor if Acme doesn’t have one available immediately. Determine what the projected available balance master production schedule and the available to promise is for each of the 12 weeks below. Complete the spreadsheet based on the following information: Period 1 2 3 4 5 6 7 8 9 10 11 12 Forecast 90 115 110 80 85 92 100 108 90 86 100 110 Cust. s 105 97 93 72 98 72 53 21 17 6 2 5 Proj. Balance (25) MPS ATP After completing the table write a brief summary of your planning process. Why did you decide on the numbers you did? What were the important factors to consider? The written summary should be 1-2 paragraphs in length and include an introduction with a thesis statement and a conclusion that summarizes the main ideas. Each paragraph should have a topic sentence supported by 3-5 sentences that offer additional details explanation and examples. The essay should be free of errors in grammar sentence structure and other mechanics. This assignment requires a file upload submission. After you have reviewed the assignment instructions and rubric as applicable complete your submission by selecting the Submit Assignment button next to the assignment title. Browse for your file and remember to select the Submit Assignment button below the file to complete your submission. Review the confirmation annotation that presents after submission. Requirements: 1-2 paragraphs | .doc file Lot size: 300 Currently starting inventory: 25 units Demand time fence: Weeks 1–3