Written Formal Report for Opening New Facility

Module12.doc

Home >Business & Finance homework help >Operations Management homework help >Written Formal Report for Opening New Facility

Your Team Number: 11 Your Name:

Exhibit 12 (Page 1 of 2)

Wood Furniture, Inc.

Equipment and Facility Costs

	1	2	3	4	5	6	7	8	9	10
Production Data: Standard = 581200 Deluxe = 318200	Life (Years)	Cost Per Unit	Cost Per Linear Foot or Per Square Foot	Number Required	Total Cost Per Year	Depreciation Per Year	Production %	Production Total Cost	Administration %	Administration Total Cost
Land	-	470000	-	1	470000	0	76	357200	24	112,800
Fencing	5	-	8/Ft.	1050	8400	1680	100	8400	0	0
Employee Entrance Gate	5	80	-	0	0	0	0	0	0	0
Driveway Gate	5	250	-	0	0	0	0	0	0	0
Concrete Paving (Docks)	5	-	.75/SF	960	720	144	100	720	0	0
Asphalt Paving (Parking)	5	-	.60/SF	70528	42317	8464	76	32160	24	10157
Landscaping	10	-	.55/SF	211039	116072	550	76	88215	24	27858
Building Structure	10	-	44/SF	42474	1868856	186886	76	1420331	24	448526
Interior Doors	10	95	-	24	2280	228	76	1733	24	548
Exterior Doors	10	205	-	2	410	41	76	312	24	98
Dock Doors	10	4200	-	5	21000	2100	100	21000	0	0
Windows	10	350	-	12	4200	420	0	0	100	4200
Interior Sprinkler System	10	-	.60/SF	42474	25485	2549	76	19367	24	6117
Interior Lighting	10	-	.32/SF	42474	13592	1360	76	10330	24	3263
Office Heating System	10	4900		1	4900	490	0	0	100	4900
Office Air Conditioning	10	4900	-	1	4900	490	0	0	100	4900
Factory Gas Heat	10	-	1/SF	40950	40950	4095	100	40950	0	0
Factory Air Conditioning	10	-	2/SF	40950	81900	8190	100	81900	0	0
Toilet	10	220	-	28	6160	616	86	5298	14	862
Toilet Partition & Door	10	85	-	27	2295	230	89	2044	11	251
Urinal	10	140		13	1820	182	92	168	8	14
Sink	10	160	-	41	6560	656	88	5773	12	787
Shower	10	110	-	0	0	0	0	0	0	0
Water Fountain	10	425	-	6	2550	255	76	1938	24	612
Power Distribution Panel	10	5200	-	6	31200	3120	76	23712	24	7488
Air Compressor	10	3800	-	2	7600	760	100	7600	0	0
Time Clock	5	4500	-	6	27000	5400	100	27000	0	0
Fire Extinguisher	5	95	-	6	570	114	76	434	24	137
First Aid Kit	5	75	-	2	150	30	76	114	24	36
First Aid Room Furniture	10	750	-	1	750	72	76	570	24	180
Employee Locker	10	65	-	120	7800	780	100	7800	0	0
PAGE TOTALS =	x	x	x	x	x	229902	x	2165069	x	633734

Exhibit 12 (Page 2 of 2)

Wood Furniture, Inc.

Equipment and Facility Costs

	1	2	3	4	5	6	7	8	9	10
Production Data: Standard = 581200 Deluxe = 318200	Life (Years)	Cost Per Unit	Cost Per Linear Foot or Per Square Foot	Number Required	Total Cost Per Year	Depreciation Per Year	Production %	Production Total Cost	Administration %	Administration Total Cost
Circular Saw	5	1500	-	5	7500	1500	100	7500
Cut-Off Saw	5	1100	-	13	14300	2860	100	14300
Drill Press	5	1300	-	18	23400	4680	100	23400
Disc Sander	5	550	-	19	10450	2090	100	10450
Bevel Grinder	5	1400	-	3	4200	840	100	4200
Band Saw	5	1100	-	6	6600	1320	100	6600
Assembly Bench	5	450	-	33	14850	2970	100	14850
Lacquer and Dry Booth	5	4800	-	2	9600	1920	100	9600
Manager Office Desk	5	950	-	10	9500	1900			100	9500
Manager Chair	5	490	-	10	4900	980			100	4900
Employee Office Desk	5	600	-	4	2400	480			100	2400
Employee Chair	5	250	-	4	1000	200			100	1000
Break Area Tables	5	350	-	4	1400	280	76	1064	24	336
Break Area Chairs	5	75	-	14	1050	210	76	798	24	252
Conference Table	5	850	-	1	850	170			100	850
Conference Room Chairs	5	200	-	10	2000	400			100	2000
File Cabinet	5	225	-	5	1125	225			100	1125
Computer (per office)	5	800	-	15	12000	2400			100	12000
Conveyor (Straight)	5	-	14/Ft.	176	2464	493	100	2464
Conveyor (Curved)	5	250	-	11	2750	550	100	2750
Pallets (Work in Progress)	5	40	-	183	7320	1464	100	7320
Containers (Work in Pro.)	5	25	-	17	425	85	100	425
Pallet Storage Racks	5	-	95/Ft.	975	92635	18525	100	92635
Storage Shelves	5	175	-	5	875	175	100	875
Narrow Aisle Lift Truck	5	16000	-	5	80000	16000	100	80000
4 Wheel Push Cart	5	750	-	5	3750	750	100	3750
2 Wheel Hand Truck	5	200	-	5	1000	200	100	1000
Hand Pallet Jack	5	1200	-	6	7200	1440	100	7200



PAGE TOTALS =	x	x	x	x	x	65447	x	291181	x	34363
GRAND TOTALS =	x	x	x	x	x	295349	x	2456250	x	668097