Spreadsheets
A film- manufacturing plant produces 35-mm photographic film for old fashioned cameras. The film is produced on large rolls between 500 m and 2,000 m long. Each large roll might have a width between 0.5 m and 2.0 m in steps of 0.5 m. That is, there are four possible values for the width. The large rolls are sliced into 35-mm strips and packaged into consumer- sized canisters for 12, 24, or 36 pictures per strip. Assume that each picture requires 35 mm of strip length, and that the 35-mm wide strip inside each canister must allocate 10% of its length to a trailer and leader (i.e., unexposed film at the start and end of each roll). Write a spreadsheet program that will allow you to compute the total number of film canisters of each size obtainable from a large roll for various percentage allocations of the three values of shots per canister. Your spreadsheet should have the following user entries: width of large roll, length of large roll, percent each of 12-, 24-, and 36-shot canisters desired from the entire roll. Assume that the slicing process generates no wasted film.
We need at least 10 more requests to produce the solution.
0 / 10 have requested this problem solution
The more requests, the faster the answer.