Pg . 1 of 7 Raw Materials Budget To begin working on the Raw Materials Budget Open your activated project workbook , and enable macros . > Click the Inputs tab Click the Set Input Values Back to Original Amounts button 3 Click the tab Overview of the Raw Materials Budge The Raw Materials Budget is the third budget in My Armor's Master Budget . The primary input that drives this budget is Finished Units to Produce , which comes from the Production Budget . The Raw Materials Budget has two main purposes To calculate Total Ounces of PSP to Purchase each quarter and for the full yea To calculate Total Cost of PSP Purchases each quarter and for the full yea Observe on the screen how the Raw Materials Budget is broken into three calculation blocks 1 5 The calculation of Ounces of PSP Required to Produce the Finished Units This is the top 3 lines of the Raw Materials Budget 2 " The calculation of Total Ounces of PSP to Purchase This is the middle 4 lines of the Raw Materials Budget . The logic in these 4 lines is the same logic that is used in the Production Budget