Sheet1
| for this assignment please explain in detail the initial situation the requirements then provide complete solution to the questions explained on calculations and provide four scholarly references and text book as reference for the data |
| March | April | May | June | July |
| Demand | 500 | 580 | 540 | 620 | Budgeting for Month April , May and June.All Given values in black and all found values in red |
| Ending Finished Goods Inventory | 190 | 145 | 135 | 155 | It is required 25% of the demand in a month be in inventory at the beginning of the month |
| production | 455 | 570 | 560 | 540 |
| Materials Required for Production (pounds) | 2275 | 2850 | 2800 | 2700 |
| Raw Materials Ending inventory (pounds) | 663 | 855 | 840 | 810 |
| Materials Acquitition ( pounds) | 2467 | 2835 | 2770 |
| Materials Budget | $ 9,868 | $ 11,340 | $ 11,080 |
