Answered step by step
Verified Expert Solution
Link Copied!

Question

...
1 Approved Answer

2 questions with 4 pictures attatched Required information [The following information applies to the questions displayed below. ] OFC Company of Kansas City prints business

2 questions with 4 pictures attatched

image text in transcribedimage text in transcribedimage text in transcribedimage text in transcribed 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: Budgeted Activity Cost Driver Activity Storage Cartons in inventory 458,866 Requisition handling Requisitions 49,666 Pick packing Lines 825,660 Data entry Lines 825,666 Requisitions 35,066 Desktop delivery Per delivery 14,566 CostDriver Rate $ 9'6729 [carton/month 23.59 1.58 6.81 1.37 44.99 l For the month, the division expects to make 10,400 deliveries to deliver 1,040,000 cartons to customers. 3C Company has decided to implement a kaizen (continuous-improvement) program to enhance operational efciency. After a reful study, management and employees agree that the rm will be able to reduce cost rates for batch-level activities by 2% and itlevel activities (other than Storage) by 1% per month during the rst year of the program starting February 2019. The firm has >cided to delay the implementation of the program for customer-sustaining and facility-level activities until 2020. The firm expects 3 amount of cost-driver usage in each of the next two months to be the same as those in January. lquired: dentify unit-level and batch-level activities. What are the total budgeted costs for each activity and for the division as a whole in February and March? Complete this question by entering your answers in the tabs below. Required 1 Required 2 identify unit-level and batch-level activities. ick packing ata entryLines equisition handling ata entryRequisitions eskiop delivery Required 2 ) Activity Storage Requisition handling Pick packing Data entry Desktop delivery Budgeted Cost Driver Activity Cartons in inventory 456, 699 Requisitions 46, 606 line 5 825 , 666 Lines 825, 698 Requisitions 35,999 Per delivery 14, 586 OFC Company of Kansas City prints business forms and other specialty paper products, such as writing paper, envelopes, note cards, and greeting cards. lts 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: Cost-Driver Rate $ 9.6726 [carton/month 23.58 1.58 6.81 1.37 44.96 For the month, the division expects to make 10,400 deliveries to deliver 1,040,000 cartons to customers. OFC Company has decided to implement a kaizen (continuous-improvement) program to enhance operational efciency. After a careful study, management and employees agree that the rm will be able to reduce cost rates for batch-level activities by 2% and unitlevel activities (other than Storage) by 1% per month during the rst 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 rm 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 batchlevel activities. 2. What are the total budgeted costs for each activity and for the division as a whole in February and March? Complete this question by entering your answers in the tabs below. Required 1 Required 2 What are the total budgeted costs for each activity and for the division as a whole in February and March? (Do not round intermediate calculations.) Storage Requisition handiing Pick packing Data entryLines Data entryRequisitions Desktop delivery Divisional totals You are given the following budgeted and actual data for the Grey Company for each of the months January through June of the current year. In December of the prior year, sales were forecasted as follows: January, 100 units; February, 95 units; March, 102 units; April, 107 units; May, 114 units; June, 122 units. In January of the current year, sales for the months February through June were reforecasted as follows: February, 90 units; March, 102 units; April, 102 units; May, 104 units; June, 117 units. In February of the current year, sales for the months March through June were reforecasted as follows: March, 97 units; April, 102 units; May, 99 units; June, 117 units. In March of the current year, sales for the months April through June were reforecasted as follows: April, 102 units; May, 94 units; June, 107 units. In April of the current year, sales for the months May and June were reforecasted as follows: May, 84 units; June, 102 units. In May of the current year, sales for June were reforecasted as 102 units. Actual sales for the six-month period, January through June, were as follows: January, 96 units; February, 90 units; March, 105 units; April, 103 units; May, 120 units; June, 118 units. Required: 1. Prepare a schedule of forecasted sales, on a rolling basis, for the months January through June, inclusive. (Hint: There will be only one forecasted number for January-this is the forecast done in December. For February, there will be two forecasts: one done in December and a second done in January. For June, there will be six forecasts, one done in each of the preceding six months.) 2. For each of the months March through June, determine the 3-month forecast error rate, defined as 1 minus the absolute percentage error. For example, the forecast error rate for March's sales is found by dividing the absolute value of the forecast error for this month by the actual sales volume for the month. The forecast error for any month (e.g., March) is defined as the difference between the actual sales volume for the month and the sales volume for that month forecasted 3 months earlier (e.g., December). Also, indicate for each month whether the actual sales volume was above or below the forecasted volume generated three months earlier. Complete this question by entering your answers in the tabs below. Required 1 Required 2 Prepare a schedule of forecasted sales, on a rolling basis, for the months January through June, inclusive. (Hint: There will be only one forecasted number for January-this is the forecast done in December. For February, there will be two forecasts: one done in December and a second done in January. For June, there will be six forecasts, one done in each of the preceding six months.) Month of Forecast for Month of Forecast January February March April May June December January February March April May 4 You are given the following budgeted and actual data for the Grey Company for each of the months January through June of the current year. In December of the prior year, sales were forecasted as follows: January, 100 units; February, 95 units; March, 102 units; April, 107 units; May, 114 units; June, 122 units. In January of the current year, sales for the months February through June were reforecasted as follows: February, 90 units; March, 102 units; April, 102 units; May, 104 units; June, 117 units. In February of the current year, sales for the months March through June were reforecasted as follows: March, 97 units; April, 102 units; May, 99 units; June, 117 units. In March of the current year, sales for the months April through June were reforecasted as follows: April, 102 units; May, 94 units; June, 107 units. In April of the current year, sales for the months May and June were reforecasted as follows: May, 84 units; June, 102 units. In May of the current year, sales for June were reforecasted as 102 units. Actual sales for the six-month period, January through June, were as follows: January, 96 units; February, 90 units; March, 105 units; April, 103 units; May, 120 units; June, 118 units. Required: 1. Prepare a schedule of forecasted sales, on a rolling basis, for the months January through June, inclusive. (Hint: There will be only one forecasted number for January-this is the forecast done in December. For February, there will be two forecasts: one done in December and a second done in January. For June, there will be six forecasts, one done in each of the preceding six months.) 2. For each of the months March through June, determine the 3-month forecast error rate, defined as 1 minus the absolute percentage error. For example, the forecast error rate for March's sales is found by dividing the absolute value of the forecast error for this month by the actual sales volume for the month. The forecast error for any month (e.g., March) is defined as the difference between the actual sales volume for the month and the sales volume for that month forecasted 3 months earlier (e.g., December). Also, indicate for each month whether the actual sales volume was above or below the forecasted volume generated three months earlier. Complete this question by entering your answers in the tabs below. Required 1 Required 2 For each of the months March through June, determine the 3-month forecast error rate, defined as 1 minus the absolute percentage error. For example, the forecast error rate for March's sales is found by dividing the absolute value of the forecast error for this month by the actual sales volume for the month. The forecast error for any month (e.g., March) is defined as the difference between the actual sales volume for the month and the sales volume for that month forecasted 3 months earlier (e.g., December). Also, indicate for each month whether the actual sales volume was above or below the forecasted volume generated three months earlier. (Round "Forecast error rate" answers to 2 decimal places. For example, 23.423% = 23.42%.) : Show less A: January February March April May June Actual sales Forecast error rate % Direction of error

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access with AI-Powered Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Edexcel AS And A Level Mathematics Pure Mathematics Year 1/AS

Authors: Greg Attwood

1st Edition

9781292183398

Students also viewed these Accounting questions