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

Vaughn Manufacturing's prepaid insurance was $197000 at December 31, 2021 and $90300 at December 31, 2020. Insurance expense was

Zina [86]

Answer:

Cash disbursements for insurance would be $ 168,700.

Explanation:

In accrual based accounting expenses are recorded when they are incurred. The payment against item purchased does not make it qualified to be recorded as expense. Any advance payment made is recognize as asset untill performance obligation has been completed. So in order to determine amount of payment we will use following accounting equation.

Payments = Prepaid current period + expenses - opening prepaid balance

Payments = 197,000 + 62,000 - 90,300 = $ 168,700

8 0

2 years ago

The University Store, Inc. is the major bookseller for four nearby colleges. An income statement for the first quarter of the ye

Effectus [21]

Answer: $30,000

Explanation:

Sales are $800,000 and the average price is $40. Number of units sold is;

= 800,000/40

= 20,000 units

Sales $ 800,000

Less: Cost of Goods Sold ($560,000)

Gross Margin $240,000

Less : Variable Costing

Selling Expenses (20,000 units X $3.00) ($60,000)

Administrative Expenses (5% of $ 800,000) ($40,000)

Contribution Margin $140,000

Less: Fixed Cost

Selling Expenses ($100,000 - $60,000) ($40,000)

Administrative Expenses ($110,000 -$40,000) ($70,000)

Net Operating Income  $30,000

3 0

2 years ago

Which of the following is the most accurate statement regarding the federal budget?

hoa [83]

The Federal Reserve System controls the monetary policy in the United States. They influence short-term interest rates and also determine the size of the money supply. The Federal budget is very hard to balance and has been a concern and is difficult to achieve. The President sends the budget to Congress who must approve it.

4 0

2 years ago

The own price elasticity of Anne’s apple pies is 5.

spin [16.1K]

Answer:

Option "B" is the correct answer to the following question.

Explanation:

Given:

Price elasticity of Anne’s apple pies = 5

Aggregate market price elasticity = 1.25

Anne’s apple pies have an approximate market share = ?

Computation of Anne’s apple pies have an approximate market share:

Anne’s apple pies have an approximate market share = (Aggregate market price elasticity / Price elasticity of Anne’s apple pies) × 100

Anne’s apple pies have an approximate market share = (1.25 / 5) × 100

Anne’s apple pies have an approximate market share = (0.25) × 100

Anne’s apple pies have an approximate market share = 25%

8 0

2 years ago

Machining Machine-hours $ 247,000 13,000 MHs Machine setups Number of setups $ 60,000 150 setups Product design Number of produc

PtichkaEL [24]

Answer:

Manufacturing overhead allocated to product P56L is $249,200

Explanation:

The missing beginning part of the question is as written below

"Bippus Corporation manufactures two products: Product X08R and Product P56L. The company uses a plantwide overhead rate based on direct labor-hours. It is considering implementing an activity-based costing (ABC) system that allocates its manufacturing overhead to four cost pools. The following additional information is available for the company as a whole and for Products X08R and P56L.

Activity Cost Pool Activity Measure Total Cost Total Activity"

Solution

Predetermined overhead rate = Estimated overhead/Estimated direct labor hours

Predetermined overhead rate = (247,000 + 60,000 + 56000 + 260,000) / 10,000

Predetermined overhead rate = 623,000 / 10,000 dhl

Predetermined overhead rate = 62.30 per direct labor hour

Manufacturing overhead allocated to product P56L

= 4,000 hours * 62.30

= $249,200

3 0

2 years ago