answer.
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
9966 [12]
2 years ago
3

Currently, customers are responsible for paying the shipping costs. The sales team suggests that customers really dislike paying

shipping costs, and that offering "free shipping" instead of the 1% discount would likely increase sales. Create a formula for the "Sales with Free Shipping" column that subtracts the "Shipping Cost" from the "Sales" only if the "Expanded Order Type" is Extra Large, XX Large, or XXX Large. Copy the formula down to all the rows. What would total 2012 sales have been if the company had offered free shipping instead of the 1% discount (rounded to 2 decimal places)?
Business
1 answer:
Nikitich [7]2 years ago
6 0

Answer:

=if(Or(type = "Extra Large";type = "XX Large";type = "XXX Large");0;shipping cost)

Explanation:

While I cannot do exact reference to your excel shet I can tell you how to build the formula

you will use and if function to determinate wether the request fullfil or not the condition.

As there are several condition we use the Or function.

the "type" will be the cell on which you can reference the order side of a particular sale

Then, we write zero if positive (fulfil the criteria to get free shipping)

Then, you write the shipping cost. which is a number value

for example

         1              2              3              4               5

A     size   extra large   =if(Or(A2= "Extra Large";A2= "XX Large";A2= "XXX Large");0;shipping cost)

You might be interested in
Businesses commonly rely upon groups to make decisions because of the many advantages to group decision making. Which of the fol
Andrei [34K]

Answer:

Almost every other business in this universe now relies upon group thinking rather than individual approach to anything.

It has several advantages, some of them are pointed out below:

o) Equality bias, when there are group discussion, this means that everyone has a part of say in the final decision and that leads to equality bias, which is beneficial.

o) More alternatives are generated, it is a fact that when an individual takes a decision, he/she is neglecting a lot of other options to explore which could be a lot beneficial for the business.

o) More acceptance of the final decision, Since the final decision taken is with the approval and consent of everyone, there is a possibility that the final decision will be more acceptable.

o) Lastly, It creates Synergy, synergy is the idea that a decision as a whole is better than in parts.

Hope this helps you. Good Luck.

3 0
2 years ago
Resources are adequate, but demand varies widely over the life of the project. Delaying noncritical activities to lower peak dem
-BARSIC- [3]

Answer:

resource smoothing

Explanation:

According to the definition provided in the question we can say that this is regarding resource smoothing. Like mentioned in the question this term refers to a management technique that adjusts the resources so that the requirements do not surpass the resource limits that the company has specified, by delaying the noncritical activities in order to allow for the important ones first.

If you have any more questions feel free to ask away at Brainly.

3 0
2 years ago
Theo currently owns 700 shares of JKL, which is an all-equity firm with 320,000 shares of stock outstanding at a market price of
valentina_108 [34]

Answer:

correct option is c. 43.75

Explanation:

given data

share own = 700

stock outstanding = 320000

market price = $25

interest and taxes =  $160,000

debt = $500,000

interest = 7%

loan = 7.5 percent interest

to find out

How many shares of JKL stock must Theo sell to unlever

solution

first we get here no of share that repurchased is express  as

no of share =  \frac{debt}{market\ price}     ..............1

no of share =  \frac{500000}{25}

no of share = 20,000 shares

sell = share own × ( no of share ÷ stock outstanding  )    .................2

sell = 700 × \frac{20000}{320000}

sell = 43.75 shares

so correct option is c. 43.75

6 0
2 years ago
Which of the following is true of entrepreneurial organizational structures? Choose all that apply.
iragen [17]

Answers are: 
<span>They are flat
A single leader makes most decisions 
Roles are undefined 
</span>They are common to small businesses
In an entrepreneurial business structure, the owner-manager makes almost all decisions and performs various roles within the company. He interacts directly with the few employees he has, often performing roles that would be "beneath" the CEO of a larger company. This is called a flat organizational structure.
Roles are not generally well defined, as there are not enough employees for the level of specialization that larger companies would have. These are common features of a small business, often in the start-up phase. 
7 0
2 years ago
The owner of Marshall Restaurant is disappointed because the restaurant has been averaging 7 comma 500 pizza sales per​ month, b
dybincka [34]

Answer:

\left[\begin{array}{ccccc}$Concept&$Base&6,000&7,500&10,000\\$Sales&6.25&37,500&46,875&62,500\\$Variable&-1.55&-9,300&-11,625&-15,500\\$Fixed&12,000&-12,000&-12,000&-12,000\\$Income&&16,200&23,250&35,000\\$Average per pizza&&2.7&3.1&3.5\\\end{array}\right]

Explanation:

Question elaborate budget for the range of 6,000 // 7,500 and 10,000 units considering the selling price per Pizza is 6.25 dollars.

a) we multiply the sales per unit by each volume sales

b) sale idea but with the variable cost

c) we also subtract the fied cost.

d) This give us the income on each volume.

Finally we also divide by the numbers of unit to determinate the gain per pizza.

4 0
2 years ago
Other questions:
  • Consider the following​ situation, which involves two options. Determine which option is less expensive. Are there unstated fact
    13·1 answer
  • You’ve just received a complaint from your best customer that her set of 50 new sensors is overheating and she wants her money b
    15·1 answer
  • Most operating decisions of management focus on a narrow range of activity called the______________.
    15·1 answer
  • Suppose an ocean-front hotel rents rooms. In the winter, demand is: P_1 = 80 - 2Q_1 with marginal revenue of: MR_1 = 80-4Q_1. Ho
    5·1 answer
  • What information appears on a designer worksheet? A. designer portfolio, previous work, and sample designs B. details of the com
    9·1 answer
  • Which one of the following is least helpful to company managers in deciding what to consider and what to do to improve their com
    15·1 answer
  • Rondelle, the manager of a busy hair salon, knows that she needs to entrust many of her tasks to supervisors and other employees
    13·1 answer
  • Farrar Corporation has two major business segments-Consumer and Commercial. Data for the segment and for the company for March a
    6·1 answer
  • Larry recently invested $24,400 (tax basis) in purchasing a limited partnership interest in which he will have no management rig
    13·1 answer
  • On average, it takes one packaging and shipping employee 15 minutes to prepare a package and label, independent of the number or
    11·1 answer
Add answer
Login
Not registered? Fast signup
Signup
Login Signup
Ask question!