Question

In: Accounting

OFC Company of Kansas City prints business forms and other specialty paper products, such as writing paper, envelopes, note cards, and greeting cards.

OFC Company of Kansas City prints business forms and other specialty paper products, such as writing paper, envelopes, note cards, and greeting cards. Its Business Services division offers inventory management services and desktop delivery on request. The division uses an activity-based costing (ABC) system. The budgeted usage of each activity cost driver and cost-driver rates for January 2019 for the Business Services division are: Activity Cost Driver Budgeted Activity Cost-Driver Rate Storage Cartons in inventory 430,000 $ 0.5120 /carton/month Requisition handling Requisitions 36,000 27.50 Pick packing Lines 815,000 1.52 Data entry Lines 815,000 0.97 Requisitions 33,000 1.34 Desktop delivery Per delivery 13,500 33.00 For the month, the division expects to make 10,200 deliveries to deliver 1,020,000 cartons to customers. OFC Company has decided to implement a kaizen (continuous-improvement) program to enhance operational efficiency. After a careful study, management and employees agree that the firm will be able to reduce cost rates for batch-level activities by 2% and unit-level activities (other than Storage) by 1% per month during the first year of the program starting February 2019. The firm has decided to delay the implementation of the program for customer-sustaining and facility-level activities until 2020. The firm expects the amount of cost-driver usage in each of the next two months to be the same as those in January. Required:

1. Identify unit-level and batch-level activities.

2. What are the total budgeted costs for each activity and for the division as a whole in February and March?

Solutions

Expert Solution

Required 1.

Storage Unit level
Pick packing unit leve
Data entry- Lines Unit level
Requisition handling Batch level
Data entry- Requisition Batch level
Desktop delivery Batch level

Required 2.

Activity Cost reduction rate per month January February March
Storage - 0.5120 0.5120 0.5120
Requisition- Handling 2% 27.50 26.95 26.4110
Pick packing 1% 1.52 1.5048 1.4898
Data entry- Line 1% 0.97 0.9603 0.9507
Data entry- Requisition 2% 1.34 1.3132 1.2869
Desktop delivery 2% $33.00 $32.34 $31.6932

Budget costs

Activity Activity volume February March
Storage 430,000 220,160 220,160
Requisition handling 36,000 970,200 950,796
Pick packing 815,000 1,226,412 1,214,187
Data entry-line 815,000 782,645 774,821
Data entry- requisition 33,000 43,336 42,468
Desktop delivery 13,500 436,590 427,858
Divisional total   $3,679,343 $3,630,290

 


Related Solutions

OFC Company of Kansas City prints business forms and other specialty paper products, such as writing paper, envelopes, note cards, and greeting cards.
  OFC Company of Kansas City prints business forms and other specialty paper products, such as writing paper, envelopes, note cards, and greeting cards. Its Business Services division offers inventory management services and desktop delivery on request. The division uses an activity-based costing (ABC) system. The budgeted usage of each activity cost driver and cost-driver rates for January 2019 for the Business Services division are: Activity Cost Driver Budgeted Activity Cost-Driver Rate Storage Cartons in inventory   600,000   $...
OFC Company of Kansas City prints business forms and other specialty paper products, such as writing...
OFC Company of Kansas City prints business forms and other specialty paper products, such as writing paper, envelopes, note cards, and greeting cards. Its Business Services division offers inventory management services and desktop delivery on request. The division uses an activity-based costing (ABC) system. The budgeted usage of each activity cost driver and cost-driver rates for January 2019 for the Business Services division are: Activity Cost Driver Budgeted Activity Cost-Driver Rate Storage Cartons in inventory 570,000 $ 0.6020 /carton/month Requisition...
OFC Company of Kansas City prints business forms and other specialty paper products, such as writing...
OFC Company of Kansas City prints business forms and other specialty paper products, such as writing paper, envelopes, note cards, and greeting cards. Its Business Services division offers inventory-management services and desktop delivery on request. The division uses an activity-based costing (ABC) system. The budgeted usage of each activity cost driver and cost-driver rates for January 2016 for the Business Services division are:   Activity Cost Driver Budgeted Activity Cost-Driver Rate   Storage Cartons in inventory 520,000 $ 0.6320 /carton/month   Requisition handling...
[The following information applies to the questions displayed below.] OFC Company of Kansas City prints business...
[The following information applies to the questions displayed below.] OFC Company of Kansas City prints business forms and other specialty paper products, such as writing paper, envelopes, note cards, and greeting cards. Its Business Services division offers inventory management services and desktop delivery on request. The division uses an activity-based costing (ABC) system. The budgeted usage of each activity cost driver and cost-driver rates for January 2019 for the Business Services division are: Activity Cost Driver Budgeted Activity Cost-Driver Rate...
Required information [The following information applies to the questions displayed below.] OFC Company of Kansas City...
Required information [The following information applies to the questions displayed below.] OFC Company of Kansas City prints business forms and other specialty paper products, such as writing paper, envelopes, note cards, and greeting cards. Its Business Services division offers inventory management services and desktop delivery on request. The division uses an activity-based costing (ABC) system. The budgeted usage of each activity cost driver and cost-driver rates for January 2019 for the Business Services division are: Activity Cost Driver Budgeted Activity...
A company wants to ship products from Jefferson City and Omaha to Des Moines, Kansas City...
A company wants to ship products from Jefferson City and Omaha to Des Moines, Kansas City or St. Louis. In the table below you see shipping costs and supply and demand amounts. How do you set this up in Excel through the Solver? Please show the steps. Thanks! From to Des Moines Kansas City St. Louis Supply Jefferson City 14 9 7 30 Omaha 8 10 5 20 Demand 25 15 10
The Specialty Steel Products Company produces items, such as machine tools, gears, automobile parts, and other...
The Specialty Steel Products Company produces items, such as machine tools, gears, automobile parts, and other specialty items, in small quantities to customer order. Because the products are so diverse, demand is measured in machine-hours. Orders for products are translated into required machine-hours, based on time standards for each operation. Management is concerned about capacity in the lathe department. Assemble the data necessary to analyze the addition of one more lathe machine and operator. Historical records indicate that lathe department...
Special-Order Decision, Qualitative Aspects Randy Stone, manager of Specialty Paper Products Company, was agonizing over an...
Special-Order Decision, Qualitative Aspects Randy Stone, manager of Specialty Paper Products Company, was agonizing over an offer for an order requesting 5,000 boxes of calendars. Specialty Paper Products was operating at 70% of its capacity and could use the extra business. Unfortunately, the order's offering price of $4.20 per box was below the cost to produce the calendars. The controller, Louis Barns, was opposed to taking a loss on the deal. However, the personnel manager, Yatika Blaine, argued in favor...
Janus Products, Inc. is a merchandising company that sells binders, paper, and other school supplies. The...
Janus Products, Inc. is a merchandising company that sells binders, paper, and other school supplies. The company is planning its cash needs for the third quarter. In the past, Janus Products has had to borrow money during the third quarter to support peak sales of back-to-school materials, which occur during August. The following information has been assembled to assist in preparing a cash budget for the quarter: a. Budgeted monthly absorption costing income statements for July to October are as...
Janus Products, Inc. is a merchandising company that sells binders, paper, and other school supplies. The...
Janus Products, Inc. is a merchandising company that sells binders, paper, and other school supplies. The company is planning its cash needs for the third quarter. In the past, Janus Products has had to borrow money during the third quarter to support peak sales of back-to-school materials, which occur during August. The following information has been assembled to assist in preparing a cash budget for the quarter: a. Budgeted monthly absorption costing income statements for July to October are as...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT