1. Create a new Excel sheet in which you will find the delivery cost for each delivery.a. Create a new sheet that has information for each delivery. Name this sheet "lookup."b. In this lookup sheet, look up the hourly rate for the driver for each delivery. Do not enter this information manually! Use the VLOOKUP function.c. For each delivery, calculate the delivery cost as hourly rate for the driver multiplied by time (hours).Fill in the table below for the first ten records.DateDelivery IDDriverTime (Hours)Hourly RateCost20.00 X1George11/125.00 X2Deanna1.51/223Ben1/34Caroline21/35Unknown11/46Elizabeth21/51/57Unknown2.58Unknown11/69Adam21/810Hannah1.51/92. Create a new Excel sheet that aggregates the data contained in the lookup sheet to show each driver's activity analysis.a. Create a pivot table in a new sheet; name this new sheet "pivot table."

Stepwise Details of how to set up this Excel sheet, including the VLOOKUP function and the pivot…

Answered: 1. Create a new Excel sheet in which…

FINANCIAL ACCOUNTING

10th Edition

ISBN:9781259964947

Author:Libby

Publisher:Libby

Chapter1: Financial Statements And Business Decisions

Section: Chapter Questions

Problem 1Q

See similar textbooks

Similar questions

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.
Hello Please provide the journal entry for I.
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.
Please help me with all answers thanku
Please help with question
Google has many types of costs. What is an out-of-pocket cost? What is an opportunity cost? Are opportunity costs recorded in the accounting records?
PLEASE ANSWER THIS WITH 5 paragraphs. Write it as if you're a memo. Concepts of Relevant cost.
see enclosed jpeg please. Explain as clear as possible how you come to the solution.
Silven Company has identified the following overhead activities, costs, and activity drivers for the coming year: Activity Expected Cost Activity Driver Activity Capacity Setting up equipment $138,000 Number of setups 120 Ordering materials 21,600 Number of orders 1,200 Machining 107,100 Machine hours 11,900 Receiving 16,740 Receiving hours 930 Silven produces two models of cell phones with the following expected activity demands: Model X 4,600 80 400 Units completed Number of setups Number of orders Machine hours Receiving hours Required: 6,800 310 Model X Model Y Model Y 9,200 40 800 5,100 620 1. Determine the total overhead assigned to each product using the four activity drivers. Total Overhead Assigned
Please see the picture below. I need help with the items that are shown in the red boxes. The other items came back as being the correct answers.
es Required information [The following information applies to the questions displayed below.] Bunnell Corporation is a manufacturer that uses job-order costing. On January 1, the company's inventory balances were as follows: Raw materials Work in process Finished goods $ 50,000 $ 30,800 $ 43,200 The company applies overhead cost to jobs on the basis of direct labor-hours. For the current year, the company's predetermined overhead rate of $12.00 per direct labor-hour was based on a cost formula that estimated $480,000 of total manufacturing overhead for an estimated activity level of 40,000 direct labor-hours. The following transactions were recorded for the year: a. Raw materials were purchased on account, $696,000. b. Raw materials used in production, $655,400. All of of the raw materials were used as direct materials. c. The following costs were accrued for employee services: direct labor, $430,000, indirect labor, $150,000; selling and administrative salaries, $251,000. d. Incurred…
please answer within the format by providing formula the detailed workingPlease provide answer in text (Without image)Please provide answer in text (Without image)Please provide answer in text (Without image)

SEE MORE QUESTIONS

Recommended textbooks for you

FINANCIAL ACCOUNTING

Accounting

ISBN:

9781259964947

Author:

Libby

Publisher:

MCG

Accounting

ISBN:

9781337272094

Author:

WARREN, Carl S., Reeve, James M., Duchac, Jonathan E.

Publisher:

Cengage Learning,

Accounting Information Systems

Accounting

ISBN:

9781337619202

Author:

Hall, James A.

Publisher:

Cengage Learning,

FINANCIAL ACCOUNTING

Accounting

ISBN:

9781259964947

Author:

Libby

Publisher:

MCG

Accounting

ISBN:

9781337272094

Author:

WARREN, Carl S., Reeve, James M., Duchac, Jonathan E.

Publisher:

Cengage Learning,

Accounting Information Systems

Accounting

ISBN:

9781337619202

Author:

Hall, James A.

Publisher:

Cengage Learning,

Horngren's Cost Accounting: A Managerial Emphasis…

Accounting

ISBN:

9780134475585

Author:

Srikant M. Datar, Madhav V. Rajan

Publisher:

PEARSON

Intermediate Accounting

Accounting

ISBN:

9781259722660

Author:

J. David Spiceland, Mark W. Nelson, Wayne M Thomas

Publisher:

McGraw-Hill Education

Financial and Managerial Accounting

Accounting

ISBN:

9781259726705

Author:

John J Wild, Ken W. Shaw, Barbara Chiappetta Fundamental Accounting Principles

Publisher:

McGraw-Hill Education

SEE MORE TEXTBOOKS