Description
The purpose of the assignment is to provide students an opportunity to use Microsoft Excel® to practice the concepts of trade discounts, invoicing, markups, and markdowns.
Assignment Steps
Resources: Mathematics of Buying and Selling Exercises Excel® Template, Excel® 2016 Essential Training
Unformatted Attachment Preview
Purchase answer to see full attachment
Explanation & Answer
See attached
Instructions:
Week 3 Individual Assignment
Total Number of Questions - 10
Total Points: 6
1. You have ten problems - one on each tab of this Excel file.
2. Please show your work in the cells. Use Excel formulas instead of writing the values/answers directly in the cell.
The instructor will then know where you made a mistake and provide you valuable feedback and partial credit (if appropria
partial credit (if appropriate).
Nordstrom plans to mark up a Brahmin Croc Embossed Laptop Case $130.50 over cost, which is a 58% markup
based on the cost. Find the cost, the selling price, and the rate of the selling price.
Cost
+ Markup
= Sell Price
Amount
$225,00
$130,50
$355,50
%
100,0%
58,0%
158,0%
Ronin Copies marks up signs that sell for $49. The markup is 80% based on the selling price.
What is the cost and the amount of markup of a sign?
Cost
+ Markup
= Sell Price
Amount
$9,80
$39,20
$49,00
%
20,0%
80,0%
100,0%
Lowe’s reduced a Maytag dishwasher 12.563%. If the dishwasher was priced at $398,
find the amount of markdown and the reduced price.
Original SP
‒ Markdown
= New Price
Amo...