Hello I Need help with the completion of this assignment,

Required: Master Budget Including following budgets

1. Sales Budget
2. Production Budget
3. Direct materials budget
4. Factory overhead budget
5. Cost of goods manufactured budget
6. Selling and administrative expense budget
7. Income statement

You must enable macros in order fo Please visit the Microsoft Office Support sit Contact the World Campus Helpdesk s in order for this assignment to function. e Support site for documentation and instructions. us Helpdesk if you continue to have trouble. . Preparing a Master Budget HBI Inc. has gathered the following budgeting information for next year and has asked you to prepare their master budget. Budgeted unit sales Quarter 1 Quarter 2 Quarter 3 Quarter 4 176 129 147 134 Sales price per unit Quarter 1 Quarter 2 Quarter 3 Quarter 4 $640 $672 $672 $672 Beginning finished goods inventory in units Quarter 1 Desired ending finished goods inventory in units Quarter 1 Quarter 2 Quarter 3 Quarter 4 Direct materials cost per unit Quarter 1 Quarter 2 Quarter 3 Quarter 4 52 31 37 45 35 $62 $68 $68 $68 Beginning direct materials inventory in dollars Quarter 1 $2,181 Desired ending inventory, direct materials Quarter 1 Quarter 2 Quarter 3 Quarter 4 $1,833 $2,206 $2,536 $1,987 Direct labor hours per unit Direct labor cost per hour 3.00 $31 Applied Variable factory overhead rate per direct labor hour $17 Fixed overhead costs Depreciation of Production equipment Utilities Other factory overhead costs $1,990 $506 $189 Beginning work in process inventory Ending work in process inventory $12,350 $11,056 Sales commission percent Salary for sales manager for year Other selling expenses for year 9% $49,575 $5,036 Administrative expenses: Wages and salaries expense Rent expense Insurance expense Depreciation expense Supplies expense $19,736 $14,767 $1,115 $297 $280 Beginning finished goods inventory Ending finished goods inventory Interest expense Income tax expense Required: Complete the master budget for HBI, Inc. including the following budgets: 1. Sales budget 2. Production budget 3. Direct materials budget 4. Direct labor budget 5. Factory overhead budget 6. Cost of goods manufactured budget $0 $0 $9,949 $0 0.094301 7. Selling and administrative expenses budget 8. Income statement Note* A PDF copy of the budgets (blank) are available if you think it would be helpful while you work through this problem. The dollar amounts for beginning and ending finished goods will self-calculate once you have completed the production budget and cost of goods manufactured budget. Use the ar (*Note: Your instru SALES BUDGET Sales Budget First quarter Second quarter Budgeted unit sales Sales price per unit Total sales in dollars PRODUCTION BUDGET Production Budget Budgeted unit sales (from sales budget) Add: Desired units in finished goods ending inventory Total units of finished goods needed Less: Beginning inventory, finished goods Total units to be produced First quarter Second quarter DIRECT MATERIALS BUDGET Direct Materials Budget Total units to be produced Direct materials cost per unit Direct materials needed for production Add: desired direct materials ending inventory Total direct materials needed Less: beginning inventory, direct materials Budgeted purchases of direct materials First quarter Second quarter DIRECT LABOR BUDGET Direct Labor Budget Total units to be produced Direct labor hours per unit Direct labor hours needed for production Direct labor cost per hour Budgeted direct labor costs First quarter Second quarter FACTORY OVERHEAD BUDGET Manufacturing Overhead Budget Variable overhead Direct labor hours needed for production First quarter Second quarter Variable overhead cost per unit Budgeted variable overhead Fixed overhead Depreciation of Production equipment Utilities Other factory overhead costs Total budgeted fixed overhead costs Budgeted total overhead costs BUDGETED COST OF GOODS MANUFACTURED Cost of Goods Manufacturing Budget Beginning work in process inventory Direct materials used: Beginning direct materials Inventory Purchases of direct materials Raw materials available for use Ending direct materials inventory Direct materials used Direct labor Total factory overhead costs Total manufacturing costs Total manufacturing costs to account for Ending Work in process inventory Cost of goods manufactured Total number of units produced Cost per unit to manufacture Round to two decimal places SELLING AND ADMINISTRATIVE EXPENSES BUDGET Selling and Administrative Expense Budget Selling expenses: Budgeted sales Sales commission percent Sales commission expense (round to whole dollars) Sales salary Other selling expenses Total selling expenses First quarter Second quarter Administrative expenses: Wages and salaries expense Rent expense Insurance expense Depreciation expense Supplies expense Total administrative expenses Total selling and administrative expenses INCOME STATEMENT Budgeted Income Statement Sales Cost of goods sold Beginning inventory, finished goods Cost of goods manufactured Cost of goods available for sale Ending inventory, finished goods Cost of goods sold Gross profit Selling and administrative expenses Selling expenses Administrative expenses Total selling and administrative expenses Operating income Interest expense Income before taxes Income tax expense Net income Use the area below to show your work and calculations. (*Note: Your instructor may use this area to help review and resolve any incorrect answers) Third quarter Fourth quarter Total for year Third quarter Fourth quarter Total for year Third quarter Fourth quarter Total for year Third quarter Fourth quarter Total for year Third quarter Fourth quarter Total for year ET DGET GET UDGET ANUFACTURED d to two decimal places PENSES BUDGET Third quarter Fourth quarter Total for year culations. ncorrect answers)