please show your work step by step and k would details foe it to be organized.

D G H 1 Thunder Creek Company expects sales of 18,000 units inhuary 2018, 24,000 units in February, 30,000 units in March, 24,000 in April, and 36,000 in May. The sales price is $34 per unit 2 Prepare a sales budget 3 2013 4 Budget 1: Sales Budget Jan Feb Mar 01 Total 5 Budgeted units to be sold April May 6 Sales price per unit 7 Total sales 3 9 Thunder Creek wants to finish each month with 20% of next month's sales in units. 10 Prepare a production budget. (When entering answers in the production budget, use the sales budget for your cell references. Enter all values as positive without a minus sign in row 18 11 Hint: Beginning inventory for the period is equal to the ending inventory of the previous period 12 13 2017 2018 14 Budget 2: Production Budget Dec Jan Teb Mar 15 Budgeted units to be sold Q1 Total April May 16 Plus: Desired unitsin ending inventory 17 Total units needed 10 Loss: Units in beginning inventory 19 Budgeted units to be produced 20 Thunder Creek Company uses 2 pounds of direct materials for each unit it produces, at a cost of $1.00 per pound. The company begins the year with 9.500 pounds of 21 material in Raw Materials Inventory Management desires an ending inventory of 25% of next month's material requirements 22 Prepare a Direct Materials budget. When entering answers in the direct materials budget, use the production budget for your cell referencer Enter all values as poutive without a minus in row 21 24 2018 25 Budget 3: Direct Materials Budget lan Teb Mar 01 Total 26 Budgeted units to be produced April 27 Direct materials (pounds) per unit 20 Direct materials needed for production 29 Plus Desired direct materials in ending inventory (pounds) 30 Total direct materials needed 31 Less Direct materials in beginning inventory (pounds) 12 budgeted purchase of direct materials 33 Orect material cost per pound 14 Budgeted cost of direct material purchases 15 Thunder Creek Company's workers require 30 minutes of labor to produce each unit of product. The labor cost is $20 per hour 12 Prepare a Direct Labor Budget. (When entering answers in the direct labor budget, use the direct material budget for your cell references) 18 2018 39 Budget : Direct Labor Budget Jan Teb Man Q.1 Total 40 Budgeted units to be produced 41 Direct labor hours per unit 42 Direct labor hours needed for production 43 Direct labor cost per hour 44 Budgeted direct labor cost 45 Thunder Creek Company prepares its Manufacturing Overhead Budget. For each direct labor hour, the variable overhead costs are Indirect Materials $1.00 per Du indirect Labor Cost=51.30 per Maintenance - $1.20 per DUH The Fixed Overhead Costs per month are: Salaries of $40,000, Depreciation $20,000 and Maintenance $10,000 Prepare a Manufacturing Overhead Budget. (When entering answers in the manufacturing overhead budget, use the direct labor budget for your cell references.) Use ROUND"function to round the predetermined overhead allocation rate to two decimal places. Manufacturing overhead is allocated using direct labor hours. 2013 Jan Feb Mar Q1 Total Budget : Manufacturing Overhead Budget Budgeted units to be produced Vow cost per unit Budgeted VOH Budgeted TOH Depreciation Salaries and maintenance Total budgeted FOH Budgeted manufacturing overhead costs biect labor hours (DU) Predetermined overhead allocation rate per Thunder Creek Company uses the first in, fost outro inventory costing method The Beginning Finished Goods Inventory is $85,400 consisting of 2,600 units Depin by calculating the projected cost to produce each unit in 2018 based on projected sales(int in Cost per unire, reli references come from Direct Material, Direct Labor and Manufacturing Overhead budgets Use 'ROUND function to round the fined manufacturing overhead cost per un tolwe decimal places Prepare a cost of Goods Sold Budget (Mint units per month calculated using cell references to both sales budget and production budget) Cost per unit Direct material cost per unit Orect labor cost per unit Manufacturing overhead cont per Total projected manufacturing cost per und 2018 lan MM Budget Cost of Goods Sold Budget Total Beginning in the Goods inventory, 1.600 units Units produced and sold in 2018 Cost per unit Units per month Total cost of units produced and sold in 2013 Total Budgeted cost of goods sold Thunder Creek Company valle wpples expert per month $300 per und Thefred selling and administreres per month con 5245000. Adating $30.000 and Deprecation 2000 Prepa a Selling and Administrative Expense Budget (When entering antes in the selling and strative budget des budget for your cell references Badget! Selling and Administrative Expense Budget ian Feb Salaries expense Advertisingepen Depreciation expense Supplies experte Total budgeted SEA expense 2016 Mar Qi Total