Managerial accounting

File Insert Draw Home Formulas View Page Layout Data Review Tell Help Morningstar Acrobat Calibri General 191.1 & Cut Pa Copy Format Painter 1-AA == . 2 Wrap Text 3. A ESE E Merge & Center - aste BIU $ - % 48.99 Condition Formatting Clipboard Font Alignment Number 13 B Chapter 9 4 O 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 3 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% 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 25 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 33. Direct materials cost per ounce 34 Budgeted purchase cost of direct materials a5 36 37 38 39 40 41 Sheet1