Reduce old stock and build the weekly sales table

What is going on

Bao Tran has two jobs for you this week. The first is the red tag round: the Op Shop Donation Sorting and Pricing Procedure says anything on the floor for four weeks or more is reduced by half and marked with a red tag, and every tag shows the date it went out. Today is 17 September. The second is the committee report. The committee wants to see the last four weeks of op shop sales and the number of donation bags sorted each week in a simple table and a bar chart. The figures are in the Cafe and Shop Daily Log and on the daily sheets: sales of $1,980, $2,240, $2,150 and $2,410, and bags sorted of 105, 132, 120 and 141.

Your brief

Work through the clothing racks, identify stock that has been out for four weeks or more, work out and write the half price on a red tag, then put the four weeks of sales and bags sorted into a clear table and bar chart with a short written summary for the committee.

Work through it

You do not need to do it all. Doing a few of these will show you what the work is like. Your ticks and notes stay on this device.

• Read the Pricing and Display sections of the Op Shop Donation Sorting and Pricing Procedure and tell Bao the rule for reducing stock and how the date on the tag is used.
• Work out the cut-off date for the red tag round by counting back four weeks from 17 September, and check your answer with a calendar.
• Go along the first two racks, read the date on each tag, and put a red tag with the new half price on every item at the cut-off, showing your working for $7 and $12.50.
• Write the number of items you reduced and the rack names on the daily sheet, and record the task as Done on the Task Board.
• Find the last four weeks of op shop sales and bags sorted in the Cafe and Shop Daily Log and put them in a table with a heading, week ending dates and units.
• Draw a bar chart of the four weeks of sales by hand or on the computer, with a title, labelled axes and a sensible scale, and check the bars match the table.
• Write two or three sentences for the committee describing what the numbers show, including the total sales for the four weeks and the busiest week.
• Read the Safety when sorting section of the procedure and explain to Bao how you kept yourself safe while moving stock on the racks.

What someone in this role would produce

• Red tag price calculations with working shown
• Daily sheet entry and Task Board update
• Sales and bags sorted table
• Bar chart with title, axes and scale
• Short written summary for the committee