please solve this using excel. and post the document urgently.
inventory Control Flemming Accessories produces paper slicers used in offices and in art stores. The minislicer has been one of its most popular items: Annual demand is 5,650 units and is constant throughout the year. Kristen Flemming, owner of the firm, produces the minislicers in batches. The setup cost for the equipment necessary to produce the minislicers is $109. Carrying costs are $0.72 per minislicer per year. 1) Construct the table on the right side (provided during the lab class) and answer the question: how many minislicers should Kristen manufacture in each batch (find the economic order quantity (EOQ))? (1 point) 2) What are total costs (TC)? (1 point) 3) List inventories that company needs to use in order to produce paper slicers. Are ther any risks which are associated with such inventories? If yes, explain. (2 points) Linear Programming Winkler Furniture manufacturestwo different types of china cabinets: a French Provincial model and a Danish Modern model. Each cabinet produced must go through three departments: carpentry, painting, and finishing. The table below contains all relevant information concerning production times per cabinet produced and production capacities for each operation per day, along with net revenue per unit produced 4) Formulate the LP problem. (2 point) 5) Determine a product mix to maximize owner's daily revenue using Solver. (2 points) 6) Discuss other possible approaches to increase revenue. (2 points) French Provincial Department capacity (hours) 35 1,75 380 Danish Modern 26 27 385 0,95 150 1,5 175 Winkler Furniture French Provincial Danish Modern Revenue Variables Units produced Hours used Department Capacity Constraints Carpentry Painting Finishing inventory Control Flemming Accessories produces paper slicers used in offices and in art stores. The minislicer has been one of its most popular items: Annual demand is 5,650 units and is constant throughout the year. Kristen Flemming, owner of the firm, produces the minislicers in batches. The setup cost for the equipment necessary to produce the minislicers is $109. Carrying costs are $0.72 per minislicer per year. 1) Construct the table on the right side (provided during the lab class) and answer the question: how many minislicers should Kristen manufacture in each batch (find the economic order quantity (EOQ))? (1 point) 2) What are total costs (TC)? (1 point) 3) List inventories that company needs to use in order to produce paper slicers. Are ther any risks which are associated with such inventories? If yes, explain. (2 points) Linear Programming Winkler Furniture manufacturestwo different types of china cabinets: a French Provincial model and a Danish Modern model. Each cabinet produced must go through three departments: carpentry, painting, and finishing. The table below contains all relevant information concerning production times per cabinet produced and production capacities for each operation per day, along with net revenue per unit produced 4) Formulate the LP problem. (2 point) 5) Determine a product mix to maximize owner's daily revenue using Solver. (2 points) 6) Discuss other possible approaches to increase revenue. (2 points) French Provincial Department capacity (hours) 35 1,75 380 Danish Modern 26 27 385 0,95 150 1,5 175 Winkler Furniture French Provincial Danish Modern Revenue Variables Units produced Hours used Department Capacity Constraints Carpentry Painting Finishing
