Activity Bleed Costing and Activity-Based Mara ABC, Retal Product line Profitability Fitzgerald Supermarkets (FS) operates at capacity and decides to apply ABC analysis to the product lines: baked goods, milk and fruit juice, and frozen foods. It identifies four activities and their acta y cost rates as follows: Ordering Delivery and receipt of merchandise Shelf-stocking Customer support and assistance $95 per purchase order $76 per delivery $19 per hour $0.15 per item sold 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 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 instructions or Productlinelinfo tabs you will be marked wrong. 6 Requirements 1 Use the simple costing system to prepare a product-line profitability report for FS. Enter all amounts as positive values. DO NOT use parentheses or a minus sign for amounts to be subtracted. 2 Use the ABC system to prepare a product-line profitability report for FS. Enter all amounts as positive values. DO NOT use parentheses or a minus sign for amounts to be subtracted to o R2 Saving & Submitting Solution 1 Save file to desktop. a. Create folder on desktop, and label COMPLETED EXCEL PROJECTS 2 Upload and submit your file to be graded a. Navigate back to the activity window - screen where you downloaded the initial spreadsheet b. Click Choose button under step 3: locate the file you just saved and click Open Click Upload button under step 3 d. Click Submit button under step 4 NA 32 Viewing Results 1 Click on Results tab in My Accountinglab 2 Click on the Assignment you were working on 3. Click on Project link; this will bring up your Score Card 4 Within Scorecard window, click on tive Comments Report flower right to download spreadsheet with feedback INSTRUCTIONS P RODUCTLINEINFO ENTERANSWERS JxTVATA SHEET - DO NOT ENTER ANSWERS HERE CATA 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-a usage of the three product lines are as follows: Baked Goods Milk and Fruit Juice Frozen Products $60,000 $41,000 $12,300 $66,500 $51,000 $15,300 $50,500 $32,000 $9,600 5 Financial data Revenues Cost of goods sold Store support 9 Activity area usage (cost-allocation base) 10 Ordering (purchase orders) Delivery (deliveries) 12 Shelf-stocking (hours) 13 Customer support (items sold) 120 170 15,400 150 20,200 7,960 15 Under its simple costing system, FS allocated support costs to products at the rate of 30% of cost of goods sold. INSTRUCTIONS PRODUCTLINEINFO E NTERANSWERS orm! Instructions 1. Use the simple costing system to prepare a product-line profitability report for FS. (Always use cell references and formulas where appropriate to receive full credit. If you copy/paste from the Instructions or Productlineinfo tabs you will be marked wrong.) 2. Use the ABC system to prepare a product-line profitability report for FS. (Always use cell references and formulas where appropriate to receive full credit. If you copy/paste from the Instructions or Productlineinfo tabs you will be marked wrong.) Total Poi Ted States) MacBook Air BS Xx B C D F G H 1. Use the simple costing system to prepare a product-line profitability report for FS. (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 Baked Goods Milk and Fruit Juice Frozen Products 5 Revenues 6 Costs 7 Cost of goods sold 8 Store support 9 Total costs 10 Operating income 11 Operating Income/Revenues percentage 13 2. Use the ABC system to prepare a product-line profitability report for FS. (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.) Milk and Fruit Juice Frozen Products 17 Revenues 18 Costs 19 Cost of goods sold 20 Ordering 21 Delivery 22 Shelf-stocking 23 Customer support 24 Total costs 25 Operating income 26 Operating income/Revenues INSTRUCTIONS PRODUCTUNEINFO ENTERANSWERS + MacBook Air esc & 2 30 F3