Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

The revenues, cost of goods sold, store support costs, activities that account for the store support costs, 2 and activity area usage of the three

image text in transcribed
image text in transcribed
image text in transcribed
The revenues, cost of goods sold, store support costs, activities that account for the store support costs, 2 and activity area usage of the three product lines are as follows: 3 4 Baked Goods Milk and Fruit Juice Frozen Products 6 $60,000 $41,000 $12,300 $66,500 $51,000 $15,300 $50,500 $32,000 $9,600 5 Financial data Revenues 7 Cost of goods sold 8 Store support 9 Activity area usage (cost-allocation base) 10 Ordering (purchase orders) 11 Delivery (deliveries) 12 Shelf-stocking (hours) Customer support (items sold) 14 36 44 120 170 15,400 24 60 150 20,200 20 7,960 13 14 15 Under its simple costing system, FS allocated support costs to products at the rate of 30% of cost of goods sold. 16 17 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.) Baked Goods Milk and Fruit Juice Frozen Products Total Revenues Costs Cost of goods sold Store support Total costs Operating income Operating income/Revenues percentage 2 3 2. Use the ABC system 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 4 Productlineinfo tabs you will be marked wrong.) 5 Baked Goods Milk and Fruit Juice Frozen Products Total 6 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 percentage 37 Activity-Based Costing and Activity-Based Management ABC, Retail Product-line Profitability Fitzgerald Supermarkets (FS) 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: 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

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Auditing Concepts For A Changing Environment

Authors: Larry E. Rittenberg, Bradley J. Schwieger

5th Edition

0324223102, 978-0324223101

More Books

Students also viewed these Accounting questions

Question

What proactive strategies might you develop?

Answered: 1 week ago

Question

How does your message use verbal communication?

Answered: 1 week ago