Hello,

I've completed most of the questions, just need assistance with the last two sections. Also, do you know how to utilize the "round function" as required below? Thanks in advance!

Thunder Creek wants to finish each month with 20% of next month's sales in units. Hint: Beginning imventory for the period is equal to the ending inventory of the previous period. Materials Imventory. Management desires an ending inventory of 25% of next month's materials requirements 6 Thunder Creek Company's workers require 30 minutes of labor to produce each unit of product. The labor cost is $20 per hour Prepare a Direct Labor Budget. (When entering answers in the direct labor budget, use the direct materials budket for vour cell references.) Budget H4: Direct Labor Budget Budgeted units to be produced 1 Direct labor hours per unit 2 Direct labor hours needed for production 3 Direct labor cost per hour 4 Budgeted direct labor cost Thunder Creek Company prepares its Manufacturing Overhead Budget. For each direct labor hour, the variable overhead costs are: 6 Indirect Materials = $1.00 per DLH; Indirect Labor Cost =$1.30 per DLH; Maintenance =$1.20 per DLH 7 The Fixed Overhead Costs per month are: Salaries of $40,000, Depreciation =$20,000 and Maintenance =$10,000. 9 Use '=ROUND' function to round the predetermined overhead allocation rate to two decimal places. Manufacturing overhead is allocated using direct labor hours. Thunder Creek Company uses the first-in, first-out (FIFO) imventory costing method. The Beginning Finished Goods tmentory is $86,400 consisting of 3,600 units. Use "-kDUND" function to round the fixed manufacturing overhead cost per unit to two decimal places. Prepare a Cost of Goods Sold Budget. (Hint: Unirs per month calculated using cell referesces to both sales budeet and production budeet.) Thunder Creek Company's variable supplies expense per month is $3.00 per unit. The fixed selling and administrative expenses per month consist of Salaries: $245,000; Advertising: $30,000; and Depreciation: $28,000 Prepare a Selling and Administrative Expense Budget. (When entering answers in the selling and administrative budget, use the sales budget for your cell references