Download cl_cost_analysis_template.xlsx File Edt Insert Format Help R PO U v w Z Y Input values Company name Product Seing price of widgets Total number of widgets Conglomco Corporation Widget $550 per unit 1.100 aa As BYUGA Costs B D K LIN Assessment 1: Cost Analysis Worksheet Problem 1 Solve the given problem based on the following information, Conglomco Corporation manufactures and sets widgets for $550 per unit The total cost of production for 1.100 widgets is given below Differentiate each cost as being other variable or foved and product or period Costs Cost by Behavior (5) Variable Fixed Resin for widget covers: $10,700 Wages/assembly: $200 Facility property taxes: 55,500 7 Accounting still sales: $38.500 38.500 Stands (1.100 outsourced): 28.600 9 Rent equipmentul s11.000 0 Salesmanagement $137.500 21 Annus maintenance fee: $11,000 >> Commissions (per unit): 515 23 24 25 Depreciation on machinery: $14.000 Cost by Function (3) Product Period 38.500 Resin for widget covers $18.700 Wages/assembly $20,200 Facility property taxes $5.500 Accounting staff salaries $38.500 Stands (1.100 outsourced) $28,600 Rentalmente stat $11.000 Sanagement 5137.500 Annual manance fee $11.000 Commissions per un $15 Deprecaon machinery $44.000