A1 X vfx Activity-Based Costing and Activity-Based Manageme D G H Activity Bed Costing and Activity Based Management ABC, Retail Product line Profitability Fitzgerald Supermarkets operates at capacity and decides to apply ABC analysis to three product lines baked goods, milk and fruit juice, and froren foods. It identibes four activities and their activity contrates as follow Ordering Delivery and receipt of merchandise Shellstocking Customer support and assistan $95 per purchase order $76 per delivery $19 per hour 50.15 per item sold The revenues, cost of goods sold, store support costs, activities that account for the store support costs, and activity area sape of the three product lines can be found on the "PRODUCTUNEINFO"tab 3 Use the blue shaded areas on the ENTERANSWERS tab for inputs Always use cell references and formulas where appropriate to receive full credit. If you copy/paste from the natructions or Productlineinfo tabs you will be marked wrong 5 6 Requirements 7 1 Use the simple conting wystem to prepare a product line profitability report for Fitzgerald Supermarkets 2. Enter all amounts as positive valots. DO NOT E parentheses or a minus sign for amounts 8 to be subtracted 9 2 Use the ABC system to prepare a product-line profitability report for Fitzgerald Supermarkets anter all amounts as positive values. DO NOT se parentheses or a minus in for amounts 20 to be subtracted 22 Saving & Submitting Solution 1 Save fle to desktop 24 2. Create folder on desktop, and label COMPLETED EXCEL GOJECTS 25 2 Upload and submit your file to be graded 26 Navigate back to the activity window screen where you downloaded the initial spreadsheet 27 b Click Choose button under step 3: locate the file you just saved and dick Open 28 Cidk Upload button under step 29 d. Click Submit button under step 4 30 31 12 Viewing Results 33 1 Oick on Resultstab In My Accountinglab 34 2 Click on the Assignment you were working on 35 3 Click on Project link this will bring up your Score Card 335 4 Within Score Card window,dick on tive Comments Report lower right to download spread out with feedback 37 BB 39 60 41 42 46 16 47 48 69 50 51 52 G H A D E F MTA SHEET -- DO NOT ENTER ANSWERS HERE" The revenues, cost of goods sold, store support costs, activities that account for the store support costs, and activity area usage of the three product lines are as follows: Baked Goods Milk and Fruit Juice Froren Products - Financial data Revenues $60,000 $66,500 $50,500 Cost of goods sold $41,000 $51,000 Store support $32,000 $12,300 $15,300 $9,600 Activity area usage (cost-allocation base) Ordering (purchase orders) 44 24 14 2 Delivery (deliveries) 120 60 36 2 Shelf-stocking (hours) 170 150 20 3 Customer support (Items sold) 15,400 20,200 7,960 3 Under its simple costing system, Fitzgerald Supermarkets allocated support costs to products at the rate of 30% of cost of goods sold. 3 3 1 1. Use the simple costing system to prepare a product-line profitability report for Fitzgerald Supermarkets. (Always use cell references and formulas where appropriate to receive full credit. If you copy/paste from the Instructions or Productlineinfo tabs 2 you will be marked wrong) 3 Baked Goods Milk and Fruit Juice Froren Products Total 5 Revenues 6 Costs 7 Cost of goods sold 8 Store support 9 Total costs 10 Operating Income 11 Operating income/Revenues percentage 12 13 2. Use the ABC system to prepare a product-line profitability report for Fitzgerald Supermarkets. (Always use cell references and formulas where appropriate to receive full credit. If you copy/paste from the Instructions or Productlineinfo tabs 14 you will be marked wrong.) 15 16 Baked Goods Milk and Fruit Juice Froren Products Total 17 Revenues 18 Costs 19 Cost of goods sold 20 Ordering 21 Delivery 22 Shell-stocking 23 Customer support 24 Total costs 25 Operating Income 26 Operating income/Revenues percentage 27 28