Question
In: Accounting
Richardson Ski Racing (RSR) sells equipment needed for downhill ski racing. One of RSR’s products is...
Richardson Ski Racing (RSR) sells equipment needed for downhill ski racing. One of RSR’s products is fencing used on downhill courses. The fence product comes in 150-foot rolls and sells for $215 per roll. However, RSR offers quantity discounts. The following table shows the price per roll depending on order size:
| Quantity Ordered | ||
| From | To | Price per Roll |
| 1 | 30 | $215 |
| 31 | 60 | $195 |
| 61 | 120 | $175 |
| 121 | and up | $155 |
Click on the datafile logo to reference the data.
| (a) | Use the VLOOKUP function with the preceding pricing table to determine the total revenue from these orders. | ||||||||||||||||||||||||
| $ | |||||||||||||||||||||||||
| (b) | Use the COUNTIF function to determine the number of orders in each price bin. | ||||||||||||||||||||||||
|
Solutions
ekkarill92 answered 1 year agoRelated Solutions
After leaving the end of a ski ramp, a ski jumper lands downhill at a point...
After leaving the end of a ski ramp, a ski jumper lands downhill
at a point that is displaced 60.9 m horizontally from the end of
the ramp. His velocity, just before landing, is 25.2 m/s and points
in a direction 31.4 ° below the horizontal. Neglecting air
resistance and any lift that he experiences while airborne, find
(a) the magnitude and (b) the direction of his initial velocity
when he left the end of the ramp.
Campfire Products sells camping equipment. One of the company's products, a camping lantern, sells for $100...
Campfire Products sells camping equipment. One of the company's
products, a camping lantern, sells for $100 per unit. Variable
expenses are $65 per lantern, and fixed expenses assoiciated with
the lantern total $140,000 per month.
A) Compute the company's break-even point in number of lanterns
and in total sales dollars.
B) At present, the company is selling 8,000 lanterns per month.
The sales manager is convinced that a 10% reduction in the selling
price will result in a 25% increase...
Big Country Ski Shop is a retail store that sells ski equipment and clothing. Big Country...
Big Country Ski Shop is a retail store that sells ski equipment
and clothing. Big Country Ski Shop commenced business on September
1, 2019. The firm purchases merchandise on open account. The firm’s
purchases, purchase returns and allowances, and cash payments on
account during September 2019 follow:
DATE
TRANSACTIONS
2019
Sept.
2
Purchased ski boots for $5,200 plus a freight charge of $250
from Colorado Ski Shop, Invoice 6672, terms n/30.
3
Purchased skis for $10,800 from Alaska Supply Company,...
Big Country Ski Shop is a retail store that sells ski equipment and clothing. Big Country...
Big Country Ski Shop
is a retail store that sells ski equipment and clothing. Big
Country Ski Shop commenced business on September 1, 20X1. The firm
purchases merchandise on open account. The firm’s purchases,
purchase returns and allowances, and cash payments on account
during September 20X1 follow:
DATE
TRANSACTIONS
20X1
Sept.
2
Purchased ski
boots for $6,100 plus a freight charge of $260 from Colorado Ski
Shop, Invoice 6672, terms n/30.
3
Purchased skis
for $11,700 from Alaska Supply Company,...
Big Country Ski Shop is a retail store that sells ski equipment and clothing. Big Country...
Big Country Ski Shop is a retail store that sells ski equipment
and clothing. Big Country Ski Shop commenced business on September
1, 2019. The firm purchases merchandise on open account. The firm’s
purchases, purchase returns and allowances, and cash payments on
account during September 2019 follow:
DATE
TRANSACTIONS
2019
Sept.
2
Purchased ski boots for $5,100 plus a freight charge of $160
from Colorado Ski Shop, Invoice 6672, terms n/30.
3
Purchased skis for $10,700 from Alaska Supply Company,...
Big Country Ski Shop is a retail store that sells ski equipment and clothing. Big Country...
Big Country Ski Shop is a retail store that sells ski equipment
and clothing. Big Country Ski Shop commenced business on September
1, 2019. The firm purchases merchandise on open account. The firm’s
purchases, purchase returns and allowances, and cash payments on
account during September 2019 follow: DATE TRANSACTIONS 2019 Sept.
2 Purchased ski boots for $5,900 plus a freight charge of $240 from
Colorado Ski Shop, Invoice 6672, terms n/30. 3 Purchased skis for
$11,500 from Alaska Supply Company,...
Big Country Ski Shop is a retail store that sells ski equipment and clothing. Big Country...
Big Country Ski Shop is a retail store that sells ski equipment
and clothing. Big Country Ski Shop commenced business on September
1, 2019. The firm purchases merchandise on open account. The firm’s
purchases, purchase returns and allowances, and cash payments on
account during September 2019 follow:
DATE
TRANSACTIONS
2019
Sept.
2
Purchased ski boots for $5,000 plus a freight charge of $150
from Colorado Ski Shop, Invoice 6672, terms n/30.
3
Purchased skis for $10,600 from Alaska Supply Company,...
Big Country Ski Shop is a retail store that sells ski equipment and clothing. Big Country...
Big Country Ski Shop is a retail store that sells ski equipment
and clothing. Big Country Ski Shop commenced business on September
1, 2019. The firm purchases merchandise on open account. The firm’s
purchases, purchase returns and allowances, and cash payments on
account during September 2019 follow:
DATE
TRANSACTIONS
2019
Sept.
2
Purchased ski boots for $4,800 plus a freight charge of $290
from Colorado Ski Shop, Invoice 6672, terms n/30.
3
Purchased skis for $10,400 from Alaska Supply Company,...
Big Country Ski Shop is a retail store that sells ski equipment and clothing. Big Country...
Big Country Ski Shop is a retail store that sells ski equipment
and clothing. Big Country Ski Shop commenced business on September
1, 2019. The firm purchases merchandise on open account. The firm’s
purchases, purchase returns and allowances, and cash payments on
account during September 2019 follow:
DATE
TRANSACTIONS
2019
Sept.
2
Purchased ski boots for $4,600 plus a freight charge of $310
from Colorado Ski Shop, Invoice 6672, terms n/30.
3
Purchased skis for $10,200 from Alaska Supply Company,...
In a downhill ski race surprisingly little advantage is gained by getting a running start. This...
In a downhill ski race surprisingly little advantage is gained
by getting a running start. This is because the initial kinetic
energy is small compared with the gain in gravitational potential
energy even on small hills. To demonstrate this, find the final
speed and the time taken for a skier who skies 75.0 m along a 30°
slope neglecting friction for the following two cases. (Note that
this time difference can be very significant in competitive events
so it is...
ADVERTISEMENT
ADVERTISEMENT
Latest Questions
- What are some causes for widespread usage of high frequency trading?
- Acme Computing Corp. has remote sites in Port Clinton and Napoleon in addition to their main...
- Why are the measurement concepts of reliability and validity important to the research process? What dangers...
- 1. Write the SQL code required to list the employee number, first and last name, middle...
- A circular coil of wire with radius 4 cm and 20 turns is placed in a...
- 7. Indri runs a soil testing business. He decides to form a company to take over...
- Pearl Products Limited of Shenzhen, China, manufactures and distributes toys throughout South East Asia. Three cubic...
ADVERTISEMENT