Question

In: Accounting

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 handling Requisitions 64,000 12.50
Pick packing Lines 885,000 1.68
Data entry Lines 885,000 0.95
Requisitions 47,000 1.22
Desktop delivery Per delivery 20,500 37.00

For the month, the division expects to make 11,600 deliveries to deliver 1,160,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

1. Unit Level Activities : Desktop Delivery

Storage Cost

Batch Level Activities : Pick Packing

Data Entry

   Requisition Handling

2.

OFC COMPANY

Total Budgeted Costs ( February )

Activity Cost Driver Budgeted Activity Cost
Storage Cartons in inventory 698,320 $ 0.6020 /carton/month
Requisition handling Requisitions 784,000 12.25
Pick packing Lines 1,451,400 1.64
Data entry Lines 823,050 0.93
Requisitions 56,400 1.20
Desktop delivery Per delivery 424,908 36.63

Total Budgeted Cost 4,238,078

TOTAL BUDGETED COST ( MARCH )

Activity Cost Driver Budgeted Activity Cost
Storage Cartons in inventory 698,320 $ 0.6020 /carton/month
Requisition handling Requisitions 768,000 12
Pick packing Lines 1,416,000 1.6
Data entry Lines 805,350 0.91
Requisitions 55,460 1.18
Desktop delivery Per delivery 419,920 36.2

TOTAL BUDGETED COST 4,163,050


Related Solutions

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...
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 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...
[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 city of Kansas City establishes a delivery truck that provides service to other departments, all...
The city of Kansas City establishes a delivery truck that provides service to other departments, all of which are accounted for in its general fund. During its first year of operations the shop engages in the following transactions: It purchases equipment at a cost of $50 million and issues long-term notes for the purchase price. The useful life of the equipment is eight years, with no residual value. It purchases supplies at a cost of $8 million. Of these it...
A company has three factories in Chicago, Kansas City, and Houston where it produces its products...
A company has three factories in Chicago, Kansas City, and Houston where it produces its products and from where it can weekly supply its three distribution centers located in New York, Los Angeles, and Atlanta. The supply capacities at the three factories, the demand requirements at each of the three distribution centers, and the transportation costs in $ per ton from each factory to each distribution center are shown in the table below. Formulate a linear programming (LP) model of...
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...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT