Question

I need help with JUST 5,6, and 7 please

3 L12 x ✓ fx I B C D E F G H I 1 Thunder Creek Company expects sales of 18,000 units in January 2018, 24,000 units in February, 30,000 units in March, 34,000 in April, and 36,000 in May. The sales price is $34 per unit. 2 Prepare a sales budget. 2018 4 Budget #1: Sales Budget Jan Feb Mar 01 Total April May 5 Budgeted units to be sold 6 Sales price per unit 7 Total Sales 8 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 1 Dec Jan Feb Mar Q1 Total April May 15 Budgeted units to be sold 16 Plus: Desired units in ending inventory 17 Total units needed 18 Less: 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 $4.00 per pound. The company begins the year with 9,500 pounds of material in 21 Raw Materials Inventory. Management desires an ending inventory of 25% of next month's materials requirements 22 Prepare a Direct Materials Budget. (When entering answers in the direct materials budget, use the production budget for your cell references. Enter all values as positive--without a minus sign--in row 31.) 23 2018 TCL TUT24T 24 P . 42. Dim .boni. Budet

Answer 1

			Jan	Feb	March	Q1 total	April	May
		Budgeted units to be sold	18000	24000	30000	72000	34000	36000
		Plus desired units in ending inventory	4800	6000	6800
		Total units needed	22800	30000	36800
		Less : Units in beginning inventory	3600	4800	6000
		Budegeted units to be produced	19200	25200	30800	75200
	Budget #5	Manufacturing Overhead Budget
			Jan	Feb	March	Q1 Total
	A	Budgeted units to be produced	19200	25200	30800	75200
	B	Direct Labor hour per unit	0.5	0.5	0.5
	C=B*(1+1.3+1.2)	VOH cost per unit	$1.75	$1.75	$1.75
	D=A*C	Budgeted VOH	$33,600	$44,100	$53,900	$131,600
		Budgeted FOH:
	E	Depreciation	$20,000	$20,000	$20,000	$60,000
	F=40000+10000	Salaries and maintenance	$50,000	$50,000	$50,000	$150,000
	G=E+F	Total Budgeted FOH	$70,000	$70,000	$70,000	$210,000
	H=D+G	Budgeted manufacturing overhead cost	$103,600	$114,100	$123,900	$341,600
	I=A*B	Diret Labor Hours(DLH)	9600	12600	15400	37600
	J=H/I	Predetermined Overhead allocatiopn rate				$9.09
			Cost per unit
		Direct Material cost per unit	$8.00	(2pounds*$4 per pound)
		Direct labor cost per unit	$10.00	(0.5 hour*$20 per hour)
		Manufacturing overhead cost per unit	$4.54	(0.5 hour*$9.09 per hour)
		Total Projected manufacturing Cost per unit	$22.54
	Budget #6	Cost of Goods Sold Budget
			January	Feb	March	Q1 toatl
	A	Beginning Finished goods inventory, 3600 unit	$86,400			$86,400
		Units Produced and sold in 2018
	B	Cost per unit	$22.54	$22.54	$22.54
	C	Units per month	14400	24000	30000		(Note: Units Produced and sold in January =18000-3600=14400)
	D=B*C	Total Cost of units produced and sold in 2018	$324,576	$540,960	$676,200	$1,541,736
	E=A+D	Total Budgeted cost of goods sold	$410,976	$540,960	$676,200	$1,628,136
							Budget#7 Selling and Administration Expense Budget Budgeted units to be sold Salaries Expense Advertising expense Depreciation Expense Supplies expense Total Budgeted S&A expense Feb March Q1 Total 18000 24000 30000 72000 $245,000 $245,000 $245,000 $735,000 $30,000 $30,000 $30,000 $90,000 $28,000 $28,000 $28,000 $84,000 $54,000 $72,000 $90,000 $216,000 $357,000 $375,000 $393,000 $1,125,000 E=A*$3