using this information, create a direct materials purchase budget for vanilla. vanilla costs $70/litre. Last years ingredient purchases for vanilla-was 29 litres, price was $70/litre per 1000 bars. The quantity for the bar was 625 units, quantity for alamonde was 370 and salt was 424.

20X8 production budget Q2 Q3 Q4 Sales units The-Bar Alamonde Salt-lick Total sales Q1 180400 118800 66000 365200 187000 123200 69300 379500 206800 134200 77000 178200 116600 68200 Total 752400 492800 280500 418000 363000 1525700 Add: El The-Bar Alamonde Salt-lick Total El Total needs 13202 8694 13202 8694 13090 8624 0 21714 386914 14476 9394 0 23870 403370 12474 8162 0 20636 438636 0 0 21896 21896 1547596 384896 Less: BI The-Bar Alamonde Salt-lick Total BI 12628 8316 0 -20944 13090 8624 0 14476 9394 0 12474 8162 12628 8316 0 0 -21714 -23870 -20636 -20944 The-Bar Alamonde Salt-lick 180862 119108 66000 365970 188386 123970 69300 204798 132968 77000 414766 178928 117132 68200 752974 493178 280500 1526652 Production req 381656 364260 Beginning inventory and ending inventory units The-Bar Alamonde Salt-lick Sales 752400 492800 280500 add El 574 378 0 min req 752974 493178 280500 less BI 0 0 0 prod req 752974 493178 280500 952 0