Budget

profileru va
PA2Guide1.xlsx

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