using this information, create a direct materials purchase budget for vanilla. vanilla costs $70/liter. 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 Sales units Q1 Q2 Total Q3 Q4 The-Bar 180400 187000 206800 178200 752400 Alamonde 118800 123200 134200 116600 492800 Salt-lick 66000 69300 77000 68200 280500 Total sales 365200 379500 418000 363000 1525700 Add: El The-Bar 13090 14476 12474 13202 13202 Alamonde 8624 9394 8162 8694 8694 Salt-lick Total El 21714 23870 20636 21896 21896 Total needs 386914 403370 438636 384896 1547596 Less: BI The-Bar 12628 13090 14476 12474 12628 Alamonde 8316 8624 9394 8162 8316 Salt-lick Total BI -20944 -21714 -23870 -20636 -20944 The-Bar 180862 188386 204798 178928 752974 Alamonde 119108 123970 132968 117132 493178 Salt-lick 66000 69300 77000 68200 280500 Production req 365970 381656 414766 364260 1526652