W ON T W INGOW help 75% Wed 5:54 PM AC306 Unit 6 Assignment template Queens Home . Paste Formulas Data A- A = . .A. E Review = View . General Insert Page Layout Calibri (Body) - 16 B I U . X v fx 12. 5 Wrap Text Margo & Contor. Insert . Delete. Format . - 2. $ . % ) * Conditional Format Formatting as Table Styles Cell sort 1 Enter numbers in blue cells 2 Enter formulas in the yellow cells 3 Enter your narrative analysis in the green cells Kitty Hawk manufactures and distributes high end drones. The following costs are available for the rear end. The company had no beginning Inventory. Last year they produced 1,800 units and but only sold 1,600 units. The unit selling price was $4,300 and expenses were: 6 Variable Cost per Unit Direct Materials Direct Labor Variable Mfg Over Head 10 Variable selling and admin 900 750 Units Produced Units Sold Units Remaining Unit selling price 1,800 1,600 200 4,300 1 12 Annual Foxed Costs 13 Mfg overhead fbed 14 Fbed Selling and admin Expenses 950,000 87,500 17 1. Compute the cost of manufacturing one unit for both variable and absorption costing fixed cost per unit 19 Fixed Overhead 20 Units produced Variable Absorption Determine the product cost for each 22 method Problem 1 Problem 2 Problem 3 + Ready MacBook Pro Home View Insert Page Layout Formulas * Calibri (Body) - 14 . A- A BIU A x fx Less Period Costs Data Review = = = E33 Paste Wrap Text Merge & Conter. 3 General $ % ) Conditional Form F39 17 1. Compute the cost of manufacturing one unit for both variable and absorption costing 17 1.Compute the cost 19 Fixed Overhead 20 Units produced fixed cost per unit Variable Absorption Determine the product cost for each 22 method 23 Direct Materials 24 Direct Labor Variable Mfg OverHead 26 Variable selling and admin Fixed Cost per unit Total Cost per unit Per unit Absorption 1,600 2. Prepare an income statement for both variable and absorption costing 34 Income Stmt Per unit Variable 35 Units sold 1,600 36 Sales 37 Variable Prod Costs VCOGS Less Variable selling expense MFG Margin Problem 1 Problem 2 Problem 3 + Sales COGS Gross Profit Less Period Costs Variable selling Ready $ ExcelFile Edit View Insert Format Tools Data Window Help AC306 Unit 6 Assignment template View 14 Home Insert Page Layout * Calibri (Body) Paste B IV B F56 x V fx Formulas Data Review A A = = 2 O A E 33 19 Eo wrap Text Morge & Center General $ % ) Conditional Format Formatting as Table Per unit Absorption 1,600 . 33 2. Prepare an income statement for both variable and absorption costing 34 Income Stmt Per unit Variable 35 Units sold 1,600 36 Sales 37 Variable Prod Costs VCOGS Less Variable selling expense MFG Margin 41 Less Fixed Costs 42 Fixed Mfg Ohead Sales COGS Gross Profit Less Period Costs Variable selling Fixed Selling Total period costs 44 Total Fixed Costs Difference 46 Net Income Net Income LI Proof Ending Inventory Per unit Difference Ending inventory Per unit Total Ending Inventory Total ending inventory Problem 1 Problem 2 Problem 3 + Ready