Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

The Auraria Recreation Company (ARC) provides products in the Denver Metro area. ARC has stores in Denver, Littleton, Boulder and Aurora. They rent and sell

The Auraria Recreation Company (ARC) provides products in the Denver Metro area. ARC has stores in Denver, Littleton, Boulder and Aurora. They rent and sell sporting equipment such as skis and snow boards, bicycles, kayaks and sup boards. They also sell apparel including ski/board jackets and pants, bicycle shirts and pants, swim suits, rash shirts and board shorts. ARC needs a transaction report of sales for each day. This report must first display the store location, date and tax rate, each displayed only this one time. Then the report will display an output line for each sales record showing the transaction number, retail amount, discount flag and the actual transaction amount paid by the customer. After all sales records are displayed a report summary is required to display the total retail amount, total discount amount, total transaction amount and the average transaction amount. The summary must also identify the "transaction with the smallest transaction amount" by displaying the transaction amount and associated transaction number. In the event of multiple instances of the smallest only the first instance should be reported.

Company policy dictates that a discount rate of 5% be applied when the retail amount on a single sale is greater than $1,500. The discount flag column is used to signify whether or not a discount was applied to the sale. The word "Discounted" or "No" should be displayed in the output report under this column to

  • Humanual Walk-through using the project 1 test data
  • Problem Statement.
  • I/O Design.
  • CIS 2110 Project #1 Test Data

    Auraria Recreation Company Daily Transactions

    STORE:

    Littleton

    DATE:

    August 15, 2014

    TAX RATE:

    8%

  • Transaction Number

    Retail Amount

    11

    1234.55

    22

    4321.95

    33

    6789.95

    44

    1111.95

    55

    4567

    66

    1111.95

    77

    7788.95

    88

    1111.95

    0

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access with AI-Powered 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

Students also viewed these Databases questions