Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Sheridan Inc. is a distributor and processor of a variety of different blends of coffee. The company buys coffee beans from around the world and

Sheridan Inc. is a distributor and processor of a variety of different blends of coffee. The company buys coffee beans from around the world and roasts, blends, and packages them for resale. Sheridan Inc. currently offers 10 different coffees in 500-gram bags to gourmet shops. The major cost is raw materials; however, there is a substantial amount of manufacturing overhead in the mostly automated roasting and packing process. The company uses relatively little direct labour. Some of the coffees are very popular and sell in large volumes, while a few of the newer blends have very low volumes. Sheridan Inc. prices its coffee at total product costs, including allocated overhead, plus a markup of 25%. If prices for certain coffees are significantly higher than market, the prices are adjusted lower. Data for the 2022 budget include manufacturing overhead of $3.9 million, which has been allocated in the existing costing system based on each products budgeted direct labour cost. The budgeted direct labour cost for 2022 totals $780,000. Purchases and use of materials (mostly coffee beans) are budgeted to total $7 million. The budgeted prime costs for 500-gram bags of two of the companys products are as follows:

Mocha

Vanilla

Direct materials

$3.20

$2.80

Direct labour

$0.25

$0.25

Data for the 2022 production of Mocha and Vanilla coffee are as follows. There will be no beginning or ending materials inventory for either of these coffees.

Mocha

Vanilla

Expected sales

50,000

kilograms

1,000

kilograms

Batch size

50,000

kilograms

250

kilograms

Set-ups

3

per batch

3

per batch

Purchase order size

12,500

kilograms

250

kilograms

Roasting time

1

hour/50 kg

1.00

hour/50 kg

Blending time

0.50

hour/50 kg

0.50

hour/50 kg

Packaging time

0.10

hour/50 kg

0.10

hour/50 kg

Sheridans controller believes the traditional costing system may be providing misleading cost information. He has developed an activity-based analysis of the 2022 budgeted manufacturing overhead costs shown in the following table:

Activity Pools

Cost Drivers

Budgeted Units

Budgeted Cost

Purchasing

Purchase orders

1,300

$

637,000

Material handling

Set-ups

2,000

670,000

Quality control

Batches

600

171,000

Roasting

Roasting hours

110,000

1,100,000

Blending

Blending hours

25,400

508,000

Packaging

Packaging hours

33,000

825,000

Total manufacturing overhead cost

$

3,911,000

A) Calculate the companys 2022 budgeted manufacturing overhead rate using direct labour costs as the single rate and the 2022 budgeted costs and selling prices of 500 grams of Mocha coffee and 500 grams of Vanilla coffee. (Round intermediate calculations and final answers to 2 decimal places, e.g. 15.25.)

Overhead rate enter the overhead rate in percentages of direct labour cost % of direct labour cost

Mocha

Vanilla

Selling price

$enter a dollar amount rounded to 2 decimal places

$enter a dollar amount rounded to 2 decimal places

B) Use the controller's activity-based approach to estimate the 2020 budgeted cost for one kilogram of Mocha coffee and one kilogram of Vanilla coffee.

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

Internal Audit In Higher Education

Authors: Alison Holmes, Sally Brown

1st Edition

0749433000, 978-0749433000

More Books

Students also viewed these Accounting questions

Question

What is really the cause of the conflict?

Answered: 1 week ago