All categories

2 years ago

The combo box (form control) option in macros can be used to substitute for ___ when doing scenario analysis.

Business

1 answer:

mina [271]2 years ago

7 0

Answer:

Data validation

Explanation:

Here the combo box determines the validating the data and also provides the data list that is to be chosen from the given set of the data. Now if can be chosen from the drop-down list with respect to combo box also the motive would remain the same as it comes under data validation option

Hence, the correct option is data validation

You might be interested in

Becker Tabletops has two support departments (Janitorial and Cafeteria) and two production departments (Cutting and Assembly). R

den301095 [7]

Answer:

A.Allocates costs to assembly department = $290,250

B.Allocated costs to cutting department =$274,000

C.Allocated costs to cutting department =$254,200

Explanation:

A. Calculation for the production department that is allocated the most support department costs under the direct method

Allocated costs to cutting department =

($62,000+ $126,750)

Allocated costs to cutting department=$188,750

Allocates costs to assembly department = ($248,000+$42,250)

Allocates costs to assembly department = $290,250

Based on the above calculation the production department that is allocated the most support department costs will be Assembly department because it has the highest allocated costs of the amount of $290,250

B) Calculation for the production department that is allocated the most support department costs under the sequential method

Allocated costs to cutting department = ($ 31,000+ $243,000)

Allocated costs to cutting department =$274,000

Allocates costs to assembly department = ($124,000+$81,000)

Allocates costs to assembly department = $205,000

Allocates costs to cafeteria department =$155,000

Based on the above calculation the production department that is allocated the most support department costs will be Cutting department because the department had the highest allocated costs of the amount of $274,000

C) production department is allocated the most support department costs under the reciprocal services method?

Allocated costs to cutting department = ($ 38200+ $216000) =$254200 ( most support cost allocated to Cutting department

Allocates costs to assembly department = ($152800+$72000) = $224000

8 0

1 year ago

Summer Dean was walking through the mall and found a gym bag lying on the ground. The decision Dean must make as to whether to k

suter [353]

Answer:

Ethics

Explanation:

Ethics also called moral philosophy involves how an individual systemises, defends and recommends the concept of right or wrong.

Summer is facing an ethical decision of either returning the bag or keeping it for herself. Her decision will be based on her definition of right or wrong.

If her moral philosophy is one that does not see theft as something that is wrong, she will decide to keep the bag. If on the other hand she sees keeping the bag that is not her own as wrong she will decide to return it.

6 0

1 year ago

Beacon Food Stores purchased canned goods at an invoice price of $4,000 and terms of 2/10, n/30. Half of the goods had been misl

seraphim [82]

Answer:

The amount paid should be $1,600

Explanation:

The terms of 2/10, n/30 means 2% discount for the payment within 10 days and the full amount to be paid within 30 days.

Beacon Food Stores purchased canned goods at an invoice price of $4,000. Half of the goods were returned immediately to the supplier.

The remaining amount of the invoice that Beacon Food needs to pay is $2,000

Beacon Food pays the remaining amount of the invoice within the discount period. The amount of discount the company is offered = $2,000 x 2% = $40

The amount paid = $2,000 - $40 = $1,600

4 0

1 year ago

Colgate reported Diluted EPS of $2.38 in accordance with GAAP. How much higher would EPS be if Colgate ignored the impact of res

Fantom [35]

Answer:

EPS will be higher than $2.38

Explanation:

The earnings per share are the income that is accessible to the company's shareholders after all the costs and taxes are deducted. Restructuring costs are one-time costs that are recorded in the income statement as other operating expenses.

The presence of restructuring and other one-time costs in the Revenue Statement leads to lower pre-tax earnings and cause decrease in net profit. When these expenses are excluded, the Earning would increase, resulting in the company's EPS.

4 0

2 years ago

EA11.

Vedmedyk [2.9K]

Answer:

$1,700

Explanation:

Given that,

Purchase of raw materials inventory = $1,000

Assignment of raw materials inventory to Job 5 = $500

Payroll for 20 hours with $1,000 assigned to Job 5

Factory utility bills = $750

Overhead applied at the rate = $10 per hour

Cost assigned to Job 5 at the end of the week:

= Raw materials inventory to Job 5 + Labor cost + Manufacturing Overhead applied

= $500 + $1,000 + ($10 per hour × 20 hours)

= $500 + $1,000 + $200

= $1,700

3 0

2 years ago