Drew manages a local gift shop that sells a handcrafted chocolate, Lulu's Maca Buttercup. In the season leading up to Halloween, Drew likes to carry the pumpkin-shaped buttercups with Halloween decor on the package.

Drew sells the buttercups for $5.00 per package.

Drew purchases the buttercups from Lulu's which are available only by the box - there are 12 packages of chocolates in a box. And the gift shop must order only a counting number of boxes (i.e. CANNOT order 3.5 boxes)

If Drew orders a dozen (1 box) the cost is $4.00 per package. If they order 2 boxes, the cost is $3.70 per package. If they order 3 dozen the cost is $3.40/package. Finally, if the order is 4 boxes or more the cost drops to $5.00/package.

Ordering for the holidays is always challenging and more challenging this year. The buttercups generally sell well from the 1st of October until Black Friday during Thanksgiving weekend. On Black Friday, Drew drops the price to $2.00 per package.

Drew looked at the gift shop's records from last year. They sold 30 packages (2 1/2 boxes).

a) Create a spreadsheet for Drew to use to calculate the profit from buttercups. This spreadsheet should be able to take demand between 10 and 48 packages and order quantity between 1 and 5 boxes. Be sure to use best practices for spreadsheets as we've talked about in class. For the most credit, do not use any IF functions.

b) Identify and label which variable or variables are decision variable(s).

c) What is the profit if Drew orders 2 boxes and the demand is 20 packages?

d) Create a data table for order quantity of from 1 to 5 boxes and demand of between 10 and 50 packages (by 5s).