Roller Blind Grid Price Calculator

This workbook provides significant flexibility in the way a user can define how a Roller Blind/Shade will be configured for manufacture, and ultimately for production costing. Users can define the following sets of variables, with the variants as shown: The User can select: 1. The Fabric Group to be used as a basis for the bill of materials calculation and the costing grid. - The fabric selection will then also define the assumed weight and thickness. 2. The Clutch, which will be used across all the sizes, unless a Geared Clutch is specified as a Lift Assistance method, which will then replace the selected clutch at larger sizes. If a Spring Assist is added, it is assumed to be attached to the selected clutch. 3. Whether or not to add Lift Assistance using either a Spring Assist (Booster Spring), or a Geared Clutch. The addition of the Lift Assist is then controlled according to 3x User selected methods: - Width based (using the small table under Spring Assist section in Parameters tab.) - Grid based (using the Lift Assist table, see below.) - Dynamic weight based (ie the workbook calculates the chain pull force and adds a Spring if the pull force exceeds the number entered in the Parameters sheet. 4. The Tube selection across the different shade sizes can be made according to one of 4x User selectable options: - Width based, using the small table in the Parameters sheet, under the Tube Table - Grid based, using the values entered into the Tube Grid sheet (see below) - Dynamic Weight, based upon calculated pull force on the chain when compared to a maximum User value - Fixed Tube, ie the User makes a selection on the Data Entry Page and the same tube is used for all sizes. (NOTE: this option is not recommended, as tube deflection is ignored!) 5. The Base Rail (Bottom Bar/Bottom Rail) to be used for all sizes - options are provided to fit Bumpers, if available. 6. The Bracket type to be used, plus whether or not to apply covers. - options are provided to automatically increase bracket size to accept larger roll diameters for long drop blinds/shades. 7. The Chain type to be used, eg plastic, metal etc. Chain Drop lengths are managed through the Chain Grid, see below. 8. Manufacturing Labour costs can be added according to 2 methods: - Average times, based upon total factory labour count, hourly rates and blinds/day, or - Standard Times, according to a small table that breaks the sizes into 1mtr ranges for total production minutes to be added 9. Gross Profit Margins at both Wholesale and Retail levels. These margins compound on top of total calculated Cost, so at (say) 40% GP each, the total margin chain is 64% 10. Fabric waste levels and Profile waste levels, both based upon % measures. This will build the waste component into the product costing.