AutoSave @ on Master Budget_ Course Project _Student Version(2) (version 1) - AutoRecovered A David MatosS DM O X File Home Insert Page Layout Formulas Data Review View Automate . Help Comments Share Times New Roma - 12 A" A = = _* * General Insert " Delete BI U . . GAV $ % 9 780 Conditional Format as Analyze Formatting " Table " Styles Format Sort & Find & " Filter " Selectv Sensitivity Clipboard Font Alignment Number Styles Cells Editing Analysis Sensitivity A1 x v fx Retro Vinyl 25 Board feet Of heart of pine wood needed to meet production for quarter I'm ZUZZ 4,000 C G H 26 Percentage of purchases paid in the quarter purchased 27 Percentage of purchases paid in the quarter after the purchase 28 29 Direct Labor Budget 30 Direct labor hour required per unit (cabinet) 5.00 31 Direct labor cost per hour S 20.00 32 33 Manufacturing Overhead Budget 34 Variable manufacturing overhead per direct labor hour 2.00 35 Fixed manufacturing overhead per quarter 50,000 36 Depreciation per quarter (included in the fixed manufacturing overhead) 10,000 10,000 10,000 10,000 10,000 37 38 Selling and Adminsitrative Expense Budget 39 Variable selling and adminsitrative expense per unit 3.00 40 Fixed selling and administrative expense per quarter 41 Advertising 5,000 42 Executive salaries 30,000 43 Insurance 2,00 44 Depreciation (Q1 ) 1,000 45 Depreciation (Q2) 1,000 46 Depreciation (Q3) 1,000 47 Depreciation (Q4) 1,000 48 Percentage of expenses paid in the quarter incurred 100% 49 50 Cash Budget 2021 Quarters 1 ... | Beginning Balance Sheet Budgeting Assumptions 1-Revenue Budget | 2-Production Budget 3-Direct Materials Budget 4-Direct Labor Budget .. D elect destination and press ENTER or choose Paste Count : 3 0 -+ 100% 3:06 PM Type here to search Uv High... ~ 9 92 6/12/2024 MacBook Air esc 30 838 N.. delete w W D R S D F G H K .. . caps look X C V N M