please help me find
- Overhead budget and
- selling and administrative Budget using Excel format providing below.
Note: you can add more rows it needed
Budget Excel Project - Bloomfield Co. Bloomfield is an ke cream company, who makes homestyle tiee creams asing fresh and aflnatural ingredients and sells to retail stores. In preparing the budget fir the coming year, 2024, they forecasted the following expected sales and gathered the costs data from managers in verious aress of the company. Sales - Forecasted to sell 25,000 units in the 1 Quarier of 2024, and an additional 2,000 units each quarter. - The 2,000 additional units per quarter are expected to continue through the end of 2 nd quarter of 2025. - The 20234 quarier sales were 24,000 units. - Selling price for one unit of ice cream is $15. - Bloomficld maintains 15% of the next quarier's unir sales in ending iaventory. - All sales to retail abos are an account, with collections of 75% made in the guarter of nales and 25% collected in the quarter afler sale. - Accounts receivable on Decomber 31,2023 is $72,000 Direct Materials - Direct materials cost $3 per pound. 1.5 pounds of direct materials are required to produce each uni. - Bloomfield maintains 6% of the materials needed for the next quarter ia its ending material inventory. - Raw Materials on December 31, 2023 were 2,250 pounds. - Payment for materials are made 50% in the quarter of purchase. and 50% in the quarter after purchase. - Accouns Payable balanee on December 31, 2023 was $56,250. 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 e per labor hour - Indirect labor 75e 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 belo - Advertising $2,000 a month - Insurance $700 a month - Office Salaries $4,000 a month - Depreciation $800 a month OtherInformation 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: Budget Excel Project - Bloomfield Co. Bloomfield is an ke cream company, who makes homestyle tiee creams asing fresh and aflnatural ingredients and sells to retail stores. In preparing the budget fir the coming year, 2024, they forecasted the following expected sales and gathered the costs data from managers in verious aress of the company. Sales - Forecasted to sell 25,000 units in the 1 Quarier of 2024, and an additional 2,000 units each quarter. - The 2,000 additional units per quarter are expected to continue through the end of 2 nd quarter of 2025. - The 20234 quarier sales were 24,000 units. - Selling price for one unit of ice cream is $15. - Bloomficld maintains 15% of the next quarier's unir sales in ending iaventory. - All sales to retail abos are an account, with collections of 75% made in the guarter of nales and 25% collected in the quarter afler sale. - Accounts receivable on Decomber 31,2023 is $72,000 Direct Materials - Direct materials cost $3 per pound. 1.5 pounds of direct materials are required to produce each uni. - Bloomfield maintains 6% of the materials needed for the next quarter ia its ending material inventory. - Raw Materials on December 31, 2023 were 2,250 pounds. - Payment for materials are made 50% in the quarter of purchase. and 50% in the quarter after purchase. - Accouns Payable balanee on December 31, 2023 was $56,250. 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 e per labor hour - Indirect labor 75e 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 belo - Advertising $2,000 a month - Insurance $700 a month - Office Salaries $4,000 a month - Depreciation $800 a month OtherInformation 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
