Excel 365/2019 Capstone – Level 3 Working With Sales Data Alternate With VLOOKUP

OnlineSales

Online Sales During Buy 1 Get 1 Free Sale
Date Quantity Item State
7/30/19 13 Old Bay MD
7/30/19 9 Original Blend OH
7/30/19 28 Original Blend CA
7/30/19 9 Sea Salt and Caramel MO
7/30/19 21 Sea Salt and Caramel NJ
7/30/19 9 Truffle VA
7/30/19 29 Truffle DC
7/30/19 20 Original Blend AL
7/30/19 17 Old Bay MD
7/30/19 20 Truffle DC
7/30/19 16 Sea Salt and Caramel MS
7/30/19 24 Original Blend NC
7/30/19 14 Original Blend VA
7/30/19 24 Old Bay NJ
7/30/19 9 Old Bay NJ
7/30/19 32 Sea Salt and Caramel NY
7/31/19 11 Old Bay ID
7/31/19 12 Sea Salt and Caramel OH
7/31/19 33 Truffle NY
7/31/19 28 Original Blend AL
7/31/19 17 Old Bay MD
7/31/19 31 Original Blend NC
7/31/19 30 Sea Salt and Caramel MS
7/31/19 21 Original Blend VA
7/31/19 21 Old Bay MD
7/31/19 9 Old Bay MD
7/31/19 9 Old Bay VA
7/31/19 27 Original Blend WV
7/31/19 13 Sea Salt and Caramel CA
7/31/19 11 Sea Salt and Caramel MO
7/31/19 16 Sea Salt and Caramel MS
7/31/19 34 Truffle NY
7/31/19 35 Truffle NY
7/31/19 28 Original Blend OH
8/1/19 26 Truffle NY
8/1/19 31 Old Bay MD
8/1/19 9 Old Bay DC
8/1/19 12 Sea Salt and Caramel MS
8/1/19 21 Sea Salt and Caramel AL
8/1/19 15 Sea Salt and Caramel NC
8/1/19 25 Original Blend AL
8/1/19 16 Original Blend DC
8/1/19 30 Original Blend NY
8/1/19 17 Original Blend WV
8/1/19 25 Original Blend OH
8/1/19 22 Truffle VA
8/1/19 13 Old Bay VA
8/1/19 16 Sea Salt and Caramel DC
8/1/19 17 Old Bay MD
8/1/19 11 Old Bay WV
8/1/19 20 Original Blend AL
8/1/19 10 Original Blend SC
8/1/19 16 Truffle SC
8/2/19 33 Original Blend OH
8/2/19 33 Original Blend NY
8/2/19 16 Sea Salt and Caramel NJ
8/2/19 20 Sea Salt and Caramel NJ
8/2/19 13 Old Bay NY
8/2/19 24 Truffle NY
8/2/19 22 Old Bay OH
8/2/19 10 Truffle DC
8/2/19 16 Old Bay CA
8/3/19 25 Original Blend AL
8/3/19 24 Original Blend MS
8/3/19 34 Sea Salt and Caramel OH
8/3/19 11 Old Bay CA
8/3/19 34 Old Bay DC
8/3/19 22 Original Blend CA
8/3/19 29 Truffle VA
8/3/19 29 Sea Salt and Caramel NJ
8/3/19 23 Sea Salt and Caramel WV
8/4/19 28 Old Bay MD
8/4/19 31 Old Bay DC
8/4/19 34 Sea Salt and Caramel NJ
8/4/19 21 Sea Salt and Caramel NY
8/4/19 21 Original Blend MD
8/4/19 33 Original Blend AL
8/4/19 14 Truffle VA
8/4/19 12 Old Bay MD
8/4/19 32 Old Bay MD
8/4/19 20 Old Bay VA
8/4/19 9 Truffle NY
8/4/19 24 Original Blend OH
8/4/19 31 Sea Salt and Caramel CA
8/4/19 18 Original Blend CA
8/4/19 21 Truffle CA
8/4/19 35 Old Bay MD
8/4/19 26 Original Blend MD
8/4/19 16 Old Bay VA
8/4/19 32 Original Blend VA
8/4/19 32 Sea Salt and Caramel MS
8/4/19 22 Original Blend NC
8/4/19 14 Original Blend WV
8/4/19 23 Old Bay WV
8/4/19 16 Truffle OH
8/5/19 12 Old Bay MD
8/5/19 28 Truffle OH
8/5/19 21 Original Blend CA
8/5/19 10 Original Blend MD
8/5/19 17 Sea Salt and Caramel VA
8/5/19 24 Truffle MD
8/5/19 30 Truffle VA
8/5/19 31 Sea Salt and Caramel AL
8/5/19 13 Old Bay MD
8/5/19 34 Old Bay WV
8/5/19 11 Original Blend WV
8/5/19 24 Truffle CA
8/5/19 9 Truffle CA
8/5/19 14 Truffle MO
8/5/19 16 Original Blend WV
8/5/19 29 Sea Salt and Caramel DC
8/5/19 32 Old Bay DC
8/5/19 15 Sea Salt and Caramel MD
8/5/19 28 Sea Salt and Caramel VA
8/5/19 18 Truffle AL
8/5/19 35 Sea Salt and Caramel MS
8/5/19 9 Old Bay NC

BOGOSale2018

Online Sales During Buy 1 Get 1 Free Sale
Date Quantity Item State
7/30/18 21 Old Bay MD
7/30/18 16 Original Blend OH
7/30/18 25 Original Blend CA
7/30/18 19 Sea Salt and Caramel MO
7/30/18 14 Sea Salt and Caramel NJ
7/30/18 21 Truffle VA
7/30/18 5 Truffle DC
7/30/18 11 Original Blend AL
7/30/18 23 Old Bay MD
7/30/18 13 Truffle DC
7/30/18 10 Sea Salt and Caramel MS
7/30/18 11 Original Blend NC
7/30/18 6 Original Blend VA
7/30/18 18 Old Bay NJ
7/30/18 18 Old Bay NJ
7/30/18 20 Sea Salt and Caramel NY
7/31/18 18 Old Bay ID
7/31/18 24 Sea Salt and Caramel OH
7/31/18 11 Truffle NY
7/31/18 16 Original Blend AL
7/31/18 14 Old Bay MD
7/31/18 20 Original Blend NC
7/31/18 14 Sea Salt and Caramel MS
7/31/18 9 Original Blend VA
7/31/18 19 Old Bay MD
7/31/18 25 Old Bay MD
7/31/18 20 Old Bay VA
7/31/18 15 Original Blend WV
7/31/18 5 Sea Salt and Caramel CA
7/31/18 7 Sea Salt and Caramel MO
7/31/18 7 Sea Salt and Caramel MS
7/31/18 12 Truffle NY
7/31/18 11 Truffle NY
7/31/18 6 Original Blend OH
8/1/18 5 Truffle NY
8/1/18 12 Old Bay MD
8/1/18 8 Old Bay DC
8/1/18 20 Sea Salt and Caramel MS
8/1/18 13 Sea Salt and Caramel AL
8/1/18 23 Sea Salt and Caramel NC
8/1/18 12 Original Blend AL
8/1/18 9 Original Blend DC
8/1/18 20 Original Blend NY
8/1/18 7 Original Blend WV
8/1/18 21 Original Blend OH
8/1/18 16 Truffle VA
8/1/18 14 Old Bay VA
8/1/18 24 Sea Salt and Caramel DC
8/1/18 23 Old Bay MD
8/1/18 17 Old Bay WV
8/1/18 11 Original Blend AL
8/1/18 25 Original Blend SC
8/1/18 6 Truffle SC
8/2/18 19 Original Blend OH
8/2/18 22 Original Blend NY
8/2/18 25 Sea Salt and Caramel NJ
8/2/18 13 Sea Salt and Caramel NJ
8/2/18 22 Old Bay NY
8/2/18 18 Truffle NY
8/2/18 14 Old Bay OH
8/2/18 5 Truffle DC
8/2/18 5 Old Bay CA
8/3/18 10 Original Blend AL
8/3/18 12 Original Blend MS
8/3/18 11 Sea Salt and Caramel OH
8/3/18 22 Old Bay CA
8/3/18 11 Old Bay DC
8/3/18 18 Original Blend CA
8/3/18 22 Truffle VA
8/3/18 13 Sea Salt and Caramel NJ
8/3/18 21 Sea Salt and Caramel WV
8/4/18 5 Old Bay MD
8/4/18 5 Old Bay DC
8/4/18 14 Sea Salt and Caramel NJ
8/4/18 11 Sea Salt and Caramel NY
8/4/18 15 Original Blend MD
8/4/18 6 Original Blend AL
8/4/18 17 Truffle VA
8/4/18 20 Old Bay MD
8/4/18 7 Old Bay MD
8/4/18 17 Old Bay VA
8/4/18 19 Truffle NY
8/4/18 6 Original Blend OH
8/4/18 13 Sea Salt and Caramel CA
8/4/18 17 Original Blend CA
8/4/18 22 Truffle CA
8/4/18 18 Old Bay MD
8/4/18 17 Original Blend MD
8/4/18 12 Old Bay VA
8/4/18 13 Original Blend VA
8/4/18 21 Sea Salt and Caramel MS
8/4/18 6 Original Blend NC
8/4/18 24 Original Blend WV
8/4/18 17 Old Bay WV
8/4/18 18 Truffle OH
8/5/18 19 Old Bay MD
8/5/18 16 Truffle OH
8/5/18 17 Original Blend CA
8/5/18 10 Original Blend MD
8/5/18 16 Sea Salt and Caramel VA
8/5/18 22 Truffle MD
8/5/18 16 Truffle VA
8/5/18 23 Sea Salt and Caramel AL
8/5/18 12 Old Bay MD
8/5/18 21 Old Bay WV
8/5/18 8 Original Blend WV
8/5/18 22 Truffle CA
8/5/18 7 Truffle CA
8/5/18 19 Truffle MO
8/5/18 24 Original Blend WV
8/5/18 12 Sea Salt and Caramel DC
8/5/18 22 Old Bay DC
8/5/18 17 Sea Salt and Caramel MD
8/5/18 7 Sea Salt and Caramel VA
8/5/18 13 Truffle AL
8/5/18 22 Sea Salt and Caramel MS
8/5/18 21 Old Bay NC

TysonsStore2019

Date Old Bay Black Truffle Sea Salt and Caramel Daily Total (# sold) Daily Total ($) Sales Goal Met? with Price Increase Current price per box: $6
1-Aug 239 83 209 531 $ 3,186 Daily sales goal: $1,500
2-Aug 225 185 77 487 $ 2,922 Average daily sales:
3-Aug 45 165 156 366 $ 2,196 Lowest daily sales:
4-Aug 240 93 177 510 $ 3,060 Highest daily sales:
5-Aug 195 215 110 520 $ 3,120
6-Aug 25 133 251 409 $ 2,454 Average sales with price increase $ 2,762
7-Aug 126 53 196 375 $ 2,250 New price per box: $6
8-Aug 263 141 37 441 $ 2,646
9-Aug 26 174 204 404 $ 2,424 Lookup date:
10-Aug 29 62 29 120 $ 720 Sales goal met?
11-Aug 210 238 98 546 $ 3,276
12-Aug 269 70 273 612 $ 3,672
13-Aug 150 86 224 460 $ 2,760
14-Aug 70 189 55 314 $ 1,884
15-Aug 221 182 240 643 $ 3,858
16-Aug 30 43 206 279 $ 1,674
17-Aug 53 143 259 455 $ 2,730
18-Aug 274 169 27 470 $ 2,820
19-Aug 166 121 101 388 $ 2,328
20-Aug 211 66 69 346 $ 2,076
21-Aug 114 240 72 426 $ 2,556
22-Aug 81 132 267 480 $ 2,880
23-Aug 273 241 194 708 $ 4,248
24-Aug 266 233 42 541 $ 3,246
25-Aug 168 237 273 678 $ 4,068
26-Aug 54 265 255 574 $ 3,444
27-Aug 165 85 189 439 $ 2,634
28-Aug 274 38 55 367 $ 2,202
29-Aug 25 222 188 435 $ 2,610
30-Aug 121 119 245 485 $ 2,910
31-Aug 114 91 257 462 $ 2,772

TysonsStore2018

Date Old Bay Black Truffle Sea Salt and Caramel Daily Total (# sold)
8/1/18 42 115 92 249
8/2/18 42 42 117 201
8/3/18 105 124 64 293
8/4/18 141 83 76 300
8/5/18 137 73 109 319
8/6/18 68 44 60 172
8/7/18 82 58 145 285
8/8/18 125 96 92 313
8/9/18 20 26 39 85
8/10/18 67 38 21 126
8/11/18 121 124 132 377
8/12/18 140 76 25 241
8/13/18 147 77 77 301
8/14/18 86 128 59 273
8/15/18 50 122 96 268
8/16/18 80 92 139 311
8/17/18 41 69 59 169
8/18/18 26 38 125 189
8/19/18 93 41 133 267
8/20/18 84 144 146 374
8/21/18 25 124 145 294
8/22/18 107 60 142 309
8/23/18 116 115 128 359
8/24/18 46 129 145 320
8/25/18 44 112 99 255
8/26/18 112 96 31 239
8/27/18 73 102 97 272
8/28/18 100 89 109 298
8/29/18 55 30 75 160
8/30/18 137 117 97 351
8/31/18 125 39 80 244
 
Do you need a similar assignment done for you from scratch? Order now!
Use Discount Code "Newclient" for a 15% Discount!

Homework Assignmet

These instructions are compatible with both Microsoft Windows and Mac operating systems.

San Diego Sailing keeps data about its fleet of rental and charter boats. One of the sheets is missing a piece of data and another sheet has circular reference errors. You will complete work on these sheets, calculate projected rates for each boat, and build basic statistics about past rentals.

[Student Learning Outcomes 2.1, 2.2, 2.3, 2.4, 2.5, 2.6, 2.7]

File Needed: SanDiegoSailing-02.xlsx (Available from the Start File link.)

Completed Project File Name: [your name]-SanDiegoSailing-02.xlsx

Skills Covered in This Project

  • Create and copy formulas.
  • Use formula auditing tools.
  • Set mathematical order of operations.
  • Use relative, mixed, and 3D cell references.
  • Use COUNTIF and SUMIF functions.
  • Build an IF formula.
  • Insert the TODAY function.

NOTE: If group titles are not visible on your Ribbon in Excel for Mac, click the Excel menu and select Preferences to open the Excel Preferences dialog box. Click the View button and check the Group Titles check box under In Ribbon, Show. Close the Excel Preferences dialog box.

  1. Open the SanDiegoSailing-02.xlsx workbook.
  2. If the workbook opens in Protected View, click the Enable Editing button so you can modify it.
  3. The file will be renamed automatically to include your name. Change the project file name if directed to do so by your instructor, and save it.
  4. Review a formula.
    1. Click the New Prices sheet tab and review the Formula bar.
    2. Click cell D5. The formula begins with 1+D4.
  5. Edit and copy a formula with mixed references.
    1. Edit the formula in cell D5 to show D$4 instead of “D4.” The formula should multiply one plus the percentage value in cell D4 by the current rate on the Fleet sheet ($H5). With an absolute reference to row 4 and column H on the Fleet sheet, you can copy the formula down the column (Figure 2-105).The formula is =(1+D$4)*Fleet!$H5Figure 2-105 Mixed reference in the edited formula
    2. Copy the formula in cell D5 to cells D6:D19 without formatting to preserve the border.
    3. Select cells D5:D19 and drag the Fill pointer to copy the formulas to cells E5:E19.
    4. Click cell E6. The formula is adjusted to use the percentage value in cell E4 in place of cell D4. Note also that the reference on the Fleet sheet ($H6) is adjusted to show the correct row.
  6. Build a formula with mixed references.
    1. Click cell F5 and type =(1+ to start the formula.
    2. Select cell F4 and make it an absolute reference to the row but not the column.
    3. Type )* for the closing parenthesis and multiplication.
    4. Click cell I5 on the Fleet sheet, and make the reference absolute for the column but not the row (Figure 2-106).The formula is =(1+F$4)*Fleet!$I5Figure 2-106 Mixed references in the new formula
    5. Copy the formula down column F without formatting to preserve the border.
    6. Format cells F5:F19 as Currency and then copy cells F5:F19 to cells G5:G19.
  7. Build an IF function formula.
    1. Click the Fleet sheet tab and select cell G5. Rental boats with a stove in the galley must seat 8 or more people.
    2. Create an IF function in which the logical_test argument determines if there are 8 or more seats.
    3. Use Yes for the value_if_true argument. Use No for the value_if_false argument. (If you type the formula, enclose the text arguments within quotation marks.)
    4. Copy the formula to cells G6:G19 without formatting and then center the data in column G.
  8. Insert the TODAY function in cell B21. Format the date to show the month spelled out, the date, and four digits for the year (January 1, 2020).
  9. Create a division formula.
    1. Click the Bookings sheet tab and select cell F5. Calculate average revenue per passenger by dividing the fee by the number of passengers.
    2. Build the division formula.
    3. Copy the formula in cell F5 to cells F6:F19.
  10. Create and copy a COUNTIF function to count bookings by boat manufacturer.
    1. Select cell D27.
    2. Start the COUNTIF function from the Statistical category by clicking the More Functions button in the Function Library group.
    3. Use cells $C$5:$C$19 as the Range argument.
    4. Set a Criteria argument that will select all boats in the “Beneteau” group. The criteria is ben*. If you type the formula, include quotation marks.
    5. Copy the formula in cell D27 to cells D28:D30.
    6. Edit the criteria in each copied formula in cells D28:D30 to reflect the boat make.
  11. Create and copy a SUMIF function to calculate total revenue by boat make.
    1. Select cell E27.
    2. Start the SUMIF function with cells $C$5:$C$19 as the Range.
    3. Set the Criteria argument to ben*.
    4. Set the Sum_range argument to cells $E$5:$E$19.
    5. Copy the formula in cell E27 to cells E28:E30.
    6. Edit the criteria in each copied formula in cells E28:E30 as needed.
  12. Complete formatting.
    1. Apply the Currency format to all values that represent money.
    2. Format the labels in cells A1:A2 as 18 point.
    3. Select cells A1:F2 and click the Alignment launcher [Home tab, Alignment group]. Center the labels across the selection.
    4. Merge and center the label in cell C25 over cells C25:E25 and format it at 16 points.
    5. Bold and center the labels in rows 4 and 26.
    6. Select cells A4:F19 and apply All Borders. Do the same for cells C25:E30.
    7. Center the page horizontally.
  13. Save and close the workbook (Figure 2-107).Excel 2-5 completedFigure 2-107 Excel 2-5 completed
  14. Upload and save your project file.
  15. Submit project for grading.
 
Do you need a similar assignment done for you from scratch? Order now!
Use Discount Code "Newclient" for a 15% Discount!

BRD Document

Project Name Version: <x.y>
Business Requirements Document Date:
BRD

 

Project Name

Business Requirements Document

Version <x.y>

 

 

 

Company Logo

 

 

Revision History

Date Version Description Author
Dd/mm/yyyy <0.1> First Draft Name
Dd mm yyyy 0.2 2.2 UML Diagrm updates  
       
  1.0 Client signed off on 23 Jan 2020  
  1.1 7.1 Added Email standatrd templates

5.3 New user story abt Regulatory req ia added

 
  2.0 Approval from client taken on mail  

 

Table of Contents

1. Introduction 4

1.1 References 4

1.2 Business Requirements Index 4

2. Gap Analysis 4

2.1 As-Is Process 4

2.2 To-Be Process 4

2.3 Strategy or project approach to be followed 4

3. Product Overview 4

3.1 Solution Scope 4

3.2 Assumptions and Dependencies 5

4. Requirements (Detailed) 5

5. Non-Functional Requirements 6

Business Requirements Document

Introduction

The purpose of this document is to collect, analyze, and define high-level needs and features of the AP Exception Handling project. It focuses on the capabilities needed by the stakeholders and the target users, and why these needs exist. The details of how the AP Exception Handlingproject fulfills these needs are detailed in the use-case and software requirements specifications.

References

Type Name Source
Input    
Non-artifact resource    
Non-artifact resource    

 

Business Requirements Index

ID Short Description
BR001 User story title
BR002  
BR003  
BR005  
BR006  
BR007  
BR009 Min 9

Gap Analysis

As-Is Process

 

Detail about as-is process and current shortcoming or what is reason to have this project.

As-is process flow

To-Be Process

To be process and complete UML diagram or process flow or process modeling diagram. This is very important

 

Strategy or project approach to be followed

………………………………………..

 

Product Overview

Solution Scope

Scope of Project

Ideally, this will be represented as a set of high-level bullet points that correspond to high level requirements.

Each bullet Requirement here will or should have a corresponding set of detailed Requirements elsewhere within or outside the document.

As the name implies, Out of Scope sub-section explains what NOT will be delivered by this project, and (usually) why. This is important to manage expectations of your stakeholders (assumptions about scope are, as you will be aware, a major source of heartburn during implementation sign-off).

On Agile projects, high level requirements usually correspond to Epics and the big User stories that make up these epics.

For most non-project stakeholders, the Overview and Scope sections provide sufficient information about the project, so it is important to be both concise and precise at the same time.

 

Assumptions and Dependencies

Type Description
Assumption  
Dependency  
Deliverables  
Risks & Constraints  

 

Requirements (Detailed)

ID Requirement      
BR001 Write User Story, details and acceptance criterion
BR002  

Document the requirements that your Business Sponsor or Product Owner need to be delivered by this project/initiative. Requirements can be classified under several headers – the internet provides a variety of responses for the search string ‘types of requirements. What we need is a standard format that you can use to document all requirements.

 

A cookie cutter format for documenting requirements would be:

· Index – can start from 1, 2, 3… for high level requirements and go on to 5.1, 5.2, 5.1.1, 5.1.2 and so on for lower level requirements. You can apply such numbering conventions to Agile user stories

· Title Description – brief description of the high-level requirement.

· Detailed Description – self-explanatory. User stories in the form of ‘As a customer, I can… so that…’ fit here.

· Owner – usually the Business Sponsor or the Product Owner. Can also be stakeholders like IT, Marketing, Legal, Compliance etc. depending on the requirement.

· Priority – High, Medium, Low (or a variation of this)or number 1 to 9. 1 means most imp

 

Non-Functional Requirements

Usually,  Non Functional Requirements  (NFRs) find their own section in a Requirements Document template. If you are familiar with this topic, you’ve heard about Performance, Reliability, Scalability, Maintainability etc.

Why do they have their own sections? This is because NFRs are often stated in measurable terms, and hence need to be stated differently to other requirements.

For example: when a customer logs on to the mobile app, logon should complete and dashboard should load in less than 2 seconds; the system should never go offline, except for scheduled maintenance periods, etc.

 

 

Confidential , 2020 Page 4
 
Do you need a similar assignment done for you from scratch? Order now!
Use Discount Code "Newclient" for a 15% Discount!

Computer Science Queuing Model

Solution

If you want the formulas and any calculations, select the corresponding cell and press F2(Function Key on key board),
It will show all calculations and formulas Automatically
Question:
14-11
The Rockwell Electronics Corporation retains a service crew to repair machine breakdowns that occur on an average of 𝜆=3 per day (approximately Poisson in nature), the crew can service an average of µ = 8 machines per day, with a repair time distribution that resembles the exponential distribution.
(a) What is the utilization rate of this service system?
(b) What is the average downtime for a machine that is broken?
(c) How many machines are waiting to be serviced at any given time?
(d) What is the probability that more than one machine is in the system? Probability that more than
two are broken and waiting to be repaired or being serviced? More than three? More than four?
Arrival rate (λ) 3 Per day
Service rate (μ) 8 Per day
(a) What is the utilization rate of this service system?
Solution: computation of the following
Utilization rate(U)=λ/μ
server utilization (U) 37.50%
(b) What is the average downtime for a machine that is broken?
Solution: computation of the following
The average down time is the time that the machine waits to be serviced plus the time taken to repair the machine.
The average down time is given by W
W=1/1(μ-λ)
W 0.2 Day
assuming 8 hrs/day 1.6 Hours
(c) How many machines are waiting to be serviced at any given time?
Solution: computation of the following
Lq=λ^2/μ(μ-λ)
Lq 0.225 Machines
(d) What is the probability that more than one machine is in the system? Probability that more than two are broken and waiting to be repaired or being serviced? More than three? More than four?
Solution: computation of the following
Pn>k=(λ/μ)^(k+1)
Pn>1 0.141
Pn>2 0.053
Pn>3 0.020
Pn>4 0.007

Solution 2

If you want the formulas and any calculations, select the corresponding cell and press F2(Function Key on key board),
It will show all calculations and formulas Automatically
Question:
From historical data, Harry’s car wash estimates that dirty cars arrive at the rate of 10 per hour all day Saturday. With a crew working the wash line, Harry figures that cars can be cleaned at the rate of one every five minutes. One car at a time is cleaned in this example of single-server waiting line. Assuming Poisson arrivals and exponential service times, find the
A) average number of cars in line
B) average time a car waits before it is washed
C) average time a car spends in the service system
D) utilization rate of the car wash
E) probability that no cars are in the system
Arrival rate 10 cars Per hour
Service rate One car at every 5 minutes
Service rate 12 cars per hour
Number of servers (s) 1
Entering above values in the Excelmodules Queuing models—->M/M/s, we get following results:
A) average number of cars in line
Avg no of cars in line(Lq) 4.1666666667
B) average time a car waits before it is washed
Avg waiting time in queue(Wq) 0.4166666667 hours
Avg waiting time in queue(Wq) 25 Mins
C) average time a car spends in the service system
Avg time in service system(W) 0.5 hours
Avg time in service system(W) 30 Mins
D) utilization rate of the car wash
Average utilization of service system 0.8333333333 83.33 Percent
E) probability that no cars are in the system
Probability of no car in the system(P(0)) 0.1666666667

Solution_Excel modules

Harry’s car wash
Queuing Model M/M/s (Exponential Service Times)
Input Data Operating Characteristics
Arrival rate (l) 10 Average server utilization (r) 0.8333
Service rate (m) 12 Average number of customers in the queue (Lq) 4.1667
Number of servers (s) 1 Average number of customers in the system (L) 5.0000
Average waiting time in the queue (Wq) 0.4167
Average time in the system (W) 0.5000
Probability (% of time) system is empty (P0) 0.1667
0
Probabilities
Number of Units Probability Cumulative Probability
0 0.1667 0.1667
1 0.1389 0.3056
2 0.1157 0.4213
3 0.0965 0.5177
4 0.0804 0.5981
5 0.0670 0.6651
6 0.0558 0.7209
7 0.0465 0.7674
8 0.0388 0.8062
9 0.0323 0.8385
10 0.0269 0.8654
11 0.0224 0.8878
12 0.0187 0.9065
13 0.0156 0.9221
14 0.0130 0.9351
15 0.0108 0.9459
16 0.0090 0.9549
17 0.0075 0.9624
18 0.0063 0.9687
19 0.0052 0.9739
20 0.0043 0.9783
Computations
n or s (lam/mu)^n/n! Cumsum(n-1) term2 P0(s) Rho(s) Lq(s) L(s) Wq(s) W(S)
0 1
1 0.8333333333 1 5 0.1666666667 0.8333333333 4.1666666667 5 0.4166666667 0.5
2 0.3472222222 1.8333333333 0.5952380952 0.4117647059 0.4166666667 0.175070028 1.0084033613 0.0175070028 0.1008403361
3 0.0964506173 2.1805555556 0.1335470085 0.432132964 0.2777777778 0.0221961787 0.855529512 0.0022196179 0.0855529512
4 0.0200938786 2.2770061728 0.0253817414 0.4343316753 0.2083333333 0.0029010774 0.8362344108 0.0002901077 0.0836234411
5 0.0033489798 2.2971000514 0.0040187757 0.434571213 0.1666666667 0.0003492888 0.8336826222 0.0000349289 0.0833682622
6 0.0004651361 2.3004490312 0.000540158 0.4345956968 0.1388888889 0.000037863 0.8333711963 0.0000037863 0.0833371196
7 0.0000553733 2.3009141673 0.0000628562 0.4345979946 0.119047619 0.0000036915 0.8333370248 0.0000003692 0.0833337025
8 0.0000057681 2.3009695406 0.0000064388 0.4345981918 0.1041666667 0.0000003254 0.8333336587 0.0000000325 0.0833333659
9 0.0000005341 2.3009753087 0.0000005886 0.4345982073 0.0925925926 0.0000000261 0.8333333594 0.0000000026 0.0833333359
10 0.0000000445 2.3009758428 0.0000000486 0.4345982084 0.0833333333 0.0000000019 0.8333333353 0.0000000002 0.0833333335
11 0.0000000034 2.3009758873 0.0000000036 0.4345982085 0.0757575758 0.0000000001 0.8333333335 0 0.0833333333
12 0.0000000002 2.3009758906 0.0000000003 0.4345982085 0.0694444444 0 0.8333333333 0 0.0833333333
13 0 2.3009758909 0 0.4345982085 0.0641025641 0 0.8333333333 0 0.0833333333
14 0 2.3009758909 0 0.4345982085 0.0595238095 0 0.8333333333 0 0.0833333333
15 0 2.3009758909 0 0.4345982085 0.0555555556 0 0.8333333333 1.34352048387924E-16 0.0833333333
16 0 2.3009758909 0 0.4345982085 0.0520833333 6.51218686419213E-17 0.8333333333 6.51218686419213E-18 0.0833333333
17 1.26721499130873E-16 2.3009758909 1.33253535168546E-16 0.4345982085 0.0490196078 2.98514163203532E-18 0.8333333333 2.98514163203532E-19 0.0833333333
18 5.86673607087373E-18 2.3009758909 6.15152908402294E-18 0.4345982085 0.0462962963 1.29778811625998E-19 0.8333333333 1.29778811625998E-20 0.0833333333
19 2.57312985564637E-19 2.3009758909 2.69116333526318E-19 0.4345982085 0.0438596491 5.36502185461152E-21 0.8333333333 5.36502185461152E-22 0.0833333333
20 1.07213743985266E-20 2.3009758909 1.1187521111506E-20 0.4345982085 0.0416666667 2.11394636204157E-22 0.8333333333 2.11394636204157E-23 0.0833333333
21 4.25451365020895E-22 2.3009758909 4.43031999939114E-22 0.4345982085 0.0396825397 7.95623609441516E-24 0.8333333333 7.95623609441516E-25 0.0833333333
22 1.61155820083672E-23 2.3009758909 1.67500537409801E-23 0.4345982085 0.0378787879 2.86596194812096E-25 0.8333333333 2.86596194812096E-26 0.0833333333
23 5.83897898853885E-25 2.3009758909 6.05848947682979E-25 0.4345982085 0.0362318841 9.89852884544816E-27 0.8333333333 9.89852884544816E-28 0.0833333333
24 2.02742325990932E-26 2.3009758909 2.10035215415067E-26 0.4345982085 0.0347222222 3.28348663103548E-28 0.8333333333 3.28348663103548E-29 0.0833333333
25 6.75807753303108E-28 2.3009758909 6.9911146893425E-28 0.4345982085 0.0333333333 1.04769859291578E-29 0.8333333333 1.04769859291578E-30 0.0833333333
26 2.16605049135612E-29 2.3009758909 2.23777401755996E-29 0.4345982085 0.0320512821 3.22030655322929E-31 0.8333333333 3.22030655322929E-32 0.0833333333
27 6.68534102270406E-31 2.3009758909 6.89824997247171E-31 0.4345982085 0.0308641975 9.54766585945925E-33 0.8333333333 9.54766585945925E-34 0.0833333333
28 1.98968482818573E-32 2.3009758909 2.05071810512395E-32 0.4345982085 0.0297619048 2.73386016760705E-34 0.8333333333 2.73386016760705E-35 0.0833333333
29 5.71748513846475E-34 2.3009758909 5.88664150350809E-34 0.4345982085 0.0287356322 7.56900547795275E-36 0.8333333333 7.56900547795275E-37 0.0833333333
30 1.58819031624021E-35 2.3009758909 1.6335671824185E-35 0.4345982085 0.0277777778 2.02841534558582E-37 0.8333333333 2.02841534558582E-38 0.0833333333
1. Both l and m must be RATES, and use the same time unit. For example, given a service time such as 10 minutes per customer, convert it to a service rate such as 6 per hour. 2. The total service rate (rate x servers) must be greater than the arrival rate.
 
Do you need a similar assignment done for you from scratch? Order now!
Use Discount Code "Newclient" for a 15% Discount!

Excel 2019 In Practice – Ch 2 Independent Project 2-4

Commissions

Central Sierra Insurance Commission Sales and Bonuses
ID Last Name First Name Branch Commissions Bonus Rate Total Earnings
101 Lingle Bob Cameron Park $15,000
102 McCartney Lanita Folsom $12,000
103 Santos Eleesha Cameron Park $5,500
104 Baxter Roy Granite Bay $4,500
105 Alaro Jennifer Folsom $3,000
115 Chan Tami Cameron Park $3,000
117 Althouse Charlene Granite Bay $4,700
119 Taylor Juan Granite Bay $4,000
120 Reza Wayne Cameron Park $4,000
125 Nevens Cheryl Cameron Park $12,000
Branch Totals
Cameron Park
Folsom
Granite Bay
Total

Family Day

Central Sierra Insurance
Family Day Community Fundraiser
ID Last Name First Name Branch Source Goal Amount Goal Reached?
101 Lingle Bob Cameron Park Raffle tickets $750
102 McCartney Lanita Folsom Walk/run pledge $225
103 Santos Eleesha Cameron Park Cash donation $725
104 Baxter Roy Granite Bay Candy sales $450
105 Alaro Jennifer Folsom Pedometer sales $750
115 Chan Tami Cameron Park Raffle tickets $275
117 Althouse Charlene Granite Bay Walk/run pledge $275
119 Taylor Juan Granite Bay Walk/run pledge $325
120 Reza Wayne Cameron Park Cash donation $325
125 Nevens Cheryl Cameron Park Candy sales $215
102 McCartney Lanita Folsom Candy sales $350
103 Santos Eleesha Cameron Park Raffle tickets $825
117 Althouse Charlene Granite Bay Raffle tickets $900
104 Baxter Roy Granite Bay Pedometer sales $825
105 Alaro Jennifer Folsom Cash donation $1,000

Tables

Commission $3,000 $6,000 $9,000 $12,000 $15,000
Bonus 1.50% 1.75% 1.90% 2.25% 2.50%
Source Goal
Candy sales $300
Cash donation $500
Pedometer sales $500
Raffle tickets $500
Walk/run pledge $250
 
Do you need a similar assignment done for you from scratch? Order now!
Use Discount Code "Newclient" for a 15% Discount!

C Programming

C programming!!!!! Expert only
Compound interest.

 

(a) Write a function to compute and return the amount of money, A, that you will have in n years if you invest P dollars now at annual interest rate i. Take n, i, and P as parameters. The formula is

 

A = P(1 + i)n

 

(b) Write a function to compute and return the amount of money, P, that you would need to invest now at annual interest rate i in order to have A dollars in n years. Take n, i, and A as parameters. The formula is:

P =A / (1 + i)n

 

(c) Write a function that will read and validate the inputs for this program. Using call by value/address, return an enumerated constant for the choice of formulas, a number of years, an interest rate, and an amount of money, in dollars. All three numbers must be greater than 0.0.

 

(d) Write a main program that will call the input routine to gather the data. Then, depending on the user’s choice, it should call the appropriate calculation function and print the results of thecalculation.
 
Do you need a similar assignment done for you from scratch? Order now!
Use Discount Code "Newclient" for a 15% Discount!

DIGITAL FORENSICS

TASK

Note: A Study Planner tool has been provided with this subject to support the assessment process. This tool provides information about the submission flexibility of assessment tasks, and a way to organise adjustments to submission dates. A link to the Study Planner can be found on the Interact2 site.

Task 1: Reflection on Hands-on Projects (5 marks)

Complete the following hands-on projects from your textbook:

1. Hands-on Project 1-1

2. Hands-on Project 1-2

3. Hands-on Project 1-4

4. Hands-on Project 1-5

5. Hands-on Project 1-6

Deliverable: Write a 500-1000 words (up to two A4 pages) report on lessons learned from these projects. Comment on each project individually within the two-page limit. You can write one lesson learned from each of the projects.

Task 2: Case Project (5 marks)
Complete the Hands-on Project 5-2 from your textbook (Nelson, Phillips, & Steuart, 6th edition, 2019, p. 260-261). In this project you will explore the MFT and learn how to locate time and date values in the metadata of a file you create during this project.
Deliverable: Write a 500-1000 words paper after completing this project and report what metadata you have discovered from the file you analysed using WinHex editor. Provide screen shots of the steps completed in the project showing the results of date and time values you have recorded. Briefly describe the main steps that you think are necessary and important to locate date and time values while analysing the file.

Task 3: Research Project (5 marks)

You have been assigned a digital forensics case to investigate involving a potential monetary fraud in an organisation. The CTO of the organisation has given you access to the workstation and other necessary hardware, e.g. USB, of one of his employees who she thinks is potentially involved in this fraud. Your job as a digital forensics examiner is to conduct this investigation. You are required to create a (investigation) plan and describe the standard practice procedure that is used in such investigations. Your plan must include the procedures for collecting the digital data, securing the evidence that you may collect and then describing the method to validate the collected data, e.g. calculating hash values and specifying the hash algorithm that you intend to use, e.g. SHA-3, MD5 etc. You can make some reasonable assumptions if required when describing your plan / procedures.

Deliverable: Write a 500-1000 word report that outlines the investigation plan, procedures to secure the digital evidence, and data validation methods.

Note: Combine deliverable’s of all three tasks mentioned above in a single document (only MS Word (preferable) or pdf, please note other formats e.g. *.zip, *.rar etc are NOT allowed) and then submit that one / single document through Turnitin

 
Do you need a similar assignment done for you from scratch? Order now!
Use Discount Code "Newclient" for a 15% Discount!

Python Programming Assignments

ITM205

Module 2 – Case

Input, Output, and Built-in and Programmer-Defined Functions

Case Assignment

Study Halterman, R. “Learning to Program with Python”, chapter 7, and complete homework assignment: question 1-10 on page 156 under 7.8 exercises

Create a Word file named as “ITM205-Case 2-Exercises-YourFirstNameLastName”containing a copy of each of the IDLE source codes and running results with clear exercise numbers marked on the page.

You can use the Snipping tools or screen print (ctrl + Print Screen) to show the Pythons editor’s (IDLE) code and results and demonstrate that your program executed correctly.

Write a summary document in Microsoft Word format named as “ITM205-Case2-Summary-YourFirstNameLastName” to show what you have accomplished through the exercises.

 
Do you need a similar assignment done for you from scratch? Order now!
Use Discount Code "Newclient" for a 15% Discount!

Subnetting Worksheet

ITT-116 Subnetting Worksheet

Use the following tables as references for the remainder of the document.

IP Address Classes
Class A 1-127 Leading bit pattern 0 Network.Host.Host.Host
Class B 128-191 Leading bit pattern 10 Network.Network.Host.Host
Class C 224-239 Leading bit pattern 110 Network.Network.Network.Host
Class D 224-230 Reserved for multicast
Class E 240-255 Reserved for experimental, used for research.

 

Private Addresses
Class A 10.0.0.0 – 10.255.255.255
Class B 172.16.0.0 – 172.31.255.255
Class C 192.168.0.0 – 192.168.255.255
APIPA 169.254.0.1 – 169.254.255.254

 

 

 

Binary to Decimal Conversion

128 64 32 16 8 4 2 1 Answers
0 0 0 1 1 0 1 1  
0 0 1 1 1 0 1 1  
1 1 1 1 0 0 0 0  
0 0 1 1 0 0 0 1  
1 0 0 0 1 0 0 0  
1 0 1 0 1 0 1 0  
0 1 1 0 1 1 0 1  
1 0 0 1 1 0 0 1  
1 1 0 1 0 1 1 0  

 

Decimal to Binary Conversion

128 64 32 16 8 4 2 1 Problem
                200
                255
                107
                224
                192
                98
                242
                224
                172
                100

 

Address Classes

Address Class
148.17.9.1  
220.200.23.1  
177.100.15.4  
249.241.80.78  
198.155.72.56  
10.0.0.1  
192.168.123.42  
123.231.132.9  
42.42.42.42  
242.81.64.3  

 

 

 

Network Identification

Highlight the Network Portion:

117. 89. 56. 90
33. 0. 0. 2
10. 252 1. 1
150. 15. 16. 3
192. 168. 123. 1
199. 155. 66. 56
242. 200. 23. 1
158. 200. 45. 62
218. 155. 230. 41
100. 25. 1. 1

 

Highlight the Host Portion

117. 89. 56. 90
33. 0. 0. 2
10. 252 1. 1
150. 15. 16. 3
192. 168. 123. 1
199. 155. 66. 56
242. 200. 23. 1
158. 200. 45. 62
218. 155. 230. 41
100. 25. 1. 1

 

 

Network Addressing

Write the network addresses for the provided IP address/subnet mask.

10.10.48.80 255.255.255.0  
10.10.10.10 255.0.0.0  
27.125.200.151 255.0.0.0  
199.203.32.91 255.255.255.0  
186.31.32.110 255.255.0.0  
192.168.24.19 255.255.0.0  
15.30.20.20 255.255.255.0  
27.0.2.1 255.0.0.0  
164.42.3.4 255.255.255.0  
25.25.142.8 255.0.0.0  

 

 

 

 

Host Addresses

Using the IP address and subnet mask shown, write the host address

10.10.48.80 255.255.255.0  
10.10.10.10 255.0.0.0  
27.125.200.151 255.0.0.0  
199.203.32.91 255.255.255.0  
186.31.32.110 255.255.0.0  
192.168.24.19 255.255.0.0  
15.30.20.20 255.255.255.0  
27.0.2.1 255.0.0.0  
164.42.3.4 255.255.255.0  
25.25.142.8 255.0.0.0  

 

 

 

 

 

 

 

 

 

 

 

 

 

Default Subnet Mask

Write the correct default subnet mask for each

10.10.48.80 255.255.255.0  
10.10.10.10 255.0.0.0  
27.125.200.151 255.0.0.0  
199.203.32.91 255.255.255.0  
186.31.32.110 255.255.0.0  
192.168.24.19 255.255.0.0  
15.30.20.20 255.255.255.0  
27.0.2.1 255.0.0.0  
164.42.3.4 255.255.255.0  
25.25.142.8 255.0.0.0  

 

Custom Subnet Masks

Fill in the blanks

Required Subnets 14
Required Hosts 14
Network Address 192.10.10.0
Address Class  
Default Subnet Mask  
Custom Subnet Mask  
Total Number of Subnets  
Total Number of Host Addresses  
Number of Usable Addresses  
Number of Bits Borrowed  
What is the 10th Subnet Range?  
What is the subnet number for the 2nd Subnet?  
What is the broadcast address for the 12th Subnet?  
What are the usable addresses for the 10th Subnet?  

 

Required Subnets 1000
Required Hosts 60
Network Address 156.100.0.0
Address Class  
Default Subnet Mask  
Custom Subnet Mask  
Total Number of Subnets  
Total Number of Host Addresses  
Number of Usable Addresses  
Number of Bits Borrowed  
What is the 10th Subnet Range?  
What is the subnet number for the 2nd Subnet?  
What is the broadcast address for the 12th Subnet?  
What are the usable addresses for the 100th Subnet?  

 

 

Required Subnets 6
Required Hosts 28
Network Address 182.86.7.0
Address Class  
Default Subnet Mask  
Custom Subnet Mask  
Total Number of Subnets  
Total Number of Host Addresses  
Number of Usable Addresses  
Number of Bits Borrowed  
What is the 3rd Subnet Range?  
What is the subnet number for the 2nd Subnet?  
What is the broadcast address for the 1st Subnet?  
What are the usable addresses for the 6th Subnet?  

 

 

 

 

 

 

 

 

Required Subnets 2000
Required Hosts 15
Network Address 187.112.0.0
Address Class  
Default Subnet Mask  
Custom Subnet Mask  
Total Number of Subnets  
Total Number of Host Addresses  
Number of Usable Addresses  
Number of Bits Borrowed  
What is the 100th Subnet Range?  
What is the subnet number for the 200th Subnet?  
What is the broadcast address for the 42nd Subnet?  
What are the usable addresses for the 10th Subnet?  

 

 

Required Subnets 412
Required Hosts 1000
Network Address 128.47.0.0
Address Class  
Default Subnet Mask  
Custom Subnet Mask  
Total Number of Subnets  
Total Number of Host Addresses  
Number of Usable Addresses  
Number of Bits Borrowed  
What is the 10th Subnet Range?  
What is the subnet number for the 42nd Subnet?  
What is the broadcast address for the 300th Subnet?  
What are the usable addresses for the 12th Subnet?  

 

 

 

 

 

 

Create the subnetting table for each subnet required for your corporate network.

Required Subnets  
Required Hosts  
Network Address  
Address Class  
Default Subnet Mask  
Custom Subnet Mask  
Total Number of Subnets  
Total Number of Host Addresses  
Number of Usable Addresses  
Number of Bits Borrowed  
What are the usable addresses for the 1st Subnet?  
What are the usable addresses for the 2nd Subnet?  
What are the usable addresses for the 3rd Subnet?  
What are the usable addresses for the 4th Subnet?  
What are the usable addresses for the 5th Subnet?  
 
Do you need a similar assignment done for you from scratch? Order now!
Use Discount Code "Newclient" for a 15% Discount!

Excel Assignment

Documentation

Shelly Cashman Excel 2019 | Module 5: SAM Project 1a
Media Hub
CONSOLIDATE WORKBOOK DATA
Author: Brittany Thomas
Note: Do not edit this sheet. If your name does not appear in cell B6, please download a new copy of the file from the SAM website.

United States

Media Hub Audio Books Date:
United States Price per book: $ 8.95
Downloads: January – April Download Projections
Book Type January February March April Total May
Adventure 2,193 2,282 2,130 2,215 8,820 Increase downloads to 14,000 in December
Literary 989 1,036 798 803 3,626 11,432 14,000
Mystery 2,405 2,788 2,239 3,011 10,443 Increase downloads by 3% per month
Romance 2,397 2,655 3,244 2,769 11,065 11,432
Science fantasy 1,873 1,869 1,904 1,874 7,520
Self-help 1,027 1,095 1,124 1,006 4,252
Total 10,884 11,725 11,439 11,678 45,726
Sales: January – April
Book Type January February March April Total
Adventure 19,627.35 20,423.90 19,063.50 19,824.25 78,939.00
Literary 8,851.55 9,272.20 7,142.10 7,186.85 32,452.70
Mystery 21,524.75 24,952.60 20,039.05 26,948.45 93,464.85
Romance 21,453.15 23,762.25 29,033.80 24,782.55 99,031.75
Science fiction 16,763.35 16,727.55 17,040.80 16,772.30 67,304.00
Self-help 9,191.65 9,800.25 10,059.80 9,003.70 38,055.40
Total $ 97,411.80 $ 104,938.75 $ 102,379.05 $ 104,518.10 $ 409,247.70

Canada

Media Hub Audio Books Date:
Canada Price per book: $ 9.95
Downloads: January – April Download Projections
Book Type January February March April Total May
Adventure 968 1,082 1,120 1,015 4,185 Increase downloads to 10,000 in December
Literary 689 836 708 640 2,873 5,972 10,000
Mystery 1,205 1,288 1,339 1,411 5,243 Increase downloads by 3% per month
Romance 1,097 1,055 1,144 1,469 4,765 5,972
Science fantasy 773 879 904 1,074 3,630
Self-help 707 795 824 866 3,192
Total 5,439 5,935 6,039 6,475 23,888
Sales: January – April
Book Type January February March April Total
Adventure 9,631.60 10,765.90 11,144.00 10,099.25 41,640.75
Literary 6,855.55 8,318.20 7,044.60 6,368.00 28,586.35
Mystery 11,989.75 12,815.60 13,323.05 14,039.45 52,167.85
Romance 10,915.15 10,497.25 11,382.80 14,616.55 47,411.75
Science fiction 7,691.35 8,746.05 8,994.80 10,686.30 36,118.50
Self-help 7,034.65 7,910.25 8,198.80 8,616.70 31,760.40
Total $ 54,118.05 $ 59,053.25 $ 60,088.05 $ 64,426.25 $ 237,685.60

Australia

Media Hub Audio Books Date:
Australia Price per book: $ 10.95
Downloads: January – April Download Projections
Book Type January February March April Total May
Adventure 652 705 759 812 2,928 Increase downloads to 5500 in December
Literary 189 227 265 303 984 3,742 5,500
Mystery 805 928 1,052 1,175 3,960 Increase downloads by 3% per month
Romance 497 610 652 736 2,495 3,742
Science fantasy 712 799 886 973 3,370
Self-help 227 281 335 389 1,232
Total 3,082 3,551 3,948 4,388 14,969
Sales: January – April
Book Type January February March April Total
Adventure 7,139.40 7,723.40 8,307.40 8,891.40 32,061.60
Literary 2,069.55 2,485.65 2,901.75 3,317.85 10,774.80
Mystery 8,814.75 10,165.25 11,515.75 12,866.25 43,362.00
Romance 5,442.15 6,679.50 7,139.40 8,059.20 27,320.25
Science fiction 7,796.40 8,749.05 9,701.70 10,654.35 36,901.50
Self-help 2,485.65 3,076.95 3,668.25 4,259.55 13,490.40
Total $ 33,747.90 $ 38,879.80 $ 43,234.25 $ 48,048.60 $ 163,910.55

All Locations

Media Hub Audio Books
All Locations
Downloads: January – April
Book Type January February March April Total
Adventure – 0
Literary – 0
Mystery – 0
Romance – 0
Science fantasy – 0
Self-help – 0
Total – 0 – 0 – 0 – 0 – 0
Sales: January – April
Book Type January February March April Total
Adventure $ – 0
Literary $ – 0
Mystery $ – 0
Romance $ – 0
Science fiction $ – 0
Self-help $ – 0
Total $ – 0 $ – 0 $ – 0 $ – 0 $ – 0
Total sales last year (Jan-Apr)
 
Do you need a similar assignment done for you from scratch? Order now!
Use Discount Code "Newclient" for a 15% Discount!