Answered

At Westonci.ca, we connect you with the answers you need, thanks to our active and informed community. Get quick and reliable solutions to your questions from a community of experienced professionals on our platform. Get immediate and reliable solutions to your questions from a community of experienced professionals on our platform.

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)
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)
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)
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)

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 Perce class=

Sagot :

The formula that can be used to calculate the percentage of expenses from the budget will be (the amount spent on event × 100) / total expenses.

How to compute the formula?

From the information given, the formula that can be used to calculate the percentage of expenses will be:

= (the amount spent on event × 100) / total expenses. The month of June will be:

= (195 × 100)/297

= 65.66%

The estimated cost for July 2014 using 7% sales tax will be:

= 360 + (7% × 360)

= $385.20

Learn more about budget on:

https://brainly.com/question/24940564

#SPJ1

We hope you found this helpful. Feel free to come back anytime for more accurate answers and updated information. Thanks for using our platform. We aim to provide accurate and up-to-date answers to all your queries. Come back soon. Thank you for using Westonci.ca. Come back for more in-depth answers to all your queries.