You are required to prepare a business model using Excel to solve the business problem using Data Table and Solver. CASE 1: A fabric company produces sheets of fabric in three different sizes, 100 inch, 80 inch and 50 inch. However, the demand for the sheets is in smaller sizes, 45 inch, 30 inch and 15 inch. The demand for each fabric is 150, 200 and 175 units respectively. How should the company cut the fabric to minimize waste?Please provide the answer in excel sheet.

Answer rating: 100% (QA)

To create a business model in Excel to solve this problem you can use the Data Table and Solver tools Here is one approach to set up the model Create a spreadsheet with the following columns Size Demand Production Waste In the Size column list the three smaller sizes 45 inch 30 inch 15 inch and the three larger sizes 100 inch 80 inch 50 inch In the Demand column list the demand for each size 150 units 200 units 175 units In the Production column enter formulas to calculate the number of large sheets needed to meet the demand for each small size For example to meet the demand for 150 units of the 45inch size you would need 3 large 100inch sheets 450 inches or 4 large 80inch sheets 320 inches In the Waste column enter formulas to calculate the amount of waste for each large size For example if you use 3 large 100inch sheets to meet the demand for the 45inch size you would have 50 inches of waste 100 inches 45 inches 55 inches Use the Data Table tool to generate a table that shows the total waste for each combination of large sheets used to meet the demand for the small sizes Use the Solver tool ... View the full answer