Question

In: Accounting

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 Cost-Driver Rate
Storage Cartons in inventory 550,000 $ 0.5120 /carton/month
Requisition handling Requisitions 60,000 12.50
Pick packing Lines 875,000 1.70
Data entry Lines 875,000 0.80
Requisitions 45,000 1.26
Desktop delivery Per delivery 19,500 44.00

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

1

Storage
Pick packing
Data entry—Lines
Requisition handling
Data entry—Requisitions
Desktop delivery   

2

Budgeted Costs
Activity February March
Storage
Requisition handling
Pick packing
Data entry—Lines
Data entry—Requisitions
Desktop delivery
Divisional totals

Solutions

Expert Solution

Storage Unit-level activities
Pick packing Batch-level activities
Data entry—Lines Batch-level activities
Requisition handling Batch-level activities
Data entry—Requisitions Batch-level activities
Desktop delivery Unit-level activities
2.
Activity Cost driver Budgeted Activity Cost driver rate Budgeted Cost-Jan19 Budgeted Cost-Feb19 Budgeted Cost Mar19
Storage Cartons in inventory 550,000 $               0.5120 $             281,600 $     281,600 $     281,600
Requisitions handling Requisitions 60,000 $ 12.50 $ 750,000 $ 735,000 $ 720,300
Pick Packing Lines 875,000 $                    1.70 $         1,487,500 $ 1,457,750 $ 1,428,595
Data Entry Lines 875,000 $                    0.80 $ 700,000 $ 686,000 $ 672,280
Data Entry requisitions Requisitions 45,000 $                    1.26 $ 56,700 $ 55,566 $ 54,454.68
Desktop Delivery Per Delivery 19,500 $ 44.00 $ 858,000 $ 849,420 $ 840,925.8
Total $         4,133,800 $ 4,065,336 $ 3,998,155.48

Related Solutions

[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.] The City of Lynnwood was...
Required information [The following information applies to the questions displayed below.] The City of Lynnwood was recently incorporated and had the following transactions for the fiscal year ended December 31. The city council adopted a General Fund budget for the fiscal year. Revenues were estimated at $2,100,000 and appropriations were $2,000,000. Property taxes in the amount of $2,040,000 were levied. It is estimated that $14,000 of the taxes levied will be uncollectible. A General Fund transfer of $30,000 in cash...
Required information [The following information applies to the questions displayed below.]    Laker Company reported the...
Required information [The following information applies to the questions displayed below.]    Laker Company reported the following January purchases and sales data for its only product.    Date Activities Units Acquired at Cost Units sold at Retail Jan. 1 Beginning inventory 185 units @ $ 11.00 = $ 2,035 Jan. 10 Sales 145 units @ $ 20.00 Jan. 20 Purchase 100 units @ $ 10.00 = 1,000 Jan. 25 Sales 125 units @ $ 20.00 Jan. 30 Purchase 270 units...
Required information [The following information applies to the questions displayed below.]    Laker Company reported the...
Required information [The following information applies to the questions displayed below.]    Laker Company reported the following January purchases and sales data for its only product.    Date Activities Units Acquired at Cost Units sold at Retail Jan. 1 Beginning inventory 235 units @ $ 16.00 = $ 3,760 Jan. 10 Sales 200 units @ $ 25.00 Jan. 20 Purchase 180 units @ $ 15.00 = 2,700 Jan. 25 Sales 190 units @ $ 25.00 Jan. 30 Purchase 390 units...
Required information [The following information applies to the questions displayed below.]    Warnerwoods Company uses a...
Required information [The following information applies to the questions displayed below.]    Warnerwoods Company uses a perpetual inventory system. It entered into the following purchases and sales transactions for March.    Date Activities Units Acquired at Cost Units Sold at Retail Mar. 1 Beginning inventory 100 units @ $50.00 per unit Mar. 5 Purchase 400 units @ $55.00 per unit Mar. 9 Sales 420 units @ $85.00 per unit Mar. 18 Purchase 120 units @ $60.00 per unit Mar. 25...
Required information [The following information applies to the questions displayed below.] Cascade Company was started on...
Required information [The following information applies to the questions displayed below.] Cascade Company was started on January 1, Year 1, when it acquired $164,000 cash from the owners. During Year 1, the company earned cash revenues of $94,300 and incurred cash expenses of $69,500. The company also paid cash distributions of $9,500. Required Prepare a Year 1 income statement, capital statement (statement of changes in equity), balance sheet, and statement of cash flows under each of the following assumptions. (Consider...
Required information [The following information applies to the questions displayed below.] Rooney Company is a retail...
Required information [The following information applies to the questions displayed below.] Rooney Company is a retail company that specializes in selling outdoor camping equipment. The company is considering opening a new store on October 1, year 1. The company president formed a planning committee to prepare a master budget for the first three months of operation. As budget coordinator, you have been assigned the following tasks. Required October sales are estimated to be $240,000, of which 40 percent will be...
Required information [The following information applies to the questions displayed below.] Cascade Company was started on...
Required information [The following information applies to the questions displayed below.] Cascade Company was started on January 1, Year 1, when it acquired $168,000 cash from the owners. During Year 1, the company earned cash revenues of $96,300 and incurred cash expenses of $61,800. The company also paid cash distributions of $12,000. Required Prepare a Year 1 income statement, capital statement (statement of changes in equity), balance sheet, and statement of cash flows under each of the following assumptions. (Consider...
Required information [The following information applies to the questions displayed below.] Cascade Company was started on...
Required information [The following information applies to the questions displayed below.] Cascade Company was started on January 1, Year 1, when it acquired $168,000 cash from the owners. During Year 1, the company earned cash revenues of $96,300 and incurred cash expenses of $61,800. The company also paid cash distributions of $12,000. Required Prepare a Year 1 income statement, capital statement (statement of changes in equity), balance sheet, and statement of cash flows under each of the following assumptions. (Consider...
Required information [The following information applies to the questions displayed below.]    Laker Company reported the...
Required information [The following information applies to the questions displayed below.]    Laker Company reported the following January purchases and sales data for its only product.    Date Activities Units Acquired at Cost Units sold at Retail Jan. 1 Beginning inventory 175 units @ $ 10.00 = $ 1,750 Jan. 10 Sales 135 units @ $ 19.00 Jan. 20 Purchase 130 units @ $ 9.00 = 1,170 Jan. 25 Sales 140 units @ $ 19.00 Jan. 30 Purchase 275 units...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT