please answer this question The attached Lego Inventory Worksheet has a list of all Lego kits in our inventory of toys.

[answerhappygod]

please answer this question
The attached Lego Inventory Worksheet has a list of all
Lego kits in our inventory of toys. The Annual Cost of Goods
Sold is the amount in dollars sold for an entire year (365 days)
for each item. You will need to compute the Daily Cost of
Goods Sold for each item. The Inventory Level $ is the dollar
value currently in inventory for each item. Compute the Days
on Hand for each Lego kit. This is the number of days that we
anticipate our inventory level will last before we need another
delivery from the factory. Identify the kits with over 93 Days on
Hand (over 3 months supply in inventory). Use conditional
formatting and highlight in Green. We do not want to carry too
much inventory Identify the kits with less than 2 Days on Hand (We
will run out tomorrow). Use conditional formatting and highlight in
Red We do not want to run out of items that customers are buying.
Executive Summary, identify the items we have too much of in
stock and recommend what we should do with those kits. Also,
identify which items we are about to run out of and what we should
do in the future with those kits. Calculate what your suggestions
would do to costs based on the following. If you increase and/or
decrease inventory calculate the annual cost based on carrying cost
of 25%. If you increase your average inventory by $100 your
carrying cost would increase by $25 on this item. If you reduce
your average inventory by $100 on an item you would reduce carrying
cost by $25. Many other costs could be incurred due to lost
customers, lost profit from lost sales etc but we do not have the
information to include these costs in this problem