Excel Problem #10

/in /by

New Perspectives Excel 2013| Tutorial 10: SAM Project 1a

 

New Perspectives Excel 2013

Tutorial 10: SAM Project 1a

Firestone Clock Company

WHAT-IF ANALYSES AND SCENARIOS

 

Project Goal

M Project Name

Project Goal

 

 

 

 

PROJECT DESCRIPTION

Walter Silva runs operations at Firestone Clock Company. The company currently owns and operates its own manufacturing facilities that produce three lines of clocks, Desktop Models, Wall Units, and Custom Clocks. Manufacturing and other costs have been rising, and profits are being squeezed. Walter has asked you to create a workbook that details the financial components of each product line, then analyze a number of scenarios that involve cutting expenses and/or raising prices. You are trying to find the most profitable mix of products using the most cost-effective means of production.

GETTING STARTED

· Download the following file from the SAM website:

· NP_Excel2013_T10_P1a_FirstLastName_1.xlsx

· Open the file you just downloaded and save it with the name:

· NP_Excel2013_T10_P1a_FirstLastName_2.xlsx

· Hint: If you do not see the .xlsx file extension in the Save file dialog box, do not type it. Excel will add the file extension for you automatically.

· With the file NP_Excel2013_T10_P1a_FirstLastName_2.xlsx still open, ensure that your first and last name is displayed in cell B6 of the Documentation sheet. If cell B6 does not display your name, delete the file and download a new copy from the SAM website.

 

· This project requires the use of the Solver add-in. If this add-in is not available in the Analysis group (or if the Analysis group is not available) on the DATA tab, install Solver by following the steps below.

· In Excel, click the FILE tab, and then click the Options button in the left navigation bar.

· Click the Add-Ins option in the left pane of the Excel Options window.

· Click on the arrow next to the Manage box, click the Excel Add-Ins option, and then click the Go button.

· In the Add-Ins window, click the check box next to the Solver Add-In option and then click the OK button.

· Follow any remaining prompts to install Solver.

PROJECT STEPS

Go to the Desktop Models worksheet. In cell C28, use Goal Seek to perform a break-even analysis for Desktop Models by calculating the number of units the company needs to sell (represented by the value in cell C27), at the price per unit listed in cell C25, in order to break even, or reach a Gross Profit of $0. (Hint: The number format applied to cell C25 will make a value of $0 display as $ -)

Create a one-variable data table to display values for Sales, Expenses, and Profits based on the Number of Clocks sold by completing the following actions:

a. In cell E5, enter a formula to reference cell C5, which is the input cell to be used in the data table.

b. In cell F5, enter a formula that references cell C20, which is the expected total sales for this product.

c. In cell G5, enter a formula that references cell C21, which is the expected total expenses for this product.

d. In cell H5, enter a formula that references cell C22, which is the expected gross profit for this product.

e. Select the range E5:H10 and then complete the one-variable data table, using cell C5 as the Column input cell for your data table.

Select range E14:L19. Create a two-variable data table to display values for gross Profit based on Units Sold and Price per Unit (Hint: Use cell C6 as the Row input cell and cell C5 as the Column input cell).

Apply a custom format to cell E14 to display the text “Units Sold/Price” in place of the cell value.

Go to the Wall Units worksheet. Create a Scatter with Straight Lines chart based on range E4:G14 in the data table Wall-Units – Break-Even Analysis. Modify the chart as described below:

f. Resize and reposition the chart so the upper-left corner is in cell E15 and the lower-right corner is in cell H28.

g. Remove the chart title from the chart.

h. Add Sales and Expenses as the Vertical Axis title and Units Sold as the Horizontal Axis title.

i. For the Vertical Axis, change the Minimum Bounds to 300000 and the Maximum Bounds to 550000. Change the Number format of the Vertical Axis to Currency with 0 decimal places.

j. For the Horizontal Axis, change the Minimum Bounds to 5000 and the Maximum Bounds to 9000.

k. Use the Change Colors option to change the color set for the chart to Color 14 (the 4th entry from the bottom in the gallery of color choices).

Open the Scenario Manager and add two scenarios for the data in the Wall Units worksheet based on the data shown in Table 1. The changing cells for both scenarios are the non-adjacent cells C12, and C15. Close the Scenario Manager without showing any of the scenarios.

 

 

 

Table 1: Wall Unit Scenario Values

Values Scenario 1 Scenario 2
Scenario Name Standard Materials Green Materials
Wall_Unit_Variable_Cost (C12) 33.75 42.50
Wall_Unit_Fixed_Cost (C15) 175000 225000

 

Copyright © 2014 Cengage Learning. All Rights Reserved.

 

Go to Custom Clocks worksheet. Create a Scatter with Straight Lines chart based on range E6:J14 in the data table Custom Clocks – Net Income Analysis. Make the following modifications to the chart:

l. Resize and reposition the chart so the upper-left corner is in cell E15 and the lower-right corner is in cell J28.

m. Remove the chart title from the chart.

n. Reposition the chart legend to the Right of the chart.

o. Add the title Net Income as the Vertical Axis title and Units Sold as the Horizontal Axis title.

p. For the Vertical Axis, change the Minimum Bounds to –150000 and the Maximum Bounds to 250000. Change the Number format of the Vertical Axis to Currency with 0 decimal places.

q. For the Horizontal Axis, change the Minimum Bounds to 3000 and the Maximum Bounds to 7500.

In the Scatter with Straight Lines chart created in the previous step, edit the chart series names as described below:

r. For Series 1, set the series name to cell F5 (Hint: The series name should automatically update to =’Custom Clocks’!$F$5).

s. For Series 2, set the series name to cell G5.

t. For Series 3, set the series name to cell H5.

u. For Series 4, set the series name to cell I5.

v. For Series 5, set the series name to cell J5.

Firestone Clocks is considering subcontracting the construction of their Custom Clock line to other woodshops in the area. Walter wants to determine if this option will reduce the costs associated with this product line.

Go to the Custom Clock – Suppliers worksheet. Run Solver to minimize the value in cell F11 (Total Cost) by adjusting number of units produced by each woodshop (Hint: Changing cells will be C5:E5) assuming the four (4) manufacturing constraints below:

w. F5=5500

x. F11 <=560000

y. C5:E5 <=3500

z. C5:E5 should be an Integer

Run Solver, keep the Solver Solution, and then return to the Solver Parameters Dialog box. Save the model to the range B15:B22. Close the Solver Parameters Dialog box.

Go to the All Products worksheet. Open the Scenario Manager and create a Scenario Summary report for the resultant cells C18:E18. The Scenario Summary report will summarize the impact of the following three scenarios: Status Quo, Outsource Manufacturing, Raise Prices 5%.

Go back to the All Products worksheet. Open the Scenario Manager and create a Scenario PivotTable report for result cells C18:E18. Format the Scenario PivotTable as described below:

aa. Remove the Filter field from the PivotTable.

ab. Change the number format of the Profit_per_Unit_Sold_Desktop, Profit_per_Unit_Sold_Wall_Units, and Profit_per_Unit_Sold_Custom fields (located in the Values box of the PivotTable Field List) to Currency (with 2 decimal places).

ac. In cell A1, enter the value All Products Scenario PivotTable and format the cell with the Title cell style.

Go back to the All Products worksheet. Open the Scenario Manager and view the Outsource Manufacturing scenario in the worksheet.

 

Your workbook should look like the Final Figure on the following page. Note that some of the outcome values have been intentionally blanked out. Save your changes, close the workbook, and exit Excel. Follow the directions on the SAM website to submit your completed project.

Final Figure 1: Desktop Models Worksheet

Microsoft product screenshot reprinted with permission from Microsoft Incorporated. Copyright © 2014 Cengage Learning. All Rights Reserved.

 

Final Figure 2: Wall Units Worksheet

Copyright © 2014 Cengage Learning. All Rights Reserved.

 

 

 

 

 

 

Final Figure 3: Custom Clocks Worksheet

Copyright © 2014 Cengage Learning. All Rights Reserved.

 

 

Final Figure 4: Scenario Summary Worksheet

 

Copyright © 2014 Cengage Learning. All Rights Reserved.

 

 

Final Figure 5: Scenario PivotTable Worksheet

 

Copyright © 2014 Cengage Learning. All Rights Reserved.

 

 

 

 

 

 

 

Final Figure 6: All Products Worksheet

 

Copyright © 2014 Cengage Learning. All Rights Reserved.

 

 

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

Homework Assignment

/in /by

Independent Project 4-5

Windows   Mac

Boyd Air is monitoring flight arrival status as well as capacities. Before formatting the data as an Excel table, you will export it as a text file for use in the reservation software. You will filter the data in the table, build a PivotTable, and create a PivotChart.

[Student Learning Outcomes 4.1, 4.2, 4.3, 4.4, 4.7, 4.8]

File Needed: BoydAir-04.xlsx (Available from the Start File link.)

Completed Project File Name: [your name]-BoydAir-04.xlsx

Skills Covered in This Project

  • Export data as a text file.
  • Format data as an Excel table.
  • Use a number filter in a table.
  • Set conditional formatting with an icon set.
  • Filter data by cell icon.
  • Create and format a PivotTable.
  • Create and format a PivotChart.
  1. Open the BoydAir-04.xlsx start file. If the workbook opens in Protected View, click the Enable Editing button so you can modify it.
  2. 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.
  3. Rename the sheet tab Stats.
  4. The worksheet includes the Boyd Air Flight Statistics.
  5. Select cell A4 and format the data as an Excel table using Green, Table Style Medium 21.
  6. Copy the Stats sheet to the end and name the copy PM Flights.
  7. Select the PM Flights sheet, and use a Greater Than filter to display flights with a departure time after 12:00 PM (Figure 4-106).Departure label in row 4 displays filter iconFigure 4-106 Filter results for Departure Time field
  8. Select the Stats worksheet, select cells I5:I32, and set conditional formatting to use 3 Flags from the Icon Sets.
  9. Build a two-level Custom Sort for the Capacity column to sort by icon. Show the green flag at the top, followed by the yellow flag. The red flag will default to the bottom (Figure 4-107).The red flag is not used in the Sort dialog boxFigure 4-107 Custom sort for the 3 Flags icon set
  10. Select the Stats worksheet, select cells A4:I32, and use the Quick Analysis tool to create a PivotTable to display average of capacity by origin (Figure 4-108).The ScreenTip displays Average of Capacity by OriginFigure 4-108 PivotTable suggestions from the Quick Analysis tool
  11. Rename the sheet PivotTable&Chart.
  12. Select cell B3 in the PivotTable and use Field Settings to set a Number Format of Percentage with two decimal places. Edit the Custom Name to display Average Capacity.
  13. Add the Passengers field to the PivotTable Values area with a sum calculation. Edit the field settings to display # of Passengers as the custom name. Set the number format to Number with zero decimals and a thousand’s separator.
  14. Use White, Pivot Style Light 8 for the PivotTable and show banded rows and columns.
  15. Add a 3-D Pie PivotChart to the sheet and position the chart object to start in cell E3. Size the chart to reach cell N22.
  16. Select the legend in the chart and change the font size to 11 from the Home tab.
  17. Show Data Labels on the chart positioned at the Inside End. Select a data label and format all labels from the Home tab as bold and 10 pt.
  18. Select cell A1 and save and close the workbook (Figure 4-109).Excel 4-5 completedFigure 4-109 Excel 4-5 completed
  19. Upload and save your project file.
  20. 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!

To Bid Or Not To Bid

/in /by

What other factors should Marvin and his team consider?

 

Marvin along with his team can examine the following factors before proceeding to bid or not bid.

1.     If Marvin’s company would voluntarily decide not to bid, then it has to think that any other company can bid for the project and potentially benefit from bidding. The primary reason is Marvin’s company is not the only company which has to publish its detail cost analysis of the project to the client, but also all companies have to present this cost analysis.

2.     Marvin’s company can research whether there is a way to get more profit margin by following the client cost model because it is a long-term contract for ten or more years.

3.     Marvin has to think whether company loses its brand value if it doesn’t participate in the bid because, in the consulting industry, the companies must be active in getting projects else the reputation diminishes among clients.

4.     Marvin and his team must consider whether their company is suitable for contracts of the type cost reimbursable because in this contract type the client pays for each work package, so the profit is less compared to fixed price projects.

 

Should they bid on the job?

There are a lot of crucial factors that help the company if they can get this contract. The most important to consider is this is the most significant contract compared to all other agreements that Marvin’ company ever received in its history. For 10-year or longer, the company will generate continuous revenue that helps the growth of the company. As it is a contract with a major client, Marvin’s company’s reputation will increase in consulting industry, and this, in turn, attracts more clients. The performance of the company will increase by improving their evaluation of contracts using a bottom-up approach. Marvin’s company can also try to address its concern to release complete cost breakdown information by using its association with the client, and they can explain in detail by showing the examples of previous project budgets associated with them. Finally, it is helpful for Marvin’s company by considering all these factors, so they have to bid for the job.

 

Marvin’s company should also consider a lot of interesting facts regarding the new contract opportunity. The customer’s ability to treat Marvin’s business as a strategic partner rather than an offer. Establishing a workable standard to win a larger contract and, ultimately, better overall earnings and profits due to a larger business base. On the other hand, Marvin’s team can also ask relevant questions about the prospects of his company. Will the company survive the impact of publishing sensitive information later? Can the company manage without the project? Will the project be a development path for the company in the long term? The answers to these questions could also be crucial for Marvin to make the right decision. If issues become a concern, it is desirable that the company explore this new horizon and learn ways to manage the impacts of sharing key information.

 

There is a legitimate purpose behind the additional necessities on the DP. Basic information has been requested in the RFP cuts on all organizations offering so, they all offer risks and rewards. What’s more, since the offer will be considered non-receptive without them, it’s excessively prescribed that Marvin’s organization offers for the task.

 

Before choosing to bid deliberately recognize all the potential hazards that might emerge on the job. Monitors tender records, plans and determinations for the task and relies on verifiable information from comparable companies whose hazards you have come to recognize. Basic hazards include fragmented development files, obscure site conditions, fast schedules, and welfare issues.

 

References

[1] Bob, L. (2015). 7 Question to Answer When Making Bid/ No Bid  Decisions. Washington Technology.

 

[2] Cagno, E., Caron, F., and Perego, A. (2001). Multi-criteria evaluation of the likelihood of winning in the focused bidding process. Global Journal of Project Management, 19(6), 313-324.

 

[3] Jones, K. (2017). Key Factors to Consider in Bid/No-Bid Decision Making. Construct Connect. Retrieved from  https://www.constructconnect.com/blog/operating-insights/key-factors-consider-bidno-bid-decision-making/

 

[4] Kerzner, H. (2013). Project management: – a systems approach to planning, scheduling, and controlling. John Wiley & Sons.

 

NOTE: All initial postings must have at least one citation or reference and it must be in APA format. please make sure they’re in APA format. Need to be atleast 150 word.

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

I Have Homework In Excel And I Need Help

/in /by

Shelly Cashman Excel 2016 | Modules 1–3: SAM Capstone Project 1a

C:\Users\akellerbee\Documents\SAM Development\Design\Pictures\g11731.pngShelly Cashman Excel 2016 | Modules 1–3: SAM Capstone Project 1a

Campus Fitness Center

modify a service report and create a chart

 

GETTING STARTED

Open the file SC_EX16_CS1-3a_FirstLastName_1.xlsx, available for download from the SAM website.

Save the file as SC_EX16_CS1-3a_FirstLastName_2.xlsx by changing the “1” to a “2”.

0. If you do not see the .xlsx file extension in the Save As dialog box, do not type it. The program will add the file extension for you automatically.

With the file SC_EX16_CS1-3a_FirstLastName_2.xlsx still open, ensure that your first and last name is displayed in cell B6 of the Documentation sheet.

· If cell B6 does not display your name, delete the file and download a new copy from the SAM website.

 

PROJECT STEPS

Stella Scott has a work-study position at the fitness center on campus. Her manager has asked her to create a worksheet to keep track of attendance and revenue for the fitness center’s classes.

Open the Class Statistics worksheet. Modify the column widths and row heights as described below:

a. Use AutoFit to change the width of column A to make all the contents visible.

b. Change the row height of row 1 to 42.00 pts.

c. Change the widths of columns B through M to 10.25 characters.

In the merged range A1:M1, apply the formatting options described below:

d. Change the font to Tw Cen MT and the font size to 26 pt.

e. Change the font color to Turquoise, Accent 3, Darker 50% (7th column, 6th row of the Theme Colors palette).

f. Change the fill color of the cell to Turquoise, Accent 3, Lighter 80% (7th column, 2nd row of the Theme Colors palette).

Use Merge Cells to merge the contents of the range A2:M2 and then apply the Heading 1 cell style to the merged range. Format the merged range with the Short Date number format.

Enter the contents in bold shown in Table 1 below into the range C4:G5.

 

Table 1: Data for Range C4:G5

 

  C D E F G
4 Cardio Hip-Hop Spinning Yoga Zumba
5 100 150 120 200 150

 

 

Format the cells in the range C5:G5 with the Currency number format with two decimal places.

Apply the following formatting options, as described below:

g. Bold and center the content of cell B4.

h. Use the Format Painter to copy the formatting of cell B4 to the range C4:G4.

i. Use Merge Cells to merge the contents of the range B4:B5.

j. Apply the All Borders border style to the range B4:G5.

Move the content of cell H6 to cell G7 and then apply the formatting options described below:

k. Merge and center the range G7:K7.

l. Apply the fill color Blue, Accent 2, Lighter 60% (6th column, 3rd row of the Theme Colors palette) to the merged range.

Use the September label in cell B8 to fill the range C8:M8 with the months of the year.

In cell B14, use the SUM function to total the values in the range B9:B13. Use the Fill handle to copy the formula from B14 into the range C14:M14.

In January, the hip-hop class is the center’s least attended class, but Stella’s manager hopes to boost attendance so that they can reach their budget goals.

Perform a Goal Seek analysis to determine the number of hip-hop class attendees needed in January (F10) to change the value in cell F14 to 400. (Hint: Cell F10 will be the changing cell.) Keep the results of the Goal Seek Analysis as the new value for cell F10.

In cell B15, use the keyboard to enter a formula that multiplies the value in cell B9 (the number of students attending the cardio class) by the value in cell C5 (the cost of each cardio class). Use an absolute cell reference to cell C5 and a relative reference to cell B9. Copy the formula from cell B15 to the range C15:M15.

Calculate the revenue for the two remaining unfilled classes (Yoga and Zumba) as described below, using absolute references to the cells in the range F5:G5:

m. In cell B18, enter a formula that multiples the value in cell B12 by the value in cell F5. Copy the formula from B18 to the range C18:M18.

n. In cell B19, enter a formula that multiples the value in cell B13 by the value in cell G5. Copy that formula from B19 to the range C19:M19.

Format the values in the range B9:M14 with the Comma Style number format with zero decimal places. Format the range B15:M20 with the Accounting number format with two decimal places.

To help see where the most profitable months are, apply a new conditional formatting rule to the range B20:M20. The rule should format only cells that contain cell values greater than $62,000 with Light Green fill color (5th column, 1st row of the Standard Colors palette) and Dark Blue font color (9th column, 1st row of the Standard Colors palette).

In cell B23, use the AVERAGE function to calculate the average monthly revenue generated for the range B15:B19. Copy the formula from cell B23 to the range C23:M23.

In cell B24, use the MAX function to calculate which value in the range B15:B19 is the largest. Copy the formula from cell B24 to the range C24:M24.

In cell B25, use the MIN function to calculate which value in the range B15:B19 is the smallest. Copy the formula from cell B25 to the range C25:M25.

The center needs to bring in $13,400 a month to stay on budget. In cell B26, use the IF function to check whether the value of cell B23 is greater than 13,400.

o. If this condition is true, the cell value should be set to Over (Hint: For the value if true, use “Over”).

p. If this condition is false, the cell value should be set to Under (Hint: For the value if false, use “Under”).

Copy the formula created in cell B26 to the range C26:M26.

In cell B28, create a Line Sparkline from the data in the range G11:K11, and then change the style of the Sparkline to Sparkline Style Accent 3 (no dark or light).

Check the Spelling in the workbook to identify and correct any spelling errors. (Hint: You should find and correct at least two spelling errors.)

Format the worksheet for printing as described below:

q. Change the orientation to Landscape.

r. Change the worksheet margins to Narrow.

s. Insert a header in the center section with the text 2018 Class Statistics.

t. Set the print area as the range A4:M28.

u. Scale the worksheet so that it prints on one page.

Switch back to Normal View.

Stella’s manager would like to emphasize certain visuals in the worksheet.

Create a Line chart from the nonadjacent ranges B8:M8 and B20:M20. Move the chart you just created to its own chart sheet. Use Monthly Revenue Chart as the name of the new chart sheet.

On the Monthly Revenue Chart worksheet, format the line chart with the following options:

v. Change the chart title to Total Revenue by Month.

w. Format the data labels using the Above positioning option.

Switch back to the Class Statistics worksheet. Use the Recommended Chart tool to create a Clustered Column chart based on the range A8:F13. Move the chart to its own chart sheet. Use the name Fall Attendance Chart as the name of the new chart sheet.

On the Fall Attendance Chart worksheet, format the clustered column chart with the following options:

x. Change the chart style to Chart Style 2.

y. Change the chart title to Fall Semester Class Attendance.

z. Add Number of Attendees as the primary vertical axis title.

aa. Add Fall Semester Months as the primary horizontal axis title.

Stella’s manager was very impressed with her work and would like her to include and format some other information as well.

Go to the Personal Trainers worksheet and make the following formatting changes:

ab. Rotate the labels in the range B3:B17 to 0 degrees.

ac. Copy the range C3:C5, then paste it into the range C6:C17. Use the paste option that pastes the values, but not the cell formatting.

ad. Set the fill color in cell C3 and the range D6:D8 to No Fill.

The center uses special codes to keep track of hours and process payments. These codes are made by typing the first three letters of the day followed by a dash, the start and end times separated by a colon, a dash, and then the first two letters of the first and last name of the trainer.

In cell E4, type Mon-11:1-LoWa. Select the range E3:E17, and use Flash Fill to fill the values in the range. [Mac Hint: Flash Fill is not available in Excel 2016 for Mac, so refer to the Final Figures to enter the text.]

In the Physical Therapists worksheet, select cell B3 and use the Freeze Panes option to freeze the rows and columns above and to the left of cell B3.

Select the Class Statistics, Personal Trainers, and Physical Therapists worksheets and then change the color of the sheet tabs to Turquoise, Accent 3 (7th column, 1st row of the Theme Colors palette).

Your workbook should look like the Final Figures on the following pages. (The value in cell F10 generated by the Goal Seek analysis has intentionally been blurred out in Final Figure 3.) Save your changes, close the workbook, and then exit Excel. Follow the directions on the SAM website to submit your completed project.

Final Figure 1: Monthly Revenue Chart Worksheet

Final Figure 2: Fall Attendance Chart Worksheet

Final Figure 3: Class Statistics Worksheet

Final Figure 4: Personal Trainers Worksheet

Final Figure 5: Physical Therapists Worksheet

 

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

Excel Problem #9

/in /by

New Perspectives Excel 2013| Tutorial 9: SAM Project 1a

 

New Perspectives Excel 2013

Tutorial 9: SAM Project 1a

Wayside Driving School

EXPLORING FINANCIAL TOOLS AND FUNCTIONS

 

Project Goal

M Project Name

Project Goal

 

PROJECT DESCRIPTION

Emma Patterson is the owner of Wayside Driving School, and wants to expand operations into neighboring towns. To do so, she would need a loan to cover the costs of additional classroom space, vehicles, and instructors. Emma has asked you to create a detailed analysis of various expansion and financing options, complete with loan amortization and depreciation schedules. She also wants you to create a five-year sales forecast and income statement.

GETTING STARTED

· Download the following file from the SAM website:

· NP_Excel2013_T9_P1a_FirstLastName_1.xlsx

· Open the file you just downloaded and save it with the name:

· NP_Excel2013_T9_P1a_FirstLastName_2.xlsx

· Hint: If you do not see the .xlsx file extension in the Save file dialog box, do not type it. Excel will add the file extension for you automatically.

· With the file NP_Excel2013_T9_P1a_FirstLastName_2.xlsx still open, ensure that your first and last name is displayed in cell B6 of the Documentation sheet. If cell B6 does not display your name, delete the file and download a new copy from the SAM website.

 

PROJECT STEPS

Go to the Loan Analysis worksheet. In cell D12, use the PMT function to calculate the monthly payment for a loan using the inputs listed under the Add 1 Location loan scenario in cells D5, D7, and D9 (Hint: The result will be displayed as a negative number to reflect the negative cash flow of a loan payment).

In cell E7, enter a formula using the RATE function to calculate the monthly interest rate for a loan using the inputs listed under the Add 2 Locations loan scenario in cells E9, E12, and E5 (Hint: Assume the present value of the loan is the loan amount shown in cell E5).

In cell F5, enter a formula using the PV function to calculate the loan amount using the inputs listed under the Add 3 Locations loan scenario in cells F7, F9, and F12.

In cell G9, enter a formula using the NPER function to calculate how many months it would take to pay back a $1 million loan using inputs listed under the Expansion + BuyOut loan scenario in cells G7, G12, and G5.

Go to the Amortization worksheet. In cell C17, enter a formula using the CUMIPMT function to calculate the cumulative interest paid on the loan after the first year (payments 1 through 12) when the payments are made at the end of the period (Hint: Use 0 as the type argument in your formula). Use absolute references for the RATE, NPER, and PV arguments and relative references for the Start and End arguments. Copy the formula from cell C17 to the range D17:G17.

In cell H17, use the Error Checking command to identify the error in the cell, then correct the error (Hint: The formula in the cell should calculate the total the values in C17:G17 using the SUM function).

In cell C18, enter a formula using the CUMPRINC function to calculate the cumulative principal paid in the first year (payments 1 through 12) when the payments are made at the end of the period (Hint: Use 0 as the type argument in your formula). Use absolute references for the RATE, NPER, and PV arguments and relative references for the Start and End arguments. Copy the formula from cell C18 to the range D18:G18.

In cell E23, enter a formula that uses the PPMT function to determine the amount of loan payment number 1 devoted to the principal. Use absolute references for the RATE, NPER, and PV arguments and use cell A23 as the period argument (Hint: Remember that the period used in the formula is based on a monthly payment schedule). Copy the formula from cell E23 to range E24:E82.

In cell F23, enter a formula that uses the IPMT function to determine the amount of loan payment number 1 devoted to the interest. Use absolute references for the RATE, NPER, and PV arguments and use cell A23 as the period argument (Hint: Remember that the period used in the formula is based on a monthly payment schedule). Copy the formula from cell F23 to range F24:F82.

Go to the Depreciation worksheet. In cell C12, enter a formula that uses the SLN function to calculate the straight-line depreciation for the new vehicle fleet during the first year of service, with the value in cell D6 representing the expected life of the vehicle fleet. Use absolute references for the cost, salvage, and life arguments in the SLN formula. Copy the formula, without cell formatting, from cell C12 to the range D12:I12.

In cell C20, enter a formula that uses the DB function to calculate the declining balance depreciation for the new vehicle fleet during the first year of service, with the value in cell D6 representing the expected life of the vehicle fleet and the value in cell C19 as the current period. Use absolute references for the cost, salvage and life arguments in the DB formula and a relative reference for the period argument. Copy the formula from cell C20 to the range D20:I20.

Determine the error in cell D21 by using the Trace Precedent and Trace Dependent arrows. The formula in cell D21 should calculate the cumulative depreciation of the vehicle fleet by adding the Cumulative Depreciation value in year 1 to the Yearly Depreciation value in year 2. Correct the error in cell D21, copy the corrected formula in cell D21 to the range E21:I21, and then remove any arrows from the worksheet.

Go to the Income Statement worksheet. Project the revenues associated with the Classroom fees category for 2018-2020 (cells D5:F5) using a Growth Trend interpolation (Hint: Remember to select the range C5:G5 before filling this series with values).

Project the revenues associated with the Other category for 2018-2020 (cells D7:F7) using a Linear Trend interpolation (Hint: Remember to select the range C7:G7 before filling this series with values).

Project the expenses associated with the Payroll category for 2018-2021 (cells D11:G11) using a Growth trend extrapolation, using a step value of 1.07. (Hint: Remember that, when extrapolating values, the trend button in the Series Dialog Box should not be checked). Do not set a stop value for the series (Hint: Remember to select the range C11:G11 before filling this series with values).

Go to the Rate of Return worksheet and complete the following actions.

a. In cell E15, enter a formula that uses the NPV function to calculate the Present Value of the Add 1 Location investment, using the value in cell E14 as the desired rate of return and the range D7:D12 as the return paid to investors (Hint: If it appears, ignore the Formula Omits Adjacent Cell error warning).

b. In cell E16, enter a formula that calculates the Net Present Value by adding the Present Value of the Add 1 Location investment (calculated in cell E15) to the value of the initial investment (in cell D6).

In cell E17, enter a formula that uses the IRR function to calculate the internal rate of return of the Add 1 Location investment, using the range D6:D12 as the returns paid to the investors.

Your workbook should look like the Final Figures on the following pages. Save your changes, close the workbook, and exit Excel. Follow the directions on the SAM website to submit your completed project.

 

 

Final Figure 1: Loan Analysis Worksheet

Microsoft product screenshot reprinted with permission from Microsoft Incorporated. Copyright © 2014 Cengage Learning. All Rights Reserved.

 

 

Final Figure 2: Amortization Worksheet

Copyright © 2014 Cengage Learning. All Rights Reserved.

 

Final Figure 3: Depreciation Worksheet

Copyright © 2014 Cengage Learning. All Rights Reserved.

 

 

 

 

Final Figure 4: Income Statement Worksheet

Copyright © 2014 Cengage Learning. All Rights Reserved.

 

 

 

 

 Final Figure 5: Rate of Return Worksheet

Copyright © 2014 Cengage Learning. All Rights Reserved.

 

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

Excel Homework

/in /by

Instructions

 

In this project, you will correct function mistakes and other formula errors in a workbook designed for planning a large party or event. Be sure to save your work often!

Skills needed to complete this project:

· Checking Formulas for Errors (Skill 3.18)

· Finding Errors Using Trace Precedents and Trace Dependents (Skill 3.19)

· Displaying and Printing Formulas (Skill 3.20)

· Creating Formulas Using Counting Functions (Skill 3.6)

· Finding Minimum and Maximum Values (Skill 3.4)

· Formatting Text Using Functions (Skill 3.7)

· Using CONCAT to Combine Text (Skill 3.8)

· Finding Data Using the VLOOKUP Function (Skill 3.17)

· Using the Function Arguments Dialog to Enter Functions (Skill 3.1)

· Using Formula AutoComplete to Enter Functions (Skill 3.2)

· Calculating Averages (Skill 3.3)

· Naming Ranges of Cells (Skill 3.11)

· Working with Named Ranges (Skill 3.12)

· Updating Named Ranges with the Name Manager (Skill 3.13)

· Editing and Deleting Names with the Name Manager (Skill 3.14)

· Using Date and Time Functions (Skill 3.5)

· Using the Logical Function IF (Skill 3.15)

· Creating Formulas Referencing Data from Other Worksheets (Skill 3.10)

· Calculating Loan Payments Using the PMT Function (Skill 3.16)

·  Open the start file EX2019-FixIt-3-6. 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.

·  If the workbook opens in Protected View, click the Enable Editing button in the Message Bar at the top of the workbook so you can modify the workbook.

· On the GuestList sheet, check all the formulas. Cells to check are filled with the light purple color. Most of them need to be corrected. Use error checking as needed and/or display the formulas on-screen for easy viewing.

·  In the Name Tag column, modify the formula to display the guest name in this format: BILL SMITH  Hint: There are multiple errors in this formula. Fix the formula in cell D10 and then copy it to the other cells in the column.

·  Correct the function used in cell A3 to calculate the sum of the values in the NumAttending column.

·  Correct the function used in cell A4 to count the number of values in the Street column.

·  Correct the function used in cell A5 to count the number of blank cells in the NumAttending column.

·  Correct the function used in cell A6 to display the largest value in the NumAttending column.

·  Correct the function used in cell A7 to display the average value in the NumAttending column.

· On the Shopping List sheet, check all the formulas. Cells to check are filled with the light purple color. Most of them need to be corrected. Many of the problems on this worksheet can be solved by creating named ranges or using a name that already exists.

·  The formula in cell B2 uses the wrong function.

·  The formulas in cells A9:A23 reference a named range that doesn’t exist. There is more than one correct way to fix this problem using the cell range A5:H18 on the Places to Shop worksheet. You can create the named range referenced in the formulas, or you can change the function arguments to reference the cell range instead.

·  The formula in cell H9 results in the correct value. However, the workbook author copied this formula to the remaining cells in the column and those values are definitely not correct! Fix the formula in cell H9 and copy it to cells H10:H23. Hint: Notice that cell H8 is named Tax.

· If you’ve fixed the formulas in cells H9:H23 correctly, the formulas in cells I9:I23 and G5 should calculate properly now. However, the formulas in cells G2:G4 still have errors that need to be fixed. Hint: Use error checking as needed and/or display the formulas on-screen for easy viewing.

·  Correct the function used in cell G2 to average value of the Cost column.

·  Correct the function used in cell G3 to display the largest value in the Cost column.

·  Correct the function used in cell G4 to display the smallest value in the Cost column.

· On the Summary sheet, you will be entering all the formulas. Cells to complete are filled with the light purple color. Hint: Use error checking as needed and/or display the formulas on-screen for easy viewing.

·  Cell B2 should use a function that will update the date to the current date every time the workbook is opened.

·  Cell B4 references a named range that doesn’t exist. It should reference cell A4 on the Guest List sheet. You can create the named range or edit the formula to reference the cell instead.

·  Cell B5 references a named range that doesn’t exist. It should reference cell A3 on the Guest List sheet. You can create the named range or edit the formula to reference the cell instead.

·  Cell B8 is missing the formula to calculate whether or not the total Cost with tax on the Shopping List sheet + the total Cost for purchasing and mailing invitations on the Guest List sheet is greater than the available cash. The cell should display yes or no.

·  Add a formula to cell B9 to calculate the amount to borrow (total Cost with tax on the Shopping List sheet + the total Cost for purchasing and mailing invitations on the Guest List sheet – the cash available) if the value in cell B8 is yes. If the value in cell B8 is not yes, the cell should display 0.

·  Add a formula to cell B12 to calculate the monthly loan payment based on the information in cells B9:B11. Use a negative number for the Pv argument.

·  Save and close the workbook.

·  Upload and save your project file.

 
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 7 Independent Project 7-6

/in /by

The Hamilton Civic Center is developing a template for member exercise and off-site seminars. You create the template, set validation, enter formulas, and insert a combo box control. You then create a new workbook from the template.

[Student Learning Outcomes 7.1, 7.2, 7.3, 7.4, 7.6]

File Needed: HamiltonCC-07.xlsx (Available from the Start File link.)

Completed Project File Names: [your name]-HamiltonCC-07.xlsx

Skills Covered in This Project

  • Set data validation to use a list.
  • Set validation to restrict dates.
  • Create an error alert message.
  • Insert a combo box control.
  • Check accessibility and add alt text.
  • Protect a worksheet.
  1. Open the HamiltonCC-07 workbook and click the Enable Editing button. The file will be renamed automatically to include your name.
  2. Select cell D2 on the Data sheet and review the formula. The formula divides calories by time and rounds the results to three decimal places.ImagesFigure 7-69 Custom format for values
  3. Select cells D2:D10 and open the Format Cells dialog box.
  4. Select the Custom category on the Number tab and build a format to display three decimal places (Figure 7-69).
  5. Select cell D2 and click the Format Painter button [Home tab, Clipboard group]. Click the Calorie Tracking tab and paint the format to cells E3:E33.ImagesFigure 7-70 VLOOKUP formula
  6. Select cell E3 on the Calorie Tracking sheet. Start a VLOOKUP function to lookup the label in cell C3. For the array, use an absolute reference to cells A2:D10 on the Data sheet. The Col_index_num is 4 for the calories per minute column. Leave the Range_lookup argument empty; the array (A2:D10) is sorted in ascending order. The result of the VLOOKUP formula is calories per minute for the exercise (Figure 7-70).
  7. Edit the formula in cell E3 to multiply the results by the number of minutes in cell D3.
  8. Copy the formula in cell E3 to cells E4:E33. The #N/A error message displays in rows where no data displays.
  9. Select cells C3:C33 and set data validation to use the list of activity names on the Data sheet. Do not use an input message or an error alert.
  10. Select the Calorie Tracking sheet and delete the data in cells A3:D23.ImagesFigure 7-71 Data validation for dates
  11. Select cells B3:B33 and set data validation to use a Date that is less than or equal to TODAY (Figure 7-71). Include a Stop error alert with a title of Check Date and a message of Date must be today or in the past. including the period.
  12. Select cells A3:D33 and remove the Locked cell property. Select cell A3 to position the insertion point.
  13. Display the Developer tab on the Ribbon and click the Data worksheet tab.ImagesFigure 7-72 Combo box settings
  14. Draw a combo box control to cover cell F8 and open its Format Control dialog box. Select cells G8:G11 for the Input range and type f8 in the Cell link box (Figure 7-72).
  15. Deselect the control and then select Second from the control. The linked cell is under the control and hidden from view.
  16. Click the Hospital Seminars tab and select cell D4. This cell has Center Across Selection alignment applied.
  17. Select cell D4 and use CONCAT and INDEX to display the result from the combo box, concatenating the Index results to the word “Quarter.”
    1. Start a CONCAT function [Text group].
    2. Use the INDEX function with the first arguments list as the Text1 argument.ImagesFigure 7-73 INDEX is nested within CONCAT
    3. Choose cells G8:G11 on the Data sheet for the Array argument and cell F8 for the Row_num argument. You can select the combo box control or type f8 after the sheet name (Figure 7-73). When the array is one column, a Column_num argument is not necessary.
    4. Click between the two ending parentheses in the Formula bar to return to the CONCAT arguments and type a comma (,) to move to the Text2 argument. (If you accidentally click OK, click the Insert Function button to re-open the Function Arguments dialog box.)ImagesFigure 7-74 Space character is included with Text2 argument
    5. Click the Text2 box, press Spacebar, type Quarter, and click OK. (Figure 7-74).
    6. Format cell D4 as bold italic 16 pt.
  18. Select the Data sheet, select Third from the combo box control, and return to the Hospital Seminars sheet to see the results.
  19. Select cell D4 and cells D6:G10 on the Hospital Seminars sheet and remove the Locked property.
  20. Delete the contents of cells D6:G10 and select cell D6.
  21. Check accessibility and add the alternative text Hamilton Civic Center Logo to both pictures in the workbook.
  22. Select cell D6 on the Hospital Seminars sheet and cell A3 on the Calorie Tracking sheet.
  23. Protect the Hospital Seminars sheet and the Calorie Tracking sheet, both without passwords.
  24. Save and close the workbook (Figure 7-75).
  25. Upload and save your project file.
  26. 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!

Problems On Scientific Computing

/in /by

Complete the following problems from the textbook. Show all your work. If you write code, include screenshots of your code and any test runs that you perform. •

5.15 – pretend this experiment is set up on the moon (where g = 1.625m/s2 ) instead of Earth •(page-142)

6.19 – write a computer program and use the Newton-Raphson method to answer this question •(page-174)

7.6 • (page-202)

7.8 • (page-202)

8.1 – use chlorine (a = 6.579, b = 0.5622) at 1atm and 291.5K • page-215

9.20 • page-277

10.19 • page-298

11.24 • page 318

11.25 • page- 318

11.26 • page- 318

12.20 . page-335

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

Tableau Project – Car Insurance Claim Project

/in /by

Dear Participants,

“Today many big organizations are sitting on large chunks of data, not knowing what to do with it. They invite consultants & business analysts to have a look at data and come up with insights that could help the organization run their business better. There is no clear set of instructions in such open-ended problems and it is expected of the consultant to do a lot of exploration first and formulate the problems themselves. These DVT projects fall into the bucket of such open-ended problems and a specific problem statement has not been given intentionally. It is expected of students to explore the data and come up with good insights. There is no right and wrong answer here. There should a clear logical story which should come out of their submission.”

Please find below DVT Project instructions:

Note: Please upload the project on Tableau public and include the URL in a word doc and upload it.

  • Any assignment found copied/ plagiarized with another person will not be graded and marked as zero.
  • Please ensure timely submission as a post-deadline assignment will not be accepted.

Please find the instructions here.

To learn how to publish your tableau file, click here.

Please use the following  datasets- (Car Claim Insurance.xlsx)

Business Context 

We are all aware that accidents are prone everywhere due to negligent driving or climatic conditions. An insurance company always needs to be prepared to estimate the number of accidents and the claims that they can receive at a given point time. Also understanding the pattern of claims would help the companies to frame different types of policies for the users providing better benefits and at the same time increasing the premium to the company.

Problem Statement:

Consider that you are a Lead Data Analyst at an Insurance Claims company that has provided you with the Car Insurance Claims dataset. You have been given a task to explore the data, create different plots and interpret useful insights/findings. Your end goal here will be to create a storyboard that you have to present to the Senior Management and the story has to have an end objective and should follow a logical flow to display that you are heading towards achieving the end objective. This will help the Senior Management in taking some decisive actions on the current claims system in place. This storyboard will be an open-ended story for you to explore various different features in the data and try to showcase different plots. Make sure to have minimum clutter in the plots, follow a consistent color scheme across all the plots, and use proper colors to highlight a specific insight. Moreover, your plots on all the dashboards should be interactive and responsive. There should be 1 dashboard that should cover the summary of the story as well as your recommendations.

Important Note: Please reflect on all that you have learned while working on this project. This step is critical in cementing all your concepts and closing the loop. Please write down your thoughts here.

Regards,

Program Office

CriteriaPoints

Creation of multiple charts and tables for representing useful insights/findings. The charts used should be inline with the objective that you wish to convey to the Senior Management.

[Mandatory 8 types of charts/tables from any of the following: text table, bar chart(multiple/stacked/side by side), bubble chart, treemap, Pareto chart, scatterplot, Wordcloud, line plot, histogram, boxplot, circle views, heatmap, highlighted tables. No restrictions on the upper limit of the number of charts/tables to be used]  16 points

Creating a calculated field. The calculated field should add some meaningful value and should be inline with your storyboard which you will create in this project. (Specify where calculated field has been used)

2 points

Use of filters, parameter, actions, etc in the charts.

4 points

Minimal clutter and consistency in use of colors across charts.

5 points

Multiple Dashboards creation

At least 5 Dashboards 10 points

Correct interpretations/insights from each type of chart created. The interpretations should be inline with the storyboard which is to be created in this project.

These interpretations can be in the captions of the storyboard or in the plots as well 16 points

Interactivity among the charts on each Dashboard 5 points
Storyboard Creation

At least 1 Storyboard 15 points

Logical flow to the story represented in the storyboard. 5 Points
1 dashboard which will cover the summary and the recommendations from the insights to be added to the end of the storyboard

This dashboard will be an extra dashboard apart from the mandatory 5 dashboards mentioned in the 5th part of the rubric. At least 5 summary/recommendation points should be mentioned in this dashboard(at least 1 recommendation/summary point from each dashboard you created). 1 conclusion point of the story. This dashboard has to be a part of the storyboard created and not to be submitted separately. Note: This will not be evaluated if submitted as a separate dashboard/storyboard.

 
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

/in /by

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!