Project3ExcelWorkbook Q . Search Sheet Home Insert Draw Page Layout Formulas Data Review View Acrobat '+ Share Calibri (Body) * 11 . A- A = Wrap Text General Insert E AP . Q . 19 * Delete Paste Merge & Center $ ~ % 2 08 0 Conditional Format Cell Sort & Find & Create and Share Formatting as Table Styles Format Filter Select Adobe PDF F23 4 x v fx B D E F G H K M N 0 Q R S T U V Additional Information: You learn that 30 % of freight charges are included in the purchases figure and should be split equally among the two products. 40 % of the selling and administrative costs are due to administration. Perform a new calculation based on this new Information. N N 1 Allocated the costs based on this new information Allocated Cost Standard Loot Box Deluxe Loot Box Total Purchases Freight charges Selling Costs General Admin Costs Depreciation Total Costs of Products Number of Products Cost per Product 15 2 Determine the Profit Margins per product based on the allocations above 16 Standard Loot Box Deluxe Loot Box 18 Sales 19 Less: Cost of Products 20 Profit 21 % Profit (Profit/ Sales) 22 23 25 26 Instructions Tab 1 Tab 2 Tab 3 Tab 4 + Ready + 100%Project3ExcelWorkbook Q . Search Sheet Home Insert Draw Page Layout Formulas Data Review View Acrobat '+ Share Calibri (Body) * 11 . A- A = Wrap Text General I7. Insert E AP . Q . 19 * Delete Paste Merge & Center $ % 2 08 40 Conditional Format Cell Sort & Find & Create and Share Formatting as Table Styles Format Filter Select Adobe PDF D8 4 X V fx 62.5 B C D E F G H K L M N Largo Global Production and Cost Information 2020 Product Type Standard Loot Box Deluxe Loot Box TUD W N Volume (Number of Products) 80 20 Selling Price Per Unit 18.20 $ 27.85 Total Sales in un in 1,456.00 $ 557.00 Cost of Sales 1,120.00 280 Selling and Admin Charges 62.5 62.5 Depreciation 87 87 Purchases 1124.8 281.2 Gross Profit 336 277 1 Determine Purchases 2020 15 Cost of Sale 1400 Plus: Closing Inventory 404 1804 Less: Opening Inventory 398 Purchases 1406 2 Use traditional Allocation Method to Allocate Cost |Allocated Cost Total Costs Standard Loot Box Deluxe Loot Box Split 25 Purchases 1,406.00 $ 1,124.80 281.2 Based on volumes sold Selling and General Admin 125.00 $ 62.50 |$ 62.50 Halfhalf Depreciation 174.00 87 87 Halfhalf Total Cost of Products 1,705.00 5 1,274.30|$ 430.70 Number of Products 100 80 20 30 Cost per Product 17.05 $ 15.93 $ 21.54 Total Cost of Prouducts / Number of Products 3 Determine the Profit Margins per product 35 36 Standard Loot Box Deluxe Loot Box Total 37 Sales 1,456.00 $ 557.00 $ 2,013.00 38 Less: Cost of Products 1,274.30 $ 430.70 $ 1,705.00 39 Profit 181.70 5 126.30 308.00 40 |% Profit (Profit/ Sales) 12% 23% 35% 41 43 44 Instructions Tab 1 Tab 2 Tab 3 Tab 4 + Ready + 100%