excel task

Project Description:

excel retail formulas

mu% = mu$/retail $

retail = cost of goods sold + mu $


week eight task:

questions:

using an excel spreadsheet, calculate the mu% if the mu dollars are $5 and the retail is $10.

using your excel spreadsheet, calculate the retail of an item that costs $152.00 and has a mu of $200.

using your excel spreadsheet, calculate the mu% for question #2.

question 4:

re-create the following on an excel spreadsheet (do not copy).

1 a b c d e f g
2 purchase order form
3 house/style# description quantity unit cost total cost unit retail total retail
4 300 leather attaché 25 $79.50 $169.99
5 401 leather folders 10 $55.00 $125.00
6 411 leather briefcases 15 $69.50 $150.00
7 total
8 mu%
9
10 instructions (do not copy)
11 make the heading in cell a2 16 pt and bold. merge and center from col. a to col g
12 format the numbers centered.
13 enter a formula to find the total cost
14 enter a formula to find the total retail.
15 find the total for cells e7 & g7
16 in cell c8, find the markup percent. format the number percent style.
17 box/format all cells


all work must be created and uploaded in an excel spreadsheet. formulas must be used. i will be able to view entered formulas.
Skills Required:
Project Stats:

Price Type: Negotiable

Expired
Total Proposals: 19
1 Current viewersl
40 Total views
Project posted by:

Proposals

Proposals Reputation Price offered