toSave Off a Chapter 22 Excel Template rev221 (2) O Search (Alt-Q Home Insert Draw Page Layout Formulas Data Review View Help Calibri 11 AA Wrap Text General Copy BIU Condition Merge & Center $%$8 Format Painter Formatting Clipboard Font Alignment G Number x D E F G H MASTER BUDGETS Using Excel to prepare an operating budget (manufacturing company) Thunder Creek Company is preparing budgets for the first quarter of 2018. All relevant information is presented on the Excel template. 5 Use the blue shaded areas on the ENTER-ANSWERS tab for inputs. 7 8 Always use cell references and formulas where appropriate to receive full credit. If you copy/paste from the Instructions tab you will be m 9 Requirements 10 1. Prepare a Sales Budget. 11 2. Prepare a Production Budget. 12 3. Prepare a Direct Materials Budget. 13 4. Prepare a Direct Labor Budget. 14 5. Prepare a Manufacturing Overhead Budget. 15 6. Prepare a Cost of Goods Sold Budget. 16 7. Prepare a Selling and Administrative Expense Budget. 17 18 19 Excel Skills 201 1. Create formulas with cell references. 21 22 23 2. Use the ROUND function. 24 Saving & Submitting Chapter Excel Assignments 25 1. Save file. 26 a. You may want to create folder on desktop, and label COMPLETED EXCEL PROJECTS 27 b. Name your files: CHnumber FirstNameLastName (e.g., CH1 RobynVerdery) 28 2. Upload and submit your file to be graded. 29 a. Click on "Assessments" located on the navigation bar at the top of the page to open the dropdown menu Instructions ENTERANSWERS ady To Accessibility Good to go Type here to search O hp