# 3. COPY YOUR HOTDOG WORKSHEET to another worksheet called “Quantity” (right-click, move or copy, check the “create a copy” box, select “(move to end)”, and click “OK”). On this new worksheet, help Daisy with the following https://d2vlcm61l7u1fs.cloudfront.net/media%2F007%2F0076e4c4-c0ee-4ed8-b61b-0dbca9849655%2FphphLClP9.png ales have increased to 350 hotdogs per sale day and the hotdog wholesaler is now offering Daisy some quantity discounts when certain order minimums are reached. The prices shown are in cents per hotdog. Daisy wants something into which Madison could enter the minimum quantity and cost for each quantity break point and have it compute the best order amount, carrying cost at that amount, order cost, production cost, and total overall cost. Madison suggested the following. Many of the costs actually have decimals, but Daisy wanted them re-formatted (without actually changing the values) because it’s hard for Daisy to count change with paws. [note: format, don’t round]. Madison also added a note so that it was clear which one Daisy should choose because, well, she’s a dog. a) Modify the “Quantity” sheet to include the following table into which Madison can enter the minimum quantities and their respective prices and have other items computed, including “N/A” where appropriate and the “ Daisy choose this one” note to Daisy as shown below. https://d2vlcm61l7u1fs.cloudfront.net/media%2Fbe9%2Fbe9ac2d0-dfc4-4d42-9b29-644d4cd2bb72%2FphpQEiJpQ.png b) Daisy’s hotdog sales keep improving and eventually they’re running 200 hotdog sale days per year and averaging 430 hotdogs per day. The wholesaler is shipping nearly full container of hotdogs to the city each trip, would love increase that to a full container, and also would benefit from a little advertising by supporting this worthy cause. As a result, Daisy is offered a quantity break for 10,000 hotdogs at a time for only 5 cents apiece or only a penny each if she’ll buy 12,000 in each order. Modify the above table to include these new price breaks to help Daisy determine how many hotdogs to purchase

3. COPY YOUR HOTDOG WORKSHEET to another worksheet called “Quantity” (right-click, move or copy, check the “create a copy” box, select “(move to end)”, and click “OK”). On this new worksheet, help Daisy with the following
https://d2vlcm61l7u1fs.cloudfront.net/media%2F007%2F0076e4c4-c0ee-4ed8-b61b-0dbca9849655%2FphphLClP9.png

ales have increased to 350 hotdogs per sale day and the hotdog wholesaler is now offering Daisy some quantity discounts when certain order minimums are reached. The prices shown are in cents per hotdog.

Daisy wants something into which Madison could enter the minimum quantity and

AllEscort