Description
Mathematics of Buying and Selling Exercises
Purpose of Assignment
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
Save the Mathematics of Buying and Selling Exercises Excel® Template to your computer.
Read the instructions on the first tab.
While the context may often make the results of the math clear, many times it does not. the number is just a number. To give that number meaning a report of findings is needed. Starting this week a short sentence or two to put your answer into context is going to be required also. For example, if the problem asked to calculate the percentage change in a price you would write "The percentage change in the price is XX%". this give meaning to the number and makes the results clear.
Complete the ten exercises located in the template.
Unformatted Attachment Preview
Purchase answer to see full attachment
Explanation & Answer
Hi!Kindly see attached the completed excel file with the solution to the 10 different problems and the explanation of the obtained result as instructed by your teacher
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
back and 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
%
63.3%
58.0%
Taking into account an overcost of $130.50 and that this represents a 58% markup based on the cost, the cost of the la
$225.00, the rate is 63.3% and the final selling price is $355.50
st, which is a 58% markup
% markup based on the cost, the cost of the laptop is
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%
Taking into account a selling price of $49 and a markup of 80% based on the selling price, the cost and the amoun
of sign are of $9.80 and $39.20, respectively
ing price, the cost and the amount of markup...