Required: 1. Determine the activity rates based on practical capacity and the cost of idle capacity for each activity. (Round "Usage %" and "Practical Capactity Rate" to 2 decimal places. For percentages.1234-12.34%)

Essentials of Business Analytics (MindTap Course List)
2nd Edition
ISBN:9781305627734
Author:Jeffrey D. Camm, James J. Cochran, Michael J. Fry, Jeffrey W. Ohlmann, David R. Anderson
Publisher:Jeffrey D. Camm, James J. Cochran, Michael J. Fry, Jeffrey W. Ohlmann, David R. Anderson
Chapter11: Linear Optimization Models
Section: Chapter Questions
Problem 7P: Vollmer Manufacturing makes three components for sale to refrigeration companies. The components are...
icon
Related questions
icon
Concept explainers
Topic Video
Question
Please do not give image format and solve with explanation
Coffee Bean Incorporated (CBI) processes and distributes high-quality coffee. CBI buys coffee beans from around the world and
roasts, blends, and packages them for resale. Currently, the firm offers 2 coffees to gourmet shops in 1-pound bags. The major cost is
direct materials; however, a substantial amount of factory overhead is incurred in the predominantly automated roasting and packing
process. The company uses relatively little direct labor.
CBI prices its coffee at full product cost, including allocated overhead, plus a markup of 30%. If Its prices are significantly higher than
the market, CBI lowers its prices. The company competes primarily on the quality of its products, but customers are price conscious as
well.
Data for the current budget Include factory overhead of $3,084,000, which has been allocated on the basis of each product's direct
labor cost. The budgeted direct labor cost for the current year totals $600,000. The firm budgeted $6,000,000 for purchase and use
of direct materials (mostly coffee beans).
The budgeted direct costs for 1-pound bags are as follows:
Malaysian
Mona Loa
$ 4.20
$ 3.20
0.30
0.30
Direct materials
Direct labor
CBI's controller, Mona Clin, believes that its current product costing system could be providing misleading cost Information. She has
developed this analysis of the current year's budgeted factory overhead costs:
Activity
Purchasing
Materials handling
Quality control
Roasting
Blending
Packaging
Total factory overhead cost
Cost Driver
Purchase orders
Setups
Batches
Roasting hours
Blending hours
Packaging hours
Budgeted Driver
Consumption
1,218
1,860
788
96,700
34,200
26,600
Budgeted Cost
$ 609,000
744,000
156,000
967,000
342,000
266,000
$ 3,084,000
Data rogarding the current year's production for the Mona Loa and Malavclan linor follow There is no boginning G onding direct
Transcribed Image Text:Coffee Bean Incorporated (CBI) processes and distributes high-quality coffee. CBI buys coffee beans from around the world and roasts, blends, and packages them for resale. Currently, the firm offers 2 coffees to gourmet shops in 1-pound bags. The major cost is direct materials; however, a substantial amount of factory overhead is incurred in the predominantly automated roasting and packing process. The company uses relatively little direct labor. CBI prices its coffee at full product cost, including allocated overhead, plus a markup of 30%. If Its prices are significantly higher than the market, CBI lowers its prices. The company competes primarily on the quality of its products, but customers are price conscious as well. Data for the current budget Include factory overhead of $3,084,000, which has been allocated on the basis of each product's direct labor cost. The budgeted direct labor cost for the current year totals $600,000. The firm budgeted $6,000,000 for purchase and use of direct materials (mostly coffee beans). The budgeted direct costs for 1-pound bags are as follows: Malaysian Mona Loa $ 4.20 $ 3.20 0.30 0.30 Direct materials Direct labor CBI's controller, Mona Clin, believes that its current product costing system could be providing misleading cost Information. She has developed this analysis of the current year's budgeted factory overhead costs: Activity Purchasing Materials handling Quality control Roasting Blending Packaging Total factory overhead cost Cost Driver Purchase orders Setups Batches Roasting hours Blending hours Packaging hours Budgeted Driver Consumption 1,218 1,860 788 96,700 34,200 26,600 Budgeted Cost $ 609,000 744,000 156,000 967,000 342,000 266,000 $ 3,084,000 Data rogarding the current year's production for the Mona Loa and Malavclan linor follow There is no boginning G onding direct
Packaging
Total factory overhead cost
Budgeted sales
Batch size
Setups
Purchase order size
Roasting time
Blending time
Packaging time
Data regarding the current year's production for the Mona Loa and Malaysian lines follow. There is no beginning or ending direct
materials Inventory for elther of these coffees.
O
Activity
Purchasing
Materials handling
Quality control
Roasting
Blending
Packaging
Mona Loa
100,000 pounds
10,000 pounds
Activity
3 per batch
25,000 pounds
Purchasing
Materials handling
Quality control
Roasting
Blending
Packaging
Packaging hours
1 hour per 100 pounds.
0.5 hour per 100 pounds
0.1 hour per 100 pounds
Show Transcribed Text
Coffee Bean has total practical capacity as noted in the table below, I.e. processing 1,520 purchase orders, 2,520 setups, etc. These
are the levels of activity work that are sustainable.
Practical
Capacity
1,520
2,520
1,320
101,200
37,200
31,200
26,600
Budgeted
Activity
Required:
1. Determine the activity rates based on practical capacity and the cost of idle capacity for each activity. (Round "Usage %" and
"Practical Capactity Rate" to 2 decimal places. For percentages 1234-12.34%.)
Budgeted Cost Usage Based
Rate
$ 3,084,000
Malaysian
2,000 pounds
see pounds.
3 per batch
500 pounds
1 hour per 100 pounds
8.5 hour per 100 pounds
8.1 hour per 100 pounds.
1.218 S 600,000
1,800 $
744,000
780 $ 156.000
96,700 $ 967,000
34,200 $ 342,000
26,000 $ 268,000
S 3,084,000
Practical
Capacity at
Current
Spending
1,520
2,520
1.320
101,200
37,200
31,200
Ċ
Usage %
Practical
Capacity Rate
Unused
Capacity
Idle Capacity
Cost
Transcribed Image Text:Packaging Total factory overhead cost Budgeted sales Batch size Setups Purchase order size Roasting time Blending time Packaging time Data regarding the current year's production for the Mona Loa and Malaysian lines follow. There is no beginning or ending direct materials Inventory for elther of these coffees. O Activity Purchasing Materials handling Quality control Roasting Blending Packaging Mona Loa 100,000 pounds 10,000 pounds Activity 3 per batch 25,000 pounds Purchasing Materials handling Quality control Roasting Blending Packaging Packaging hours 1 hour per 100 pounds. 0.5 hour per 100 pounds 0.1 hour per 100 pounds Show Transcribed Text Coffee Bean has total practical capacity as noted in the table below, I.e. processing 1,520 purchase orders, 2,520 setups, etc. These are the levels of activity work that are sustainable. Practical Capacity 1,520 2,520 1,320 101,200 37,200 31,200 26,600 Budgeted Activity Required: 1. Determine the activity rates based on practical capacity and the cost of idle capacity for each activity. (Round "Usage %" and "Practical Capactity Rate" to 2 decimal places. For percentages 1234-12.34%.) Budgeted Cost Usage Based Rate $ 3,084,000 Malaysian 2,000 pounds see pounds. 3 per batch 500 pounds 1 hour per 100 pounds 8.5 hour per 100 pounds 8.1 hour per 100 pounds. 1.218 S 600,000 1,800 $ 744,000 780 $ 156.000 96,700 $ 967,000 34,200 $ 342,000 26,000 $ 268,000 S 3,084,000 Practical Capacity at Current Spending 1,520 2,520 1.320 101,200 37,200 31,200 Ċ Usage % Practical Capacity Rate Unused Capacity Idle Capacity Cost
Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 3 steps

Blurred answer
Knowledge Booster
Costing Systems
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, accounting and related others by exploring similar questions and additional content below.
Similar questions
  • SEE MORE QUESTIONS
Recommended textbooks for you
Essentials of Business Analytics (MindTap Course …
Essentials of Business Analytics (MindTap Course …
Statistics
ISBN:
9781305627734
Author:
Jeffrey D. Camm, James J. Cochran, Michael J. Fry, Jeffrey W. Ohlmann, David R. Anderson
Publisher:
Cengage Learning
Cornerstones of Cost Management (Cornerstones Ser…
Cornerstones of Cost Management (Cornerstones Ser…
Accounting
ISBN:
9781305970663
Author:
Don R. Hansen, Maryanne M. Mowen
Publisher:
Cengage Learning