1. Wiengot Antennas, Inc., produces and sells a unique type of TV antenna. The company has just opened a new plant to manufacture the antenna, and the following cost and revenue data have been provided for the first month of the plant's operation. Use MS Excel to carry out the required tasks for the given information Beginning inventory Units produced O units 50,000s units units Units sold 45,000 units Selling price per unit 76 AED Selling and administrative expenses: Variable per unit 3 AED Fixed (total) 567,000 AED Manufacturing costs Direct materials cost per unit 15 AED Direct labor cost per unit 7 AED Variable manufacturing overhead cost per unit 3 AED Fixed manufacturing overhead cost (total) 900,000 AED Because the new antenna is unique in design, management is anxious to see how profitable it will be and has asked that an income statement be prepared for the month. Requirements: a) Determine the unit product cost using Absorption Costing b) Determine the unit product cost using Variable Costing