Question

In: Accounting

What is the formula I would insert into Excel Copy the "Donation List" worksheet to a...

What is the formula I would insert into Excel

Copy the "Donation List" worksheet to a new worksheet. Rename new worksheet "Delivery Charges" and place it to the right of "Donation List". Convert the relevant range into a table. Name the table Delivery.
Insert a new field to the right of Price. Name the field Delivery Charges and using structured references calculate delivery charge at a certain percentage of Price for items that need to be delivered. The percentage is indicated at the top of the worksheet. Enter 2.5% in cell B1.
Academy 6000 Southwest Freeway (555) 399-2341 Sports $75.00 Soccer Equipment 45 Delivery $125 Home Pickup
Ali's Hair Stylist 1825 May Avenue (555) 242-2530 Spa $50.00 Shampoo, Conditioner, Spray 36 Pickup $45 Home Delivery
Ali's Hair Stylist 1825 May Avenue (555) 242-2530 Spa $50.00 GC 125 Pickup $55 Sports Pickup
Ali's Hair Stylist 1825 May Avenue (555) 242-2530 Spa $50.00 GC 125 Pickup $55 Sports Delivery
Avalon Burgers 421 Montrose Blvd (555) 578-7800 Dining $40.00 GC 5 Pickup $40 Spa Pickup
Barry's Goldwater 2216 S. Oklahoma Street (555) 321-2311 Dining $100.00 GC 65 Pickup $95 Spa Delivery
Barry's Goldwater 2216 S. Oklahoma Street (555) 321-2311 Dining $100.00 GC 65 Pickup $95 Kids Pickup
Bounce Play Area 3509 Bounce Circle (555) 980-9808 Kids $25.00 GC 18 Pickup $30 Kids Delivery
Brother's Burgers 1100 Choctaw Lane (555) 298-3322 Dining $40.00 GC 18 Pickup $40 Vacation Pickup

Solutions

Expert Solution

I have created a sample copy of the worksheet using the data provided in the question by you. You can refer to that for better understanding.
While pasting the data, and the inserts a table for the data, I have not named all the column, as that has not been mentioned in the question.

I have only named the price column, as I assume it to be the header of that column (column E), based on my inference from the question.

The Delivery charges rate value has been written in B1 cell, as stated by the question.

The delivery charges column has been inserted next to the price column, and has been highlighted in orange (column F).

The excel formula for calculating delivery charges (i.e. column F) has been mentioned in cell F1 and highlighted in orange.

Note : The formula for the cell is $B$1 * [@Price].

However, in case the name of the column which I have labelled as 'Price' is something else, like 'Price Rate' for example. then the formula would be changed to $B$1 * [@[Price Rate]]

Also please remeber that structured referencing first would require you to insert a table for the entire dataset that is the subject in the question.


Related Solutions

Copy the table to Excel then for each part using Excel formula to do the questions...
Copy the table to Excel then for each part using Excel formula to do the questions below and make sure to apply DCOVA, which stands for Define, Collect, Organize, Visualize, and Analyze. 1. Find the mean and standard deviation, 2. What did you observe and what that means in term of Cholesterol levels for a patient. 3. Find the five-number summary ( Minimum, Q1, Q2, Q3, and Maximum) 4. Interpret your result in term of cholesterol level 5. Find interquartile...
How would you calculate this with an excel formula on excel: •What is the future value...
How would you calculate this with an excel formula on excel: •What is the future value of the following cash flows if the discount rate is 8%? What is the future value if the discount rate is 5%? (this is asking you take the future value of the cash flows. Please find the future value at year 4. ))
Everywhere there is a "?", I need a formula and the answer. Variance Analysis Insert a...
Everywhere there is a "?", I need a formula and the answer. Variance Analysis Insert a formula into each cell marked with a "?". For the variances indicate whether they are favorable or unfavorable Bradley Company produces a garden statue which requires the following variable manufacturing costs: Std Qty Std Price/Rate Direct material (mix) 6 lbs 0.06 per lb Direct labor 1 hours $16 per hour Variable O/H (based on direct labor hours) 1 hours $8.30 per hour Standard Cost...
EXCEL: In cell I4 insert formula(s) that will calculate the sum of Sales where COGS is...
EXCEL: In cell I4 insert formula(s) that will calculate the sum of Sales where COGS is greater than or equal to its average. Date Product Region SalesRep Customer Sales COGS Sum of Sales: 4/19/2020 Product3 Region3 SalesRep2 Customer16 $           14,046 $             5,337 4/19/2020 Product7 Region4 SalesRep15 Customer72 $             2,504 $             1,703 4/19/2020 Product2 Region4 SalesRep18 Customer71 $             1,505 $                 843 4/19/2020 Product6 Region4 SalesRep14 Customer88 $             4,232 $             2,793 4/19/2020 Product3 Region4 SalesRep3 Customer65 $             5,947 $             3,390 4/19/2020 Product1...
I am very lost on this. If there is an Excel formula I could use, that...
I am very lost on this. If there is an Excel formula I could use, that would help tremendously. Thank you... Create confidence intervals related to the interval and ratio-level data you collected. 1. What is the best estimate of the population mean 2. Develop a 95% confidence interval for the population mean. Develop a 90% confidence interval for the population mean. Develop a 98% confidence interval for the population mean. 3. Interpret the confidence interval. Create an individual Excel...
what does a recommendations worksheet look like in a Master Budget created in Excel? I have...
what does a recommendations worksheet look like in a Master Budget created in Excel? I have already created the Assumptions tab, Sales Budget, Collections, Production Budget tabs and now need to provide my impressions and recommendations based on that information. I'm looking for an example of layout and type of content to include in that.
***PLEASE SHOW HOW TO SOLVE IN EXCEL*** Case Problem 3:        Consumer Research, Inc. (Copy the worksheet...
***PLEASE SHOW HOW TO SOLVE IN EXCEL*** Case Problem 3:        Consumer Research, Inc. (Copy the worksheet named “Consumer” in QMB3200-Homework#10Data.xlsx into your file for this problem) Consumer Research, Inc., is an independent agency that conducts research on consumer attitudes and behaviors for a variety of firms. In one study, a client asked for an investigation of consumer characteristics that can be used to predict the amount charged by credit card users. Data were collected on annual income, household size, and...
What formula do I use to calculate the Effective Cost of Borrowing (IRR in excel) for...
What formula do I use to calculate the Effective Cost of Borrowing (IRR in excel) for the following cash flows. Years Cashflows 0 $ (94,000.00) 1 884.91 2 833.33 3 786.50 4 744.30 5 706.57 6 698.12 7 705.77 8 712.64 9 718.74 10 724.03 11 728.49 12 732.11 13 734.87 14 736.76 15 737.74 ECB IRR= To calculate ECB, IRR function has to be used using annual payments for cash-flows. However the payments have to be calculated monthly and...
What order would I need to insert the numbers 1 to 7 into a new AVL...
What order would I need to insert the numbers 1 to 7 into a new AVL tree in order to ensure that there was no need to perform a rotation.
PLEASE USE FORMULA AND NOT EXCEL SO I CAN UNDERSTAND HOW TO USE FORMULA THE INITIAL...
PLEASE USE FORMULA AND NOT EXCEL SO I CAN UNDERSTAND HOW TO USE FORMULA THE INITIAL QUESTION: Gerald has taken out a loan of $100,000 today to start a business. He has agreed to repay the loan on the following terms: Repayments will be made on a monthly basis. The first repayment will be made exactly one month from today. The repayments for the first 5 years will cover interest only to help reduce the financial burden for Gerald’s business...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT