Convert the accompanying database to an Excel table to​ find:   a.The total cost of all orders. b.Thetotal quantity of airframe fasteners purchased. c. The total cost of all orders placed with Manley Valve. Question content area bottom Part 1 a. The total cost of all orders is ​$?????? enter your response here.

Chapter 1: Applying Excel: Excel Worksheet (Part 1 of 2)   Download the Applying Excel form and enter formulas in all cells that contain question marks.   For example, in cell C18 enter the formula "= B6".   After entering formulas in all of the cells that contained question marks, verify that the dollar amounts in both the traditional and contribution format income statements match the numbers in Exhibit 1-7.   Check your worksheet by changing the variable selling cost in the Data area to $900, keeping all of the other data the same as in Exhibit 1-7. If your worksheet is operating properly, the net operating income under the traditional format income statement and under the contribution format income statement should now be $700 and the contribution margin should now be $4,700. If you do not get these answers, find the errors in your worksheet and correct them.   Save your completed Applying Excel form to your computer and then upload it here by clicking “Browse.” Next, click…

Can you please show me how to workout this problem

not use ai please

Please help me with b2, c1, and c2. Thanks!

Below is a list of costs. Please identify each cost as either a product or period cost. Dragged and dropped options on the right-hand side will be automatically saved. For keyboard navigation... SHOW MORE ✓ Depreciation on office copier Depreciation on office building Insurance on office building Metal used in building a car Salary of CEO Salary of production manager Salary of assembly line workers Utilities of office building = = Product Period = Period = Period = Product = Product = = Period Period

Do not give image format

Required information [The following information applies to the questions displayed below.] The following data is provided for Garcon Company and Pepper Company for the year ended December 31. Finished goods inventory, beginning Work in process inventory, beginning. Raw materials inventory, beginning Rental cost on factory equipment Direct labor Finished goods inventory, ending Work in process inventory, ending Raw materials inventory, ending Factory utilities General and administrative expenses. Indirect labor Repairs-Factory equipment Raw materials purchases Selling expenses Sales Cash Accounts receivable, net Garcon Company $ 12,700 18,800 8,900 27,500 21,600 20,150 23,800 7,600 11,400 24,500 14,200 7,700 43,500 53,200 294,720 30,000 15,200 Pepper Company $ 19,750 22,350 14,700 23,500 44,200 14,100 18,400 9,600 16,250 52,000 13,120 3,700 58,000 54,700 391,1801 24,200 20,700 1. Compute the total prime costs for both Garcon Company and Pepper Company. 2. Compute the total conversion…

Check image file for question Q1a. Allocate the service department costs to the two operating departments using the direct method. b.Allocate the service department cost to the two operating departments using ,I)the step-down method (Allocate administrative service first) . ii)the step down method (Allocoate Maintenance service first) c. Assuming you are the manager of the Daily Patient department.Discuss which method of cost allocation would you prefer.Justify your decision d.Mr Smith the financial controller of LabAid is convinced that the step-down method allocates more costs to the operating departments than the direct method.Do you agree with ,Mr Smith.Explain.

Please don't give image format