Question

i need a Diresct material and Direct Labor budget (seperate budgets)

thank you so much!!!!

The 1. December 31, 20Xx, balance sheet for the company follows. DYB-ASPORA, Inoorporated Balance Sheet December 31, 20xx AssetS Lisbilities and Stockholder quity Ca.sh Accounts Receivable Raw Materials Inventory Finished Goods Inventory Prepaid Insuranoe Building Aco Depreciation Total Asseta $5,080 26,500 2000 3.680 1,300 Notes Pa yable Accounts Payable Dividends Payable Total Liabilities Common Stock Paid-in Capital Retained Earnings $25,0o0 2,148 10000 37,148 100,000 50,000 300,00O 280 312 Total Liabilities and Equity $317480 (20,00080.000 The Accounts Receivable balance at December 31st represents the remaining balances of November and December credit sales: $70,000 and $65,000, respectively 2. 3. Estimated sales in gallons of dye for January through May follow: 8,000 10,00O 15,000 12,000 11,000 January February March April May Each gallon of dye sells for $12.75. 4. The collectio n pattern for accounts receivable is as follows . 70% in the month of sale, 20% the month after sale, and . 10% the second month after sale. Dye-Aspora expects no bad debts and gives no cash discounts 5. Each gallon of dye has the following standard quantities and costs for direct materials and direct labor Cost irate Std Cost Quantity $2.40 $3.00 串2.00 1.20 Gal 0.36 Hr $13.00 Mordant (DM) Dire ot labor Some evaporation loss occurs during processing. Variable overhead (VOH) is applied basıs machine-hours. The processing of 1 gallon of dye takes 5 MH. The variable overhead rate is 50.06 per MH VOH is entirely of utility costs FOH is applied per gallon based on an expected annual capacity of 120,000 gallons ER F G Fixed overfhead is incurred evenly throughout the year. Fixed overhead per year is composed of the following costs: Salaries Utilities Insurance-factory Depreciation-factory $78,000 12,000 2,400 27,600 There is no beginning work in process inventory. All work in process is completed in the period in which it is started. Raw materials inventory at the beginning of the year consists 6. of 1,000 gallons of Mordant. There are 400 gallons of dye in finished goods inventory at the beginning of the year carried at standard cost. 7. Accounts Payable relates solely to raw material and is paid 60 percent in the month of purchase and 40 percent in the month after purchase. No discounts are given for prompt payment. 8. The dividend will be paid in January A new piece of equipment costing $9,000 will be purchased on March I percent will be made in March and 20 percent in April. The equipment has a useful life of three years and will have no salvage value. . Payment of 80 10. The note payable has a 6% interest rate; interest is paid at the end of each month. The 11. Dye-Aspora's management has set a minimum cash balance at $5.000, Investments and 12. The ending finished goods inventory should include 15 percent of the next month's needs. principal of the note is repaid as cash is available to do so. borrowings are made in $100 increments. Investments are expectedto earn 9% per year. This is not true at the beginning of January due to a miscalculation in sales for December. The ending inventory of raw materials also should be 25 percent of the next month's needs. elling and administrative costs are paid in cash. Per month costs are as follows: 13. Monthly s $18,000 800 7,000 Salaries Utilities Office Rent

Answer 1

				January	February	March	April	May
Production
units sold				8,000	10,000	15,000	12,000	11,000
Ending finished goods inventory in units (next month's units sold * 15%)			400	1,500	2,250	1,800	1,650
Total needed				9,500	12,250	16,800	13,650
Less: Beginning finished goods inventory				400	1,500	2,250	1,800
Units To Produced				9,100	10,750	14,550	11,850
Units To Produced				9,100	10,750	14,550	11,850
Material required for Production of finished goods (unit produced *1.20)				10,920	12,900	17,460	14,220
ending raw material ( Next month's Material required for Production of finished goods * 25%)			1,000	3,225	4,365	3,555
Beginning raw material ( Same month's Material required for Production of finished goods * 10%)				1,000	3,225	4,365

Estimated Production units
	January	February	March	Quarter
Units sold	8,000	10,000	15,000	33,000
Add: ending finished goods inventory	1,500	2,250	1,800	1,800
Total needed	9,500	12,250	16,800	34,800
Less: Beginning finished goods inventory	400	1,500	2,250	400
Units To Produced	9,100	10,750	14,550	34,400

Material Budget
	January	February	March	Quarter
Units To Produced	9,100	10,750	14,550	34,400
Multiply: Quantity of raw material Needed per unit	1.20	1.20	1.20	1.20
Material required for Production of finished goods	10,920	12,900	17,460	41,280
Add: ending raw material inventory	3,225	4,365	3,555	3,555
Total quantity of material Needed	14,145	17,265	21,015	44,835
Less: Beginning raw material inventory	1,000	3,225	4,365	1,000
Purchase of material Quantity	13,145	14,040	16,650	43,835
Multiply by: cost per board Feet	$                         2	$                         2	$                         2	$                         2
Cost of material purchased	$              26,290	$              28,080	$              33,300	$              87,670

Budgeted Labor Cost
	January	February	March	Quarter
Unit produced	9,100	10,750	14,550	34,400
Multiply: Hour per unit	0.25	0.25	0.25	0.25
Total Hour need	2,275	2,688	3,638	8,600
Multiply: labour rate per hour	$                      12	$                      12	$                      12	$                       12
Direct labor cost	$              27,300	$              32,250	$              43,650	$            103,200