Attached are the data tables and problem. Please help!!!! The requirements are on the left, there are 3 parts
Henderson Supermarkets (HS) operates at capacityr and decides to apply ABC analysls tothree product l' as Iollows: 0 (Click the icon to View the activity mat rates.) Milk and Frozen The revenues, cost at goods mid, store support costs, activities that amount for the store support push, and ectl a (Clickthe icon to View the ininrrnetlon for the three product lines) 33"\" GM\" Fm\" J"' Pmm' Requirement: Flnenelel data 1. Um the simple ousting system In prepare a product-line protability report For HS. Revenues 50.000 3 57.000 5 50.000 2- Use the ABC eyelem le erepere a product-line pretebillty reeert for H5- Cost ofgoods sold 35,000 $ 44,000 $ 31.000 3. What new In5lghls does the ABC system In requlrement 2 pruvrde to H5 managers? Store support \"1500 $ 13200 $ 9300 Baked Goods Fruit Juice Produce: Total Myyama usage Revenues (metallocation base) Costs Ordering (purchase orders) 30 25 10 Cost of goods sold Delivery (deliveries) 96 38 26 Store support Shelf-slodring (hours) 185 165 25 Total Customer support (items sold) 11,000 17,000 8,000 . 1 Under lts simple costing system, HS allocated support oeststo products at the rate arms. of Operating Income cost ofgoods sold. Operating income'Ftevenues Ba Ba Ba Ba Enter any number in the edit elds and then click Check Answer. print Done - nun.- E5-25 (similar to) as Question Help Henderson Supermamets (HS) operates at capacity and decides to apply ABC analysis to three product lines: baked goods, milk and fruit juice, and frozen foods. It identies four activities and their activity cost rate as follows: 0 (Click the icon to View the activity cost rates.) The revenues. cost of goods sold. store support costs. aotivmes that amount for the store support costs. and actlyrtyarea usage of the three product llnes are asfollows: a (Clickthe icon to View the intonation for the three product lines.) Requirements 1. Use the simple costing system to prepare a product-tine protability report for H5. 2. Use the ABC system to prepare a product-line protability report for H3. 3. What new insights does the ABC system in requirement 2 provide to H5 managers? Requirement 1. Use the simple costing system to prepare a product-line protability report for H5. (Round the percentages to the nearest hundredth peroent, XXXVo.) Milk and Frozen Baked Goods Fruit Juice Products Total 0 More '"FD Ravenu 805:5 Ordering $96 per purchase order Cost of goods sold Delivery and receipt of merchandise $75 per delivery Store support Sheff-stocking $24 per hour Customer support and assistance $0.16 per item sold Total costs Enter any number in the edit elds and then click Check Answer. Print Done