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, 21.06.2019 18:00

Sara bought 12 3/4 cakes sara's friends ate 3/8 how much cake is left

Answers: 1

Answer

Business, 22.06.2019 01:00

You are the manager in charge of global operations at bankglobal â€“ a large commercial bank that operates in a number of countries around the world. you must decide whether or not to launch a new advertising campaign in the u.s. market. your accounting department has provided the accompanying statement, which summarizes the financial impact of the advertising campaign on u.s. operations. in addition, you recently received a call from a colleague in charge of foreign operations, and she indicated that her unit would lose $8 million if the u.s. advertising campaign were launched. your goal is to maximize bankglobalâ€™s value. should you launch the new campaign? explain. pre-advertising campaign post-advertising campaign total revenues $18,610,900 $31,980,200 variable cost tv airtime 5,750,350 8,610,400 ad development labor 1,960,580 3,102,450 total variable costs 7,710,930 11,712,850 direct fixed cost depreciation â€“ computer equipment 1,500,000 1,500,000 total direct fixed cost 1,500,000 1,500,000 indirect fixed cost managerial salaries 8,458,100 8,458,100 office supplies 2,003,500 2,003,500 total indirect fixed cost $10,461,600 $10,461,600

Answers: 2

Answer

Business, 22.06.2019 10:50

Kimberly has been jonah in preparing his personal income tax forms for a couple of years. jonah's boss recommended kimberly because she had done a good job setting up the company's new accounting system. jonah is very satisfied with kimberly's work and feels that the fees she charges are quite reasonable. kimberly would be classified as a(n) (a) independent auditor (b) private accountant (c) public accountant (d) accounting broker

Answers: 1

Answer

Business, 22.06.2019 13:30

Presented below is information for annie company for the month of march 2018. cost of goods sold $245,000 rent expense $ 36,000 freight-out 7,000 sales discounts 8,000 insurance expense 5,000 sales returns and allowances 11,000 salaries and wages expense 63,000 sales revenue 410,000 instructions prepare the income statement.

Answers: 2

Answer

You know the right answer?

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

Questions