Please show work in Excel :)

Cost Accounting Chapter 4 Test Activity Based Costing Please use Microsoft Excel to prepare your answers to the following problems. Please put both problem in the same file on separate sheets and upload to the dropbox in D2L Be sure to put your name at the top of each page. Problem 1 (25 points) The True manufactures wooden cases for a variety of clients. As production manager you have developed the following value chart: Operation Average Number of Days Receiving materials Storing materials Handling materials Cutting measuring materials Assembling materials Building cases Attaching hinges Inspection a. Determine the value-added activities and their total time, (Show your work b. Determine the non-value-added activities and their total time. (Show your work!) c. Calculate the manufacturing cycle efficiency. (Show your work Problem 2: (40 points) Delano Incorporated would like to institute an activity-based costing system to price products The company's Purchasing Department incurs costs of S620.000 per year and has 10 employees. Purchasing has detemined the three major activities that occur during the year Allocation of People Total Activity Involved in OS