Show the tracer arrows from cell C2 to the cells that are dependent on it (cells containing formulas that reference the value or formula in cell C2).

Apharmaceutical packaging company (ppc) has decided to reorganize its processes into cells. the company has four different production operations, each requiring a unique piece of equipment. the names and functions of the four pieces of equipment are sort, count, place, and package. the company packages five different families of products (a, b, c, d, and e). the tables below indicate the demand (total units/day by product family), required operations, and operation cycle times for each product family. assume that any individual piece of equipment is available to operate 16 hours/day, but 2 hours (in total) are lost each day on each piece of equipment due to breaks and meetings when operators are not available to operate the equipment. how many minutes/day are available for production

Down under products, ltd., of australia has budgeted sales of its popular boomerang for the next four months as follows: unit salesapril 74,000may 85,000june 114,000july 92,000the company is now in the process of preparing a production budget for the second quarter. past experience has shown that end-of-month inventory levels must equal 10% of the following month’s unit sales. the inventory at the end of march was 7,400 units.required: prepare a production budget by month and in total, for the second quarter.

Thomas kratzer is the purchasing manager for the headquarters of a large insurance company chain with a central inventory operation. thomas's fastest-moving inventory item has a demand of 6,000 units per year. the cost of each unit is $100, and the inventory carrying cost is $10 per unit per year. the average ordering cost is $30 per order. it takes about 5 days for an order to arrive, and the demand for 1 week is 120 units. (this is a corporate operation, and the are 250 working days per year.)a) what is the eoq? b) what is the average inventory if the eoq is used? c) what is the optimal number of orders per year? d) what is the optimal number of days in between any two orders? e) what is the annual cost of ordering and holding inventory? f) what is the total annual inventory cost, including cost of the 6,000 units?