Philco Data:
Philco Chemicals makes a patented glue for gluing electronic components together.
They have a CPU fan glue and a Moltherboard component glue.
The glues use two patented chemical bonding agents called Coride and Dride.
Operating Expenses are expected to be 17.5% of sales.
The operating budgets for 2019 use the following data:
DLH POR rate	$ 12.00	per DLH
Operating Expenses	17.5%
Direct Materials:	Coride	Doride
Beginning Inventory ($)	$ 45,000	$ 36,000
Beginning Inventory (grams)	500	750
Target Ending Inventory (grams)	750	500	grams
Input Prices:
Coride	$ 4.50	per gram
Doride	$ 6.00	per gram
Direct Manufacturing Labor	$ 30.00	per DLH
Input Quntities per unit of Output:	CPU	Motherboard
Coride	0.50	1.00	gram
Doride	1.50	2.50	gram
Direct Labour Hours	0.30	0.40	DLH's
Sales and FG Inventory:	CPU	Motherboard
Expected Sales in Units	200,000	120,000	units
Selling price	$ 55.00	$ 65.00
Units to be produced	206,000	132,500	units
Target ending FG inventory (units)	15,000	20,000	units
Beginning inventory in dollars	$ 225,000	$ 200,000
Beginning FG inventory (units)	9,000	7,500	units
Required - Produce the following budgets in the tabs shown:
i) Sales Budget
ii) Production Budget
iii) Direct Materials Purchases Budget
iv) Direct Materials Used Budget
v) Direct Labor Budget
vi)MOH (manufacturing overhead) Budget
vii)Finished Goods Budget
viii)Cost of Goods Sold Budget
ix) Budgeted Balance Sheet