please help me find
(1) Overhead budget and
(2) selling and administrative Budget
using Excel format providing below.
Note: you can add more rows if needed
with Excel formula
Variable selling and administrative cost are budgeted per sales unit: - Shipping expense $.75 per sales unit - Packaging expense $.50 per sales unit Fixed selling and administrative costs are budgeted for the month, listed below: - Advertising $2,000 a month - Insurance $700 a month - Office Salaries $4,000 a month - Depreciation $800 a month Group 2 Broomfield Project of Horne Insert Page Layout Formulas Data Revien. View Draw (2) n Sans 10 B I U 5 General fx Enter text, or formula here A A B. c. D E. G H 1 k M N 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 Seling and Administrative Expense Budget For the Year Ending ct Material Budget Drect Labor Eudget Overhead Budget Selling of Admin Bu... Bodoeted income Si... Casicolect A Pay... Cash Eudge: after purchase. - Accounts Payable balance on December 31, 2023 was $56,250. Direct Labor Labor required is 15 minutes per unit at a rate of $11 per hour. Manufacturing Overhead Variable overhead costs are based on labor hours, listed below: - Indirect materials 50 per labor hour - Indirect labor 75 per labor bour - Utilities 65 e per labor hour - Maintenance 35 e per labor hour Foxed overhead costs are budgeted for the month, listed below: - Rent \$3,000 per month - Salaries $11,000 per month - Depreciation \$4,800 per month - Property taxes \$675 per month - Insurance $500 per month Selling and Administrative Variable selling and administrative cost are budgeted per sales unit: - Shipping expense $.75 per sales unit - Packaging expense $.50 per sales unit Fixed selling and administrative costs are budgeted for the month, listed below - Advertising $2,000 a month - Insurance $700 a month - Onfice Salaries $4,000 a month - Depreciation $800 a month Other Information after purchase. - Accounts Payable balance on December 31, 2023 was $56,250. Direct Labor Labor required is 15 minutes per unit at a rate of $11 per hour. Group 2 Broomfield Project of Horne Insert Page Layout Formulas Data Revien. View Draw (2) n Sans 10 B I U 5 General fx Enter text, or formula here A A B. c. D E. G H 1 k M N 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 Seling and Administrative Expense Budget For the Year Ending ct Material Budget Drect Labor Eudget Overhead Budget Selling of Admin Bu... Bodoeted income Si... Casicolect A Pay... Cash Eudge: Variable selling and administrative cost are budgeted per sales unit: - Shipping expense $.75 per sales unit - Packaging expense $.50 per sales unit Fixed selling and administrative costs are budgeted for the month, listed below: - Advertising $2,000 a month - Insurance $700 a month - Office Salaries $4,000 a month - Depreciation $800 a month Group 2 Broomfield Project of Horne Insert Page Layout Formulas Data Revien. View Draw (2) n Sans 10 B I U 5 General fx Enter text, or formula here A A B. c. D E. G H 1 k M N 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 Seling and Administrative Expense Budget For the Year Ending ct Material Budget Drect Labor Eudget Overhead Budget Selling of Admin Bu... Bodoeted income Si... Casicolect A Pay... Cash Eudge: after purchase. - Accounts Payable balance on December 31, 2023 was $56,250. Direct Labor Labor required is 15 minutes per unit at a rate of $11 per hour. Manufacturing Overhead Variable overhead costs are based on labor hours, listed below: - Indirect materials 50 per labor hour - Indirect labor 75 per labor bour - Utilities 65 e per labor hour - Maintenance 35 e per labor hour Foxed overhead costs are budgeted for the month, listed below: - Rent \$3,000 per month - Salaries $11,000 per month - Depreciation \$4,800 per month - Property taxes \$675 per month - Insurance $500 per month Selling and Administrative Variable selling and administrative cost are budgeted per sales unit: - Shipping expense $.75 per sales unit - Packaging expense $.50 per sales unit Fixed selling and administrative costs are budgeted for the month, listed below - Advertising $2,000 a month - Insurance $700 a month - Onfice Salaries $4,000 a month - Depreciation $800 a month Other Information after purchase. - Accounts Payable balance on December 31, 2023 was $56,250. Direct Labor Labor required is 15 minutes per unit at a rate of $11 per hour. Group 2 Broomfield Project of Horne Insert Page Layout Formulas Data Revien. View Draw (2) n Sans 10 B I U 5 General fx Enter text, or formula here A A B. c. D E. G H 1 k M N 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 Seling and Administrative Expense Budget For the Year Ending ct Material Budget Drect Labor Eudget Overhead Budget Selling of Admin Bu... Bodoeted income Si... Casicolect A Pay... Cash Eudge
