Question
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
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