Question

In: Computer Science

Exercise 3: Create a worksheet that gives a price quote. You will select an item name...

Exercise 3:

Create a worksheet that gives a price quote. You will select an item name and enter the quantity of that item purchased. Use Data Validation to create a drop down list for your item names. Your worksheet should look up the item name in the Price Table to find the Unit Price. Then it should calculate the Total Before Discount. Look up this amount in the Discount Table to find the discount percent. Then your worksheet should calculate the Discount Amount, the Total After Discount, add in Sales Tax (use an assumption for tax percentage), and give the final Total Due for the order. Place the Price Table, Discount Table and Sales Tax Percentage in the assumptions area.

Use the layout shown below starting your title in A4:

Price Quote (title)

Item:     (input)

Quantity: (input)

Unit Price:

Total Before Discount:

Discount %:

Discount Amount:

Total After Discount:

Sales Tax:

Total Due:

(The price and discount information is shown below…you may need to reconfigure the layout to meet your needs. All information shown below needs to be included in your Lookup Tables, even if it is not used in the problem.)

Price Information:

Unit Price                          Item #                 Item Name        

9.99                                   H5528                 Hat       

5.99                                   L8511                  Lanyard                             

14.99                                 T3592                  T-shirt                                             

19.99                                 D7435                 Drawstring Bag               

Discount Information:

Total Price

Before Discount ($)         Discount

$0 – $99.99                               0%

$100 – $399.99                        5%

$400 – $999.99                      10%

$1000 and over                      15%

Solutions

Expert Solution

Dear Seeker,

Please find the model completed,

Formulas used

References

You can also download the prepared model from below link of G Drive

https://docs.google.com/spreadsheets/d/1MaUdKzsYiciiRPRb9aC741GmlFzyoj6v1OTSczdepjw/edit?usp=sharing

Regards,


Related Solutions

Create a new worksheet and name it as “Roster”. Assume that you are the TA for...
Create a new worksheet and name it as “Roster”. Assume that you are the TA for Mgtop 470. You have the class roster in the worksheet “Roster” and the full names of students are in column A, starting in Cell A3, with last name last and case insensitive (such as Ben ALT). Write a sub that counts the number of names in the list with last name ALT and then displays this count in an MsgBox that is titled “Number...
Flooring Quote Calculator Create a program that calculates a price quote for installing different types of...
Flooring Quote Calculator Create a program that calculates a price quote for installing different types of flooring in a house. Allows the user to enter the homeowner’s information, number of rooms where they want new flooring installed, the area of each room, and the type of flooring for each room. Your program will then calculate and print the installation costs. Need to use a House class that contains information about the home and home owner. An inner class, Room, will...
The GroceryItem class must maintain the name of the item and its price (a double). You...
The GroceryItem class must maintain the name of the item and its price (a double). You must read the grocery data from file, and store each line's information in a single GroceryItem object. In other words, there should be one GroceryItem object created for each line in the file. Implement all standard and necessary getters and setters, as well as constructors. Also, implement a calculateWithTax method that takes a double parameter, and returns the price with the tax added. The...
2.13 Program: Food receipt (Python 3) 1.Enter food item name: hot dog Enter item price: 2...
2.13 Program: Food receipt (Python 3) 1.Enter food item name: hot dog Enter item price: 2 Enter item quantity: 5 RECEIPT 5 hot dog @ $ 2.0 = $ 10.0 Total cost: $ 10.0 2.Enter food item name: hot dog Enter item price: 2 Enter item quantity: 5 RECEIPT 5 hot dog @ $ 2.0 = $ 10.0 Total cost: $ 10.0 Enter second food item name: ice cream Enter item price: 2.50 Enter item quantity: 4 RECEIPT 5 hot...
Select 5 item topics. For each item topic you select, you need to write a minimum...
Select 5 item topics. For each item topic you select, you need to write a minimum of 5 sentences. Any responses that involve one-word answers, responses less than the 5 sentence minimum, or any answers that are copy and pasted (from the book or otherwise) will result in decreased points or a “0.” Points are awarded per instructor discretion. 1.What are the goals of nursing? 2. 5 Steps to achieve critical thinking 3. Critical judgement 4. 3 learning styles 5....
Select 5 item topics. For each item topic you select, you need to write a minimum...
Select 5 item topics. For each item topic you select, you need to write a minimum of 5 sentences. Any responses that involve one-word answers, responses less than the 5 sentence minimum, or any answers that are copy and pasted (from the book or otherwise) will result in decreased points or a “0.” Points are awarded per instructor discretion. 1."Eating your young" ritual 2. What is workplace violence? 3.Lavinia Lloyd Dock 4.Affordable Care Act (ACA) 5.Nursing shortage
Select 5 item topics. For each item topic you select, you need to write a minimum...
Select 5 item topics. For each item topic you select, you need to write a minimum of 5 sentences. Any responses that involve one-word answers, responses less than the 5 sentence minimum, or any answers that are copy and pasted (from the book or otherwise) will result in decreased points or a “0.” Points are awarded per instructor discretion. 1. 3 verbal communication blockers 2. Sentinel events 3. Maslow's hierarchy 4. Evidence- based practice 5. Cultural awareness write a minimum...
1. The Item class includes two fields: a String for the name and a double for the price of an item that will be added to the inventory.
  1. The Item class includes two fields: a String for the name and a double for the price of an item that will be added to the inventory. 2. The Item class will require one constructor that takes a name and price to initialize the fields. Since the name and price will be provided through TextFields, the parameters can be two Strings (be sure to convert the price to a double before storing this into the field). 3. Write...
3. Suppose you bought a call option for $3 with an exercise price of $50 and...
3. Suppose you bought a call option for $3 with an exercise price of $50 and another call option for $2 with an exercise price of $60 per share. Draw a graph of the payout on the investment as a function of the stock price. Label the graph.
4. Create a program that takes in the following CMD arguments: Item name, quantity, cost per...
4. Create a program that takes in the following CMD arguments: Item name, quantity, cost per item, and total cost. Your task then is to take this given information to print a simple receipt as indicated below (Don’t worry about the calculations for now.) 1 Sample run 1: Java lab01_task04 Banana 6 3.25 19.50 Output: Welcome to FCI Fresh Goods Sales ====================== You have purchased: 6 X Banana @ N$ 3.25 including 15% VAT ====================== Total Cost: N$ 19.50 ======================
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT