Acrobat Tell OT View Review Help Morningstar Data Formulas Page Layout Insert Draw File Home rata 2 Wrap Text General Colibri Conditional AX Cut E Copy Paste AA BIU-2.5.A. Merge & Center - $ - % Formatting Number Format Painter Clipboard Alignment Font E13 B A Chapter 9 8 9 10 Grady, Inc. manufactures model airplane kits. Use the form below to complete Grady's Direct Materials Budget. 11 12 Budgeted kits to be produced in Quarter 1 650 13 Budgeted kits to be produced in Quarter 2 500 14 Budgeted kits to be produced in Quarter 3 450 15 Direct materials needed per kit (in ounces) 16 Direct materials cost per ounce $1 17 Beginning raw materials inventory (in ounces) in Quarte 850 Desired ending raw materials inventory as a percent of 18 materials needed for next quarter's production 10% 4 25 19 In the form below, input the correct formula for each cell under Quarter 1 and Quarter 2. Use cell referencing, do not type in numbers! After inputting your formulas, the cells should show the resulting computed amount. You will upload this Excel file to 20 Canvas for your submission 21 22 Grady, Inc. 23 Direct Materials Budget 24 For the First and Second Quarters Quarter 1 Quarter 2 26 Budgeted kits to be produced 27 Direct materials per kit (ounces) 28 Direct materials needed for production 29 Plus: Desired direct materials in ending inventory 30 Total direct materials needed 31 Less: Direct materials in beginning inventory 32 Budgeted purchases of direct materials 31 Direct materials cost per ounce 34 Budgeted purchase cost of direct materials 35 36 37