A Retailer Tracks List Prices and Discounts in an Excel

question 25

Multiple Choice

A retailer tracks list prices and discounts in an Excel spreadsheet so owners can analyze how different sales will affect the company's bottom line. One item in Cell B4 has a list price of $172.89. Varying rates for discount 1 and discount 2 can be entered into Cells B5 and B6. Which formula should be entered into Cell B7 to calculate the net-price equivalent?

• A) =B4*B5*B6
• B) =B4*(1-B5)*(1-B6)
• C) =1-(B5+B6)
• D) =(1-B5)*(1-B6)

Relate the concept of marginal product to the determination of factor prices, including rent, interest, and profit.

Understand how the supply of one factor of production can impact the earnings and productivity of other factors.

Comprehend the effects of market changes on the marginal productivity of land, labor, and capital.

Identify the circumstances under which wages and rent are determined in the labor and land markets.

---

Definitions:

Possession

The state or fact of owning or having control of something.

Public Notice

An announcement conveyed through accessible channels to inform the public about legal actions, government activities, or public interest issues.

Collateral

Property or assets that a borrower offers to a lender as security for a loan, which can be seized if the loan is not repaid according to agreed terms.

Public Filing

The process of submitting financial documents and other important corporate information to a regulatory authority for public disclosure.