The Jupiter Candy Company wants to calculate (1) discounted order costs for its Halloween promotional discounts...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
The Jupiter Candy Company wants to calculate (1) discounted order costs for its Halloween promotional discounts and (2) summary statistics on the number of boxes ordered. 1. The discount percentage is based on (1) customer status either Ruby or Pearl and (2) the number of boxes ordered. The discount schedule is: Customer Status Boxes Ordered Discount Ruby 1999 or less 6% Ruby 2000 or more 8% Pearl Pearl 2999 or less 5% 3000 or more 7% This information is also given in the Discount Schedule table on the worksheet. Use logical functions in cells H4:H340 to calculate each customer's order cost after the discount has been applied. For example, if a customer is Ruby status, ordered 4,000 boxes, they would thus receive a discount of 8%. If the original order cost was $4,760 the discounted order cost would be 4, 760 (1-0.08) = 4, 760 0.92 = $4,379.20. 2. In the Boxes Ordered: Summary Statistics, use functions to retrieve the requested information. For example, cell K5 should give the total number of Bitterfinger boxes ordered by Pearl customers. Cell P10 should give the total number of Three Corn-husketeers orders (not boxes) by Ruby customers. Customer Customer ID Status Candy Brand C100 Ruby Bitterfinger Halloween Promotion Orders Boxes Discounted Ordered Price Order Cost Order Cost 4224 $1.19 $5,026.56 Boxes Ordered: Summary Statistics Pearl Customers Ruby Customers Total Boxes Candy Brand Ordered Average Boxes Ordered Number of Total Boxes Orders Average Boxes Number of Ordered Ordered Orders C101 Pearl Dorks C102 Pearl Spittles 1337 $1.64 $2,192.68 1397 $1.33 $1,858.01 Bitterfinger Dorks C103 Ruby Dorks 2033 $1.64 $3,334.12 Spittles C104 Ruby Dorks 462 $1.64 $757.68 Angry Rancher C105 Pearl Angry Rancher 273 $1.62 $442.26 Drees' Almond Butter Cups C106 Pearl Drees' Almond Butter Cups 4066 $1.98 $8,050.68 Three Corn-husketeers C107 Pearl Drees' Almond Butter Cups 2818 $1.98 $5,579.64 C108 Ruby Bitterfinger 4943 $1.19 $5.882.17 Discount Schedule C109 Pearl Drees' Almond Butter Cups 1775 $1.98 $3,514.50 Boxes Ordered C110 Ruby Three Corn-husketeers 3956 $1.34 $5,301.04 Customer Status C111 Ruby Three Corn-husketeers 51 $1.34 $68.34 Ruby Low 0 High Discount 1999 0.06 C112 Ruby Three Corn-husketeers 4566 $1.34 $6,118.44 Ruby 2000 Infinity 0.08 C113 Pearl Dorks 1994 $1.64 $3,270.16 Pearl 0 2999 0.05 C114 Ruby Three Corn-husketeers 2954 $1.34 $3,958.36 Pearl 3000 Infinity 0.07 C115 Pearl Dorks 1656 $1.64 $2,715.84 C116 Ruby Drees' Almond Butter Cups 3594 $1.98 $7,116.12 C117 Pearl Bitterfinger 3565 $1.19 $4,242.35 C118 Ruby Three Corn-husketeers 538 $1.34 $720.92 C119 Pearl Spittles 215 $1.33 $285.95 C120 Pearl Bitterfinger 4548 $1.19 $5,412.12 C121 Ruby Drees' Almond Butter Cups 3563 $1.98 $7,054.74 C122 Ruby Dorks 4101 $1.64 $6,725.64 C123 Ruby Dorks 1795 $1.64 $2,943.80 C124 Pearl Dorks 2653 $1.64 $4,350.92 C125 Ruby Bitterfinger 4056 $1.19 $4,826.64 C126 Ruby Bitterfinger 4735 $1.19 $5,634.65 C127 Pearl Angry Rancher 4839 $1.62 $7,839.18 C128 Ruby Drees' Almond Butter Cups 3588 $1.98 $7,104.24 The Jupiter Candy Company wants to calculate (1) discounted order costs for its Halloween promotional discounts and (2) summary statistics on the number of boxes ordered. 1. The discount percentage is based on (1) customer status either Ruby or Pearl and (2) the number of boxes ordered. The discount schedule is: Customer Status Boxes Ordered Discount Ruby 1999 or less 6% Ruby 2000 or more 8% Pearl Pearl 2999 or less 5% 3000 or more 7% This information is also given in the Discount Schedule table on the worksheet. Use logical functions in cells H4:H340 to calculate each customer's order cost after the discount has been applied. For example, if a customer is Ruby status, ordered 4,000 boxes, they would thus receive a discount of 8%. If the original order cost was $4,760 the discounted order cost would be 4, 760 (1-0.08) = 4, 760 0.92 = $4,379.20. 2. In the Boxes Ordered: Summary Statistics, use functions to retrieve the requested information. For example, cell K5 should give the total number of Bitterfinger boxes ordered by Pearl customers. Cell P10 should give the total number of Three Corn-husketeers orders (not boxes) by Ruby customers. Customer Customer ID Status Candy Brand C100 Ruby Bitterfinger Halloween Promotion Orders Boxes Discounted Ordered Price Order Cost Order Cost 4224 $1.19 $5,026.56 Boxes Ordered: Summary Statistics Pearl Customers Ruby Customers Total Boxes Candy Brand Ordered Average Boxes Ordered Number of Total Boxes Orders Average Boxes Number of Ordered Ordered Orders C101 Pearl Dorks C102 Pearl Spittles 1337 $1.64 $2,192.68 1397 $1.33 $1,858.01 Bitterfinger Dorks C103 Ruby Dorks 2033 $1.64 $3,334.12 Spittles C104 Ruby Dorks 462 $1.64 $757.68 Angry Rancher C105 Pearl Angry Rancher 273 $1.62 $442.26 Drees' Almond Butter Cups C106 Pearl Drees' Almond Butter Cups 4066 $1.98 $8,050.68 Three Corn-husketeers C107 Pearl Drees' Almond Butter Cups 2818 $1.98 $5,579.64 C108 Ruby Bitterfinger 4943 $1.19 $5.882.17 Discount Schedule C109 Pearl Drees' Almond Butter Cups 1775 $1.98 $3,514.50 Boxes Ordered C110 Ruby Three Corn-husketeers 3956 $1.34 $5,301.04 Customer Status C111 Ruby Three Corn-husketeers 51 $1.34 $68.34 Ruby Low 0 High Discount 1999 0.06 C112 Ruby Three Corn-husketeers 4566 $1.34 $6,118.44 Ruby 2000 Infinity 0.08 C113 Pearl Dorks 1994 $1.64 $3,270.16 Pearl 0 2999 0.05 C114 Ruby Three Corn-husketeers 2954 $1.34 $3,958.36 Pearl 3000 Infinity 0.07 C115 Pearl Dorks 1656 $1.64 $2,715.84 C116 Ruby Drees' Almond Butter Cups 3594 $1.98 $7,116.12 C117 Pearl Bitterfinger 3565 $1.19 $4,242.35 C118 Ruby Three Corn-husketeers 538 $1.34 $720.92 C119 Pearl Spittles 215 $1.33 $285.95 C120 Pearl Bitterfinger 4548 $1.19 $5,412.12 C121 Ruby Drees' Almond Butter Cups 3563 $1.98 $7,054.74 C122 Ruby Dorks 4101 $1.64 $6,725.64 C123 Ruby Dorks 1795 $1.64 $2,943.80 C124 Pearl Dorks 2653 $1.64 $4,350.92 C125 Ruby Bitterfinger 4056 $1.19 $4,826.64 C126 Ruby Bitterfinger 4735 $1.19 $5,634.65 C127 Pearl Angry Rancher 4839 $1.62 $7,839.18 C128 Ruby Drees' Almond Butter Cups 3588 $1.98 $7,104.24
Expert Answer:
Posted Date:
Students also viewed these finance questions
-
This assignment requires you to complete the 2022 tax reporting for a fictional woman named Anna Smith. Question 1 T1 - step 4 - line 66 This is Anna's taxable income Answer: Question 2 T1 - step...
-
The following additional information is available for the Dr. Ivan and Irene Incisor family from Chapters 1-5. Ivan's grandfather died and left a portfolio of municipal bonds. In 2012, they pay Ivan...
-
Burger Doodle is a fast-food restaurant that processes an average of 680 food orders each day. The average cost of each order is $6.15. Four percent of the orders are incorrect, and only 10% of the...
-
Multiple Choice Questions 1. Which expense, incurred and paid in 2014, can be claimed as a miscellaneous itemized deduction subject to the 2% of AGI floor? a. Self-employed health insurance. b....
-
1. Assume that the preference relation on a metric space X is continuous. Show that this implies that the sets > (y) = {x : x>y} and < (y) = {x : x (y) = {x : x>y} and < (y) = {x: x z0. a. Suppose...
-
How is the iterative nature of preparing financial forecasts significant? How long does the financial forecasting wheel need to turn before the financial forecasting process is complete?
-
Baker Machine Company Is a Job shop that specializes in precision parts for firms in the aerospace industry. Figure shows the current block plan for the key manufacturing centers of the...
-
Marigold Corp. lends Blossom Company $38400 on April 1, accepting a four-month, 15% interest note. Marigold Corp. prepares financial statements on April 30. What adjusting entry should be made before...
-
The table shows Frigidia's preferences. The marginal cost of producing a pair of skis is 2 kilograms of fish per month. Skis Willingness to pay (kilograms of fish per pair) (pairs per month) 25 75...
-
List the event number, customer name, plan number, employee name, facility name, work date, and activity for event plans. The result should show only event plans with a work date in October 2007. How...
-
Input the following names in the array in a stack (as shown in the class lecture) and print out the names in reverse order char* names[] = {"Aaron", "Alizia", "Andrew", "Anthony", "Ashleigh"}; This...
-
create a class that implements the Iterable interface use a for-each loop with an Iterable object define and analyze the Insertion Sort draw diagrams showing the effect of list operations for a...
-
Data science palindrome.py Using import sys: .Create a program, palindrome.py, that has a function that takes one string argument and prints a sentence indicating if the text is a palindrome. The...
-
Someone is climbing stairs daily and wants to understand the work and power they are putting into the activity. On day 1, they walk slowly up the stairs and it takes 8.8s. On day 2, they run up the...
-
Discuss the importance of and audit procedures used for: - The review for contingent liabilities and commitments, and - The review for subsequent events
-
PC Contractors, Inc., was an excavating business in Kansas City, Missouri. Union Bank made loans to PC, subject to a perfected security interest in its equipment and other assets, including...
-
Let \(X\) have a geometric distribution with \[P(X=i)=(1-p) p^{i} ; \quad i=0,1, \ldots ; 0
-
A random variable \(X\) has distribution function \[F_{\alpha}(x)=e^{-\alpha / x} ; \alpha>0, x>0\] (Frecht distribution). What distribution type arises when mixing this distribution with regard to...
-
The random variable \(X\) has distribution function \[F(x)=\frac{x}{x+1}, x \geq 0\] Check whether there is a subinterval of \([0, \infty)\) on which \(F(x)\) is \(D F R\) or \(I F R\).
Study smarter with the SolutionInn App