FIFO Calculator

If you own a small business, manage accounts and inventory for a large organization or if your business is to handle the bookkeeping for client companies, the FIFO Calculator will make your job easier, your numbers more accurate and your company more efficient and profitable.

The Excel template is a Cost-of-Goods-Sold (COGS) tracking program that will benefit any business that holds an inventory, from home-based crafts, to retail and manufacturing. Created using the first-in, first-out cost flow method, the FIFO Calculator comes ready to use, already formatted with the necessary formulas.

The template is designed, however, to be customized, with little effort, to your company’s production, output, policies, desires and needs. The FIFO Calculator is free, it is available right here on this page, its quick and easy to download and simple to use. All you have to do is follow the steps below to take advantage of the FIFO Calculator.

Screenshot of the FIFO Calculator

Using the FIFO Calculator

Here’s how to use the FIFO calculator:

  • Enter the period you will be tracking (month and year)
  • Enter the beginning inventory (number of units)
  • Enter the beginning inventory price (price per unit to produce the item)
  • Enter the number of units sold
  • In the fields below, enter the number of units and the price of net purchases

 

The COGS subtracted from the sum of the beginning inventory and the net purchases formula gives you the ending inventory ( BI + NP – COGS = EI). When the net purchases are updated the COGS will also be updated, automatically.

A tip for using the FIFO Calculator:

  • The formulas for the template are set in hidden fields; simply highlight on either side of the missing columns, right click and select ‘unhide’ in order to get to them. Highlighting individual fields allows access to the calculations. Become familiar with the configurations and the worksheet, but take care not to change them (or delete) unless, of course, it betters suites your business needs

 

The FIFO cost flow technique is the best accounting method used to determine the value of your ending inventory. Make it easy, download the free calculator and get the job done quickly and accurately.

Download: FIFO Calculator

If you enjoyed this post, make sure you
Subscribe to my RSS feed!


Behavior Reward Chart

Monitoring the behavior of all the students in a classroom can be a challenge. Fortunately, Excel provides an easy template for tracking behavioral rewards. Documentation and data tracking can be frustrating and time consuming when robbing teachers of valuable time. With the Excel behavior reward chart template, all that has to be done is to fill in the fields.

Teachers everywhere will love that the template can be downloaded instantly for free.

Using the Behavior Reward Chart

Before Creating Your Reward Chart, Consider the Following:

screenshot of the behavior reward chart
  • Are you tracking rewards for one student or an entire class?
  • What behavior or behaviors will be rewarded?
  • What is the schedule of rewards?

 

The reward chart available here is very basic but also very effective. It has slots for the names of all the students in your classroom. Simply list all the students in whichever order is easiest for you. All five days of the school week make up the next five columns. Here, you can track the daily behavior of each student.

The next column is reserved to note the overall/cumulative behavior of the student for the entire week. The next space is reserved for the reward. This column can be filled in prior to the start of the week, or can be left blank so the student is left in a bit of suspense. Finally, you will mark whether or not the student received the reward in the final column. Whether you save these to your computer or print off sheets, you can have a running file of the students’ behavior throughout the entire school year.

The Excel template affords teachers an easy tool for generating the required documentation to meet the Behavior Intervention Plan (BIP) components of an Individual Education Plan (IEP). The template allows for the charting of multiple behaviors, documentation of classroom management strategies implemented before the denial of a scheduled reward, documentation of rewards given, what type of reward and the dates and/or periods the reward was administered. The Excel template also allows for easy manipulation. Teachers can quickly add any extra information they wish. Such behavioral tracking charts are motivational for some students.

Download: Behavior Reward Chart

If you enjoyed this post, make sure you
Subscribe to my RSS feed!


Music Lesson Plan Template

Templates are an effective means of keeping track of what you are doing. In the case of providing music lessons to students, a music lesson plan template is necessary in order to track lessons for each individual student. The template can be used for a variety of reasons when giving lessons, including student progress, lesson times, and material that is to be covered.

A special section of the template can be created for miscellaneous notes. The use of a template increases productivity and allows both the teacher and the student to keep accurate records of an individual’s progress that can be understood at a glance. This allows the teacher more time to focus on the lessons themselves rather than trying to keep various notes on an array of students.

By using a template, teachers can easily fill out the necessary information regarding lessons for each student and then move on to the lessons themselves. This makes using a template more effective for increasing the productivity of the lessons with each student. There are three major points to consider when using a template: getting the right template, using it to decide lesson plans, and providing feedback.

Screenshot of the music lesson plan template

Using a Music Lesson Plan Template to Determine Lessons

A template can be designed to track the lessons that you provide for each student, including tracking the progress of the student. This is an effective means of determining lesson plans for your students because it allows you to quickly determine the level your students are currently playing at, and then decide which lessons are most effective for each individual student. You can also track their favorite pieces of music or their favorite genres, so that you are able to keep the lessons interesting for your students, thereby keeping them engaged in making continual progress.

Providing Feedback With a Music Lesson Plan Template

You can also use a template to provide feedback to your students. A copy can be printed out each month which allows you to provide information to your students regarding their progress, as well as any special activities that your students may be working on. Having a small section set aside on the template for miscellaneous information is a good way to keep students apprised of upcoming events, or even to congratulate them on a job well done.

Using a template makes your operation more productive. In turn, you can spend more of your efforts teaching instead of doing paperwork. Increasing your productivity also allows you to grow your business and keep more accurate records. Best of all, using a template lets you focus on your love of music and passing that passion on to your students.

Download: Music Lesson Plan Template

If you enjoyed this post, make sure you
Subscribe to my RSS feed!


RtI Lesson Plan Template

Response to Intervention, or RtI, is an important element in school service delivery to students. When a school uses the Response to Intervention model, periodic testing is used to ensure that students have a positive response to interventions that the teacher selects. An RtI lesson plan template is a useful tool to ensure that all of the data tracking obligations are met.

For educators to succeed in this model of service delivery, a great deal of data must be maintained in an organized fashion. Testing dates, results, and changes to the selected intervention must all be tracked for future analysis and decision making purposes.

About the RtI Lesson Plan Template

One item to note in the RtI lesson plan template is the name and type of intervention used. When a teacher is required to give multiple interventions to multiple students, it is vital that the data recorded matches with the appropriate intervention. The data is useless if this does not happen.

Screenshot of the RtI Lesson Plan Template

For example, there are multiple types of interventions that a teacher could select for a student to improve their reading fluency. A raw score of 27 might mean a positive result for a specific intervention. On a different intervention that uses a different time frame for assessment, that same score would indicate a major problem.

Another important piece of data to include in the RtI lesson plan template is the date of the test. Students change a great deal over the course of a school year. A score on a progress check in September means something completely different from that same score occurring in May. Since the goal of Response to Intervention is to indicate how a student responds to an intervention over time, the date is an extremely important piece of the data picture.

Since interventions in the RtI model are based on research and their proven impact on student learning in prior use, the fidelity and integrity of the intervention’s implementation is crucial to the process. Therefore, if any changes are needed when administering an intervention, those changes should also be marked on the template. This will allow the instructor to see if the implementation changes create a positive or negative impact on the student’s performance.

A final piece of information to include on the template is the intended outcome for the lesson. Otherwise known as the target skill, every lesson in the RtI model is designed to show improvement in a specific skill area. In the past, teachers could say that a lesson was designed to improve student reading. With the Response to Intervention model, a teacher must be much more specific with the intent of their lesson. This intent should also be denoted in the template.

The use of this template will allow the teacher to keep track of all the important factors that go into effective Response to Intervention planning. The finished product will contain all the information in one place that the teacher needs to make informed, data-driven decision about the education of their students in the RtI model.

Download: RtI Lesson Plan Template

If you enjoyed this post, make sure you
Subscribe to my RSS feed!


UBD Lesson Plan Template

Before using the UBD lesson plan template, it’s important to know exactly what it is. The term UBD stands for understanding by design. It is a platform that has been developed to teach learning through understanding. The thought process is that by looking at the end or the outcome of something the learning experience a curriculum can be developed that will produce the best results.

Creators of the UBD Lesson Plan Template

The team of Grant Wiggins and Jay McTighe created the initial concept in 1998. The course is suitable for K thru 12. Since its inception, over 250,000 educators own a copy of the book, and it is a part of the curriculum in over 150 university campuses across the country.

Part of the core components of this theory is the fact that essential questions are the key, and they are supposed to provoke a response that causes the learner to come to their conclusion through a series of other questions, that stimulate dialog and conversation.

Screenshot of the UBD Lesson Plan Template

They should not be written in a manner that allows the learner to answer the question in one final statement. It should cause a chain reaction that will lead to more questions, and require further investigation.

Concept of the UBD Lesson Plan Template

The UBD concept is the support network for creating curriculums that immerse the student into the depth of the learning experience. This is seen through the information presented. The student receives a deeper understanding of what they are learning.

The hope is that with the application of the UBD lesson plan a student will be able to grasp the six components behind the concept. These components include the ability to explain what they have learned, the insight to interpret the meaning of it all, and the skill to apply it.

This leads to the development of personal perspective, which in turn inspires the heart to express empathy, and finally, the realization of self-knowledge in regards to the content. Classroom learning traditionally, was based on the concept of take the information and create the curriculum by structuring the elements around it.

The problem with that approach is it can result in a hit or miss response. The educator has no way of knowing exactly what the student has learned. The UBD concept is based on what is referred to as ”backward planning” or “backward design.” Using this approach the educator looks at the goal and tailors the curriculum to meet that goal.

The UBD lesson plan template is based on 3 distinct parts. The first part is teacher centered because it is here that decisions about the goals are defined. The planned activities and structure is discussed. Teachers will state what they feel the students should comprehend and grasp.

The second part of the UBD lesson plan sets up the criteria by which the students will be measured. It is the responsibility of the assessors to make sure that the tasks will give the students enough information, experience, and opportunity to gain a thorough understanding of the content.

Lastly, the third part actually maps out all of the reading, exercises and tests that will guarantee that the students will reach the desired goal. The educators should leave enough room for there to be plenty of student/teacher interaction and the overall plan should incorporate the idea of, “teaching for understanding.” If it is successful, it will be evident in all aspects of the program.

Download: UBD Lesson Plan Template

If you enjoyed this post, make sure you
Subscribe to my RSS feed!