Directions:
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:
Lot size – 300
Currently starting inventory – 25 units
Demand time fence – Weeks 1-3
Period
1
2
3
4
5
6
7
8
9
10
11
12
Forecast
90
120
110
80
85
95
100
110
90
90
100
110
Cust. orders
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?
Submission: 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. Submit the assignment as a Word document with the file name LastName_FirstName_CaseStudy.
Grading: This essay is worth 100 points toward your final grade and will be graded using the Case Study Rubric. Please use it as a guide toward successful completion of this assignment.