Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Scenario Ordering a Cap & Gown for Graduation RRC contracts the rental of caps and gowns (C&G) with a local Winnipeg company. Six months prior

Scenario Ordering a Cap & Gown for Graduation

RRC contracts the rental of caps and gowns (C&G) with a local Winnipeg company. Six months prior to graduation students are asked to indicate if they are planning to attend the graduation ceremony. Four months prior to graduation, those that indicated that they would be attending are asked to visit a specific classroom so they can be fitted.

During the fitting, the company documents the measurements of the student and provides RRC and the student an inventory ticket. The inventory ticket is used to identify the students garment at graduation time. The student is also asked if they will be purchasing the cap for $45. If the student wishes to purchase the cap, then they can pay for it at the time of the fitting or wait until graduation. RRC only accepts cash, Visa or Mastercard.

Two months before the graduation, students that were fitted for a C&G are asked to confirm that they will be attending the graduation ceremony.

Two days before the graduation ceremony, RRC receives the C&Gs along with a packing slip indicating all the inventory ticket numbers that RRC confirms to ensure all the C&Gs have been received.

On the day of graduation, students sign out the C&G using their copy of the inventory ticket. Upon return of the C&G, those students that paid for their cap are allowed to keep them. Students that indicated they wish to buy the cap are required to pay for them before they keep them.

The day after graduation, RRC verifies that all garments and unsold caps are accounted for and then calls the local company asking that the C&Gs be picked up the next day. When the company arrives to pick up the C&Gs, RRC and the company review the packing slip to ensure that all garments and unsold caps are returned.

Within two weeks after the C&Gs are picked up, the local company must indicate to RRC if there are any issues with the condition of the returned C&Gs. If there is an issue with a cap or gown, RRC may approach the student to cover the cost of repairs / replacement.

Currently all of this information is tracked in an excel spreadsheet and requires one part-time accounting person to administer. Other people volunteer to help when needed.

RRC would like to build / buy a system to handle all their tasks.

REQUIREMENT:EXHIBIT

Make a representation of a function or component using Structured English.(use IF ELSE)

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

AutoCAD Database Connectivity

Authors: Scott McFarlane

1st Edition

0766816400, 978-0766816404

More Books

Students also viewed these Databases questions