Answered step by step
Verified Expert Solution
Question
1 Approved Answer
I've provided a starting file to try to make it easier! Scenario : The databases are down for the next several days as they make
I've provided a starting file to try to make it easier!
Scenario:
The databases are down for the next several days as they make unplanned service updates. As the store manager, you need to find a quick solution and minimize errors. You decide to create an order form that you can use based on the information from the Inventory sheet. You will be doing this on the spot with your first customer of the day!
Requirment:
- Format the current information using the same themes and styles you used in the Potential Profit and Inventory sheets.
- Create a Data Validation as a List and use the Named Range from the Inventory Item Number column you created as the source. Be sure that In-cell drop down and Ignore Blanks are checked off.
- Enter 3 different items the customer is purchasing using the data validation list.
- Create a VLOOKUP to bring over the description from the Inventory sheet of each item number to the Description Column.
- Enter the Quantity of each item the customer is purchasing (any quantity of your choice)
- Create a VLOOKUP to bring over the Unit Price from the Inventory Sheet of each number.
- Use the appropriate formula to calculate the Order Amount.
- Create the appropriate functions to calculate the Sub Total.
- Create the appropriate formula to calculate the Total with the Sales Tax included.
- Remember to go back and Format any numbers or other areas you missed at the beginning. Remember the header and print set up
Super Store Order Form Customer Name Order Date Item Number Description Quantity Unit Price Order Amount Sub Total Sales Tax Total 7% Super Store Order Form Customer Name Order Date Item Number Description Quantity Unit Price Order Amount Sub Total Sales Tax Total 7%
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started