Question: Sales data: Just Java-> 50 cups x $2.00= $100 Cafe Au Lait-> 20 single cups x $2.00= $40 -> 30 double cups x $3.00= $90
Sales data:
Just Java-> 50 cups x $2.00= $100
Cafe Au Lait-> 20 single cups x $2.00= $40
-> 30 double cups x $3.00= $90
Iced Cappuccino-> 10 single cups x $4.75= $47.50
->16 double cups x $5.75= $92
Total dollar sales= $369.50
Final Output:
Clicking on the first checkbox will link to another page that will show the total dollar sales by products.Eg. The total dollar sales by product is $369.50.
Clicking on the second checkbox will link to another page that will show the sales quantities by product categories (single and double shots) and the product category with the highest sales.
Eg. Sales quantities by product categories:
Just Java-> 50 cups x $2.00= $100
Cafe Au Lait-> 20 single cups x $2.00= $40
-> 30 double cups x $3.00= $90
Iced Cappuccino-> 10 single cups x $4.75= $47.50
->16 double cups x $5.75= $92
Product catergory with the highest sales is Just Java- Endless cup.
Sales data will be in mySQL database.
HTML code:
height="auto" width="auto" alt="student submitted image, transcription available below" />
- Home
- Menu
- Music
- Jobs
Coffee at JavaJam
| Just Java | Regular house blend, decaffeninated coffee, or flavor of the day.Endless Cup $2.00 |
|---|---|
| Cafe au Lait | House blended coffee infused into a smooth, steamed milk.Single $2.00 Double $3.00 |
| Iced Cappuccino | Sweetened espresso blended with icy-cold milk and served in a chilled glass.Single $4.00 Double $5.75 |
As shown below is an administrative page to generate the daily sales reports. Daily sales reports showing the total dollar sales by products and sales quantities by product categories (single and double shots) should be generated on separate pages. It should also be possible to report the product category which achieved the highest dollar sales in the latter report. rvadn CoffFee House Daily Sales Report Click to generate daily sales report: Total dollar sales by products Sales quantities by product categories As shown below is an administrative page to generate the daily sales reports. Daily sales reports showing the total dollar sales by products and sales quantities by product categories (single and double shots) should be generated on separate pages. It should also be possible to report the product category which achieved the highest dollar sales in the latter report. rvadn CoffFee House Daily Sales Report Click to generate daily sales report: Total dollar sales by products Sales quantities by product categories
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
Study Help