Question: Answer the following where the X's Indicates. Using the data provided in the following excel sheet, extrapolate the correct answers for each Cell indicated with

Answer the following where the X's Indicates.

Using the data provided in the following excel sheet, extrapolate the correct answers for each Cell indicated with an X that corresponds with the column and row it is contained within.

Answer the following where the X's Indicates. Using the data provided in

H N P Practice 5 2 3 One Way Pricing and Adjustments 4 5 Activity-based cost per unit of activity 6 Revenue per unit of activity (operating ratio 80%) 7 Activity Based Costs Suggested Price Per mile Per load Per hour Per load Per mile $1.75 $40.00 $15.00 Final rate Per mile 8 956 Loaded Miles Empty miles ( Utilization allowed is 10%) Actual utilization Applied revenue 1 X 9 Baseline cost-plus pricing 10 Based on length of Haul 11 12 13 14 15 Adjustments To Empty 16 Miles Expectations 17 18 19 20 Cylce time Adjustments 6% Actual empty miles % Actual empty miles Difference from allowed Adjustment to revenue X Hours per load Total Dock Time (Del & PU) Transit time @45 mph Total adjusted hours Applied revenue In contrac Actual Adjustment - 2.2 1.8 x 24 X 27 Special customer Service 28 Adjustments Adjustments Insurance requirements Trailer requirements Other special requirements Total Revenue adjustments Per mile Per load Total $0.08 $24.00 x $16.00 X 29 30 31 x x H N P Practice 5 2 3 One Way Pricing and Adjustments 4 5 Activity-based cost per unit of activity 6 Revenue per unit of activity (operating ratio 80%) 7 Activity Based Costs Suggested Price Per mile Per load Per hour Per load Per mile $1.75 $40.00 $15.00 Final rate Per mile 8 956 Loaded Miles Empty miles ( Utilization allowed is 10%) Actual utilization Applied revenue 1 X 9 Baseline cost-plus pricing 10 Based on length of Haul 11 12 13 14 15 Adjustments To Empty 16 Miles Expectations 17 18 19 20 Cylce time Adjustments 6% Actual empty miles % Actual empty miles Difference from allowed Adjustment to revenue X Hours per load Total Dock Time (Del & PU) Transit time @45 mph Total adjusted hours Applied revenue In contrac Actual Adjustment - 2.2 1.8 x 24 X 27 Special customer Service 28 Adjustments Adjustments Insurance requirements Trailer requirements Other special requirements Total Revenue adjustments Per mile Per load Total $0.08 $24.00 x $16.00 X 29 30 31 x x

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related Accounting Questions!

help me answer q1, 2, 3, 4, 5 the audit of Alpine Cupcakes, Inc. tasks Audit Case Assignments ng standards ble Introduction: Data Analytics Module e accounts In the Data Analytics Module, instead of...

The case discusses the dilemma of the CFO of PSUWC Energy LLC, an energy generating firm, who needs to present his recommendation to the company Board regarding a proposed investment in a new...

Hi, I need to understand how this is worked out, not just the answer. Thank you! Common-Size Financial Statement Analysis Using Excel Completing this activity will help you learn to: 1. create Excel...

1. Prepare a written analysis of the financial ratios of the company Walmart.. This must include trend analysis (historical and projected) and comparative analysis (cross-sectional or industry). The...

please help with the excel formulas and answers for the blue highlighted columns. instrustions attached Cost of Ingredients for Menu Options O Menu bibe Avec Medium Avenes Price La Y Y Cather Mains...

Having difficulty with this lab :/ any kind of help would be useful and very much appreciated! Learning Objectives: Deeper understanding about the costs associated with an Ordering policy (i.e. an...

Estimates regarding payments obtained from the credit department are as follows: collected within the month of sale, 10%; collected the month following the sale, 75%; collected the second month...

hello can someone please review this and tell me if everything is correct, I am not getting the same answer as my team and want to know what I am doing wrong. Also can you please fix my calculation...

I need a step by step solutions for the 10 problems in the excel file. The correct answers are provided I only need the solutions steps. Subject is Finance (options valuation) On March 2, a Treasury...

Practical Completion Point 3 - Computerised Section For this final part of the practical assignment you will be using the same information as for Practical Completion Point 1 with a couple of extra...

A particle initially at the origin in an inertial frame S, has a constant velocity Vi. Frame S' is rotating about the z-axis with angular velocity (anticlockwise). The coordinate axes of S' coincide...

The editor of a textbook publishing company is trying to decide whether to publish a proposed business statistics textbook. Information on previous textbooks published indicates that 10% are huge...

De Bondt and Thaler ( 1 9 9 0 ) argue that the P / E effect can be explained by

Write a function named(Count_elements), that accepts a one-dimensional array and its size, returns how many elements of the array divisiblel ) by 3 and by 2. e.g. the array is...