Module 1 Practice Tasks (MO-1.1, 1.2, 1.3, 1.4, 1.5)
Please complete:
1. Chapter 2, “Enter and Revise Data”
2. Chapter 2, “Manage Data by Using Flash Fill”
3. Chapter 2, “Define Excel Tables”
4. Chapter 3, “Name Groups of Data”
5. Chapter 3, “Create Formulas to Calculate Values”
6. Chapter 3, “Summarize Data that Meets Specific Conditions”
7. Chapter 3, “Find and Correct Errors in Calculations”
8. Chapter 4, “Apply Workbook Themes and Excel Table Styles”
9. Chapter 4, “Change the Appearance of Data Based on its Value”

If any of the practice tasks asks you to undo or delete the work you have done, do not undo your work. I cannot see that you have successfully used the skill if you remove it.
Remember to combine all worksheets into a single workbook for submission to the dropbox.FirstBid

Conveyer

350′ track $ 14,012.00

Catch bin $ 895.00

Motor $ 1,249.00

Chain drive $ 1,495.00

Sorting table $ 675.00

Subtotal $ 18,326.00

Loading Dock

Concrete $ 2,169.00

Labor $ 4,500.00

Posts $ 300.00

Excavation $ 2,500.00

Drain $ 1,800.00

Rails $ 495.00

Stairs $ 1,295.00

Subtotal $ 13,059.00

Build Total $ 31,385.00

Labor Percentage ERROR:#DIV/0!Fuel

Fuel Surcharge Rates

Surcharge 103%

Delivery Q1 Q2 Q3 Q4

Ground $ 1,876 $ 2,145 $ 2,200 $ 2,800

Three Day $ 3,000 $ 3,142 $ 2,703 $ 3,215

Two Day $ 4,000 $ 4,500 $ 3,815 $ 5,378

Overnight $ 8,000 $ 8,500 $ 8,200 $ 9,900

Total $ 16,876 $ 18,287 $ 16,918 $ 21,293

With Surcharge

Volume

Package Volumes

Year Packages Increase Projected Total

2013 1,500,000 107%

2014 2,000,000 108%

2015 3,000,000 107%

2016 4,000,000 106%Summary

Category Expenses

Hardware $ 1,469,002.00

Desktop Software $ 385,671.00

Server Software $ 599,101.00

Maintenance $ 64,703.00

Cable $ 11,240.00

Backup Power Supply $ 33,249.00

Total

Software Total

JuneLabor

Region Labor Expense

Northeast $ 64,685.00

Atlantic $ 99,001.00

Southeast $ 91,039.00

North Central $ 40,036.00

Midwest $ 77,238.00

Southwest $ 43,303.00

Mountain West $ 45,994.00

Northwest $ 95,633.00

Central $ 80,122.00

TotalNortheast

Code Type Size Destination Expense Potential Discount Average Box Cost

PKG0001 Box Small Domestic $ 44,816.00

PKG0002 Box Medium Domestic $ 57,715.00

PKG0003 Box Large Domestic $ 51,965.00 International Envelope Cost

PKG0004 Box Small International $ 31,813.00

PKG0005 Box Medium International $ 52,830.00

PKG0006 Box Large International $ 37,476.00

PKG0007 Envelope Small Domestic $ 22,793.00

PKG0008 Envelope Medium Domestic $ 21,056.00

PKG0009 Envelope Large Domestic $ 20,488.00

PKG0010 Envelope Small International $ 10,189.00

PKG0011 Envelope Medium International $ 18,309.00

PKG0012 Envelope Large International $ 17,255.00MilesLastWeek

Day

VehicleID Monday Tuesday Wednesday Thursday Friday Saturday

V_101 159 144 124 108 125 165

V_102 113 106 111 116 119 97

V_103 87 154 124 128 111 100

V_104 137 100 158 96 127 158

V_105 86 132 154 97 154 165

V_106 159 163 155 101 89 160

V_107 111 165 155 92 91 94

V_108 101 162 123 87 93 140

V_109 164 159 116 97 149 120

V_110 100 107 143 144 152 132Sheet1

Savings Incentive Program

Previous Expense $ 145,000.00

New Expense $ 125,000.00

Gross Savings $ 20,000.00

Savings Incentive

Net Savings $ 20,000.00

Incentive Rate 8%




Why Choose Us

  • 100% non-plagiarized Papers
  • 24/7 /365 Service Available
  • Affordable Prices
  • Any Paper, Urgency, and Subject
  • Will complete your papers in 6 hours
  • On-time Delivery
  • Money-back and Privacy guarantees
  • Unlimited Amendments upon request
  • Satisfaction guarantee

How it Works

  • Click on the “Place Order” tab at the top menu or “Order Now” icon at the bottom and a new page will appear with an order form to be filled.
  • Fill in your paper’s requirements in the "PAPER DETAILS" section.
  • Fill in your paper’s academic level, deadline, and the required number of pages from the drop-down menus.
  • Click “CREATE ACCOUNT & SIGN IN” to enter your registration details and get an account with us for record-keeping and then, click on “PROCEED TO CHECKOUT” at the bottom of the page.
  • From there, the payment sections will show, follow the guided payment process and your order will be available for our writing team to work on it.