Jan Feb Mar Q1 Total Budget as: Manufacturing Overhead Budget Budgeted units to be produced VOH cost per unit Budgeted VOH Budgeted FOH Depreciation Salaries and maintenance Total budgeted FOH fludgeted manufacturing overhead costs Direct labor hours (O) Predetermined overhead allocation rate per DHE Thunder Creek Company uses the first in, first-out (FIFO) Inventory costing method. The Beginning Finished Goods Inventory is $86,400 consisting of 3.600 units. Segin by calculating the projected cost to produce each unit in 2018 based on projected sales. (Hint: In "Cost per unit" table, cell references come from Direct Materials, Direct labor, and Manufacturing Overhead by UROUND function to round the fined manufacturing overhead cost per unit to two decimal places. Prepare a cost of Goods Sold Budget Clint: Units per month calculated using cell references to both sales budget and production budget Thunder Creek Company uses the first-In, first-out (FIFO inventory costing method. The Beginning Finished Goods Inventory is $86,400 consisting of 3,600 units. Begin by calculating the projected cost to produce each unit in 2018 based on projected sales. (Hint: In "Cost per unit" table, cell references come from Direct Materials, Direct Labor, and Manufacturing Overhead Use 'ROUND function to round the fixed manufacturing overhead cost per unit to two decimal places. Prepare a Cost of Goods Sold Budget. (Hint: Units per month calculated using cell references to both sales budget and production budget.) Cost per unit Direct material cost per unit Direct labor cost per unit Manufacturing overhead cost per unit Total projected manufacturing cost per unit 2018 lan Feb Mar Q1 Total Budget : Cost of Goods Sold Budget Beginning Finished Goods Inventory,2,000 units. Units produced and sold in 2018 Cost per unit Units per month Total cost of units produced and sold in 2018 Total budgeted cost of goods sold Total projected manufacturing cost per unit 2018 Jan Feb Mar Q1 Total Budget #6: Cost of Goods Sold Budget Beginning Finished Goods Inventory, 3,600 units. Units produced and sold in 2018 Cost per unit Units per month Total cost of units produced and sold in 2018 Total budgeted cost of goods sold Feb Thunder Creek Company's variable supplies expense per month is $300 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.) 2018 Budget #7: Selling and Administrative Expense Budget Jan Mar Q1 Total Salaries expense Advertising expense Depreciation expense Supplies expense Total budgeted S&A expense
