Question

please answer questions in excel

Namaste Company manufactures a unique yoga mat. The company began operations December 1, 2018. Its accountant quit the second week of operations, and the company is searching for a replacement. The company has decided to test the knowledge and ability of all candidates interviewing for the position. Each candidate will be provided with the information below and then asked to prepare a series of reports, schedules, budgets, and recommendations based on that information. The information provided to each candidate is as follows. $15,500 mt 1.000 Cost Items and Account Balances Administrative salaries Advertising Cash, December 1 Depreciation on factory building Depreciation on office equipment Insurance on factory building Miscellaneous expenses-factory Office supplies expense Professional fees Property taxes on factory building Raw materials used Rent on production equipment Research and development Sales commissions Utility costs-factory Wages-factory Work in process, December 1 Work in process, December 31 Raw materials inventory, December 1 Raw materials inventory, December 31 Raw material purchases Finished goods inventory, December 1 -0- 1,500 800 1,500 1,000 300 500 400 70,000 6,000 t2.000 w 40,000 900 70,000 70,000 -0-

Answer 1

Please hit LIKE button if this helped. For any further explanation, please put your query in comment, will get back to you.
Part 1
	Direct Material	Direct Labor	Manufacturing overhead	Period Cost
Administrative Salaries				$          15,500
Advertising				$          11,000
Depreciation on factory building			$                                         1,500
Depreciation on office Equipment				$                800
Insurance on factory building			$                                         1,500
Miscellaneous expenses—factory			$                                         1,000
Office Supplies Expense				$                300
Professional Fee				$                500
Property taxes on factory building			$                                             400
Raw Material Used	$                    70,000
Rent on production equipment			$                                         6,000
Research and Development				$          10,000
Sales commission				$          40,000
Utility Cost Factory			$                                             900
Wages Factory		$              70,000
Total	$                    70,000	$              70,000	$                                       11,300	$          78,100
Part 2
	Variable	Fixed	Total
Administrative Salaries		$              15,500	$                                       15,500
Advertising		$              11,000	$                                       11,000
Depreciation on factory building		$                 1,500	$                                         1,500
Depreciation on office Equipment		$                    800	$                                             800
Insurance on factory building		$                 1,500	$                                         1,500
Miscellaneous expenses—factory		$                 1,000	$                                         1,000
Office Supplies Expense		$                    300	$                                             300
Professional Fee		$                    500	$                                             500
Property taxes on factory building		$                    400	$                                             400
Raw Material Used	$                    70,000		$                                       70,000
Rent on production equipment		$                 6,000	$                                         6,000
Research and Development		$              10,000	$                                       10,000
Sales commission		$              40,000	$                                       40,000
Utility Cost Factory		$                    900	$                                             900
Wages Factory	$                    70,000		$                                       70,000
Total	$                  140,000	$              89,400	$                                    229,400