Enter titles and accounts in the green cells
Enter Numbers in the blue cells
Enter your Calculations in the yellow cells
Unit 1	Intro To Managerial Acctg
Read Chapter 17	https://www.principlesofaccounting.com/managerial-cost-accounting/
Allocate the Costs of each item to the correct category. Put the entire amount in the column where it is correctly classified. Then total Each column using the Excel Sum formula. Look at the formula in C36 for an exmample on how to sum a column.
	Amount	Direct materials	Direct labor	Overhead	Selling	Admin
Salary of chief compliance officer of company	65,000					65,000
Power used by painting equipment	5,000
Instrument panel installed in the airplane cockpit	137,000
Annual bonus paid to the chief operating officer of the company	100,000
Turbo-charged airplane engine	250,000
Interior trim material used throughout the airplane cabin	70,000
Cost of normal scrap from production of airplane body	15,000
Total Hourly wages of employees that assemble the airplane	325,000
Salary of the marketing department personnel	125,000
Cost of paving the headquarters employee parking lot	7,000
Cost of electrical wiring throughout the airplane	80,000
Cost of electronic guidance system installed in the airplane cockpit	350,000
Salary of plant manager	90,000
Cost of miniature replicas of the airplane used to promote and market the airplane	10,000
Human resources department costs for the year	135,000
Metal used for producing the airplane body	137,000
Annual fee to a celebrity to promote the aircraft	50,000
Hydraulic pumps used in the airplane's flight control system	95,000
Yearly cost of the maintenance contract for robotic equipment	27,000
Prebuilt leather seats installed in the first-class cabin	28,000
Depreciation on factory equipment	57,000
Special advertising campaign inAviation Worldmagazine	5,000
Oil to lubricate factory equipment	2,500
Masks for use by painters in painting the airplane body	1,000
Decals for cockpit door, the cost of which is immaterial to the cost of the final product	1,000
Salary of chief financial officer	65,000
Totals		-