Description
WEEK THREE ASSIGNMENT 2:
Mathematics of Buying and Selling Exercises
oDue Jun 26, 6:00 PM (PST)
oNot Submitted
oPOINTS 6
- Exercise
- no new messages
Objectives:
- 2.1
- 2.2
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.
Complete the ten exercises located in the template.
Click the Assignment Files tab to submit your assignment
Unformatted Attachment Preview
Purchase answer to see full attachment
Explanation & Answer
Here is my answer :)
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
$130.50
$75.69
$206.19
%
58.0%
ch is a 58% markup
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
%
80.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
Amount
...