Computers and Technology, 16.10.2020 02:01 MorgannJ

Josh Bartel is the senior director of the Pennsylvania field office for New Era Medical, a global company that manufactures medical equipment. He has created a worksheet summarizing the revenue and expenses for the first three quarters of the year. He asks for your help in determining what the Pennsylvania office needs to do to meet its targeted profit goals in the fourth quarter. Go to the Budget Summary worksheet. Cut the worksheet title from cell 11 and paste it in cell A1 to display the title in its expected location. In cell E2, add the text Number of so that the complete text appears as "Number of salespeople:" and more clearly identifies the value in cell G2. Enter Quarter 2 in cell 04 and Quarter 3 in cell 04. In cell G5, enter a formula without a function that subtracts the target revenue (cell F5) from the year to date revenue (cell E5) to determine how much revenue the field office needs to earn in Quarter 4 to reach its target for the year. Josh wants to calculate the gross margin for Quarters 1-3 and the year to date. Provide this information as follows: a. In cell B7, enter a formula without a function that divides the gross profit for Quarter 1 (cell B6) by the revenue in Quarter 1 (cell B5).
b. Fill the range 07:57 with the formula in cell B7 to find the gross margin for Ouarters 2 and 3 and for the year to date. 4. 5.

Answers: 2

Show answers

Another question on Computers and Technology

Computers and Technology, 22.06.2019 00:40

Reading characters and strings from the keyboard: consider the following c++ program 1. #include 2. #include 3. using namespace std; 4. mystring1 5. 6. int main() 7. { 8. 9. string mystring1, mystring2; mychar1 10. 11. 12. char mychar1, mychar2; 13. 14. cout< < "enter a string: "; mychar2 15. 16. cin> > mystring1; // 17. cin.get(mychar1); 18. cin> > mychar2; 19. getline(cin,mystring2); mystring2 20. 21. 22. cout<

Answers: 1

Answer

Computers and Technology, 23.06.2019 06:30

Which option correctly describes a dbms application? a. software used to manage databases b. software used to organize files and folders c. software used to develop specialized images d. software used to create effective presentations

Answers: 1

Answer

Computers and Technology, 23.06.2019 09:30

Why is an outfitting a workspace with video games in a technology development company considered a strategic use of money

Answers: 1

Answer

Computers and Technology, 23.06.2019 09:30

Write a function called checkfactor that takes two arrays of positive numbers, firstnumberrow and secondnumberrow. checkfactor checks if the first entry in firstnumberrow is divisible by the first entry in secondnumberrow, and performs the same operation on the next array elements until all entries have been checked. all the numbers are positive and the number of entries in the arrays are the same. the function should return the identified divisible numbers in two row arrays named firstdivisible and seconddivisible.restrictions: branches or loops should not be used. the code must use the internal mod and logical functions.hint: the mod function should be used to determine if two numbers are divisible. ex: for num1 and num2 if mod(num1,num2) is 0, then the two numbers are divisible.this is matlab

Answers: 2

Answer

You know the right answer?

Josh Bartel is the senior director of the Pennsylvania field office for New Era Medical, a global co...

Questions