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 3 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
- 1. Creep is one of deformation that occurred in concrete structure. Give one example that can...
- Why does a particular codon represent only one specific amino acid?
- Write a function template sort that takes two references to generic objects and switches them if...
- What 2 things happen to the melting point of a solid when an impurity is present?
- How Can Hominin Evolution be characterized as " mosaic evolution" Use examples of species from the...
- Absorption and Variable Costing Income Statements for Two Months and Analysis During the first month of...
- Mobile and wireless devices are being increasingly used in the Business Administration and Management Industry. write...
ADVERTISEMENT