er Term B) AC 306-8 > Assignments > Unit 6 Assignment - Managerial Reporting Unit 6 Assignment - Man- agerial Reporting Submit Assignment Due Sunday by 11:59pm Points 80 Submitting a file upload Instructions Variable costing is a costing system where we consider taking on additional work to help fill our production capacity. Variable costing is used for short term decisions and excludes fixed overhead costs. In this assignment, we will explore how variable costing can help us determine how to select special orders. Download the AC 306 Unit 6 Assignment template a [Excel] and complete the problems on each tab. In this assignment Problem 1 - Absorption vs variable costing Problem 2 - ROI and Residual income Problem 3 - Calculating Cost of Goods Sold Assignment Objectives Demonstrate Describe managerial and internal uses of cost accounting data. Deliverables When you have finished, rename the file using your first initial, last name. course number and assignment number (for example UDoc_AC306 A6.xlsx) L O TUS Dola WowHelp Wed 5:54 PM Quen se Q AC306 Unit 6 Assignment template Home Insert Page Layout 6 Calibri (Body) - 16 View Formulas .A- A Data = Review = = General 2 " A . Paste to Wrap Text Merge & Center Insert Delete. CH Format 2Y $ % ) do 6 Conditional Format Formatting as Table Cell Styles - Sort & Filter 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 year 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 Variable selling and admin Units Produced Units Sold Units Remaining Unit selling price 1,800 1,600 200 4,300 Annual Fbeed Costs Mfg overhead fbxed Foxed 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 Fixed Overhead 20 Units produced Variable Absorption Determine the product cost for each 22 method