H 11 Bose Activity Fermus Data Julian Chang Review View Autowe OCR R C File Home Insert Dr Page Layout C -10AA BIU - 11-10-A- - Share PC X WCO Carl Sort a Find a Conditional Formatas Formatting 1141xfo 1 Below are total costs of the 2019 production of 15,000 Blu-ray Discs (BD). 2 Required: 3. 1. Classily each cost and its total amount as (al either variable or fixed (b) either product or period 4 2. Compute the manufacturing unit cost of Blu-ray Discs. 5 3. Assume that 18,000 BDs are produced. What is the unit cost of the Blu-ray discs. 6 Hint: variable costs per unit remain the same, fixed costs per unit changes 7 1. What is the total product cost for 18,000 BD units? Excel Instructions: The You can complete this in a way that works for you. Please review my examples for different uses of the IF function You are not required to use them. In the If Function (quote, space bar, quote) leaves a cell blank in 19 and 1 multiply cost per unit x total units G19B1929 Per unit Total Total Costs: Total Costs: Total Cost Variable Period 1.500 9,000 1,500 0.10 050 15.000 30.000 30.000 2.00 2.00 36,000 11 Costs 12 Plastic for 15,000 BDs 13 Cost of factory rent 14 Administrative staff salaries 15 Wages of assembly workers 16 Hard-coating for 15,000 BDS 17 Office equipment rent 18 Upper management salaries 19 Labeling $0.25 per BD unit 20 Annual fee for office cleaning service Sch of Goods M atured $1,500 9,000 15,000 30,000 450 1,050 90,000 0.25 4.520 450 450 1.050 90.000 90.000 Contacto acer DIKONSTGONDERODA AutoSave 3 Home in Chang - 8 DrawPage Layout nert Formulas Review ViewH elp -10-AA 2:27 04 S I - - O - A- Sort % 3 Find a 9 Conditional Formats Cell Formatting able Styles deng DEF 7 4. What is the total product cost for 18.000 BD units? Total Costs: Total Costs: Total Costs: Total Costs: 1,500 $1,500 9,000 15,000 30,000 9.000 15,000 30.000 2.00 36.000 450 1050 12 Plastic for 15,000 BDS 13 Cost of factory rent 14 Administrative staff salaries 15 Wages of assembly workers 16 Hard-coating for 15.000 BDS 17 Office equipment rent 18 Upper management Salaries 19 Labeling $0.25 per BD unit 20 Annual fee for office cleaning service 21 Sales commissions 5.0.50 per BD unit 22 Machinery depreciation, straight-line 23 Total Product / Unit Costs 90.000 1,050 90,000 0.25 4,520 0.50 1R000 24 Sch of Goods Mandatured Cost classifica acer