Resources Presenter Info Slide ID: 4498 Step 4 of 40: Enter Inventory Assumptions D F 1 Budget Assumptions LEFT/FIND Functions 2 First Month's Sales in Units First Month's Sales in Units Assumption 3 Unit Sales Growth Per Month Init Sales Growth Per Month Assumption YOUR TURN: Based on this paragraph enter 4 Unit Sales Price these assumptions: 5 Wally's Widgets is starting operations as of January 1. The 7 company sells a single product, and expects first month's sales 8 to be 10,000 units, with sales increasing by 250 units per month 9 thereafter. The sales price for the product is $12.00 10 Inputs Supporting Schedules Operating Budget Cash Budget AutoSave (. Off) Percent Style get v3 adex - Excel Sign in File Home Insert Comma Style Share Comments Calibri Currency Style matting Insert LOT BIU- Delete Paste Editing Ideas Decrease Decimal Format Clipboard Font Alignment Numbe Ideas (2 1 Bub 2 First YOUR TURN: Apply the Currency and Comma Style formats on the Home menu as 3 Unit appropriate to cells B2: B4. Use Decrease Decimals to remove decimal places from 82:83 Students Excel du We're here to help. Email us at support@studentsexcel.com 8 / 46 00:44 / 00:46 Type here to searchMaps Weather PDF PDF to DOC Instagram f Facebook Twitter a Ama n What are we searching for... O Search (Alt+Q) AutoSave (C Off) _ ~ Cash Flow Budget - Ashley Patel File Home Insert Draw Page Layout Formulas Data Review View Help & Cut Calibri ~ 11 - AA de Wrap Text General Conditional Format as Cell Insert Delete Form Paste [ Copy " B I U . F - GAV EEE EE Merge & Center $ ~ % 9 08 -20 Formatting Table Styles Format Painter Number Styles Cells Clipboard IN Font Alignment B2 X V H D 2 First Month's Sales in Units First Month's Sales in Units Assumption 3 Unit Sales Growth Per Month Unit Sales Growth Per Month Assumption 4 Unit Sales Price Unit Sales Price Assumption 5 6 TRIM Function 7 Gross Margin 8 Commission 9 Ending Inventory 10 11 SUBSTITUTE Function 12 Minimum Cash Balance Assumption 13 Interest Rate Assumption 14 15 Month Collections Payments CONCATENATE/RIGHT Function UPPER Function LOWER Function 16 Period 1 17 Period 2 18 Period 3 19 0 Operating Expenses Per Month MID Function 21 7200 . Payroll 22 7500 . Utilities 7900 . Other 23 24 25 26 27 28 29 30 33 34 35 36 37 38 39 40 InputsSupporting Schedules Operating Budget Cash Budget Ready x Accessibility : Investigate Type here to search O X