Instructions: Questions 5-19 use the data table on tab Q5-19 in the Exam Workbook. We strongly recommend you analyze this data with the aid of a pivot table. You may also benefit from adding some extra calculation columns to the dataset. Answers for numerical data should be rounded to the nearest 1 decimal, comma-separating 000s, NOT written in currency format. So if the answer is $10,500.658, you would input 10,500.7. Over the entire analysis period, which sales rep sold the highest cumulative quantity of a single item

Croy inc. has the following projected sales for the next five months: month sales in units april 3,850 may 3,875 june 4,260 july 4,135 august 3,590 croy’s finished goods inventory policy is to have 60 percent of the next month’s sales on hand at the end of each month. direct material costs $2.50 per pound, and each unit requires 2 pounds. raw materials inventory policy is to have 50 percent of the next month’s production needs on hand at the end of each month. raw materials on hand at march 31 totaled 3,741 pounds. 1. determine budgeted production for april, may, and june. 2. determine the budgeted cost of materials purchased for april, may, and june. (round your answers to 2 decimal places.)