Business Finance Homework Help

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	115	110	80	85	92	100	108	90	86	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.

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.