Question

In: Accounting

Project Description: Roger Harding, the manager of Thunder City Bookstore, wants to improve the appearance of...

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.

Project Description: Roger Harding, the manager of Thunder City Bookstore, wants to improve the appearance of the workbook cr

Format cell range A4:E40 as Table Style Medium 4, with headers and add a Total Row. Format cell E41 as Currency with two deci

On the Inventory worksheet, in the center position of the header, enter the phrase Open Daily from 10 AM to 8 PM (no period).

D21 D. 1 Thunder City Bookstore Promotion Schedule 4 Promotion Item 5 Clothing Promotion 6 Sweatshsirt Clearance 7 Review Car

D6 1 Thunder City Bookstore 2 Manager: Roger Harding Inventory Cost Subtotal Quantity in Stock Price per Unit Inventory Iitem

1 Thunder City Bookstore 3. Workbook Name s Create Date 2018-10-15 Roger Harding 7 Mod. Date By Whom Description Inventory an

Expert Solution

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

ekkarill92 answered 2 years ago

Data from a small bookstore are shown in the accompanying table. The manager wants to predict...

Data from a small bookstore are shown in the accompanying table. The manager wants to predict Sales from Number of Sales People Working. Complete parts a through h below. Number of ales peaople working sale (in $1000) 2 10 3 12 5 14 8 15 10 19 10 21 13 21 14 22 17 22 19 27 x(bar)= 10.1 y(bar)=18.3 SD(x)=5.74 SD(y)=5.33 A) find the slope etimate, b1. B) What does b1 mean, in thi context? C) Find the intercept,...

The branch manager of a nationwide bookstore chain (located near a college campus) wants to study...

The branch manager of a nationwide bookstore chain (located near a college campus) wants to study characteristics of her store’s customers. She decides to focus on two variables: the amount of money spent by customers (on items other than textbooks) and whether the customers would consider purchasing educational DVDs related to graduate preparation exams such as the GMAT, CRE, or LSAT. The results from a sample of 70 customers are as follows: Amount spent; mean = $28.52, standard deviation =...

You are the manager of a project to improve the billing process at your firm. The...

You are the manager of a project to improve the billing process at your firm. The table below contains the data you will need to conduct a cost analysis of the project. Indirect costs are $1600 per week, and penalty costs are $1200 per week after week 12. a- What is the minimum-cost schedule for this project? b- What is the difference in total project costs between the earliest completion time of the project using "normal" times and the minimum-cost...

A potential client wants you to be the project manager for a project that involves moving...

A potential client wants you to be the project manager for a project that involves moving to a new computerized human resource management system that supports the firm’s staffing, compensation, employee relations, and benefit functions. The client is very vague about what needs to be done, and all that they know is that they do not like the current system. Identify the types of questions that you could ask the client to gain a better understanding of the scope of...

Gordon Rivers, the City Manager of Saratoga, Florida and Jay Andrews, the project manager for Major...

Gordon Rivers, the City Manager of Saratoga, Florida and Jay Andrews, the project manager for Major Design Corporation (MDC), must manage this project. ?We need the ?intake and transmission main? designed, bid, and completed in 35 weeks. The City of Saratoga has a future $2 million dollar federal grantriding on the project getting done on time,? Mr. Rivers said. Jay nodded in agreement. Mr. Rivers continued by saying, ?Jay, the project needs to come in on-schedule and within the budget....

A project manager wants to calculate the probability of completing his project in 30 days. If...

A project manager wants to calculate the probability of completing his project in 30 days. If the variance of the critical path is 1.33 and the critical path is completed in 32 days, what is the probability of completing the project in 30 days? 41.8% 32% 4.18% 0 45.82%

1. The manager of a local fast-food chain wants to improve the service provided to customers...

1. The manager of a local fast-food chain wants to improve the service provided to customers who use the drive-up window. As a first step in this process, the manager records how long it takes from the time the customer first enters the drive-in window until they are served their food at the final window. Below are the times (in minutes) for the 30 customers (in order): 3 4 5 6 6 7 9 10 11 11 12 12 12...

You are the manager of a project to improve the healthcare insurance claims auditing process. For each...

You are the manager of a project to improve the healthcare insurance claims auditing process. For each day that the claims auditing process takes, there is an associated cost of $1,700 so this cost is saved for each day reduction in the project completion time. Following is the information for the healthcare claims auditing process. The normal time and crash time are the times it will take to complete each activity under each of those scenarios (normal and crash). The Total Normal Cost...

As the project manager for a not-for-profit organization, you were notified that your proposal to improve...

As the project manager for a not-for-profit organization, you were notified that your proposal to improve the safety of the Lafayette Park in Los Angeles was approved. You and your team will receive funding for $50,000. Please prepare a positive letter informing your team members and outline the safety improvements you propose to be implemented. Prepare this into a Positive Letter.

Your HR Manager wants to promote a high-performance culture and improve Communications with line managers in...

Your HR Manager wants to promote a high-performance culture and improve Communications with line managers in your organization. To contribute to this, he/she has given you the following task: As part of the revision of the HR Guide for Managers, you are asked to write a section in approximately 1,000 words, on Performance Management which: * identifies and describes the main stages of the performance management cycle ensuring you include the objective-setting process, interim reviews, and appraisal. *Evaluates how Performance...