Need help making resume

Enter a formula in cell B1 using the SUMPRODUCT function to calculate the total value of the current leases by multiplying the c

Burka [1]

Answer:

The answer is " =SUMPRODUCT(Rents, Leases in cell B1, and pressed Enter)".

Explanation:

The function "SUMPRODUCT" returns the total of products with their respective ranges or arrays. Its main operation is multiplying, although it is necessary to add, subtract, and divide.

To calculate the "SUMPRODUCT", we just click on the cell B1 and type the "SUMPRO" by typing the in cell B1, and double-clicked and apply the above formula that is "=SUMPRODUCT(Rents, Leases in cell B1, and pressed Enter)".

5 0

3 years ago

Suppose the demand and supply curves for eggs in the United

Pachacha [2.7K]

Answer: Please find answers in explanation column

Explanation:

Given

Qd = 100 - 20P

Qs = 10 + 40P

Price Quantity Quantity Quantity

( Per Dozen) Demanded (Qd) Supplied (Qs)

$ .50 90 30

$ 1.00 80 50

$ 1.50 70 70

$ 2.00 60 90

$ 2.50 50 110

Calculation

at price = $0.50

Qd = 100 - 20P = 100 - 20 x (0.50) =100-10 =90

Qs = 10 + 40P= 10 + 40 x (0.50)=10+ 20 = 30

at price = $1.00

Qd = 100 - 20P = 100 - 20 x (1.00) =100-20 =80

Qs = 10 + 40P= 10 + 40 x (1.00)=10+ 40 = 50

at price = $1.50

Qd = 100 - 20P = 100 - 20 x (1.50) =100-30 =70

Qs = 10 + 40P= 10 + 40 x (1.50)=10+ 60 = 70

at price = $2.00

Qd = 100 - 20P = 100 - 20 x (2.00) =100-40 =60

Qs = 10 + 40P= 10 + 40 x (2.00)=10+ 80 = 90

at price = $2.50

Qd = 100 - 20P = 100 - 20 x (2.50) =100-50=50

Qs = 10 + 40P= 10 + 40 x (2.50)=10+ 100 = 110

7 0

3 years ago

Scenario: Mary Ling works for XYZ Corporation, LLC and they have just merged with ABC, Inc. Mary’s job, supervisor, and work loc

Minchanka [31]

Answer: c. Mary will need to send some sort of official documentation regarding the merge or company name change to the DSO, so that her record can be updated.

Explanation:

The options to the question are:

a. This is a new company and new position, Mary will need to compelete a new CPT application.

b. Nothing has changed, Mary does not need to provide any updates.

c. Mary will need to send some sort of official documentation regarding the merge or company name change to the DSO, so that her record can be updated.

d. Mary can call campus and just tell someone.

From the question, we are informed that Mary Ling works for XYZ Corporation, LLC and they have just merged with ABC, Inc. In this case since there is a merger, Mary has to send official documentation to the DAO in order to notify them about the merger and the change of name of the company. When the documents are received by the DSO, it'll be processed and the change will be effected in the student's record.

4 0

3 years ago

Daybook Inc. budgeted production of 403,500 personal journals in 20Y6. Paper is required to produce a journal. Assume six square

Phantasy [73]

Answer:

Direct Materials = $969,000

Direct Labor = $699,400

Factory overhead = $214,600

WIP = $2,200

Finished Goods = ($2,000)

Cost of Goods = $1,883,200

Explanation:

Direct Materials = $969,000

403,500 x 6 square yards = 2,421,000

2,421,000 + (40,400 - 38,900) = 2,422,500

2,422,500 x 0.40 per square yard = $969,000

Direct Labor = $699,400

403,500 personal journals

403,500 * 8 minutes = 3,228,000 minutes

3,228,000/60 minutes = 53,800

53,800 x $13.00 = $699,400

Prepare a cost of goods sold budget for Daybook Inc. using the information above

Direct Materials = $969,000

Direct Labor = $699,400

Factory overhead = $214,600

WIP ($16,500 - $14,300) = $2,200

Finished Goods ($28,000 - $30,000) = ($2,000)

Cost of Goods = $1,883,200

6 0

3 years ago

isk Co. purchases raw materials on account. Budgeted purchase amounts are April, $96,000; May, $126,000; and June, $136,000. Pay

JulijaS [17]

Answer:

Given that Payments are made as follows: 70% in the month of purchase and 30% in the month after purchase, therefore, firstly we need to differentiate the total amount of purchases of each month into 70% and 30%. 70% of the purchases will be paid in current month and balance 30% of the purchases will be ending accounts payable for that month and paid in next month. This is shown as follows:

Particulars April May June

Current month purchases 70% $67,200 $88,200 $95,200

Ending accounts payable 30% $28,800 $37,800 $40,800

Total purchases $96,000 $126,000 $136,000

The schedule of budgeted cash payments for the month of April May and June are shown as follows:-

Schedule of Cash Payments

For April, May, and June

April May June

Cash payments for:

Current month purchases $67,200 $88,200 $95,200

Prior month purchases $38,000 $28,800 $37,800

Budgeted cash payments for materials $105,200 $117,000 $133,000

3 0

3 years ago