4. On the sheet of 2016 Orders, complete the following tasks. a. Make of list on the entire dataset. b. Sort the dataset by Product first and then by Region. (Other idea: By Salesperson first and then by Month) c. Add a column at the right of Product. Name it Price. Use vLookup function to pull product prices from the sheet Income Statements (D4:D7) and show prices for all orders. d. Add a column at the right of Unit. Name it Total. The order totals = Price * Unit. e. At the right of Total, add a column called Discount. Use a nested If function to decide the discounts. The company gives 10% discount to all orders from the West region, and the other regions only enjoy 10% discount in December. f. At the right of Discount, add a column called Totalw/Dis. It is the order totals – discounts. g. In cell L2, use the AVERAGE function to calculate the average number of units sold from the column Unit. Next, use conditional formatting tool and highlight the orders with unit sold greater than average unit sold. Select the green fill and dark green text color option if the cells meet this rule.

Chipotle mexican grill, the american mexican food chain restaurant, opened its first restaurant in the united states in 1993. in 2010, chipotle opened its first restaurant in the united kingdom in london on charing cross. by late may 2013, the company had 6 restaurants in london, but they have not been doing well even though the british have taken a liking to mexican food (boyle, 2013). why has this successful u.s. chain not seen the same success overseas? if you were chipotle's ceo, how would you fix this situation? what is an alternative means of venturing outside of its domestic markets that may allow for a competitive advantage? then, pick a company that has not yet expanded overseas, or if it has expanded, suggest a different strategy for entrance into an overseas market that you feel would be more strategic for the company. research its rivals in the global marketplace and market conditions in the overseas market you are targeting. justify your recommended entry strategy based on these industry and market conditions.

1tanner invested $135,000 cash along with office equipment valued at $32,400 in the company in exchange for common stock. 2 the company prepaid $7,200 cash for 12 months’ rent for office space. (hint: debit prepaid rent for $7,200.) 3 the company made credit purchases for $16,200 in office equipment and $3,240 in office supplies. payment is due within 10 days. 6 the company completed services for a client and immediately received $2,000 cash. 9 the company completed a $10,800 project for a client, who must pay within 30 days. 13 the company paid $19,440 cash to settle the account payable created on april 3. 19 the company paid $6,000 cash for the premium on a 12-month insurance policy. (hint: debit prepaid insurance for $6,000.) 22 the company received $8,640 cash as partial payment for the work completed on april 9. 25 the company completed work for another client for $2,640 on credit. 28 the company paid $6,200 cash in dividends. 29 the company purchased $1,080 of additional office supplies on credit. 30 the company paid $700 cash for this month’s utility bill. prepare general journal entries to record these transactions. 2. post the journal entries from part 1 to the ledger accounts.

The purpose of safety stock is to: a. eliminate the possibility of a stockout. b. control the likelihood of a stockout due to variable demand and/or lead time. c. eliminate the likelihood of a stockout due to erroneous inventory tally. d. protect the firm from a sudden decrease in demand. e. replace failed units with good ones.