Business, 04.03.2021 01:00 cramirezorozco392

HELPP use the budgets provided for the last three summers for the Countywide IT Professional Society (CIPS) to e perform the calculations described in this spreadsheet.
2014 Countywide IT Professional Society (CIPS) Summer Budget
1. Use a formula to calculate the percentage of expenses for the 2013 summer budget that was spent on
rent for the event. Write the formula you used and the percentage you calculated, to two decimal places, in
the cell below. Hint: Use order of operations principles for the formula. (5 points)
June July August
# # $150.00 #
Eten en
2. A closer estimate of the total cost can be made by including the estimated sales tax. Use a formula to
calculate the estimated cost for July 2014 using 7% sales tax. Then, write the formula you used and the
estimated cost in the cell below. Hint: Convert 7% into a decimal for the formula. (5 points)
Askesmans
Website/single
Actividade cos's
$50.00 $60.00 $70.00 $180.00
$10.00
$10.00 $10.00 $30.00
$50.00 $40.00 $60.00 $150.00
3. Current data can be used to predict future costs. Based on the budget for the last three summers, predict
the amount of money that will be sponsored for each event in 2015. Write your prediction in the cell below,
and explain how you arrived at your conclusion. Be sure to use currency formatting for the monetary
amount. (5 points)
Expenses
Sponsored at $150/event
$310.00 # #
- 150 - 150 -150
160 210 140
4. Based on the budget for the last three summers, predict the website hosting fee for August 2015. Write
your prediction in cell A21, and explain how you arrived at your conclusion in cell A22. Be sure to use
currency formatting for the monetary amount in cell A21. (5 points)

(ANSWER 2 OF THE QUESTIONS ILL MARK YOU)

HELPP use the budgets provided for the last three summers for the Countywide IT Professional Societ

Answers: 1

Show answers

Another question on Business

Business, 22.06.2019 11:10

How much are you willing to pay for a zero that matures in 10 years, has a face value of $1,000 and your required rate of return is 7%? round to the nearest cent. do not include a dollar sign in your answer. (i.e. if your answer is $432.51, then type 432.51 without $ sign)

Answers: 1

Answer

Business, 22.06.2019 13:50

Diamond motor car company produces some of the most luxurious and expensive cars in the world. typically, only a single dealership is authorized to sell its cars in certain major cities. in less populous areas, diamond authorizes a single dealer for an entire state or region. the manufacturer of diamond automobiles is using a(n) distribution strategy for its product.

Answers: 2

Answer

Business, 22.06.2019 16:40

An electronics store is running a promotion where for every video game purchased, the customer receives a coupon upon checkout to purchase a second game at a 50% discount. the coupons expire in one year. the store normally recognized a gross profit margin of 40% of the selling price on video games. how would the store account for a purchase using the discount coupon?

Answers: 3

Answer

Business, 22.06.2019 20:30

When many scrum teams are working on the same product, should all of their increments be integrated every sprint?

Answers: 3

Answer

You know the right answer?

HELPP use the budgets provided for the last three summers for the Countywide IT Professional Society...

Questions