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)
Answers: 1
Other questions on the subject: Business
Business, 21.06.2019 21:30, cesar566
In its 2016 annual report, caterpillar inc. reported the following (in millions): 2016 2015 sales $38,537 $47,011 cost of goods sold 28,309 33,546 as a percentage of sales, did caterpillar's gross profit increase or decrease during 2016? select one: a. gross profit increased from 26.8% to 28.6% b. gross profit decreased from 28.6% to 26.5% c. gross profit increased from 71.4% to 73.2% d. gross profit decreased from 73.2% to 71.4% e. there is not enough information to answer the question.
Answers: 2
Business, 22.06.2019 13:10, Hannahdavy5434
Thomas kratzer is the purchasing manager for the headquarters of a large insurance company chain with a central inventory operation. thomas's fastest-moving inventory item has a demand of 6,000 units per year. the cost of each unit is $100, and the inventory carrying cost is $10 per unit per year. the average ordering cost is $30 per order. it takes about 5 days for an order to arrive, and the demand for 1 week is 120 units. (this is a corporate operation, and the are 250 working days per year.)a) what is the eoq? b) what is the average inventory if the eoq is used? c) what is the optimal number of orders per year? d) what is the optimal number of days in between any two orders? e) what is the annual cost of ordering and holding inventory? f) what is the total annual inventory cost, including cost of the 6,000 units?
Answers: 3
Business, 22.06.2019 14:10, miacervenka
When paul o’neill joined alcoa as ceo, he set a , that there would be zero workplace accidents. a lot of people in the organization thought this was impossible given how dangerous some aluminum-manufacturing jobs are, but alcoa’s safety record improved tremendously. as the board of governors of the american red cross considers planning, one option is to make strategic plans and then direct managers to align tactical and operational plans accordingly. another option is to have planning specialists managers across the organization make their own plans. why might this organization’s executives opt for the latter approach? check all that apply. (a) the environment is a dynamic one, and department and frontline managers can come up with more responsive plans than can central leadership. (b)resources will be better coordinated across the organization in support of the overall strategy.(c) senior leadership will have more control over the organization’s direction. (d)when managers come up with their own plans, they are likely to be more committed to following through on them.
Answers: 2
Business, 22.06.2019 20:00, HahaHELPP
In william rathje's garbology project that focused on household waste, front door interviews found 15 percent of respondents saying that they consumed beer. the trash discard from the same area showed what percentage of household's consuming beer
Answers: 1
You know the right answer?
HELPP use the budgets provided for the last three summers for the Countywide IT Professional Society...
Questions in other subjects:
Mathematics, 01.10.2019 04:30
Biology, 01.10.2019 04:30
Mathematics, 01.10.2019 04:30
