Question

Project Description: 

Roger Harding, the manager of Thunder City Bookstore, wants to improve the appearance of the workbook created to review the store inventory. Roger has a workbook started with the inventory, backorder, and documentation sheets already created. This project will require you to use your Excel skills to improve Roger's workbook. Some of the actions needed include copying the promotions worksheet from the marketing director's workbook and pasting it into Roger's workbook, enhancing the appearance of the worksheets by applying a theme, using built-in cell styles, rotating labels, changing a worksheet theme, formatting a section of a worksheet as a table, and using and printing functions and formulas. 

Answer 1

Thunder City Book Store
Open Daily from 10:00 AM to 8:00 PM
Inventory Items	Price Per Unit	Quantity in Stock	Inventory Cost	Subtotal
Clothing
Gym Shorts (S)	$15.99	5	$79.95
Gym Shorts (M)	$15.99	20	$319.80
Gym Shorts (L)	$15.99	25	$399.75
Gym Shorts (XL)	$15.99	12	$191.88
				$991.38
sweat pants (S)	$24.99	20	$499.80
sweat pants (M)	$24.99	25	$624.75
sweat pants (L)	$24.99	10	$249.90
sweat pants (XL)	$24.99	15	$374.85
				$1,749.30
t- shirts (S)	$12.99	30	$389.70
t- shirts (M)	$12.99	45	$584.55
t- shirts (L)	$12.99	30	$389.70
t- shirts (XL)	$12.99	28	$363.72
				$1,727.67
sweatshirts (S)	$39.99	20	$799.80
sweatshirts (M)	$39.99	15	$599.85
sweatshirts (L)	$39.99	25	$999.75
sweatshirts (XL)	$39.99	3	$119.97
				$2,519.37
Class Supplies
Pen (pack of 10)	$2.50	100	$250.00
Pencil (pack of 10)	$5.49	75	$411.75
Note Books	$0.79	250	$197.50
Review Card Individualy laminated 5*7 Card with summary of course review	$2.00	200	$400.00
Calendars	$4.99	50	$249.50
Mouse pads	$3.99	5	$19.95
				$1,528.70
Miscellaneous
Coffee Mug	$4.50	100	$450.00
Digital Fram (3*5)	$24.99	25	$624.75
Digital Fram (5*7)	$34.99	35	$1,224.65
Key Chains	$2.50	150	$375.00
Water Bottels	$3.00	200	$600.00
				$3,274.40
No of Product	$27.00
Avearge Price	$17.24
Maximum Price	$39.99
Minimum Price	$0.79

Thunder City Book Store
Promotion Schedule
Promotion Item	Start	End	Inventory Items
Clothing Promotion	15 January 2020	30 January 2020	All clothing during collage registration week
Sweatshirt Clearance	01 April 2020	15 April 2020	Just Sweatshirt to reduce inventory for summers
Review Card 25% Off	25 April 2020	10 May 2020	Exam week at local collage and universities
Additional 25% off on all item	11 May 2020	25 May 2020	End of Season Clearance - make room for summers and fall

Thunder City Book Store
Create Date	BY Whom	Description	WorkBook Name
15-10-2018	Roger Harding	Inventory analysis	Ratanpal
Mod. Date	By Whom	Mod. Description	Last Version Backup Name
15-10-2018	Mayank MOL		Added the Promotion Worksheet
15-10-2018
15-10-2018
15-10-2018
15-10-2018
15-10-2018
15-10-2018
15-10-2018
15-10-2018
15-10-2018
15-10-2018
Create Date	Sheet Name	Creator	Purpose
15-10-2018	Inventory	Roger Harding	List Inventory item and price
15-10-2018	Backorders	Roger Harding	List Items that are back orders
15-10-2018	Promotion	Mayank MOL