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

document that a discount "was" or "was not" applied to each transaction.

The transaction amount is determined by taking the retail amount less the discount, if applicable, and then multiply the difference by the tax rate. The tax rate can vary by store location so it is an input field. The average transaction amount is determined by dividing the total transaction amount by the number of transactions that day.

All monetary values should be displayed with at least two decimal positions to ensure those values are expressed in dollars and cents.

At this time the solution only needs to deal with a single store. Each store has a $9,000 retail limit for any one sale.

The sales data is currently accumulated and entered as a single batch at the end of the day already organized and sorted by transaction number. ARC is willing to enter the data which consists of the store location, date and tax rate (these three fields are input once) followed by each sales record containing the transaction number & retail amount. A 0 value for transaction number indicates the end of sales records.

A subset of data for a typical day is given for you to test your models.

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

The design of the problem solution by showing the following:

  • A Humanual Walkthrough using the project 1 test data
  • The Problem Statement,
  • The I/O Design.

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

More Books

Students also viewed these Databases questions

Question

12 Assignment Question 2 of 4

Answered: 1 week ago