O Excel File Edit View D HO . Home Insert Page Layout Calibri (Bodyl . B TUS noort Format Tools Data Window Help Chapter 8 - Budget Extra Credit Olivia Conradi Formulas Data Review View 11 AA- General H .A . S .% ) 8 Insert - Conditional Formatting Format Table Cal Styles X fx $2,000.00 2.750.00 Plan and Equipment 900 000.00 14 Accumulated Depreciation Liabilities and Stockholders' Equity 7,500.00 for simplicity, gnore interest on Bonds Payable) Stockholders' Equity Common Stock 837,550.00 Total Liabilities and Stockholders' Equity Budgeting Assumptions Sales Beginning Balance Sheet Production Direct Materials Direct Labor Manufacturing Overhead Finished Ready MacBook Pro 3 QSearch Sheet ... D o Home Insert Page Layout * Calibri (Body) LS Chapter 8 - Budget Extra Credit Olivia Conradi Review View Data Formulas 11 A A General Conditional Formatting Format as Table Cell Styles $ o anda Insert Dete Format . 1x fx Perkey Turkey Jerky, LLC Budgeting Assumptions For the Quarter Ending June 10, 2018 April Sales Budget 7 Budgeted Sales in units 8 Selling Price Per Unit 9 Percentage of Sales collected in the month of the sale 10 Percentage of Sales collected in the month after the sale 10,000 $9.00 12 Production Budget 13 Percentage of next month's sales in ending finished goods inventory 15 Direct Meterie Budget 16 Meat per pound 17 Pounds of meat per unit 18 Percentage of next months production needs in ending inventory 19 Percentage of purchases paid in the month purchased 20 Percentage of purchases paid in the month after purchase 22 Direct Labor Budget 23 Direct labor hours required per unit (20 units per labor hour 24 Cost per direct labor hour 26 Manufacturing Overhead Budget 27 Variable manufacturing overhead per direct laborho 28 Pixed manufacturing overhead 29 Manufacturing Depreciation $5.00 $15.000 $10.000 31 Variable Selling and Administrative Expense Budget 32 Sales Commissions Beginning Balance Sheet Budgeting Assumptions Ready Direct Labor Manufacturing Overhead Finished Sales + 100% Calibri (Body) 11 A+ A- = > General Conditional Formatting Format as Table Cell Styles x fx 1A UZ LAT LOBO Buyer 23 Direct labor hours required per unk (20 units per labor hour 24 Cost per direct labor hour 0.05 $15.00 $15.00 26 Manufacturing Overhead Budget 27 Variable manufacturing overhead per direct labor hou 28 Feed manufacturing overhead 2 Manufacturing Depreciation $5.00 $15,000 $10,000 $10,000 8 $0.15 a 31 Variable Selling and Admin tretive Expense Budget 32 Sales Commissions 33 Fixed selling and administrative expenses 34 Advertising 35 Manager Salaries 36 Insurance 37 Depreciation on Office Equipment 38 Total fused selling and administrative expenses $2.500 $5,000 8 8 8 8 8 $10,000 8 40 Cash Budget 41 Minimum cash balance 42 Simple annual interest rate Beginning Shot Budgeting Assumptions Sales Production Direct Materials Direct Labor Manufacturing Overhead + Ready MacBook Pro O Excel File Edit View O D 0 Home Insert Page Layout . Calibri (Body) . Paste BIU insert Format Tools Data Window Help Chapter 8 - Budget Extra Credit Olivia Conradi Formulas Data Review View 11 N A A 0 Number . . - $ $ . % % ) ) * 00 TUS Conditi Format Cul Sty Xfx Perky Turkey Jerky, LLC For the Quarter Ending June 10, 2018 Month May Quarter Total April 8 I Budgeted Sales (in units) 9 Selling price per un 10 Total Sales Schedule of Expected Car llections 13 Beginning Accounts Receivable 14 April sales 15 Vasales 16 June sales 17 Total cash collections Beginning Balance Sheet Production Direct Materials Direct Labor Mar Ready MacBook Pro Excel file Editve Tools Data Window Help DO di Chapter 8 - Budget Extra Credit Olivia Conradi me Insert Page Layout Formulas Data Review View * Calibri (Body) 11 A Av Number BIULA. 2. $ % ) Conc Form DIE Perky Turkey Jerky, LLC - Sales Budget For the Quarter Ending June 30, 2018 Month May Quarter Total April Budgeted sales in units Add: Desired Ending Inventory Total units needed Less: Units of beginning finished goods inventory Required production in units Beginning Balance Sheet Budgeting Assumptions Production Direct Materials Direct Labor Mana Ready 999 230 x] 9 w po MacBook Pro Excel File Edit View insert Format Tools Data Window Help O D U C hapter 8 - Budget Extra Credit Olivia Conradi Home Insert Page Layout Formulas Data Review View Calibri (Body) 11 - A. A General 9 Paste B IUI $ . % ) Conditior Format : Cell Style Perky Turkey Jerky, LLC Direct Materials Budget For the Quarter Ending June 10, 2018 Month Quarter Total April Required production in units) Pounds of raw materials per unit Pounds of raw materials needed for production 1 Add: Desired Raw Materials ending inventory 2 Total pounds of Raw Materials needed 3 Less: Beginning Raw Materials inventory 14 Pounds of Raw Materials to be purchased 15 Cost of Raw Materials per pound 16 Cost of Raw Materials to be purchased Expected Cash Disbursements for the purchase of Materials 21 Beginning Accounts Payable 22 April purchases 23 May purchases 24 June purchases Beginning Balance Sheet Budgeting Assumptions Sales Production Direct Materials Direct Labor Manufact Ready MacBook Pro O Excel File Edit View D HO . Home Insert Page Layout Calibri (Bodyl . B TUS noort Format Tools Data Window Help Chapter 8 - Budget Extra Credit Olivia Conradi Formulas Data Review View 11 AA- General H .A . S .% ) 8 Insert - Conditional Formatting Format Table Cal Styles X fx $2,000.00 2.750.00 Plan and Equipment 900 000.00 14 Accumulated Depreciation Liabilities and Stockholders' Equity 7,500.00 for simplicity, gnore interest on Bonds Payable) Stockholders' Equity Common Stock 837,550.00 Total Liabilities and Stockholders' Equity Budgeting Assumptions Sales Beginning Balance Sheet Production Direct Materials Direct Labor Manufacturing Overhead Finished Ready MacBook Pro 3 QSearch Sheet ... D o Home Insert Page Layout * Calibri (Body) LS Chapter 8 - Budget Extra Credit Olivia Conradi Review View Data Formulas 11 A A General Conditional Formatting Format as Table Cell Styles $ o anda Insert Dete Format . 1x fx Perkey Turkey Jerky, LLC Budgeting Assumptions For the Quarter Ending June 10, 2018 April Sales Budget 7 Budgeted Sales in units 8 Selling Price Per Unit 9 Percentage of Sales collected in the month of the sale 10 Percentage of Sales collected in the month after the sale 10,000 $9.00 12 Production Budget 13 Percentage of next month's sales in ending finished goods inventory 15 Direct Meterie Budget 16 Meat per pound 17 Pounds of meat per unit 18 Percentage of next months production needs in ending inventory 19 Percentage of purchases paid in the month purchased 20 Percentage of purchases paid in the month after purchase 22 Direct Labor Budget 23 Direct labor hours required per unit (20 units per labor hour 24 Cost per direct labor hour 26 Manufacturing Overhead Budget 27 Variable manufacturing overhead per direct laborho 28 Pixed manufacturing overhead 29 Manufacturing Depreciation $5.00 $15.000 $10.000 31 Variable Selling and Administrative Expense Budget 32 Sales Commissions Beginning Balance Sheet Budgeting Assumptions Ready Direct Labor Manufacturing Overhead Finished Sales + 100% Calibri (Body) 11 A+ A- = > General Conditional Formatting Format as Table Cell Styles x fx 1A UZ LAT LOBO Buyer 23 Direct labor hours required per unk (20 units per labor hour 24 Cost per direct labor hour 0.05 $15.00 $15.00 26 Manufacturing Overhead Budget 27 Variable manufacturing overhead per direct labor hou 28 Feed manufacturing overhead 2 Manufacturing Depreciation $5.00 $15,000 $10,000 $10,000 8 $0.15 a 31 Variable Selling and Admin tretive Expense Budget 32 Sales Commissions 33 Fixed selling and administrative expenses 34 Advertising 35 Manager Salaries 36 Insurance 37 Depreciation on Office Equipment 38 Total fused selling and administrative expenses $2.500 $5,000 8 8 8 8 8 $10,000 8 40 Cash Budget 41 Minimum cash balance 42 Simple annual interest rate Beginning Shot Budgeting Assumptions Sales Production Direct Materials Direct Labor Manufacturing Overhead + Ready MacBook Pro O Excel File Edit View O D 0 Home Insert Page Layout . Calibri (Body) . Paste BIU insert Format Tools Data Window Help Chapter 8 - Budget Extra Credit Olivia Conradi Formulas Data Review View 11 N A A 0 Number . . - $ $ . % % ) ) * 00 TUS Conditi Format Cul Sty Xfx Perky Turkey Jerky, LLC For the Quarter Ending June 10, 2018 Month May Quarter Total April 8 I Budgeted Sales (in units) 9 Selling price per un 10 Total Sales Schedule of Expected Car llections 13 Beginning Accounts Receivable 14 April sales 15 Vasales 16 June sales 17 Total cash collections Beginning Balance Sheet Production Direct Materials Direct Labor Mar Ready MacBook Pro Excel file Editve Tools Data Window Help DO di Chapter 8 - Budget Extra Credit Olivia Conradi me Insert Page Layout Formulas Data Review View * Calibri (Body) 11 A Av Number BIULA. 2. $ % ) Conc Form DIE Perky Turkey Jerky, LLC - Sales Budget For the Quarter Ending June 30, 2018 Month May Quarter Total April Budgeted sales in units Add: Desired Ending Inventory Total units needed Less: Units of beginning finished goods inventory Required production in units Beginning Balance Sheet Budgeting Assumptions Production Direct Materials Direct Labor Mana Ready 999 230 x] 9 w po MacBook Pro Excel File Edit View insert Format Tools Data Window Help O D U C hapter 8 - Budget Extra Credit Olivia Conradi Home Insert Page Layout Formulas Data Review View Calibri (Body) 11 - A. A General 9 Paste B IUI $ . % ) Conditior Format : Cell Style Perky Turkey Jerky, LLC Direct Materials Budget For the Quarter Ending June 10, 2018 Month Quarter Total April Required production in units) Pounds of raw materials per unit Pounds of raw materials needed for production 1 Add: Desired Raw Materials ending inventory 2 Total pounds of Raw Materials needed 3 Less: Beginning Raw Materials inventory 14 Pounds of Raw Materials to be purchased 15 Cost of Raw Materials per pound 16 Cost of Raw Materials to be purchased Expected Cash Disbursements for the purchase of Materials 21 Beginning Accounts Payable 22 April purchases 23 May purchases 24 June purchases Beginning Balance Sheet Budgeting Assumptions Sales Production Direct Materials Direct Labor Manufact Ready MacBook Pro