1answer.
Ask question
Login Signup
Ask question
All categories
  • English
  • Mathematics
  • Social Studies
  • Business
  • History
  • Health
  • Geography
  • Biology
  • Physics
  • Chemistry
  • Computers and Technology
  • Arts
  • World Languages
  • Spanish
  • French
  • German
  • Advanced Placement (AP)
  • SAT
  • Medicine
  • Law
  • Engineering
LenaWriter [7]
3 years ago
13

George runs a mid-size accounting practice and recently upgraded to Excel 2016. He expects sales to grow in the next few months

during tax season. After that, he would like to begin upgrading some of the equipment and furniture for the employees in his office. He will start with the Reception area, which has the most visibility. If sales reach a certain amount by the end of April, George will purchase a desk, chair, computer, and software upgrade for the receptionist. Otherwise, George will just purchase the desk and chair. How can George determine the best action to take using a Sales Data worksheet
Business
1 answer:
Dimas [21]3 years ago
4 0

Answer:

The options are missing, so I looked for a similar question and found them:

  1. Copy and paste all his Sales data formulas with relative reference
  2. Add an IF function formula to his Sales data worksheet
  3. Add the Now function formula to his sales data worksheet
  4. Copy and paste all his sales data formulas with absolute references

The correct answer is:

2. Add an IF function formula to his Sales data worksheet

Explanation:

The most popular worksheet is Excel, and the IF function in excel helps us to compare the actual value of a cell (or group of cells) and the value that we expected it would have.

In this case, George has decided to refurbish his office only IF his sale level increases above a certain point.

You might be interested in
What is the safest way to dispose of old bank account statements?
zheka24 [161]
Soaking the documents in water after tearing them up words well, burning them is less safe, but is the safest for your records, always tear or shred them no matter what
7 0
3 years ago
Padco averages $15 million worth of inventory in all of its worldwide locations. They operate 51 weeks a year and each week aver
Phoenix [80]

Answer:

Option (d) is correct.

Explanation:

Given that,

Average inventory in all of its worldwide locations = $15 million

Operate in a year = 51 weeks

Weekly cost of goods sold = $3 million

Annual cost of goods sold:

= Weekly cost of goods sold × Number of weeks in a year

= $3 million × 51 weeks

= $153 million

Inventory turnover:

= Cost of goods sold ÷ Average inventory

= $153 million ÷ $15 million

= 10.2 turns

4 0
3 years ago
Which answer option is not a job function associated with a corporate finance department?
Leto [7]
4. As it is not the finance departments job to keep up with reputation and how they look.
5 0
3 years ago
Park Sung Inc. is a fictional South Korean manufacturer of refrigerators. The company produces at its manufacturing plant in Bus
Murrr4er [49]

Answer:

The answer for each requirement is given separately below.

Explanation:

What is the economic production quantity (EPQ)?

EPQ = ((Annual Requirement * setup cost *2)/Carrying cost per unit)^(1/2)

         = ((30,000 * 50 *2)/3^(1/2)

         = 1000 Units

a. What is the average inventory level for this optimum production quantity?

Average Inventory level = EPQ/2 = 500 units

b. How many production setups would there be in a year?

Production setups = Annual Usage /EPQ = 30 set ups

C. What is the optimal length of production run in days

length of production = Total Requirement/production per day

                                   = 30,000/275

                                   =110 days approx

d. What would be the savings in annual inventory Cost if setup costs can be reduced to US$40 per setup?

If set up cost reduce to $40  than EPQ = 895

So Set up cost = 30,000/ 895 * 40 = 1,360

Carrying cost = 883/2 *3                  = 1,325

Total Cost                                          = $ 2,685 -A

If set up cost  $50  than EPQ = 1000

So Set up cost = 30,000/ 1000 * 50   = 1,500

Carrying cost = 1000/2 *3                  = 1,500

Total Cost                                          = $ 3,000- B

Saving = B-A = 315 Dollars

4 0
4 years ago
On January 1, 2014, Evers Company purchased the following machine for use in its production process:
iren2701 [21]

Answer:

a) Calculate the amount of depreciation expense that Evers should record each year of its useful life under the following assumptions. Show your workings.

(1) Straight-line method

depreciable value = $180,000 - $10,000 = $170,000 / 4 = $42,500 per year (same for each year)

(2) Double declining balance method

depreciation expense year 2014 = $180,000 x 1/4 x 2 = $90,000

depreciation expense year 2015 = $90,000 x 1/4 x 2 = $45,000

depreciation expense year 2016 = $45,000 x 1/4 x 2 = $22,500

depreciation expense year 2017 = $22,500

(3) Units-of-activity method and estimates that the useful life of machine is 125,000 units. Actual usage is as follows: 2014, 45,000 units; 2015, 35,000 units; 2016, 25,000 units; 2017, 20,000 units.

depreciation expense per unit = $170,000 / 125,000 units = $1.36

depreciation expense year 2014 = $1.36 x 45,000 = $61,200

depreciation expense year 2015 = $1.36 x 35,000 = $47,600

depreciation expense year 2016 = $1.36 x 25,000 = $34,000

depreciation expense year 2017 = $1.36 x 20,000 = $27,200

b) Which method used to calculate depreciation reports the highest amount of depreciation expense in year 1?

double declining balance

The highest in year 4?

straight line method

The highest total amount over the 4-year period?

double declining balance

5 0
3 years ago
Other questions:
  • It is known that roughly 2/3 of all human beings have a dominant right foot or eye. is there also right-sided dominance in kissi
    15·1 answer
  • Soccer players are expected to congratulate and shake hands with the opposing team, even when their team loses the game and they
    6·1 answer
  • Gretta is observing and interviewing several database administrators to determine the duties and responsibilities associated wit
    15·1 answer
  • Help please.........
    5·2 answers
  • Question:
    10·1 answer
  • Assume all excavators delivered in 2018 are delivered at year end, calculateTGX’s 2018 revenue based on the transactions describ
    14·1 answer
  • Using aggregate supply and demand curves drawn according to the Keynesian view, which of the following will occur if the Fed buy
    14·1 answer
  • A 20-tooth spur pinion has a diametral pitch of 8, runs at 1200 rev/min, and drives a gear at a speed of 400 rev/min. Find the n
    9·1 answer
  • You own a bond with a 6 percent coupon rate and a yield to call of 6.90 percent. the bond currently sells for $1,070. if the bon
    5·1 answer
  • What should you do when the job you interviewed for is not what you wanted?
    13·2 answers
Add answer
Login
Not registered? Fast signup
Signup
Login Signup
Ask question!