Question

In: Accounting

[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 Storage Cartons in inventory 400,000 $ 0.4925 /carton/month Requisition handling Requisitions 30,000 12.50 Pick packing Lines 800,000 1.50 Data entry Lines 800,000 0.80 Requisitions 30,000 1.20 Desktop delivery Per delivery 12,000 30.00 For the month, the division expects to make 11,700 deliveries to deliver 1,170,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

Step 1

Requirement 1

Storage

Batch Level

Pick packing

Unit-Level

Data entry—Lines

Unit-Level

Requisition handling

Batch Level

Data entry—Requisitions

Batch Level

Desktop delivery

Batch Level

Step 2:

Requirement 2

Activity Cost reduction rate per month January February March
Storage 2% 0.4925 0.4827 0.4730
Requisition- Handling 2% 12.5 12.25 12.005
Pick packing 1% 1.5 1.485 1.47015
Data entry- Line 1% 0.8 0.792 0.7841
Data entry- Requisition 2% 1.2 1.176 1.15248
Desktop delivery 2% 30 29.4 28.812

Step 3:

Budget costs

Activity Activity volume February March
Storage 400000 193080 189200
Requisition handling 30000 367500 360150
Pick packing

800000

1188000 1176120
Data entry-line 800000 633600 627280
Data entry- requisition 30000 35280 34574
Desktop delivery 12000 352800 345744
Divisional total

$2770260

$2733068


Related Solutions

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...
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...
he following information applies to the questions displayed below.] The accounts and balances for Paw Prints...
he following information applies to the questions displayed below.] The accounts and balances for Paw Prints Pet Sitters on November 1 are provided below. Cash 19,850 Fees Income -0- Accounts Receivable 890 Rent Expense -0- Office Equipment 2,900 Utilities Expense -0- Supplies 290 Salaries Expense -0- Accounts Payable 1,900 Kelly Connor, Capital 22,030 Kelly Connor, Drawing -0- The following transactions occurred during the month of November. Collected $390 from credit customers. Issued a check for $720 for November's rent. Paid...
[The following information applies to the questions displayed below.] At the beginning of July, CD City...
[The following information applies to the questions displayed below.] At the beginning of July, CD City has a balance in the inventory of $2,600. The following transactions occur during the month of July. July 3 Purchase CDs on account from Wholesale Music for $1,500, terms 1/10, n/30. July 4 Pay cash for freight charges related to the July 3 purchase from Wholesale Music, $110. July 9 Return incorrectly ordered CDs to Wholesale Music and receive credit, $200. July 11 Pay...
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.] The following information pertains to Mason Company...
[The following information applies to the questions displayed below.] The following information pertains to Mason Company for 2016: Beginning inventory 144 units @ $ 44 Units purchased 414 units @ $ 66 Ending inventory consisted of 56 units. Mason sold 502 units at $132 each. All purchases and sales were made with cash. Operating expenses amounted to $3,900. 3.value: 3.00 pointsRequired information Required a. Compute the gross margin for Mason Company using the following cost flow assumptions: (1) FIFO, (2)...
[The following information applies to the questions displayed below.] The following information pertains to Baxter Company...
[The following information applies to the questions displayed below.] The following information pertains to Baxter Company for 2014. Beginning inventory 70 units @ $15 Units purchased 310 units @ $18 Ending inventory consisted of 27 units. Baxter sold 353 units at $34 each. All purchases and sales were made with cash. 5. value: 0.40 points Required information Required a. Compute the gross margin for Baxter Company using the following cost flow assumptions: (1) FIFO, (2) LIFO, and (3) weighted average....
[The following information applies to the questions displayed below.] The following are the transactions for the...
[The following information applies to the questions displayed below.] The following are the transactions for the month of July. Units Unit Cost Unit Selling Price July 1 Beginning Inventory 59 $10 July 13 Purchase 295 13 July 25 Sold (100) $15 July 31 Ending Inventory 254 M7-7 Calculating Cost of Goods Available for Sale, Ending Inventory, Sales, Cost of Goods Sold, and Gross Profit under Periodic FIFO [LO 7-3] a. Calculate cost of goods available for sale and ending inventory,...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT