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 2 years 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.
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 50.0 m horizontally from the end of
the ramp. His velocity, just before landing, is 24.0 m/s and points
in a direction 34.1 ° 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,...
ADVERTISEMENT
ADVERTISEMENT
Latest Questions
- Find out whether or not the integer pairs are relatively prime: (8, 15), (6, 50), (3,...
- Compute additive and multiplicative inverses of 7 and 9 in Z11 (mod 11). Find out whether...
- IN C++ PLEASE. Use ONLY: exception handling, read and write files, arrays, vectors, functions, headers and...
- 4. Bond yields Coupon payments are fixed, but the percentage return that investors receive varies based...
- 1) An electron has a kinetic energy that is 50% larger than its classical kinetic energy....
- Write in C Language Write all these code in one program and upload. Consider this array...
- 1. When comparing the future value of two investments: one that earns 6% p.a. simple interest...
ADVERTISEMENT