Question: In column H, creat a formula using the IF and VLOOKUP functions to calculate the rental charges for each set of funiture based on the

In column H, creat a formula using the IF and VLOOKUP functions to calculate the rental charges for each set of funiture based on the funiture's group code, the rental period, and the Funiture Rental charges table. For the IF function arguements, use one VLOOKUP for 3 months and another for 9 months. The defined name Rental Charges has been assigned to the Funiture Rental Charges table.

In column I, enter a fromula to calculate the insurance charge if the renter has elected insurance coverage (Yes in column E). Use the funitures group code and the Monthly Insurance column in the Rental Charges Table to look up the insurance charge. Remember to multiply themonthly insurance charge by the rental period. If the renter has not elected insurance, the cost is $0.

In column J, enter the formula with an IF function to determine the shipping charge for each set of funiture. Use the shipping code (column F) and the shipping charge option Pickup (0) and Truck ($50) to assign shipping costs to rental funiture.

In column K enter a formula to calculate the total cost, which is the sum of the rental charges, the insurance cost, and the shipping cost.

**PLEASE SHOW ALL FORMULAS**

Renter	Furniture	Rental Date	Rental Period	Insurance	Shipping Code	Group Code	Rental Fee	Insurance Charge	Shipping Charge	Total Cost
Mogan	LR-3pc	8/15/2017	6	Yes	Pickup	C
Novarre	LR-3pc +	8/28/2017	6	Yes	Pickup	D
Chico	GR-Electronic	7/13/2017	12	Yes	Truck	E
Roman	BR-King	7/17/2017	6	Yes	Truck	D

Funiture Rental Charges

Furniture Rental Charges
Group	Rental for 6-months	Rental for 9-months	Monthly Insurance
A	$ 100	$ 175	$ 10
B	$ 150	$ 250	$ 15
C	$ 200	$ 375	$ 20
D	$ 250	$ 475	$ 25
E	$ 400	$ 750	$ 40

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 Databases Questions!

In column H, create a formula using the IF and VLOOKUP functions to calculate the rental charges for each set of furniture based on the funiture's group code, the rental period, and the Furniture...

answer the questions based off the excel tables File Home Insert Draw Design Layout References Mailings Review View Help Share Comments X Arial 9 ~A Aar Po AL 1 AaBb CcDd AaBb C AaBbCcl AaBbCcDdl...

Emma sells and rents musical instruments. Her rental business involves renting instruments to K-12 students who participate in school bands and orchestras. Emma maintains an Excel worksheet to track...

I have attached pictures of the project instructions in excel. Please help. Thank you so much DETAILED ASSIGNMENT REQUIREMENTS The the Chart of Accounts, below, shows the balances in GBI accounts as...

Base Price $1,699 $1,749 $1,799 $1,849 $1,899 $1,949 Commission 2.5% 3.0% 3.5% 4.0% 4.5% 5.0% Package 10 20 30 40 50 60 70 80 Tour Description Adventures in Canada Check Out the Czech Republic!...

Data File needed for this Assignment: Rentals.xlsx Barrett Furniture Rentals leases furniture by the room to corporations outfitting apartments for temporary stays as well as to homeowners and...

B 1 1 M r Category Type 1 F 2 3 H Base case city Houston Comparison city Lubbock H Living Factor 6.30% 28.20% 13.40% -4.60% 0.00% 33.6.21% HC 5 Food & Groceries Housing Health care Miscellaneous...

The Red Bluff Golf Course & Pro Shop generates revenue through its golfers, golfer services, and pro shop sales. Aleeta Herriott, the pro shop manager, receives revenue data on a weekly basis. She...

Excel project due Friday please help EXP E Capstone 1 - European Excursions 2.5 Project Description: You work for a travel company that specializes in arranging travel accommodations for student...

I got up to part 7 but do not know how to do the rest of the formulas in Excel Project Description: You work for a travel company that specializes in arranging travel accommodations for student tours...

Under IFRS, equity is defined under the Framework for Preparation and Presentation of Financial Statements. Under PE GAAP , a definition of equity is provided in the CICA Handbook, Part II, Section...

What is the difference between an operating and a financial budget?

NewCo is interested in raising up to $ 5 million in equity capital from an unlimited number of accredited and unaccredited purchasers during a 1 2 - month period. NewCo understands that the offering...

37) All of the following contribute to nitrogen-fixation except a) lightning b) bacteria on the roots of legumes c) the combustion process in car engines d) the Haber process e) the Ostwald process...

Economist John Taylor has suggested that the Fed use the following rule for choosing its target for the federal funds interest rate (r): r = 2% + + 12 (y y*) / y* + 12 ( *), where is the average...

Suppose banks install automatic teller machines on every block and, by making cash readily available, reduce the amount of money people want to hold. a. Assume the Fed does not change the money...

Consider two policiesa tax cut that will last for only 1 year and a tax cut that is expected to be permanent. Which policy will stimulate greater spending by consumers? Which policy will have the...