X Williams Company Template (1).xlsx File Edit Insert Format Help Calibr BIUSAA A 1 2 C D Raw Materials Budget Willams Company First Quarter F + w H January Februar March Quarter 1 April 6 Units to be produced 7,000 8,000 10.000 25,000 7 RAW PVC 5 3 5 a RAW PVC per unit 4 4 4 4 9 Units of RAW PVC needed for production $5,000 40,000 10 Add. Desired ending RAW PVC inventory 11 Total RAW PVC units required 12 Less Beginning RAW PVC inventory 14 $4 4 13 RAW PVC materials purchase Cost per unit of SAW PVC 15 Total cost of RAW PVC purchases 16 17 Note: Desired ending invertory of RAW 18 at next month's production needs 19 20 21 Units to be produced 22 RESIN 23 RESIN per unit 24 Units of RESIN needed for production 25 Add: Desired ending RESIN inventory 26 To RESIN units required 27 Less Beginning RESIN 28 RESIN makes purchase 29 Cost per unt of RESIN 30 Total cost of RESIN purchases 32 Note Desaed ending inventory of RESIN 33 of next months production nee 10.000 12.500 85.000 52,500 50,000 125,000 10,000 12,500 60,000 157,500 8.750 10,000 12.500 31.250 36.250 42.500 47500 126,250 54 61450000 120.000 15.000 50,000 25% $4 January Februar March Quarter 11 25% April