help pleasee
Activity-Based 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 frozen foods. It identifies four activities and their activity cost rates as follows: \begin{tabular}{lc} Ordering & $95 per purchase order \\ Delivery and receipt of merchandise & $76 per delivery \\ \hline Shelf-stocking & $19 per hour \\ \hline Customer support and assistance & $0.15 per item sold \end{tabular} 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 "PRODUCTUINEINFO" tab. 13 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/Productlineinfo tabs or if you type the numbers in, you will be 14 marked wrong. Requirements 1 Use the simple costing system to prepare a product-line profitability report for Fitzgerald Supermarkets. a. 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 Fitzgerald Supermarkets. a. Enter all amounts as positive values. DO NOT use parentheses or a minus sign for amounts to be subtracted. Saving \& Submitting Solution "DATA SHEET - DO NOT ENTER ANSWERS HERE" he revenues, cost of goods sold, store support costs, activities that account for the store support costs, and ictivity-area usage of the three product lines are as follows: Under its simple costing system, Fitzgerald Supermarkets allocated support costs to products at the rate of 30% of cost of goods sold. 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 .w.wathowithetlineinfo tabs or if you type the numbers in, you will be marked wrong.) 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/Productlineinto tabs or if you type the numbers in, you will be marked wrong.)
