Question
Bigfoot, reported the following data for 2021 Gross Margin Income Statement General Supermarkets Drugstore Chains Mo m -and-Pop Single Stores Bigfoot Total Sales revenues $3,758,000
Bigfoot, reported the following data for 2021
Gross Margin Income Statement | General Supermarkets | Drugstore Chains | Mom-and-Pop Single Stores | Bigfoot Total |
Sales revenues | $3,758,000 | $3,150,000 | $1,980,000 | $8,888,000 |
Cost of goods sold | 3,600,000 | 3,000,000 | 1,800,000 | 8,400,000 |
Gross margin | $ 158,000 | $ 150,000 | $ 180,000 | $488,000 |
Other operating costs | 290,080 | |||
Operating income | $ 197,920 | |||
Gross Margin % | 4.20% | 4.76% | 9.09% |
For many years Bigfoot has used gross margin percentage [(sales revenue cost of goods sold) / sales revenue] to evaluate the relative profitability of its market segments. You have recently been hired by Bigfoot as a business analyst and are considering allocating the other operating costs which are not currently allocated to market segments using a Job Costing or Activity-Based Costing (ABC) system.
Over the past few weeks you have met with all the key managers and several operations and sales staff and they agree that a job costing system would use a volume-based measure such as cartons shipped to stores while an ABC system would allocate using five key activities that drive other operating costs at Bigfoot.
Activity Area | Cost Driver |
Order processing | Number of customer purchase orders |
Line-item processing | Number of line items ordered by customers |
Delivering to stores | Number of store deliveries |
Cartons shipped to stores | Number of cartons shipped |
Stacking of customer store shelves | Hours of shelf-stocking |
Each customer order consists of one or more line items. A line item represents a single product (such as Diet Pepsi). Each product line item is delivered in one or more separate cartons. Each store delivery entails the delivery of one or more cartons of products to a customer. Bigfoots staff stacks cartons directly onto display shelves in customers stores. Currently, there is no additional charge to the customer for shelf-stocking and not all customers use Bigfoot for this activity. The level of each activity in the three market segments and the total cost incurred for each activity in 2021 is as follows:
Activity | General Supermarkets | Drugstore Chains | Mom-and-Pop Single Stores | Total Cost of Activity |
Orders processed (number) | 140 | 360 | 1,500 | $80,000 |
Line-items ordered (number) | 1,960 | 4,320 | 15,000 | 63,840 |
Store deliveries made (number) | 120 | 360 | 1,020 | 60,000 |
Cartons shipped to stores (number) | 24,000 | 36,000 | 16,000 | 76,000 |
Shelf stocking (hours) | 100 | 180 | 360 | 10,240 |
$ 290,080 |
- Compute a Job Costing rate using the number of cartons shipped to stores (round to two decimal places) and the ABC rates for each of the five activity areas which you and the managers at Bigfoot have identified.
- Using the Job costing and ABC rates, allocate the $290,080 of other operating costs to each of the three market segments and find the Operating income for each market segment (use the tables provided below).
Job Costing based Income Statement
General Supermarkets | Drugstore Chains | Mom-and-Pop Single Stores | |
Sales revenues | $3,758,000 | $3,150,000 | $1,980,000 |
Cost of goods sold | 3,600,000 | 3,000,000 | 1,800,000 |
Gross margin | $ 158,000 | $ 150,000 | $ 180,000 |
Other operating costs | |||
Operating income |
ABC Allocations of other operating costs
Activity & Rate | General Supermarkets | Drugstore Chains | Mom-and-Pop Single Stores |
TOTAL |
ABC costing based Income Statement
Gross Margin Income Statement | General Supermarkets | Drugstore Chains | Mom-and-Pop Single Stores |
Sales revenues | $3,758,000 | $3,150,000 | $1,980,000 |
Cost of goods sold | 3,600,000 | 3,000,000 | 1,800,000 |
Gross margin | $ 158,000 | $ 150,000 | $ 180,000 |
Other operating costs | |||
Operating income | Calculate the operating income percent (operating income / sales revenue) for each segment. |
3. Calculate the operating income percent (operating income / sales revenue) for each segment.
Please give the calculation procedure for each step, do not use this pic to answer question,Thanks.
ABC Sale Revenue Cost of goods Cold Gross margir qerstar Subemel 3.758.000 Total 158,888.000 $8.900,000 1198.000 operating muigin Total Single Store 12010] de Dore mom-and pot chun Strle stok 3,150,000 3.600,000 1.980,000 3.000.000 1 800,000 158,000 150.000 180,000 otheugenoting com 1.880 80,6uo 161,560 990,080 Obesching Income 116,170 69.360 19.440 191,920 3-09-11 0.63/ ABC Rate Computohton Activity & Rate General Scibeu mudah Drugstore Mom-2 - POB Chains Oude. Puoce sedu 5600 14,400 $ 80,000 + 2000 60,000 80,000 4ox 360] line ltem order $ 3 [40X1500) 6.880 $63,8402280 12,960 45,000 (63x1960] [$3 4320] C$ 3*15000] Stone $40 0.800 14. HDO 40,800 [$ 60000 1500] $40 V 120] [$40 x 360] [$408 1090] cartons Shibbed $1 $ 76,000 = 76,000 24.000 36,000 16000 I 20000] [11x36000) ($1x 16000] Shelb sloucing pic 1.600 $ 10,240 $ 600] 2.880 5,760 [ 16 x 100] [$16 x 180] (360x$16] 41.880 80,640 Job Costing Rate Activity & Rate General Cordons Shibled Supeu mawcet 638110 60,000 76,000 10240 Total 2900 167,560 Drug Store mom Pobl TotaStep by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started