Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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

  1. 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.
  2. 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.

image text in transcribed

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 Tota

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

Business Of Sport Management

Authors: John Beech, Simon Chadwick

2nd Edition

027372133X, 9780273721338

More Books

Students also viewed these Accounting questions