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
9966 [12]
4 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]4 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
A bank service charge of $10 would be included on the bank reconciliation as a(n):_____.
iris [78.8K]

A bank service fee of $10 would be included on the bank reconciliation as on the last day of the bank statement

<h2>What exactly does a bank reconciliation include?</h2>

Starting with the bank's ending cash balance, adding any deposits that are currently being made up of the company to the bank, subtracting any checks that haven't yet been cleared by the bank, then either adding or subtracting any other items completes the basic process flow for a bank reconciliation.

<h3>A bank reconciliation is what?</h3>

At the conclusion of every month, a business should perform a bank reconciliation, which is that the process of confirming the correctness of both the bank statement and the cash accounts.

The most frequent reasons why the ending bank balance and ending book balance of cash differ.

Learn more about bank reconciliation :

brainly.com/question/15525383

#SPJ4

7 0
2 years ago
Maxim manufactures a hamster food product called Green Health. Maxim currently has 10,000 bags of Green Health on hand. The vari
SVEN [57.7K]

Answer:

$6,655

Explanation:

Variable cost per bag = $3.70

Total fixed cost = $10,000

Unit selling price before further processing = $9.05

No of bags = 10,000

Contribution per bag = 9.05-3.7 = $5.35

Total revenue = 9.05*10,000= $90,500

Net income =90500-(10,000+37000 )= 43500

Incremental cost =2100

Incremental revenue( 10,000*8.05) + (3100*6.05)

80500 + 18755 = $99255

Net income  = 99255 - (2100+47000)= 50155

Financial advantage = 50155-43500=6655

5 0
3 years ago
On January 1, 2020, Waterway Company purchased 11% bonds, having a maturity value of $312,000 for $336,270.95. The bonds provide
mafiozo [28]

Answer and Explanation:

The journal entries are shown below:

1. 11% bonds payable $336,270.95

         To cash  $336,270.95

(Being the bond purchased for cash is recorded)

2. Cash ($312,000 × 11%)      $34,320

       To Interest revenue ($336,270.95 × 9%) $30,264

       To 11% bond payable $4,056

(Being the interest revenue is recorded)

Fair value adjustment $1,685.05

       To Unrealized gain $1,685.05

(Being the recognition of fair value is recorded)

It is computed below:

= (333,900 - ($336,270.95 - $4,056) )

3. Unrealized gain $13,000     ($333,900 - $320,900)

            To fair value adjustment $13,000

(Being the  recognition of fair value is recorded)

8 0
4 years ago
Which is cheaper: eating out or dining in? the mean cost of a flank steak, broccoli, and rice bought at the grocery store is $13
Daniel [21]

Answer:

H_o: \mu \geq 13.04\\H_{\alpha}: \mu \geq 13.04

b) 0.0751

c) We cannot afirm whether eating out or dinning in is cheaper

d) do not reject neither.

<u>Questions:</u>

(a). Develop appropriate hypotheses for a test to determine whether the sample data support the conclusion that the mean cost of a restaurant meal is less than fixing a comparable meal at home.

(b). Using the sample from the 100 restaurants, what is the p -value?

(c). At α = .05 ,what is your conclusion?

(d). Repeat the preceding hypothesis test using the critical value approach

Explanation:

(b)

\frac{X-\mu}{\sigma \sqrt{n} } = P_v\\\frac{12.75-13.04}{2 \sqrt{100} } = -1.45

We use excel function to get the Pz which is .0751

(c). 0.0751 > .05 , We cannot reject the hypotesis. Thus, we can neither say dinning in is more cheap nor eating out is cheaper.

(d). With = 99 , t .05 = −1.66 Reject H 0 if ? ≤ −1.66 −1.45 > −1.66 , do not reject

Degrees of freedom = n − 1 = 99 and Pz of 0.05 = -1.66

Reject when Pz < of -1.66

-1.45 > 1.66 threfore we cannot reject the hypotesis.

8 0
3 years ago
A market that is efficient has which of the following features
iogann1982 [59]

Answer: Option D

               

Explanation: In financial economics, the effective-market theory is a theory that asset values represent all available data. Strong inference is that this is difficult to reliably "outperform the market" on a threat-adjusted basis because market rates will respond only to new data.

           Thus, consumer valuation is always taken into consideration as the prices are determined by the m,market forces which are dependent on consumer valuation.

In such markets resources are allocated to most efficient firms who are capable to make maximum output result.

7 0
4 years ago
Other questions:
  • Describe ways in which an interpersonal learner prefers to learn.
    15·1 answer
  • Which technique might a scrummaster use to facilitate communication between the development team and the product owner?
    11·1 answer
  • Prom Night Formal Wear has the following stockholders' equity accounts at December 31, 2018: Common Stock, $1 par value, 1,200,0
    10·1 answer
  • To sell to Joann, you need to appeal to her ego. She'd rather hear that your new product will make people notice her as an innov
    11·1 answer
  • Cream and Crimson Foods has a target capital structure of calling for 45.00 percent debt, 4.00 percent preferred stock, and 51.0
    12·2 answers
  • Simplify:<br><br>a. (-18x2y)/(3x)<br><br>b. (x-4) (x-1) - 4(x-3) (x+2)​
    11·2 answers
  • $5,000,000, 12% bonds for $5,325,000. The market rate of interest for these bonds is 10%. Interest is payable annually on Decemb
    11·1 answer
  • Currency $1,000 Checking Account Balances $2,000 Savings Account Balances $5,000 Small-Denomination Time Deposits $6,000 Non-Ins
    7·1 answer
  • The growth rate is a measure of the rate at which a countrya's population is increasing. Please select the best answer from the
    14·1 answer
  • out of the over 700,000 construction firms in united states the majority are which of the following business types? question 3 o
    15·1 answer
Add answer
Login
Not registered? Fast signup
Signup
Login Signup
Ask question!