In cell c3 in the october worksheet, enter a 3-d reference in formula that calculates the overall percentage of total sunday orchestra front tickets sold based on the total available orchestra front seating. the formula must sum the total sunday orchestra front seats sold in cells c3 of the weekly sheets and then divide it by the sum of the available orchestra front seats in cell b3 of the weekly sheets. avoid raw numbers and use an appropriate mix of relative and mixed references to derive the correct percentage. format the result with percent style. copy the formula to the range c4: c6 and then to the range d3: g6.

Journalize the following transactions that occurred in september 2015 for aquamarines. no explanations are needed. identify each accounts payable and accounts receivable with the vendor or customer name. sep. 3 purchased merchandise inventory on account from shallin wholesalers, $5,000. terms 1/15, n/eom, fob shipping point. 4 paid freight bill of $80 on september 3 purchase. 4 purchased merchandise inventory for cash of $1,700. 6 returned $500 of inventory from september 3 purchase. 8 sold merchandise inventory to hermosa company, $6,000, on account. terms 2/15, n/35. cost of goods, $2,640. 9 purchased merchandise inventory on account from thomas wholesalers, $8,000. terms 2/10, n/30, fob destination. 10 made payment to shallin wholesalers for goods purchased on september 3, less return and discount. 12 received payment from hermosa company, less discount. 13 after negotiations, received a $200 allowance from thomas wholesalers. 15 sold merchandise inventory to jordan company, $2,500, on account. terms 1/10, n/eom. cost of goods, $1,050. 22 made payment, less allowance, to thomas wholesalers for goods purchased on september 9. 23 jordan company returned $400 of the merchandise sold on september 15. cost of goods, $160. 25 sold merchandise inventory to smithsons for $1,100 on account that cost $400. terms of 2/10, n/30 were offered, fob shipping point. as a courtesy to smithsons, $75 of freight was added to the invoice for which cash was paid by aquamarines. 26 after negotiations, granted a $100 allowance to smithsons for merchandise purchased on september 25. 29 received payment from smithsons, less allowance and discount. 30 received payment from jordan company, less return.

Manipulation manufacturing's (amm) standards anticipate that there will be 5 pounds of raw material used for every unit of finished goods produced. amm began the month of maymay with 8,000 pounds of raw material, purchased 25,500 pounds for $ 15,300 and ended the month with 7,400 pounds on hand. the company produced 4,9004,900 units of finished goods. the company estimates standard costs at $ 1.10 per pound. the materials price and efficiency variances for the month of maymay were:

Carlos hears juan and rita’s complaints about the new employees with whom they have to work with, as well as their threats to quit the company. if carlos were to reassign juan and rita to new, unique roles and separate them from the ronny and bill, it would signal that carlos has moved into the stage of managing resistance.