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.<\/p>\n
Price with discount<\/p>\n
Belt Price 35.00 10% 15% 20%<\/p>\n
Jacket Price 150.00 10% 15% 20%<\/p>\n
Pants Price 90.00 10% 15% 20%<\/p>\n
Shirt Price 25.00 10% 15% 20%<\/p>\n
Suit Price 425.00 10% 15% 20%<\/p>\n
<\/p>\n
2md Sheet<\/p>\n
<\/p>\n
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<\/p>\n
<\/p>\n
Rent: Expense: 4,000 Actual Expense: 4,000.00 Percent Diff<\/p>\n
Electricity: Expense 2,400 Actual Expenses 3,245.15 Percent Diff<\/p>\n
Supplies: Expense 7,500 Actual Expense 7,230.95 Percent Diff<\/p>\n
Insurance: Expense 2,000 Actual Expense 2.150.00 Percent Diff<\/p>\n
Consultants Expense 3,000Actual Expense 2,500.00 Percent Diff<\/p>\n
<\/p>\n
Total<\/p>\n","protected":false},"excerpt":{"rendered":"
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 Read More …<\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[],"tags":[],"class_list":["post-179230","post","type-post","status-publish","format-standard","hentry"],"_links":{"self":[{"href":"https:\/\/www.benedictsol.com\/blogs\/wp-json\/wp\/v2\/posts\/179230","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.benedictsol.com\/blogs\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.benedictsol.com\/blogs\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.benedictsol.com\/blogs\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.benedictsol.com\/blogs\/wp-json\/wp\/v2\/comments?post=179230"}],"version-history":[{"count":0,"href":"https:\/\/www.benedictsol.com\/blogs\/wp-json\/wp\/v2\/posts\/179230\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.benedictsol.com\/blogs\/wp-json\/wp\/v2\/media?parent=179230"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.benedictsol.com\/blogs\/wp-json\/wp\/v2\/categories?post=179230"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.benedictsol.com\/blogs\/wp-json\/wp\/v2\/tags?post=179230"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}