smith File Home Insert Page Layout Formulas Data Review View ACROBAT PPC Tell me what yo - 12 of Cut Da Copy ste Format Painter Calibri - Wrap Text General BIU.E. DA SE Merge & Center - $ - % Clipboard Font Alignment Number F18 X fx G H B D E 1 Master Budget and Responsibility Accounting 2 Sales and production budget 3 4 The Coby Company expects the following: Sales 201,000 units of serving trays Beginning inventory 13,000 units of serving trays Target ending 29,000 units of serving trays 5 6 7 8 a. 9 Use the blue shaded areas on the ENTERANSWERS tab for inputs. Always use cell references and formulas where appropriate to receive full credit. If you 10 copy/paste from the Instructions tab you will be marked wrong. 11 12 Requirement 13 Compute the number of trays budgeted for production in 2018. 14 15 Saving & Submitting Solution 16 1 Save file to desktop 17 Create folder on desktop, and label COMPLETED EXCEL PROJECTS 2 Upload and submit your file to be graded. 19 Navigate back to the activity window - screen where you downloaded the initial spreadsheet 20 Click Choose button under step 3; locate the file you just saved and click Open 21 Click Upload button under step 3 22 d. Click Submit button under step 4 23 24 25 Viewing Results 26 1. Click on Results tab in My Accountinglab INSTRUCTIONS ENTERANSWERS Ready 18 a. b. C