Now you will need to create a spreadsheet to list the pricing options for several products (Use
Question:
Now you will need to create a spreadsheet to list the pricing options for several products (Use the products from your presentation).
Be sure to include a Title for your spreadsheet formatted appropriately.
Show individual pricing for at least five different items in a single column. (This can be more but must be at least five different items).
Show the price for multiple items in the next column. Ex: Organic Marshmallows- 4.79 / bag-- Box of 12 = $57.48
Use formulas to calculate the totals in these columns.
The next column, provide a quantity discount. (Example - Box of 12 Marshmallows = $57.48. You can give a 3% discount for 6 or more boxes, etc. Make this up.)
Use a formula to calculate the discount based on the number of items ordered. The discount should have its own column and must use a formula for the calculations.
Next create a column that shows the amount of tax on the total. You must use an absolute reference.
Finally, create a column that adds the total plus tax for a final amount.
You may add additional columns for more information if you like, but this must be your OWN, MANUALLY CREATED WORK.
When the Excel spreadsheet is complete, you need to embed it into your Powerpoint slide in the appropriate place.
Now you can finish saving your Powerpoint file and submit that to the Final Project Powerpoint drop box.
Then Save your Excel file as “yourname.excel.xlsx” and place it in the Final Project EXCEL Drop Box.