Coffee Bean Inc
					Mona Loa		Malaysian
Product Costs
Direct Materials					4.2		3.2
Direct Labor		0.025	hrs		0.3		0.3
activities				activity		expected activity			expected cost
				purchasing		for the year			for the year
	purchasing			purchase orders		1710	setups		513000
	material handling			number of setups		1800	setups		720000
	quality control			number of batches		600	batches		144000
	roasting			roasting hours		96100	roasting hours		961000
	blending			blending hours		33500	blending hours		402000
	packaging			packaging hours		26000	packaging hours		260000
	total								3000000
	direct labor				HRS	50000	DL$		600000
data					Mona Loa			Malaysian
	expected sales				100000	pounds		2000	pounds
	batch size				10000	pounds		500	pounds
	setups				3	per batch		3	per batch
	purchase order size				20000	pounds		500	pounds
	roasting time per 100 pounds				1	roasting hour		1	roasting hour
	blending time per 100 pounds				0.5	blending hours		0.5	blending hours
	packaging time per 100 pounds				0.1	packaging hours		0.1	packaging hours
Please prepare an excel report with the similar format as depicted on page 139 of your text. NOTE!!! The report should be on a SEPARATE TAB IN THE EXCEL WORKSHEET so that all cells on the separate tab (in the report) should be nothing but ALL formulae (except for the textual material). Using the information above supposed to prepare an excel sheet to fit the ABC template. I've worked on the basics but am stuck please help if you can! Due soon.