Retail Discount Create a spread sheet that will calculate all discounted prices given below. Use absolute and relative references to the discount percentages. (note: one mixed reference in cell C4 could be copied through the range.) report all numbers to two decimal places. Show dollar signs on the top row of numbers only.

Need a Professional Writer to Work on this Paper and Give you Original Paper? CLICK HERE TO GET THIS PAPER WRITTEN

Price with discount

Belt     Price 35.00    10%    15%    20%

Jacket Price 150.00 10%    15%    20%

Pants Price 90.00      10%    15%    20%

Shirt Price 25.00       10%    15%    20%

Suit Price 425.00      10%    15%    20%

 

2md Sheet

 

Projected v. Actual Expenses Create a spread sheet below that compares projected and actual expenses by calculating a percent difference between the two. Calculate totals for the first two columns and overall percent difference. Format to match the spread sheet below. Percents should show one decimal place

 

Rent: Expense: 4,000           Actual Expense: 4,000.00    Percent Diff

Electricity: Expense 2,400   Actual Expenses 3,245.15    Percent Diff

Supplies: Expense 7,500      Actual Expense 7,230.95     Percent Diff

Insurance: Expense 2,000   Actual Expense 2.150.00     Percent Diff

Consultants Expense 3,000Actual Expense 2,500.00     Percent Diff

 

TotalNeed a Professional Writer to Work on this Paper and Give you Original Paper? CLICK HERE TO GET THIS PAPER WRITTEN

Latest completed orders:

Completed Orders
# Title Academic Level Subject Area # of Pages Paper Urgency