Seth Bozman

Auto generating reports with formulas using Unifize

In this story

Seth Bozman

Seth Bozman highlights the transformative impact of Unifize's formulas and auto-generator features on Efco's cost analysis and quality reporting. He shares how these features have eliminated the need for manual data entry into external databases, significantly reducing the time spent on generating quality reports. This video showcases Unifize's capability to automatically calculate costs, offering Efco a streamlined, efficient approach to tracking and analyzing scrap and rework data.

SpeakerSeth Bozman
IndustryConstruction
Runtime1:29

Transcript

11 passages · 1:29
  1. 0:00

    The formulas finally got in in which is it was really hard because I wasn't quite ready with how I wanted the flow of the Unifize essentially to work.

  2. 0:08

    And now since that's done and I've been running a bunch of tests today and I mean it's it's going pretty smoothly, I'd say.

  3. 0:13

    The dollar amount that I'm tasked with, which is scrap and rework. People want to know how much scrap dollar it is, how many rework dollars are in each department. Why do we have those?

  4. 0:22

    And so the formula basically is getting rid of me, having to use Access because there's formulas based in there, which is like unit material weight plus unit material labor times the quantity of the part times our overhead.

  5. 0:34

    So that's the formula, right? To get the total cost of that part that we scrapped.

  6. 0:38

    So basically it's just being they just got in the, auto generator like so everything now is just filling out itself because we have our part numbers in there and it's like we don't have to take it out of Unifize to put it into Access to run my quality report anymore.

  7. 0:52

    You know what I mean? And it's it's pretty sweet.

  8. 0:54

    I think that I won't have to sit at my computer for, 3 hours running quality reports because it will automatically run those reports themselves like they're as soon as you enter that part, like the scrap value and everything is already totaled up.

  9. 1:05

    So I don't have to go into Access, run reports and stuff like that. It'll already be there. Right.

  10. 1:11

    So if I want to go in for Department 121, which is lasers and see over the last two months what it scrapped out, you can go to through that filtering process and you can go over.

  11. 1:19

    You can put rework dollars in there, your scrap dollars in there, the weight in there, everything's just ready.

Ready when you are

Your team has a story like this waiting.

Bring the process that hurts most. We will run it on Unifize, live, on your own work.