Determine the maximum christmas card sales

Reference no: EM13820119

1. In cell G6 write a formula giving Ann's total sales using the SUM function.

2. Drag the formula in G6 to cells G7:G10. Did this give the right values for Bob's, Charles's, David's, and Ellen's total sales?

3. Without using the SUM function, enter a formula in cell B11 giving the total sales of boxes of Christmas cards.

4. Drag the formula in cell B11 to cells C11:F11. Did this give the right values for total sales of boxes of Birthday, All Occasion, Thank You, and Mixed cards?

5. In cell B12, enter a formula for the total profit made by these five persons selling Christmas cards. Do not enter any numbers, only cell references.

6. Drag the formula in cell B12 to cells C12:F12. Did this give you the right values for the total profit on boxes of Birthday, All Occasion, Thank You, and Mixed cards?

7. Using the SUMPRODUCT function, enter a formula in cell H6 giving Ann's total profit from selling all types of cards.

8. Drag the formula in H6 to cells H7:H10. Do not enter any numbers, only cell references. Did this give the right values for Bob's, Charles's, David's, and Ellen's total profit from selling all types of cards? If not, it is because you did not use absolute addresses for the profits per box. If that is the case, go back to cell H6. In the formula bar, highlight each unit profit and use the F4 key to make the reference absolute. After making all the references to unit profits absolute, now drag the formula in H6 to cells H7:H10. Now, did this give the right values for Bob's, Charles's, David's, and Ellen's total profit from selling all types of cards?

9. In cell B13, use the MAX function in order to determine the maximum Christmas card sales.

10. Drag the formula in cell B13 to cells C13:F13. Did this give the maximum values of Birthday, All Occasion, Thank You, and Mixed card sales?

11. In cell IS enter "Most Christmas Sales." In cell 16, enter an IF statement that will compare Ann's Christmas card sales to the maximum value in cell B13. If it is equal to this value, Ann's name (the entry in cell A6) should be printed in 16; otherwise, nothing should be printed-this is accomplished by entering " ".

12. Make sure the reference to cell B13 is absolute in the formula in the IF statement formula in cell 16. Drag cell 16 formula down to 17:110. Did it print the person with the most Christmas card sales?

13. Instead of the profit per box values in row 4, assume that Ann's profit is calculated as follows: 0.12(Christmas Cards Sales)2 + 0.02(Birthday Card Sales)3 +

3.50V(All Occasion Card Sales) + 0.05(Thank You Card Sales) * (Mixed Card Sales). In cell C15, determine Aim's total profit.

14. In cell C16, use an IF statement that compares Ann's profit using the new method proposed in problem 33 (given in cell Cl 5) with that of the old method proposed in problem 27 (given in cell 146). If the new profit is higher, "NEW' should be printed in cell C16; otherwise, "OLD" should be printed in the cell.

15. Suppose we wish to calculate the sum of all Mixed card sales of those persons who sold less than 20 boxes of Christmas cards. In cell C19, use a SUMIF command to determine this quantity.

Attachment:- greeting_cards_sales.xls

Reference no: EM13820119

Questions Cloud

Question regarding the budgetary variance model : Prior to completing this assignment, review Assignment of your course text. Prepare an evaluation of the performance of the Radiology Department Manager for a hospital.

Description of e-marketing process or program : Description of e-marketing process/program critical success factor(s): The actual Cyber-Health e-marketing advantages derived from incorporating the identified benchmark(s)

Which sites seem most useful for a job seeker : For the occupation and job of your choice, search the Net for employment opportunities. Which sites seem most useful for a job seeker in this occupational area?

Determine the annual worth of the purchase : At an interest rate of 10% per year compounded semiannually, determine the annual worth of the purchase over a 10 year amortization period.

Determine the maximum christmas card sales : Write a formula giving Ann's total sales using the SUM function - Determine the maximum Christmas card sales.

Why you think requirements analysis process is so diffcult : Why do you think the requirements analysis process is so difficult

Why is it controversial at the present time : What is Affirmative action? Why is it controversial at the present time? Using your personal experience and the course material, make a case either in favor or against the statement.

Production of chocolate bars : Compute the multifactor productivity measure for each of the weeks shown for production of chocolate bars. Assume 40-hour weeks and an hourly wage of $14. Overhead is 1.5 times weekly labor cost. Material cost is $9 per pound.

Assess how these segments affect the corporation : Choose the two (2) segments of the general environment that would rank highest in their influence on the corporation you chose. Assess how these segments affect the corporation you chose and the industry in which it operates

User Account

All Pages