I ideally need this in Excel/spreadsheet form. Please and thanks!

Problem 1: Perez Animal Feeds has developed the following data for lower-of-cost-or-market valuation for its inventory products Cost Market Large Animals: Cattle Horse $400,000 875,000 $380,000 920,000 Small Animals Cat Dog Ferret 550,000 90,000 280,000 700,000 165,000 245,000 Required: Determine the amount of inventory to appear in the balance sheet assuming LCM applied to 2 3 Individual item approach Group by group approach Total inventory approach