Trend Reporting for Non-Value Added Costs 19 64 Cicleta Manufacturing has four activities: receiving materials, assembly, expediting products, and storing goods. Receiving and assembly are necessary activities; expediting and storing goods are unnecessary. The following data pertain to the four activities for the year ending 20x1 (actual price per unit of the activity driver is assumed to be equal to the standard price): Activity Activity Driver SQ AQ SP Receiving Receiving orders 15,200 25,500 $27 Assembly Labor hours 105,000 127,500 Expediting Orders expedited 0 8,500 Storing Number of units 0 17,000 Assume that at the beginning of 20x2, Cicleta trained the assembly workers in a new approach that had the objective of increasing the efficiency of the assembly process. Cicleta also began moving toward a JIT purchasing and manufacturing system. When IT is fully implemented, the demand for expediting is expected to be virtually eliminated. It is expected to take two to three years for full implementation. Assume that receiving cost is a step-fixed cost with steps of 1,900 orders. The other three activities employ resources that are acquired as used and needed. At the end of 20x2, the following results were reported for the four activities: 9 AQ SP SQ 5,600 125,000 $9 Activity Driver Receiving orders Labor hours Orders expedited Number of units Activity Receiving Assembly Expediting Storing Required: 7 5,600 128,000 5,000 10,000 0 22 0 3 Prepare a trend report that shows the non-value-added costs for each activity for 20x1 and 20x2 and the change in costs for the two periods. Enter all decreases as positive amounts and all increases as negative amounts. i.e. if 20x1 was 150,000 and 20x2 was 250,000 that would be an increase and would need to be entered as a negative amount. If an amount is zero, enter "0". Cicleta Manufacturing Trend Report: Non-Value Added Costs For the Years 20x1 and 20x2 Activity 20x1 20x2 Change Receiving $ Assembly Expediting Storing Total