QuestionJones Family Household Expenses for February 2022 Items $…Jones Family Household Expenses for February 2022 Items $ Over/Underbudget? Requirements January Electricity & Water Bill 250 1 Calculate the to total Household Expenses for each month and for the quarter ending March . Phone Bill 150 2 Calculate the average monthly Household Expense for the quarter. Internet 90 3 How many items in March exceeded $1000? Gas 60 4 Assuming the Jones family has a monthly budget of $3000, determine of they are over or underbudget for January, February, and March. Apartment rental 1,450 5 The Jones family has five children with the following names. Attach the family name “Brown” to each name using the concatenate function. Donation 150 Larry Car maintenance 100 Jenny Car Repairs 800 Tom Car Insurance 250 Jerry Medical insurance 230 Jessica Groceries 1000 Miscellaneaous 125 Note: Input your formula and answers in the designated yellow cells. For Q6, input formula and answers in cells I8 through I12. TOTAL Q1 Q4 Do not change any amount in Column D. Make sure to use the excel formulas when calculating.February Electricity & Water Bill 230 Phone Bill 150 Internet 90 Gas 65 Apartment rental 1,450 Donation 50 Car maintenance 100 Car Repairs 0 Car Insurance 250 Medical insurance 1250 Groceries 300 Miscellaneaous 95 TOTAL Q1 Q4 March Electricity & Water Bill 380 Phone Bill 150 Internet 90 Gas 65 Apartment rental 1,450 Donation 50 Car maintenance 100 Car Repairs 0 Car Insurance 250 Medical insurance 230 Groceries 1100 Miscellaneaous 80 TOTAL Q1 Q4 GRAND TOTAL Q1 AVERAGE MONTHLY EXPENSE Q2 NUMBER OF ITEMS IN MARCH EXCEEDING $1000 Q3 BusinessAccountingCOMP 268Share Question
You will get a plagiarism-free paper and you can get an originality report upon request.
All the personal information is confidential and we have 100% safe payment methods. We also guarantee good grades
Delivering a high-quality product at a reasonable price is not enough anymore.
That’s why we have developed 5 beneficial guarantees that will make your experience with our service enjoyable, easy, and safe.
You have to be 100% sure of the quality of your product to give a money-back guarantee. This describes us perfectly. Make sure that this guarantee is totally transparent.
Read moreEach paper is composed from scratch, according to your instructions. It is then checked by our plagiarism-detection software. There is no gap where plagiarism could squeeze in.
Read moreThanks to our free revisions, there is no way for you to be unsatisfied. We will work on your paper until you are completely happy with the result.
Read moreYour email is safe, as we store it according to international data protection rules. Your bank details are secure, as we use only reliable payment systems.
Read moreBy sending us your money, you buy the service we provide. Check out our terms and conditions if you prefer business talks to be laid out in official language.
Read more