Business, 14.03.2022 03:40 issaaamiaaa15

9. In cell B15, enter a formula that uses the IF function and tests whether the total sales for Q1 (cell B8) is greater than or equal to 1000000. If the condition is true, multiply the total sales for Q1 by 0.18 to calculate a commission of 18%. If the condition is false, multiply the total sales for Q1 by 0.10 to calculate a commission of 10%.

Answers: 1

Show answers

Another question on Business

Business, 22.06.2019 00:10

What are the forecasted levels of the line of credit and special dividends? (hints: create a column showing the ratios for the current year; then create a new column showing the ratios used in the forecast. also, create a preliminary forecast that doesn’t include any new line of credit or special dividends. identify the financing deficit or surplus in this preliminary forecast and then add a new column that shows the final forecast that includes any new line of credit or special dividend.) now assume that the growth in sales is only 3%. what are the forecasted levels of the line of credit and special dividends?

Answers: 1

Answer

Business, 22.06.2019 03:00

Fanning books buys books and magazines directly from publishers and distributes them to grocery stores. the wholesaler expects to purchase the following inventory: april may june required purchases (on account) $ 111,000 $ 131,000 $ 143,000 fanning books accountant prepared the following schedule of cash payments for inventory purchases. fanning books suppliers require that 85 percent of purchases on account be paid in the month of purchase; the remaining 15 percent are paid in the month following the month of purchase. required complete the schedule of cash payments for inventory purchases by filling in the missing amounts. determine the amount of accounts payable the company will report on its pro forma balance sheet at the end of the second quarter.

Answers: 2

Answer

Business, 22.06.2019 05:10

Suppose that the free states of eldricia, a small nation, has consumption, investment, government purchases, imports, and exports as follows. consumption $140 investment $50 government purchases $45 imports $30 exports $15 calculate the free states of eldricia's gdp

Answers: 2

Answer

Business, 22.06.2019 16:00

Advanced enterprises reports year-end information from 2018 as follows: sales (160,250 units) $968,000 cost of goods sold 641,000 gross margin 327,000 operating expenses 263,000 operating income $64,000 advanced is developing the 2019 budget. in 2019 the company would like to increase selling prices by 14.5%, and as a result expects a decrease in sales volume of 9%. all other operating expenses are expected to remain constant. assume that cost of goods sold is a variable cost and that operating expenses are a fixed cost. should advanced increase the selling price in 2019?

Answers: 3

Answer

You know the right answer?

9. In cell B15, enter a formula that uses the IF function and tests whether the total sales for Q1 (...

Questions