Microsoft Excel?
I enjoy a inventory of directives that I call for to summarize and assign a charge to respectively demand. But the cost structure is approaching this $7 for first item surrounded by decree $1 respectively secondary item within the direct.Here is an example of my issue I hold a schedule 2000 items long so I can't do this manually.
1st row is command # 1234 and my charge is $7
2nd row is decree # 5678 and charge is $7
3rd row is also directive #5678 and my charge should be $1 because it is the second within my document.
I know I can do this I am newly drawing a blank I am sure I can write an if statement or something close to that to do this I freshly involve aid! Please comfort
Answers: Let's articulate your proclaim #s are contained by column A.
Then you would hold this formula for the charge (put this at row 3 and copy down):
=IF(A3=A2, 1, 7)
So if the order# is one and the same as the previous one (i.e. it's not the first one), next it's $1.00, otherwise (it is the first) it's $7.00.
This assumes that your notes is sorted by order# (i.e. adjectives the 5678 instructions are together). If they're not sorted, you can use this instead:
=IF(COUNTIF(A$2:A2, A3) >0, 1, 7)
Copy and smooth mixture this down.
If you necessitate more info, join more details or e-mail.
Good luck.
.
I allow nouns thru my avatar. If you really want aid, email me, include your email address because I can't attach to YA letters, next I'll dispatch you a solution.
****
Help beside this accouning homework?
how do i seize the cost of merchandise sold out of this ask...appreciation surrounded by creditThe Dutch auction be for the following number of items 300
The mart price for respectively item be $40.00
Therefore, the total mart to the Nearby Shrine be for $12,000.00
Cash received from Nearby Shrine at the time of the mart be $8,000.00
The remaining symmetry placed on details (terms 2/10, n/30) next to Nearby Shrine be $4,000.00
Answers: You can't win cost of biddable sold from the information given. You obligation percentage of mark-up, or something along that procession. All you can do next to the info given is add A/R and how much the discount offered is.
Where can I find information on the structure of the FDA?
Answers: FDA website
***
The Food and Drug Administration have a website near a .gov address. It should own some dear information for you. Also, Wikipedia have sources on it's FDA website (DO NOT USE WIKIPEDIA).
What are some tips for selling on eBay?
What are some selling tips for selling an item valued at nearly 400$? It is a retired doll next to lots pets, clothing, and extramural frills. Thanks surrounded by mortgage!Answers: Well the best item i can recommend is to start the auction during i time when you touch that would be the idyllic time for the item to stop. If you are selling a collectible doll go start it on a weekend around 3pm est so that it ends at a unblemished time no thing where on earth within the US you are. The source for this is so bidders obtain into a bidding time of war the end hour of the auction. This is when you create the most money!! Also if you be aware of that this item is worth a generous amount i would influence $200+ I would do a feature list (cost $20) for this index! you will return with much more exposure and one of the biggest points i would say aloud is start this out fundamentally low resembling $1.00 this does two item you bring back charged by eBay for how much you start an auction at and the more bids you achieve on an item the more attractive it looks to the buyers. example if your item is worth $400 if you start the item at $1.00 you will most credible enjoy 20-30 bids on the item once it reach $400 but if you start this at $400 you will own 1 bid. When most relatives survey on eBay for an item i.e. one of the most looked at paddock # of bids. its only just approaching proverb it is a hot item! Not that i do this since eBay is against this and i would not suggest doing this but i hold hear of seller doing this if your item is going to get rid of for lower than what you hoped to attain for it hold a Friend bid on it.
Well pious luck!
Sell a few cheap items first to build up some history as a trader.
How normally does packages win lost within the correspondence by the fused states postal service?
Answers: It is a bloody entity and usually is a result of poor address by the sender or scrawled writing.
You should other PRINT the address and include a return address so that if here is a problem , it can be sent hindmost to you for correction. It is also a worthy model to include any the return address or the sending address inside beside the contents. If for any point the address on the outside become incomprehensible, the department of the USPS that handle undeliverables would next know how to meeting the item next to an address and acquire it on it's agency.The deceased e-mail center would not be needed as much if race would follow these simple help to find their item deliver.
Very from time to time. Far more adjectives is their nicking by the receiver.
Can I unfasten a put up for sale if it's not the best asking price?
Well I be selling on ebay and logically I forgot to look at my communication and in a minute I'm screwed can I unknot my vend?Answers: Not usually. You could contact the lofty bidder and explain to them you hold a problem and possibly they will release you from the bid.
Track a ups box? It be sent saturday, any concept why zilch shows up on the other hand not even the initial scan?
Answers: Unless you are sending second daylight or overnight by UPS, they don't pick up on the weekends. Most potential, your bundle will be scan into the system tonight since they do most of their pickups contained by the hasty evening.
Check tonight after more or less 6pm and I'll bet your pack is within at hand.
ups office are closed on Saturday and Sunday, it should be available for viewing latter today.
Shopping traditions?
1.) When you be in motion shopping do you transport resembling 15 minutes to find the faultless parking space? I whip the closest and quickest2.) Do you hold a shopping account? I don't other
3.) Do you stick to this chronicle? I do (if i made one)
4.) Do you use coupons? Sometimes
5.) When select a product, do you budge by Dutch auction price, brand entitle or best efficacy by section price? I turn by price
6.) When you jump shopping do you spend lower than or over the parameter? If I enjoy my schedule underneath.
7.) How long do you shop for? 1-3 hours
8.) Where do you shop the most? Family Dollar
9.) Do you shop alone, next to household associate or friend? adjectives three
10.) Are you a quirk buyer? Yes
Answers: 1.) When you turn shopping do you clutch close to 15 minutes to find the faultless parking space? when it's cold definately
2.) Do you filch a shopping detail? Not really
3.) Do you stick to this enumerate? Nope
4.) Do you use coupons? Always. I use OnlineStoreCoupon.com
5.) When select a product, do you travel by public sale price, brand identify or best significance by part price? I buy products base on coupons.
6.) When you budge shopping do you spend beneath or over the consideration? beneath because of adjectives of the extra reserves beside coupons.
7.) How long do you shop for? 2-4 hours
8.) Where do you shop the most? Buy.com
9.) Do you shop alone, next to kith and kin bough or friend? myself surrounded by the comfort of my living room.
10.) Are you a craze buyer? Yes
1.) When you run shopping do you rob similar to 15 minutes to find the ideal parking space? Not really I don't fastidiousness where on earth I park
2.) Do you clutch a shopping chronicle? ALWAYS
3.) Do you stick to this catalogue? Most of the time
4.) Do you use coupons? ALWAYS! I attain the Sunday Inserts and use grocerygame.com
5.) When select a product, do you budge by mart price, brand first name or best significance by part price? I buy products base on price. Sometimes, the coupons will NOT be the best wrangle
6.) When you move about shopping do you spend beneath or over the contain? Ususally.... lower than the bound
7.) How long do you shop for? 1-2 hours
8.) Where do you shop the most? Kroger
9.) Do you shop alone, near relatives contestant or friend? Just me and my husband
10.) Are you a quirk buyer? No
Carla finds Jack stealing some software from the company he works for, he is also running a side businness?
using the software, she finds out and confronts him, she call him a robber. he responds to her that she is also a intruder because she uses the phone to trade name personal call and the copying mechanism to manufacture copies for her church group. she stays shut and dont relay her boss, assume you are Carla, what option do you enjoy and what are the consequences of respectively pickingAnswers: Big or small stealing is stealing. If Carla is a principled woman, she would at tiniest allow that she have be stealing too. If not, a well-mannered comparison is if I steal my friend's ear-ring is OK, but not her motor. . . Before we take into the consequences...Carla should distribute her travels a serious thought. Really CARLA what drives you that you want to report to your boss? Could this piece be discussed next to your coworker and can be stopped? ....After Carla's intention is clearly identified...next I ruminate the consequences will be. One: Carla would own that she's be stealing too, and she would also grant that both her and her co-workers behaviors is not adequate. Two: She tell her boss that she's a markedly biddable hand who care profusely roughly speaking the company, and she hate population who stills, ...and consequently carry the make higher she desires, or bring back the attention she seek. But wide inside, she continues to be or grain dark, dirtier and stinky, for man pretentious. Three: she have no clue of what's going on...and she tell her checker what happen,..and she continues to live her vivacity blissfully ever after, because she didn't donate it any thought, or her mind can not deduce any further than one step at a time.
MYOFB is what I would voice. His logic is without doubt correct within that Carla is as much a mugger as Jack, save more, because she is also stealing time from the company. The software get written past its sell-by date, they cannot put together up the losses from Carla using company time doodling her churchie stuff and chatty pattying up near her friends. If I be Jack I would turn Carla within.
Bad Debt Expense...Accounting Help!?
Does anyone know what the discouraging debt expense would be for this problem? I cannot integer it out for anything! I took a peak shot of the problem since I cant type it out. I dont even know what the stuff at the bottom is!! Please someone comfort me Im have a frenzy attackPart 1: http://i6.tinypic.com/71vztcz.gif
Part 2: http://i2.tinypic.com/71vt28p.gif
Answers: How lots more attempts enjoy you get? Would you dare try feed surrounded by these answers?
Dec 31
Dr Bad debt exp. $20,150
Cr Allowance for doubtful a/cs $20,150
Qn 3 - $798,490
Qn 4a - $17,815
Qn 4b - $14,415
Qn 4c - $800,825
I yearning my proposal could be caring.And here is a pious resource.Check it up.http://debt-consolidation.featured-resou...
What is Offshoring?
I obligation a not so breif synopsis of what offshoring is and how iit effects the countries. I hold already used wiki.Answers: Offshoring describes the relocation of business processes from one country to another. This includes any business process such as production, engineering, or services.
Offshoring can be see contained by the context of any production offshoring or services offshoring. After its accession to the WTO, China emerge as a prominent destination for production offshoring. After precise progress contained by telecommunications better the possibilities of trade contained by services, India become a country main contained by this domain though copious parts of the world are presently emerging as offshore destinations.
The monetary logic is to weaken costs. If some ancestors can use some of their skills more cheaply than others, those empire enjoy the comparative control. The notion is that countries should freely trade the items that cost the lowest possible for them to produce
According to classical economics, the three factor of production are estate, labor, and income. Offshoring relies heavily on the mobility of two of these factor. That is, how offshoring effects economy depends on how glibly possessions and labor can be repurposed. Land, as a factor of production, is unanimously see to own little or no mobility potential.
The effects of income mobility on offshoring enjoy be widely discussed. In microeconomics, a corporation must be capable of spend working wherewithal to afford the initial costs of offshoring. If the state heavily regulates how a corporation can spend its working funds, it will not know how to offshore its operation. For duplicate purpose the macroeconomy must be free for offshoring to succeed. Generally, those who favor offshoring support possessions mobility, and those who argue against offshoring hail as for greater regulation.
Labor mobility also plays a trunk role, and it is hotly debate. When computers and the Internet made work electronically portable, the forces of free flea market resulted within a intercontinental mobility of work within the services industry. Most theories that argue offshoring eventually benefits domestic workers assume that those workers will know how to search out unknown job, even if they enjoy to search out employment by downpricing themselves support into the labor flea market (by accepting lower salaries) or by retraining themselves surrounded by a brand new grazing land. Foreign workers benefit from foreign job and greater wages when the work moves to them.
How to vend items on eBay and tips, abet much appreciated?
I'm an eBay appendage and I hold fixed to start selling. I'm only not sure how to numeral out the entire selling process especially the shipping. For example if I deal in something for $10 and the shipping is $6 and the buyer sends me $16 via PayPal afterwards how do I remuneration for the shipping? Do I only repeal the $6 dollars from my PayPal/banking portrayal or is near something else I obligation to do? Also some item description on eBay have this small box at the bottom which states the breadth of the item and at the bottom of the box it say that everything stated the trader is responsible for. Now does this appear itself or do I enjoy to produce the box myself and is contained by critical of suggested? It usually starts rotten next to Additional Information around El Hobbit / the Hobbit Portions of this page Copyright 1995 - 2007 Muze. Also how do I numeral out the shipping rate near USPS or Fedex etc.? Because copious individuals on eBay charge different prices for shipping even though they use duplicate shipping method/company.Answers: Your ask deal specifically near the postage and handling quantity of the leading bids. It can be a pleasant experience for the buyer or not depending on how restrained the s/h charges are. Plus, several seller use the s/h charges to 'pad' their eventual profits from respectively mart, especially if the victorious bid is smaller amount than they have hoped. This is really annoying to bidders. Charge what it costs to ship them and a bit for yourself as very well, but be conceivable.
If you want to ensure that you go and get the price you want, consequently bring in that your bottom price. I would support you to return with the price you want to by selling the item as a 'Buy it now' item. This boundaries how large the price get, but it also avoids the disappointment of have an item thoroughly few bidders are interested within.
As for knowing ahead of time what it will cost for USPS you can gain the postage of the item ahead of time and attach your per hour handling duty and flog that as your s/h price, or you can do what plentiful seller do - explain to the buyer to dally till you can grasp the item weigh for the country/province/state and afterwards email the amount.
With paypal, you can hold adjectives your winnings until it reach an amount that you conjecture is plausible, and later cancel it to your checking reason. Each transaction costs 50 cents, and the cost of subtracting 50 cents respectively time will eventually incorporate up as economically.
You purely shift the money over subsidise to your checking commentary. It take 3-5 days to process but I would hope you would enjoy dosh on appendage to pilfer precision of the post department fees right away.
Boxes are adjectives flexible.
When you set up the description of the classified ad further down here is a section for shipping.. a moment ago put within how much it weigh.. inside a box and afterwards state that price or use the flat box shipping.. you can get hold of free boxes from the post organization for Ebay shipping basically check the Shipping supplies interconnect surrounded by your My Ebay nouns.. moved out column.
You can charge extra for packing, buying boxes or bubblewrap, your gas to the post bureau even. I other charge a 1.00 extra so it covers Confirmation. Always ship beside confirmation so you know they received the bag it also help the post bureau track it down if lost.