K
Kat
I have Excel 2003 and am taking a Statistics class that requires me to do the
following:
There are two companies that sell widgets. Both companies sell the widgets
to the general public for the same price. In order to earn business, Company
A offers a special 25% discount on each order. In response, Company B offers
a 35% discount on every dollar the customer spends over $50. Both discounts
are rounded to the nearest cent. If you place an order for $50 or less, it is
less expensive to order from Company A. If you place a large enough order, it
will be less expensive to order from Company B. At what price does it become
less expensive to order from Company B?
.. Create and properly label a table of data demonstrating this technique.
The table should include at least four hypothetical orders and should
estimate the answer within a $50 range. Each row will represent a
hypothetical order. The first row will represent a $50 order and each
additional row will represent orders in $50 increments (i.e., $100, $150).
The table should include three columns. The first column is the order amount,
the second column is the discount that Company A would give, and the third
column is the discount Company B would give.
This is where I am lost! I am new to using Excel, but need to learn!!
Problem is I have to have this task in before I can take a class. Can
someone please help walk me through this? I would be so very greatful!!
Kat-Cornfused about Excel
following:
There are two companies that sell widgets. Both companies sell the widgets
to the general public for the same price. In order to earn business, Company
A offers a special 25% discount on each order. In response, Company B offers
a 35% discount on every dollar the customer spends over $50. Both discounts
are rounded to the nearest cent. If you place an order for $50 or less, it is
less expensive to order from Company A. If you place a large enough order, it
will be less expensive to order from Company B. At what price does it become
less expensive to order from Company B?
.. Create and properly label a table of data demonstrating this technique.
The table should include at least four hypothetical orders and should
estimate the answer within a $50 range. Each row will represent a
hypothetical order. The first row will represent a $50 order and each
additional row will represent orders in $50 increments (i.e., $100, $150).
The table should include three columns. The first column is the order amount,
the second column is the discount that Company A would give, and the third
column is the discount Company B would give.
This is where I am lost! I am new to using Excel, but need to learn!!
Problem is I have to have this task in before I can take a class. Can
someone please help walk me through this? I would be so very greatful!!
Kat-Cornfused about Excel